Course overview
Using Excel for BI supported by Codex: CSV consolidation with Power Query, Power Pivot data modeling, DAX and building auditable dashboards. Includes practical exercises for each step.
Demonstrates using Power Query to consolidate CSVs and prepare datasets for Excel-based BI.
Explains building a Power Pivot data model and includes a hands-on session to structure the model.
Covers using DAX in Excel with practical exercises to create meaningful measures and calculations.
Addresses designing auditable Excel dashboards: best practices and a lab focused on Excel BI and DAX measures.
4lessons
4lessons
8activities
1exercises
0videos
Skills and topics covered
Access the platform
Open the catalogue to review course details, access conditions, and your personal progress. Sign in.