Getting Started with Power BI

Join Connect+Learn for a session on getting started with Power BI. The session will include the following:

  • Use cases for demo
  • Power BI demo
    • Connect to data sources from Power BI
    • Build Power BI report using visualization ​
    • Publish report to a workspace in the cloud and share with users​
    • Schedule dataset refreshes in the cloud
    • Subscribe to reports using user emails
    • Connect to Power BI Shared Dataset
    • Create an App with a package of reports and permission setting​s
  • Resources: Power BI Toolbox and Training Videos Report

The following prerequisites for this sessions are:

  • Downloaded Power BI Desktop Clients
  • Connected to Cisco AnyConnect AdminVPN
  • Granted access to UofT’s premium workspace (requested through ESC ticket)
  • Have access to ROSI-REPLICA database (requested through ESC ticket)

Resources

 

Update: Azure Data Studio and Power BI Resources

Date: April 18, 2023
To:
Azure Data Studio and Power BI Users
From:  Reporting and Analytics Technology Team, EASI
Re: Update: Azure Data Studio and Power BI Resources

 

Hi everyone,

The Reporting and Analytics Technology Team at Enterprise Applications & Solutions Integration would like to provide you with an update on the latest resources for Azure Data Studio and Power BI.

Connect+Learn Presentation: Getting Started with Power BI

When: Wednesday, April 26 at 11 a.m.
Where: Join Microsoft Teams Meeting and Add to Calendar

The session will include the following:

  • Use cases for demo
  • Power BI demo
    • Connect to data sources from Power BI
    • Build Power BI report using visualization ​
    • Publish report to a workspace in the cloud and share with users​
    • Schedule dataset refreshes in the cloud
    • Subscribe to reports using user emails
    • Connect to Power BI Shared Dataset
    • Create an App with a package of reports and permission setting​s
  • Resources: Power BI Toolbox and Training Videos Report

Training Videos
We have also published the following Azure Data Studio training videos:

You can view all introductory videos on our Training Resources page, and we will also be developing intermediate and advanced training videos shortly.

Finally, you can find all resources in the Power BI Toolbox.

If you have any questions, please contact Katie Babcock at katie.babcock@utoronto.ca

Sincerely,

Reporting and Analytics Technology Team
Enterprise Applications & Solutions Integration

Introduction to Power Automate

Join Connect+Learn for a session on Microsoft Power Automate (formerly Microsoft Flow). A service that helps you create automated workflows for repetitive business processes. Power Automate can send reminders on past due tasks, move business data between systems on a schedule, talk to many data sources. We will discuss:  

  • What Power Automate is
  • Its building blocks
  • Types of flows and what it can be used for
  • Create a simple automatic workflow together

Resources

 

Reminder: AMS FI Fiscal Year-End Closure 2023 

Date: April 18, 2023
To: AMS Users
From: Enterprise Applications & Solutions Integration 
Re: Reminder: AMS FI Fiscal Year-End Closure 2023

 

Hi everyone,

As a reminder, this year AMS will close for FI year-end processing on Thursday, April 27, 2023 at 7pm and will re-open on Monday, May 1, 2023 at 7am. 

ERDD and the Capital Projects Portal and Invoice Workflow will resume regular functionality on Monday, May 1, 2023 at 7am, and uSOURCE will resume operation at 9am.

The following summarizes the AMS system availability during the week prior to year-end closing:

 

Date Status
Tuesday, April 18 System closes for bi-weekly payroll at 6pm
Wednesday, April 19 System re-opens at 7am
Thursday, April 20 System open regular hours
Friday, April 21 System closes for monthly payroll phase 1 and for “Copy Plan to Budget” at 6pm
Saturday, April 22 System re-opens at 7am
Sunday, April 23 System open regular hours
Monday, April 24 System closes for monthly payroll phase 2 at 5pm
Tuesday April 25 System re-opens at 7am
Wednesday April 26 System open regular hours
Thursday, April 27 System closed to all users at 7pm
Friday, April 28 System closed to all users
Saturday, April 29 and Sunday, April 30 System closed to all users
Monday, May 1 System re-opens at 7am except uSOURCE opens at 9am

 

Please check our System Availability page for information on all systems.

 

For information on the impact of the year-end closing dates on reporting and processing, refer to the Financial Services website.

 

Please note that the Fiori Launchpad Reporting will be available.

 

Sincerely,

Enterprise Applications & Solutions Integration (EASI)

AMS Password Reset Available in the Enterprise Service Centre 

Date: April 17, 2023
To: AMS SAP GUI Users
From: Enterprise Applications & Solutions Integration
Re: AMS Password Reset Available in the Enterprise Service Centre 

 

Dear AMS SAP GUI Users,

As you may be aware, in an effort to streamline processes, increase security and provide an improved user experience, Enterprise Applications & Solutions Integration (EASI) is working to update the current AMS Password Reset process.

