See how live online training works in this brief video.
All Power BI classes include
Free retake
Detailed curriculum
Live instructor
Flexible rescheduling
Certificate of Completion
Small class sizes
Course recording
Power BI Course Online August 28, 2026 Transforming Data
Power BI course for transforming data
$495.00
The Power BI Course is a comprehensive program designed to equip participants with the expertise to maximize Power Query's capabilities in Power BI. The training begins with a detailed overview of Power Query, emphasizing its integration with Power BI and Excel. Participants gain mastery over accessing various data sources, including querying relational databases, extracting data from files, and effectively utilizing diverse data sources. The course then delves into the transformation of data using Power Query, covering essential topics such as query steps, column manipulation, row filtering, table sorting, and custom column creation. Participants will also become adept in the M language, learning to write M in the Query Editor, understanding M language concepts, and establishing relationships between tables in the model. Additionally, the curriculum explores working with multiple queries, enabling participants to use one query as a source for another, handle data from various external sources, and strategically merge and append queries. The course offers real-world Power Query examples, encompassing calculations, table transformations, and effective data handling from the web.
Topics covered in Power BI course for transforming data
Understanding Power Query
- Empowering Power BI with Dynamic Data Transformation
- Seamless Synergy: Power Query and Excel
- Mastering Power Query Concepts
- Guided Tour: Working with Power Query
Diverse Data Sources
- Creating Relational Database Queries
- Data Extraction Wizardry to collect data from Various Sources
- Beyond the Basics: Exploring Data Sources
Data Transformation Magic with Power Query
- Decoding Query Steps for Efficient Transformations
- Column Mastery: Techniques for Effective Data Handling
- Row Revolution: Filtering with Precision
- Table Tidbits: Sorting Strategies
- Transformative Values: Changing the Game
- Flexibility Unleashed: Unpivoting Columns and Rows
- Table Tango: Transposing for Better Perspectives
- Custom Columns: Crafting Data to Your Needs
M Language Demystified
- Crafting M in the Query Editor Canvas
- M Language Unveiled: Key Concepts Explored
- Building Bridges: Relationships in the Model
- Lists, Records, and Tables: M's Building Blocks
- Functionality Amplified: The Power of Functions
Synergizing Multiple Queries
- One Query to Rule Them All: Source Utilization
- Harmony in Diversity: Blending Data from External Sources
- Append and Expand: Data Fusion Unleashed
- Merge Mastery: Blurring the Lines between Queries
- Calculated Fields: Explicit Expressions in Action
Introduction to AI in PowerBI
- Using copilot to add insight
- Using AI to assist with reporting
Bonus Content: Power Query Guides
- Crunching Numbers: Calculations That Count
- Table Talk: Transformations That Matter
- Web Wonders: Unveiling Data from the Web
Why Power BI classes at AGI are the best option for you
- Hands-on learning: Learn Power BI quickly with our proven teaching methods.
- Exceptional curriculum: AGI has delivered Power BI training to thousands over 25 years.
- Expert instructors: Our instructors are Power BI experts and skilled educators.
- Small class sizes: Receive personalized attention with 10 or fewer participants per class.
- Repeat for Free: If you need a refresher or miss a class day, retake the Power BI class at no cost.