This session introduces Power Query and Power Pivot to help automate data preparation and build scalable data models. Participants will learn how to connect multiple datasets and streamline reporting workflows.
Learning Outcomes:
Automate data cleaning
Connect multiple datasets
Build data models
Create basic DAX measures
Recommended Prerequisite: Participants should have strong working knowledge of Excel, including experience with formulas, tables, and basic data analysis. Completion of Advanced Excel: Data Tools for Decision-Making or equivalent hands-on experience is strongly recommended.