Starting today, you can quickly and conveniently reset your AMS SAP GUI password in the Enterprise Service Centre. This new form will provide an automated email that will guide you through the process.

The current form on the EASI website will remain active until June 1, 2023, after which time it will redirect to the Enterprise Service Centre.

If you have questions about the password reset process, please review these FAQs.

Sincerely,
Enterprise Applications & Solutions Integration

Update on Microsoft Teams

Join Connect+Learn for an overview of some recent changes. Updates discussed will include:

  • Delete Chats from your chat list
  • Even more reactions at your fingertips
  • Send your messages later
  • Add people to chat with @mention

 

Resources

Rocket Shuttle Migration Update and Resources

Date:  April 11, 2023
To:  Rocket Shuttle Users
From:  Enterprise Applications & Solutions Integration
Re:   Rocket Shuttle Migration Update and Resources

 

Dear past and present Rocket Shuttle users,

Thank you to those who offboarded from Rocket Shuttle on April 6 in advance of the expiry of the application’s license on May 17, 2023. We will be following up this week with select users who remain to be offboarded.

As mentioned in previous communications, we are offering many resources to support you in the transition to Azure Data Studio and Power BI:

Thank you again for your help with this project and ensuring U of T is prepared for the end of the Rocket Shuttle license.

If you have any questions, please contact Katie Babcock at katie.babcock@utoronto.ca.

Please do NOT process Change of POSt (CHOP) on Thursday, April 13 and Friday, April 14

Date:  April 10, 2023
To: ROSI Users
From:  Student Information Systems
Re: Please do NOT process Change of POSt (CHOP) on Thursday, April 13 and Friday, April 14

 

*** This e-mail is sent on behalf of Student Receivables & Accounting ***

Please do NOT process any batch or online Change of POSt (CHOP) on Thursday, April 13 and Friday, April 14.

If you process a CHOP for a student during this period, the student’s fees will be calculated incorrectly and in a manner that will be very difficult and time-consuming for Student Accounts to correct.

The student’s ACORN Financial Account may be blocked while the corrections are made.

If you must process a CHOP for a student during this period, then you must trigger fees assessment by viewing the student’s invoice and forward an email message to bonnie.vincze@utoronto.ca.

Student Receivables & Accounting is testing the Summer 2023 session fees assessment process during this period, and if the testing is successful, fees assessment will be turned ‘ON’ at 5pm on Friday, April 14 and fees will be available to view on ROSI on Monday, April 17.

Your co-operation is greatly appreciated.

Sincerely,
Student Information Systems

Update to AMS Password Reset

Date: April 5, 2023
To:
AMS SAP GUI Users
From:
Enterprise Applications & Solutions Integration 
Re: Update to AMS Password Reset

 

Dear AMS SAP GUI Users,

In an effort to streamline processes, increase security and provide an improved user experience, Enterprise Applications & Solutions Integration (EASI) is working to update the current AMS Password Reset process.

Starting April 17, you can quickly and conveniently reset your AMS SAP GUI password in the Enterprise Service Centre. This new form will provide an automated email that will guide you through the process.

The current form on the EASI website will remain active until June 1, 2023, after which time it will redirect to the Enterprise Service Centre.

We will provide future updates when this new form is activated.

Sincerely,
Enterprise Applications & Solutions Integration

AMS FI Fiscal Year-End Closure 2023

Date: April 4, 2023
To: AMS Users
From: Enterprise Applications & Solutions Integration 
Re: AMS FI Fiscal Year-End Closure 2023

 

Hi everyone,

This year AMS will close for FI year-end processing on Thursday, April 27, 2023 at 7pm and will re-open on Monday, May 1, 2023 at 7am. 

ERDD and the Capital Projects Portal and Invoice Workflow will resume regular functionality on Monday, May 1, 2023 at 7am, and uSOURCE will resume operation at 9am.

The following summarizes the AMS system availability during the week prior to year-end closing:

Date Status
Tuesday, April 18 System closes for bi-weekly payroll at 6pm
Wednesday, April 19 System re-opens at 7am
Thursday, April 20 System open regular hours
Friday, April 21 System closes for monthly payroll phase 1 and for “Copy Plan to Budget” at 6pm
Saturday, April 22 System re-opens at 7am
Sunday, April 23 System open regular hours
Monday, April 24 System closes for monthly payroll phase 2 at 5pm
Tuesday, April 25 System re-opens at 7am
Wednesday, April 26 System open regular hours
Thursday, April 27 System closed to all users at 7pm
Friday, April 28 System closed to all users
Saturday, April 29 and Sunday, April 30 System closed to all users
Monday, May 1 System re-opens at 7am except uSOURCE opens at 9am

Please check our System Availability page for information on all systems.

For information on the impact of the year-end closing dates on reporting and processing, refer to the Financial Services website.

Please note that the Fiori Launchpad Reporting will remain available.

Sincerely,
Enterprise Applications & Solutions Integration (EASI)