Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
The data processing and analytical capabilities of Excel can be augmented using Power BI. You’ll encounter highlights and difficulties of using Excel in data analysis. The advantages of employing Power BI tools for data analytics are outlined throughout. You’ll study Power BI essentials, including:
- Interface
- Key features
- Seamless Excel Integration
- Power Pivot for Data Modeling
- Power Query for Data Transformation
Focusing on Power BI’s tools, this session aims to highlight the distinct capabilities and advantages of these tools, equipping you with the proficiency to apply Power BI across diverse business environments. You’ll engage with the following tools:
- Power BI Desktop for advanced data modeling and report generation
- Power BI Service for sharing and collaboration in the cloud
- Power BI Report Server for deploying reports within on-premises infrastructure
Key Topics:
- Data Analytics
- Data Analysis
- Data Modeling
- Data Sharing
- Key Performance Indicators (KPIs)
- Dashboards
- Machine Learning Capabilities
This course is 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:
- Identify the differences between Power BI with Excel and standalone Power BI.
- Distinguish between specific data analysis and reporting functions of Power BI.
- Recognize how to efficiently integrate Power BI with Excel functions of data processing, analysis and visualization tasks to develop powerful organizational data analysis strategies.
Who Will Benefit
Finance Professionals looking to enhance their data analysis skills and increase their knowledge of Microsoft Power BI.
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.