In this program, you will learn how to use automated data queries to link data from external databases into Excel and then transform this data into Data Models. From there, you will learn how to use Power Pivot and CUBE formulas to streamline the process of summarizing and reporting this data. You will also learn how to take advantage of advanced features such as Data Analysis Expressions, Key Performance Indicators, Hierarchies, and Dimensions to streamline your reporting processes. Further, you will learn how to create compelling visualizations of this summarized data to help your readers understand the true meaning behind the numbers. If you currently use PivotTables on a regular basis and want to take advantage of the powerful advanced reporting features available in Excel, then sign up today for this program. 

Upon completing this course, you should be able to:

• Construct and manage links from external data sources into Excel for the automatic acquisition of data
• Define, build, and manage Data Models and build PivotTables from these objects
• Create PivotTables using Power Pivot, including PivotTables that summarize data from multiple data sources
• Utilize Data Analysis Expressions and other tools to add calculations to PivotTables
• Add features such as Key Performance Indicators, Dimensions, and Hierarchies to Power Pivotbased PivotTables
• Create compelling visualizations of the data in your Power Pivot-based PivotTables using PivotCharts and Power View

How to Register for this Webinar:

1. If you do not yet have a CITT account, click here to create an account. If you already have an account, you'll need to be logged in. If you aren't already logged in, please use the "Sign In" fields to the right. If you've forgotten your login information, you can click here to retrieve your username or reset your password here.
   
   
2. Once you're logged in, click on seminar session you would like to attend. Note: you can choose to attend the full three session package option, individual sessions or a combination of two sessions. Please click on the appropriate check box to select your program. 
   
   
3. If choosing individual or a combination of sessions please double check in the Program box that you have selected the correct options. 
   
   
4. Then click the green Register Myself button
   
   
5. Click the green Proceed to Checkout button

If you need any help registering, please contact Jennifer at jtraer@citt.ca.