Use Power Query, Power Pivot, DAX, & Excel's data visualization tools to build powerful Business Intelligence solutions
InstructorTravis CuzickInstruction moves beyond basic syntax into complex functions like CALCULATE, Time Intelligence (DATEADD, DATESINPERIOD), and ranking functions.
The curriculum utilizes dedicated exercise sections following major blocks in Power Query, Data Modeling, DAX, and Visualization.
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 volume of formulas and technical topics may require significant manual note-taking due to a lack of provided course documentation.
The curriculum aligns well with the goals of aspiring analysts and requires a Windows environment.
