Data Analysis with Excel - Using Power Query and Power Pivot
Reference : EX-PQPP-09
Price : Contact us
Level & Prerequisites :
Duration : 2 days
Good knowledge of Excel basics
Description
This course teaches participants how to use Excel’s advanced BI tools—Power Query and Power Pivot—to clean, transform, model, and analyze data. It is ideal for professionals who want to go beyond traditional Excel formulas and leverage modern data analysis capabilities.
Public
Who Should Attend:
Excel users
Data analysts
Finance and business professionals
Course objective
Import and transform data using Power Query
Build data models with Power Pivot
Create relationships and hierarchies
Use DAX for calculations in Excel
Design interactive dashboards
Automate data refresh and reporting
Content
Introduction to Power Query
Data cleaning and transformation
Introduction to Power Pivot
Data modeling and relationships
DAX basics in Excel
Dashboard creation
Practical case studies