IPT EXCEL SCHOOLLEARN • AUTOMATE • ANALYSE
Free demo class
← All courses IPT EXCEL SCHOOL · LIVE ONLINE COURSEPower BI MasterclassDashboard · DAX · Data Analytics · Business IntelligenceBasic to AdvancedPower Query and DAXPython in Power BI40+ Real-time DashboardsData Modeling35 to 45 hours · Live online · 30-day course outline
COURSE 13 / 15

Power BI Masterclass: Dashboard, DAX, Data Analytics & Business Intelligence

Learn Power BI from basic to advanced in live online classes: Power Query data transformation, data modeling, 200+ DAX functions, interactive reports and 40+ real-time dashboards built on real data.

35 to 45 hoursBasic to AdvancedLive online200+ DAX functions40+ real-time dashboards21 years trainer
Book a free demo →⬇ Download course PDFCall Sujeet Sir for fees

Course highlights

35-45HoursLive online classes
200+DAX functionsCovered in the course
40+DashboardsReal-time data projects
8-10ProjectsOne-to-one or group class
Sujeet Sir, trainer of the Power BI Masterclass, 21 years experience
YOUR TRAINER

Sujeet Sir

21 Years Exp.

Excel | VBA | Power BI | SQL | Python

Data Analytics Expert & Corporate Trainer

  • Sujeet Kumar Singh (MCA), founder of IPT Excel School since 2007
  • Worked as MIS Executive and VBA Developer in 10+ companies
  • Report consultant for 40+ organizations

What you will learn

1
Power BI basics and Business Intelligence

Installation, architecture, Power BI vs Tableau vs QlikView and basic components.

2
Power BI Desktop and data sources

Connect SQL Server, Oracle, SAP, Google Sheet, JSON, XML, CSV, Web and OData feeds.

3
Data transformation with Power Query

Clean, shape and transform rows, columns, text, numbers and dates.

4
Data modeling and relationships

Fact and dimension tables, relationships vs merged tables, and 1 crore row data.

5
Charts, reports and interactive visuals

Matrix, slicers, maps, KPI cards, custom visuals, bookmarks and page layout.

6
DAX: 200+ functions

Calculated columns, measures, filters and time intelligence for real analysis.

7
40+ real-time dashboards

Sales, finance, HR, marketing, healthcare, supply chain and IT dashboards.

8
Web portal, Python and advanced analytics

Share, embed and publish reports, use Python scripts, parameters and Smart Narrative.

BENEFITS

  • Build interactive Power BI reports and dashboards from real data
  • Master DAX with 200+ functions, from basic to advanced
  • Handle large data, even 1 crore (10 million) rows
  • Publish, share and embed dashboards on the web

YOUR GOAL

Become a confident Power BI user who can model data, write DAX and build real-time dashboards for business.

WHO SHOULD LEARN

Students, MIS executives, accountants, analysts and office staff who want to move from Excel reports to Power BI dashboards.

COURSE OUTLINE

⬇ Download PDF
Power BI skills covered
  • Desktop Layout
  • Data Transformation
  • DAX Commands
  • Charts and Page Layout
  • Reports and Dashboards
  • Advanced Analytics
  • Level: Basic to Advanced
Module 1 - Introduction to Power BI
  • Installation of Power BI
  • Introduction to Business Intelligence
  • Power BI vs Tableau vs QlikView
  • Uses of Power BI
  • Basic Components of Power BI
  • Power BI Architecture
Module 2 - Power BI Desktop and Data Sources

Getting started Desktop layout and views

  • Data Sources in Power BI Desktop
  • Loading Data in Power BI Desktop
  • Views in Power BI Desktop
  • Query Editor in Power BI
  • Transform, Clean, Shape and Model Data

Connect to data Sources and connection types

  • SQL Server, Oracle and SAP
  • Google Sheet, JSON and XML
  • CSV, Web and OData Feed
  • Types of connection

Power BI components The building blocks

  • Power Query
  • Power Pivot
  • Power View and Power Map
Module 3 - Power Query for Data Transformation

Query Editor basics Clean and reshape data

  • Power Query Introduction
  • Query Editor
  • Transformation GUI
  • Row Transformations
  • Column Transformations
  • Data Type

Add and calculate New columns and calculations

  • Adding Column
  • Text Transformations
  • Number Column Calculations
  • Date and Time Calculation
Module 4 - Data Modeling and Large Data
  • Data Normalization
  • Fact Tables vs Dimension Tables
  • Managing Data Relationships
  • Relationships vs Merged Tables
  • Working with large data like 1 crore (10 million) rows
Module 5 - Data Visualization

Visuals Charts, tables and maps

  • Introduction to Visuals in Power BI
  • Visualization Charts in Power BI
  • Matrixes and Tables
  • Slicers and Map Visualizations
  • Gauges and Single Number Cards
  • KPI Visuals
  • Custom Visuals

Design and layout Make reports look professional

  • Modifying Colours in Charts and Visuals
  • Shapes, Text Boxes and Images
  • Page Layout and Formatting
  • Bookmarks and Selection Pane
  • Z-order
Module 6 - DAX Functions and Statements (200+ functions)

DAX basics Foundation

  • Introduction to DAX
  • Importance of DAX
  • Data Types in DAX
  • DAX Calculation Types
  • DAX Syntax
  • DAX Operators

