Data Analysis Using Power Tools in Excel (Power pivot & Power Query)

This course is designed to help professionals and students master Power Tools in Excel (Power Query, Power Pivot, DAX, and Power BI integration) for advanced data analysis, reporting, and business intelligence. Participants will learn to clean, transform, model, and visualize large datasets efficiently.

Course Objectives

By the end of this course, learners will be able to:

- Model Data efficiently with Power Pivot
- Import & Clean Data using Power Query (Get & Transform)
-Create Advanced Calculations using DAX (Data Analysis Expressions)
- Build Interactive Dashboards in Excel

Course Contents

Module 1: Introduction to Excel Power Tools

Module 2: Power Pivot & Data Modeling

Module 3: Power Query (Get & Transform Data

Module 4: DAX (Data Analysis Expressions)

Module 5: Advanced Analytics & Visualization

Target Audience

Business Professionals
Data Analysts
Marketing Professionals
Students and Graduates
Anyone interested in learning data analysis using Excel

Pre-requisites

- Basic to intermediate Excel knowledge
- Familiarity with PivotTables

Evaluation Mean(s)

Case Study

Certificate(s) Awarded

Egyptair Training Academy Certificate

Course Code: BTD-DA
Duration: 3 Days
Price: Price [EGP] : 1800.00 - For Egyptians Price [USD] : 150.00 - For Non Egyptians
Registration: Register Here
Course Schedule