December 9, 2025

Webinar

2 CPE

Get started with Power BI

December 9, 2025
Webinar
2 CPE

Get started with Power BI

  • Instructor

    Chris
    Smith

  • Embark on a journey to master Power BI, a powerful tool for data analysis and business intelligence, in our comprehensive course, "Get Started with Power BI." This course is meticulously designed for professionals who seek to understand the full spectrum of Power BI capabilities, including its integration with Excel's Power BI features like Power Pivot and Power Query, and its comparison with standalone Power BI tools such as Power BI Desktop, Power BI Service, and Power BI Report Server. In the first part of the course, participants will be introduced to the fundamentals of Power BI. This includes an overview of Power BI's interface, key features, and its seamless integration with Excel. The course will cover Excel's Power BI tools
  • Power Pivot, for advanced data modeling, and Power Query, for efficient data transformation and preparation. This segment is essential for understanding how Power BI extends and enhances the data processing and analytical capabilities of Excel. The second section of the course delves into the standalone Power BI tools. Here, participants will explore Power BI Desktop for creating complex data models and sophisticated reports, Power BI Service for cloud-based collaboration and sharing, and Power BI Report Server for on-premises report deployment. This part of the course will focus on the unique features and strengths of these standalone tools, providing attendees with the skills to leverage Power BI in a variety of business contexts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Learning Objectives

After attending this presentation you will be able to ...

  • Select the most appropriate Excel functions and features for specific tasks, ensuring optimal efficiency and accuracy in data management and reporting across a range of business applications.
  • Apply advanced Excel features like PivotTables and Array Formulas to streamline complex data analysis and enhance reporting accuracy in diverse professional contexts.
  • Differentiate between the uses of custom sorting and slicers in Excel to enhance data presentation and facilitate more efficient data navigation and analysis.

Major Topics

The major topics that will be covered in this class include:

  • Introduction to Power Query in Power BI: Understanding the interface and basic functionalities.
  • Data Cleaning Techniques: Removing duplicates, handling null values, and data type conversions.
  • Data Transformation: Advanced methods for manipulating data, including pivoting, merging, and appending queries.
  • Data Loading: Efficiently loading data into the Power BI data model.
  • Document the Process Steps: Setting up details for each step in the process so you can document what is happening and why.

CPE Credits Available

2 CPE
2
Computer Software & Applications

Things to Know About This Course

Course Level

  • Overview

Professional Area of Focus

  • Power Bi (Cpax)

Advanced Preparation

None

Intended Audience

Anyone who wants to enhance their analytical skills and embrace the advanced capabilities of Power BI, setting them apart in a data-driven business environment.

Provider

CPA Crossings, LLC

Register For This Event

  • ASCPA Member

    $ 89 89
    Join

  • ASCPA Non-Member

    $ 139 139
    Your Price

Please login to register.