Use Power Query, Power Pivot, DAX, & Excel's data visualization tools to build powerful Business Intelligence solutions
InstructorTravis Cuzick
Free
Instruction moves beyond basic syntax into complex functions like CALCULATE, Time Intelligence (DATEADD, DATESINPERIOD), and ranking functions.
Editorial course preview
These 4 complementary views highlight concrete, legible examples from the course presentation.
This screenshot displays the Power Query Editor interface within Excel, showing a dataset of order details used to demonstrate Extract, Transform, and Load processes.
This diagram illustrates how to mash up datasets in Excel using Power Pivot by establishing relationships between tables like Customers, Orders, and Products.
This slide displays the DAX formula editor interface showing the syntax for creating a dynamic measure using variables and conditional logic.
This dashboard view demonstrates data visualization techniques by combining region and date slicers with a dual-axis chart that tracks profit alongside items sold over time.
The curriculum utilizes dedicated exercise sections following major blocks in Power Query, Data Modeling, DAX, and Visualization.
The volume of formulas and technical topics may require significant manual note-taking due to a lack of provided course documentation.
This course is best suited for Windows-based users looking to move beyond standard spreadsheets into automated, industrial-strength data analysis.
Score breakdown
The curriculum demonstrates depth through advanced DAX functions like Time Intelligence and complex Power Query ETL operations.
Instruction is supported by multiple exercise blocks integrated into the major topical sections.
Learner signals suggest the instruction is clear and concise, though the high volume of topics may make retention difficult without notes.
The curriculum covers essential modern business intelligence tools and functions.
The curriculum aligns well with the goals of aspiring analysts and requires a Windows environment.