Summary

Learning Outcomes

• Master the art of data manipulation and transformation using Power Query, allowing you to efficiently clean, shape, and combine data from various sources.
• Excel in advanced data analysis and modeling with Power Pivot, empowering you to create dynamic relationships, calculated measures, and insightful dashboards.
• Automate your data workflows  saving you time and ensuring your reports are always up-to-date.
  

Who should attend?

• Analyst working in excel   

Day 1

Mastering Power Query 

Focus: Data cleaning and preparation in Excel and Power Query 

Session 1

Introduction to Power Query 

Session 2 

Data Transformation Basics

Session 3

Advanced Data Cleaning

Session 4

Loading Data for Analysis

Day 2

Session 5

Building Dashboards with Power BI

Focus: Visualization and reporting in Power BI.

Session 6

Data Modeling Essentials 

Session 7

Building Visualizations 

Session 8

Sharing and Collaboration

Trainer Profile

The trainer is a principal engineer at one of the leading investment management firms and leads the Research vertical with building, enhancing, and automating various models on fixed income and currency domains. He is a versatile practitioner having rich experience in handling machine learning and programming tools like R and Python. He is also a visiting faculty on data science for management colleges and have designed and built data science courses like Python, R, Tableau, Machine Learning, NLP, Neural Networks, data mining for them. He is a computer engineer and MBA by education.

Training dates - March 17-18, 2026

Training fees - ₹ 30,000 + applicable taxes