Calculations Columns, measures and tables

  • Steps to Create Calculated Columns
  • Measures in DAX
  • DAX Functions
  • DAX Tables and Filtering
  • Creating Calculated Columns and Measures
  • Performing Data Analysis using DAX

Advanced DAX Queries and advanced functions

  • DAX Query
  • Advanced DAX Functions
  • 200+ DAX functions: Logical, Text, Date, Time Intelligence, Filter, Table, SUMX and more
Module 7 - Power BI Dashboard
  • Creating a Dashboard
  • Power BI Q&A
  • Power BI Embedded
  • Bookmarks and Buttons
  • 40+ real-time dashboards on real data (full list below)
Module 8 - Power BI Web Portal and Server
  • Creating a Dashboard on Web
  • Configuring a Dashboard
  • Power BI Embedded
  • Creating QR Code for Report
  • Share Dashboard as PDF, PPT and Web Link
  • Creating Dashboard Public Web Link
  • Embedded Dashboard on Web Page
Module 9 - Python in Power BI
  • Python Scripts in BI
  • Python integration with Power BI
Module 10 - Advanced Analytics in Power BI
  • Use Parameters
  • Introduction to Smart Narrative
  • Advanced Get More Visuals
  • Handling Workspaces
Dashboards (40+ real-time dashboards, 43 listed)

Sales, Retail and Marketing 11 dashboards

  • 1 : Sales Dashboard
  • 2 : Product Sales Data Analysis
  • 3 : Retail Analysis
  • 4 : Sales Target vs Achievement Dashboard
  • 5 : Monthly Sales Trend and Seasonality Dashboard
  • 6 : Branch and Regional Performance Dashboard
  • 7 : Product Profitability Dashboard
  • 8 : E-Commerce Sales and Returns Dashboard
  • 9 : Marketing Dashboard
  • 10 : Marketing Campaign Insights Analysis
  • 11 : Digital Marketing and ROI Dashboard

Customer, Web and Media 4 dashboards

  • 12 : Customer Analysis Dashboard
  • 13 : Customer Segmentation Dashboard
  • 14 : Web Traffic Dashboard
  • 15 : OTT Media Dashboard

Finance and Banking 7 dashboards

  • 16 : Financial Performance Analysis
  • 17 : Profit and Loss Dashboard
  • 18 : Revenue and Expense Dashboard
  • 19 : Budget vs Actual Dashboard
  • 20 : Receivables, Payables and Collection Dashboard
  • 21 : Loan Application Analysis
  • 22 : Banking and Loan Collection Dashboard

HR and Education 5 dashboards

  • 23 : HR Analytics Dashboard
  • 24 : Recruitment and Hiring Funnel Dashboard
  • 25 : Attendance and Workforce Productivity Dashboard
  • 26 : Payroll and Compensation Dashboard
  • 27 : Education Dashboard

Operations, Supply Chain and IT 8 dashboards

  • 28 : Inventory Stock Analysis
  • 29 : Supply Chain Dashboard
  • 30 : Purchase and Supplier Performance Dashboard
  • 31 : Logistics and Delivery Performance Dashboard
  • 32 : Manufacturing, Production and Quality Dashboard
  • 33 : Project Management Dashboard
  • 34 : IT Operations Dashboard
  • 35 : Energy Usage Analysis

Healthcare and Service 4 dashboards

  • 36 : Healthcare Sales Analysis
  • 37 : Hospital and Healthcare Operations Dashboard
  • 38 : Customer Service and Complaint Dashboard
  • 39 : Call Center and SLA Performance Dashboard

Executive and MIS 4 dashboards

  • 40 : Custom KPI Dashboard
  • 41 : Executive KPI Scorecard Dashboard
  • 42 : Multi-Department MIS Dashboard
  • 43 : CEO Executive Dashboard: Final Capstone Project

Dashboard tools Used in every dashboard

  • Slicers and interactive filters
  • KPI cards, matrix and map visuals
  • Bookmarks, buttons and the selection pane
  • DAX measures behind every number

Full course outline (PDF)

Power BI course outline PDF, page 1 of 2Power BI course outline PDF, page 2 of 2

Your browser cannot show the PDF inline. Open the PDF or download it.

⬇ Download course outline PDF

COURSE DETAILS

Duration35 to 45 hours
LevelBasic to Advanced
ModeLive online
Class typeOne-to-one or group class
Dashboards40+ real-time dashboards
Projects8 to 10 projects
DemoFree demo class
FeesContact Sujeet Sir: +91 88025 79388

HOW IT IS TAUGHT

Live online by Sujeet Sir with practical, real-world examples. You build dashboards on real data in every module, so you can use the skills directly at work.

Join a free demo

Questions about this course

What is the fee of the Power BI Masterclass course?

Fees depend on one-to-one or group class. Contact Sujeet Sir on +91 88025 79388 or WhatsApp for the current fee.

Is there a free demo?

Yes. Join the free demo class before you pay.

How many dashboards will I build?

The course covers 40+ real-time dashboards on real data, along with 8 to 10 projects.

Are the classes live or recorded?

Classes are live online, as one-to-one or group classes.

← Tableau DesktopMIS Report Automation →

🎥 Video Courses

Prefer to learn at your own pace? Watch IPT video courses anytime on our learning app.

Watch video courses →
Chat on WhatsApp