Minnesota Society of Certified Public Accountants

1650 West 82nd Street, Ste 600
Bloomington MN 55431
Ph: 952-831-2707 Fax: 952-831-7875
www.mncpa.org

Show Menu

Help | Pay an Invoice | My Account | CPE Log | Log in

Webinar

New

CPAxPACK Bundle: Unlock Power BI with Comprehensive Data Analysis

Thursday, May 1, 2025
8 a.m.-4 p.m. Central
10 CPE (10 non-technical)

Course code: 25WX-0469
View pricing

Firm administrators: Please log in before starting the employee registration process.

This CPAx Pack includes four individual sessions for a total of 10 CPE. You receive significant savings when purchasing these webinars as a Pack. Each of the courses runs live once a month beginning May 1, 2025 through April 30, 2026. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this pack, log in instructions will be emailed to you separately for each individual course.

Unlock the full potential of your data with our comprehensive Power BI course bundle, designed to take you from a beginner to an advanced data analyst.

Get started with Power BI to familiarize yourself with the basics of setting up your workspace and learn how to clean, transform, and load data in Power BI. You will master the essential techniques for preparing your data for analysis. This bundle dives deeper into how to create measures in Power BI to help master the art of tracking and analyzing key performance indicators. Learn how to bring Power BI and Data Analysis together to integrate your skills to perform sophisticated data analysis and create compelling visualizations.

Each course is meticulously crafted to provide you with practical knowledge and hands-on experience, ensuring you can confidently use Power BI to transform raw data into actionable insights.

Join us and elevate your data analysis skills to new heights. Enroll today and become a Power BI expert!

Major subjects

Course 1: Get started with Power BI | CPE: 2 | Description: 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.
Course 2: Clean, transform & load data in Power BI | CPE: 2 | Description: This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities.
Course 3: Create measures in Power BI that define your Metrics | CPE: 4 | Description: Starting with the foundational elements of DAX, you'll rapidly progress to tackle advanced formulas and time-intelligent functions, essential for nuanced data analysis. The highlight of the course is the emphasis on the DAX calculation process, a crucial aspect for validating measures in Power BI. Additionally, the practical application of PivotTables for measure validation will equip you with the skills to confirm the accuracy and effectiveness of your data measures. These advanced techniques are not just theoretical concepts but are presented through engaging, real-world scenarios, enabling you to apply your learning immediately to your daily tasks.
Course 4: Power BI - Bringing It All Together for Data Analysis | CPE: 2 | Description: Building on the foundational knowledge from previous courses, this session focuses on the crucial next steps after creating data models and measures, guiding participants on how to fully utilize the potential of these tools to uncover insights and create impactful, actionable visualizations. This course takes a deep dive into the critical aspects of using Power BI to its fullest potential, emphasizing a holistic approach to data analytics. You'll learn how to build a streamlined workflow, ensuring every step in your data journey contributes to actionable insights.

Learning objectives

Identify the differences and synergies between Excel's Power BI tools and the standalone Power BI tools, enabling a clear understanding of when and how to use each tool effectively in various business scenarios
Distinguish between the various functionalities and use cases of Power BI tools, empowering participants to select the most appropriate Power BI tool for specific data analysis and reporting needs in their professional roles
Identify the key features and functionalities of Microsoft Power Query
Distinguish between different data transformation techniques in Power Query, including data cleaning, merging, and pivoting
Apply advanced DAX formulas in Power BI to create dynamic and efficient data measures tailored to specific business needs
Determine the most effective time-intelligent functions in DAX for analyzing temporal data trends and patterns in Power BI
Identify key differences between common DAX functions and their use cases, enabling more strategic and informed decision-making in Power BI measure creation
Choose the appropriate DAX calculation processes for validating and ensuring the accuracy of measures in various data scenarios
Use PivotTables in Power BI to validate and test the effectiveness of DAX measures, enhancing the reliability of data analysis
Categorize the components of an efficient Power BI workflow and identify areas for optimization
Evaluate Power BI performance metrics and apply optimization techniques for enhanced usability
Assess the capabilities of Power BI Services to effectively share, collaborate, and manage data insights across teams and organizations

Who should take this program?

Accountants looking to increase their toolset for data analysis

Pricing

Standard Member Fee	$249.00
Standard Nonmember Fee	$249.00

Our records indicate you are a nonmember. If you register, you will be charged $249.00 (Standard Nonmember Fee). Members: Please log in to receive member fee.

Firm administrators: Please log in before starting the employee registration process.