Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
This nine-part bundle will help you develop the skills necessary to use Microsoft Power BI tools, which will allow you to perform enhanced data analysis.
In 2010, Microsoft released PowerPivot, a new data analysis tool that removed the weaknesses of Excel PivotTables. PowerPivot took Excel from a low-end data analytics tool to one of the most sophisticated and comprehensive tools used. Since 2010, Microsoft has continued its development of end-user data analysis tools. This entire suite of products is called Power BI.
These courses are presented using Excel 2019/Office 365, but most concepts covered apply to all versions of Excel.
Courses Include:
- Get Started with Power BI
- Prepare Your Data Efficiently for Excel Analysis
- Analyze Your Data with Excel Pivot Tables
- Create Excel Dashboards for Maximum Impact
- Use Power Query to Transform Your Data
- Go Beyond Pivot Tables with Power Pivot
- Use Advanced Calculations with Dax Formulas
- Create Visuals in Power BI to Successfully Analyze Data
- Leverage PowerBI.com to Create Data Analysis for Others
Key Takeaways
By the end of this course, you will be able to:
- Recognize how Power BI tools can help with your data analysis needs.
- Identify uses for each Power BI tool.
- Select which Power BI tool will meet your organization's strategy.
Who Will Benefit
Finance Professionals looking to enhance their data analysis skills and increase their knowledge of Microsoft Power BI tools.
Disclaimer
Most of CPA Ontario's 450+ on-demand courses are compatible with the mobile app. Unfortunately, this on demand course is not compatible. For the best learning experience, we suggest you use your computer.
How to Access the Course
To access your course, visit the CPA Ontario Blackboard site and sign in using the same username and password used for the Registration Portal.
Important: Course access begins on the date of purchase and remains available for the Access Time specified for the course under Dates and Location. Please review the access time before purchasing. Note that it may take up to 15 minutes after registration for the course to appear in Blackboard.
Registration, cancellation, withdrawal, and 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.