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:
- Introduction to MS Power BI Tools
- 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
This is an online session. This course is available 24 hours a day, 7 days a week. Once registered, you can access the material at any time.
However, you will only have access to the course for 90 days after REGISTRATION.
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.