Data Analytics & BI
Power Query & Power Pivot
Advanced Excel data management course covering Power Query, Power Pivot, data cleaning, transformation, data modelling and automated MIS reporting.
Enquire Now →
WHO CAN JOIN
Eligibility
Advanced Excel students, MIS executives, accountants, data analysts, graduates and working professionals handling business data and reports.
CAREER VALUE
Course Benefits
Automated Data Cleaning, Multiple File Consolidation, Advanced MIS Reporting, Data Modelling, DAX Basics, Dashboard Preparation, Reduced Manual Excel Work, Practical Projects and Certificate.
WHAT YOU WILL LEARN
Course Syllabus
Module 01
Power Query Fundamentals
Module 02
Import Data from Excel & CSV
Module 03
Combine Multiple Files
Module 04
Append & Merge Queries
Module 05
Data Cleaning
Module 06
Data Transformation
Module 07
Split & Merge Columns
Module 08
Pivot & Unpivot Data
Module 09
Custom Columns
Module 10
Data Types
Module 11
Power Pivot Fundamentals
Module 12
Data Model
Module 13
Table Relationships
Module 14
Calculated Columns
Module 15
Measures
Module 16
DAX Basics
Module 17
KPIs
Module 18
Pivot Tables with Data Model
Module 19
Automated MIS Reports
Module 20
Dashboard Preparation and Practical Business Projects.
START YOUR LEARNING JOURNEY
Talk to MCTI →
Ready to learn Power Query & Power Pivot?
Enquire today for latest batch details, fees and available offers.