Power BI, Power Query & Data Cleaning – Beginner to Advanced

LIVE

55 Hours

₹ 18,000 1-on-1 Class

Just Pay ₹9,999 to Register

- OR -

Course offered by Arpan Pal

12 reviews

Certified

overview batches reviews

Learn Power BI, Power Query and practical data-cleaning techniques through live, hands-on training.

This course is designed for students, working professionals, MIS executives, analysts and job seekers who want to build practical data-analysis and dashboard-development skills.

The training starts with the fundamentals and gradually covers advanced reporting concepts. Students will work with real-world business datasets related to sales, finance, operations and HR.

Topics Covered

Introduction to Power BI Desktop and its interface
Importing data from Excel, CSV, folders and other sources
Data cleaning using Power Query
Removing duplicates, errors, blanks and unwanted records
Changing data types and handling missing values
Split, merge, append and group data
Pivot and unpivot operations
Combining multiple files automatically
Creating relationships between tables
Introduction to data modelling and star schema
Creating calculated columns and measures
DAX functions such as SUM, COUNT, CALCULATE, IF, SWITCH and DIVIDE
Building KPI cards, charts, tables, matrices and slicers
Creating interactive dashboards
Drill-down, drill-through, filters and tooltips
Dashboard formatting and visualisation best practices
Publishing and sharing Power BI reports
Practical interview questions and project guidance

What Students Will Learn

By the end of the course, students will be able to:

Clean and transform raw business data
Automate repetitive data-preparation activities
Build structured Power BI data models
Create DAX measures and business KPIs
Develop professional and interactive dashboards
Analyse sales, finance, HR and operational data
Create an end-to-end Power BI project for their resume or portfolio

Course Features

Live instructor-led classes
Practical exercises during every session
Real-world datasets and business scenarios
Assignments and practice files
Doubt-clearing support
Interview preparation
Resume and project guidance
One complete dashboard project

Who Can Join?

Beginners with no Power BI experience
Students and fresh graduates
MIS and reporting professionals
Data and business analyst aspirants
Finance, sales, HR and operations professionals
Excel users who want to move into data analytics

Prerequisites

Basic knowledge of Excel is helpful but not compulsory. No programming experience is required.

About the Trainer

5 Avg Rating

11 Reviews

22 Students

8 Courses

Arpan Pal

EPGP in Data Science (Business Intelligence & Analytics), IIIT Bangalore | MBA in Marketing | B.Com in Accounting | Certified Data Analyst

6 Years of Experience

I am a Data Analytics and MIS Reporting professional with over 4 years of industry experience and 3 years of teaching experience. My expertise includes Advanced Excel, Power BI, SQL, Power Query, dashboard development, KPI reporting, data cleaning and reporting automation.

I have worked on practical business requirements related to sales, revenue operations, finance, collections, employee performance and management reporting. This industry exposure enables me to teach not only software features but also how these tools are applied in real jobs.

My training is practical, structured and job-oriented. Students learn through live demonstrations, real-world datasets, assignments, interview questions and end-to-end projects. I explain every concept step by step, from fundamentals to advanced applications, and ensure that students understand the business logic behind every formula, query, KPI and dashboard.

I train students, fresh graduates, MIS Executives and working professionals preparing for Data Analyst, MIS Analyst, Reporting Analyst, Business Analyst and Power BI roles. Classes are customised according to the learner’s current knowledge and career goals. Training is available in English, Hindi and Hinglish, with dedicated doubt support, interview preparation and project guidance.