Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Take the next step with Power Pivot!
This course focuses on using the Power Pivot features to enhance data analysis. Four features of Power Pivot will be reviewed:
- Data model
- Calculations
- Hierarchies
- KPIs
A majority of the course will be spent on building a data model and using calculations. You will learn how to add data to your data model either directly into PowerPivot or from Get & Transform/Power Query.
Key Topics:
- Data modeling
- Basic DAX and calculations
- Calculated columns and measures
- Data models and pivot tables
- Hierarchies
This course is a part of the Microsoft Power BI Bundle.
Please note this course contains an assessment component. Learners are permitted multiple attempts to complete the course assessment with a passing grade.
Key Takeaways
By the end of this course, you will be able to:
- Create a data model using Power Pivot.
- Differentiate between calculated columns and measures.
- Use Power Pivot for data analysis.
Who Will Benefit
Finance Professionals looking to enhance their understanding of using Power Pivot features to enhance data analysis.
How to Access the Course
To access the course please visit our BlackBoard site, and log-in using the same login and password used for the Registration Portal.
Please allow up to 15 minutes after registration for the course to appear on your BlackBoard page.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
Bryan Smith, CPA, CITP, CISA, serves as a trusted adviser to CPAs in public accounting, as well as business and industry, on all aspects of information technology. Bryan’s expertise includes in-depth knowledge of paperless work flow solutions, the impact of technology on internal controls, strategic IT infrastructure design and information security best practices. As a nationally recognized author and presenter on information technology issues impacting CPAs, Bryan is passionate about the opportunities for CPAs to benefit from safe and secure computing.