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!
The major topics that will be covered in this course include:All courses in this Pack are presented by Bryan Smith.
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
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
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.
After attending this presentation, you will be able to...
Accountants looking to increase their toolset for data analysis.