Data analytics · Course by Ravindra Bagale
Power BI Course
Power BI from beginner to job-ready: Power Query, data modelling, DAX, visuals, Service and security.
A free online Power BI course for beginners, from Power Query and DAX to dashboards. The lessons are in simple English with Marathi phrases, and Ravindra Bagale's online and offline Power BI classes are taught in Marathi and Hindi.
Start with “How to Read This Book” → Continue → Read in Marathi · मराठीत वाचा Become certified, sign up
Trainer: Ravindra Bagale
Learning roadmap
Follow the steps top to bottom. Each step builds on the one above.
-
1
Get data & clean
Desktop tour, connectors, Power Query, folder combine
Ch 1–10 -
2
Model & DAX
Relationships, hierarchies, measures, CALCULATE
Ch 11–13 -
3
Visuals & reports
Charts, maps, drill, bookmarks, filters, design
Ch 14–24 -
4
Service & delivery
Publish, RLS, performance, end-to-end project, KPIs
Ch 25–36 -
5
Advanced
Workspaces, gateways, advanced DAX, composite models, every data source
Ch 37–52
Course chapters
The main handbook — 52 chapters in the course count, 382 concepts listed below. Open a chapter, or expand its concept list.
Part 1 · Get data to first visuals
Show 12 concepts
- 4.1 Database Terms in Simple Words
- 4.2 Connecting to Microsoft SQL Server
- 4.3 Advanced Options and Native SQL Queries
- 4.4 Query Folding with Databases and View Native Query
- 4.5 Connecting to MySQL
- 4.6 DirectQuery in Practice
- 4.7 Import vs DirectQuery vs Live Connection – Clearly Explained
- 4.8 The On-premises Data Gateway
- 4.9 Data Source Settings, Changing Sources and Privacy Levels
- 4.10 Connecting to PostgreSQL
- 4.11 Azure Sources
- 4.12 SQL for Power BI: Views, Joins, CTEs and Where to Transform
Show 8 concepts
- 5.1 The Web Connector
- 5.2 Scraping an HTML Table (Worked Example)
- 5.3 Many Pages: Pagination with a Parameter and a Custom Function
- 5.4 JSON APIs with Web.Contents and Json.Document
- 5.5 Google Sheets Connector
- 5.6 Alternative: Publish a Google Sheet as CSV and Use the Web Connector
- 5.7 Refreshing Web Data and Ethics
- 5.8 XML Files
Show 25 concepts
- 7.1 A Cleaning Workflow You Can Repeat
- 7.2 Data Profiling Tools
- 7.3 Messy Excel Exports: Title Rows, Headers, Footers and Transpose
- 7.4 Removing Duplicates (Full Row and by Key)
- 7.5 Blanks and Nulls: Remove, Replace, Fill Down / Fill Up
- 7.6 Extra Spaces, Non-printable Characters and Text Case
- 7.7 Wrong Data Types and Indian Date Formats (Using Locale)
- 7.8 Numbers Stored as Text, ₹ Symbol and Commas
- 7.9 Inconsistent Spellings and Standardisation
- 7.10 Split Columns (All Six Methods, Plus Split into Rows)
- 7.11 Merge Columns
- 7.12 Extract: Length, First/Last Characters, Range and Delimiters
- 7.13 Phone Numbers, E-mails and PIN Codes
- 7.14 Dates and Times: Parts, Split DateTime, UTC to IST, Age and Duration
- 7.15 Errors: Remove, Replace, Keep and try … otherwise
- 7.16 Outliers and Invalid Values
- 7.17 Unpivot and Pivot
- 7.18 Keep / Remove Rows, Sort and Filter
- 7.19 Rounding
- 7.20 Combine Files from a Folder (Quick Version)
- 7.21 Append Queries (Stack Rows)
- 7.22 Merge Queries and All Join Kinds
- 7.23 Group By (Basic and Advanced)
- 7.24 Conditional Column, Index Column and Column From Examples in Cleaning
- 7.25 Case Study: Cleaning a Messy Blinkit Export End to End
- Practice and Answer Key: Data Cleaning in Power Query
Show 13 concepts
- 8.1 The Add Column Tab at a Glance
- 8.2 Column From Examples
- 8.3 Custom Column
- 8.4 Invoke Custom Function
- 8.5 Conditional Column
- 8.6 Index Column
- 8.7 Duplicate Column
- 8.8 From Text: Format, Merge Columns, Extract, Parse
- 8.9 From Number: Statistics, Standard, Scientific, Trigonometry, Rounding, Information
- 8.10 From Date & Time: Date, Time, Duration
- 8.11 DAX Calculated Columns
- 8.12 Calculated Columns vs Measures in Depth
- 8.13 Implicit vs Explicit Measures, Measure Tables, Display Folders and Formatting
- Practice and Answer Key: Calculated Columns vs Measures
Show 8 concepts
- 9.1 The Files and Their Layout
- 9.2 Connect to the Folder
- 9.3 Filter Out Hidden, Temporary and Unwanted Files
- 9.4 Combine Files and the Helper Queries
- 9.5 Clean One File in Transform Sample File
- 9.6 Add Month from Source.Name and Categorise Transactions
- 9.7 A File with an Extra Column or Different Headers
- 9.8 Automatic Refresh When a New Month Arrives
- Practice and Answer Key: Combine Files from a Folder
Show 9 concepts
- 10.1 What Is a Parameter and Why Use It?
- 10.2 Creating a Parameter (Manage Parameters Dialog)
- 10.3 Parameterising a File or Folder Path
- 10.4 Parameterising Server and Database (Dev, then Prod)
- 10.5 Date-range Parameters for Filtering
- 10.6 Using Parameters Elsewhere in M
- 10.7 Templates (.pbit) with Parameters
- 10.8 Incremental Refresh with RangeStart and RangeEnd (Overview)
- 10.9 What-if Parameters and Field Parameters Are Different
Show 12 concepts
- 11.1 Why Data Modelling Matters
- 11.2 Fact Tables and Dimension Tables
- 11.3 Star Schema vs Snowflake Schema
- 11.4 Relationships
- 11.5 The Date Table
- 11.6 Hierarchies and Groups
- 11.7 Model View Properties
- 11.8 Modelling Best Practices
- 11.9 A Flat Table versus a Dimensional Model
- 11.10 Role-Playing Dimensions
- 11.11 Bridge Tables and Many-to-Many
- 11.12 Perspectives
- Practice and Answer Key: Data Modelling (Star Schema)
Show 27 concepts
- 13.1 What is DAX?
- 13.2 Calculated Columns vs Measures (Recap)
- 13.3 Evaluation Context
- 13.4 DAX Syntax
- 13.5 Base Measures for the Quick-Commerce Model
- 13.6 Aggregation Functions
- 13.7 Logical Functions
- 13.8 CALCULATE – The Most Important Function
- 13.9 FILTER
- 13.10 ALL, ALLEXCEPT, REMOVEFILTERS, ALLSELECTED
- 13.11 RELATED and RELATEDTABLE
- 13.12 USERELATIONSHIP
- 13.13 VALUES, SELECTEDVALUE, HASONEVALUE
- 13.14 Text Functions
- 13.15 Date Functions
- 13.16 Time Intelligence
- 13.17 Ranking: RANKX and TOPN
- 13.18 Variables: VAR and RETURN
- 13.19 Other Useful Functions
- 13.20 PREVIOUSMONTH, PREVIOUSYEAR, DATESMTD and Rolling 30 and 90 Days
- 13.21 KEEPFILTERS, and How a Slicer Hits a Measure
- 13.22 LOOKUPVALUE, TREATAS and CROSSFILTER
- 13.23 Virtual Tables
- 13.24 Weighted Averages and FILTER inside an Iterator
- 13.25 IFERROR, Blank versus Zero, and Circular Dependency
- 13.26 Dynamic Segmentation, Pareto and ABC
- 13.27 DAX Query View
- Practice and Answer Key: DAX Measures and CALCULATE
Show 27 concepts
- 14.1 Creating a Visual Step by Step
- 14.2 The Format Pane: Visual Tab, General Tab and Analytics
- 14.3 Choose the Right Chart
- 14.4 Bar and Column Charts (Stacked, Clustered, 100% Stacked)
- 14.5 Line, Area and Stacked Area Charts
- 14.6 Line and Column Combo Charts
- 14.7 Ribbon Chart
- 14.8 Waterfall Chart
- 14.9 Funnel Chart
- 14.10 Scatter and Bubble Charts (with Play Axis)
- 14.11 Pie, Donut and Treemap
- 14.12 Map, Filled Map, Shape Map and Azure Map (Summary)
- 14.13 Gauge
- 14.14 Card, Card (new) and Multi-row Card
- 14.15 KPI Visual
- 14.16 Slicer
- 14.17 Table
- 14.18 Matrix
- 14.19 AI Visuals: Decomposition Tree, Key Influencers, Q&A, Narrative
- 14.20 Text Box, Image, Shapes and Buttons
- 14.21 R and Python Visuals, and Custom Visuals from AppSource
- 14.22 Small Multiples and Visual Calculations (Quick Look)
- 14.23 The Analytics Pane
- 14.24 Sparklines in a Table or Matrix
- 14.25 Visual Calculations (Version-Dependent)
- 14.26 Anomaly Detection on a Line Chart
- 14.27 Copilot in Power BI
Part 2 · Interaction, Service & projects
Show 8 concepts
- 20.1 The fx Button
- 20.2 Dynamic Titles with Measures
- 20.3 Showing Several Selected Cities (CONCATENATEX)
- 20.4 Text Box with Dynamic Values and Smart Narrative
- 20.5 Cards with Dynamic Labels
- 20.6 Conditional Formatting: Rules, Gradient and Field Value
- 20.7 Data Bars, Icons and Web URLs
- 20.8 KPI-based Colouring in Charts and Cards
Show 8 concepts
- 21.1 Field Parameters: Switch Measures
- 21.2 Field Parameters: Switch Dimensions (Dynamic Axis)
- 21.3 The Older Method: Disconnected Table + SWITCH
- 21.4 What-if Parameters (Numeric Range)
- 21.5 Dynamic Top N with a Parameter
- 21.6 Chart/Table Toggle (Recap)
- 21.7 Calculation Groups and Time Intelligence Items
- 21.8 Field Parameters or a Calculation Group
- Practice and Answer Key: Parameters and Top N
Show 12 concepts
- 22.1 The Filters Pane and Its Levels
- 22.2 Basic and Advanced Filtering
- 22.3 Measure Filters (Visual Level)
- 22.4 Top N Filter
- 22.5 Relative Date and Relative Time Filters
- 22.6 Locking, Hiding, Renaming and Formatting Filters
- 22.7 Slicers: Styles and Settings
- 22.8 Clearing Selections
- 22.9 Sync Slicers Across Pages
- 22.10 Edit Interactions: Filter, Highlight, None
- 22.11 Slicer vs Filter: When to Use Which
- 22.12 How All Filters Combine
- Practice and Answer Key: Filters, Slicers and Interactions
Show 17 concepts
- 25.1 What is the Power BI Service?
- 25.2 Publishing
- 25.3 Workspaces and Roles
- 25.4 Reports vs Dashboards
- 25.5 Sharing and Distribution
- 25.6 Refreshing Data
- 25.7 Gateways
- 25.8 Subscriptions and Alerts
- 25.9 Other Service Features Worth Knowing
- 25.10 When Refresh Fails, and How to Make It Cheaper
- 25.11 Exporting from the Service
- 25.12 Lineage View and Usage Metrics
- 25.13 Dataflows
- 25.14 Deployment Pipelines
- 25.15 Sensitivity Labels and Endorsement
- 25.16 Paginated Reports
- 25.17 Metrics (Scorecards) and Embedding
- Practice and Answer Key: Publish, Share and Refresh
Show 9 concepts
Show 10 concepts
- 28.0 Beginner checkpoints (before you chase polish)
- 28.1 Business Requirements
- 28.2 Step 1 – Prepare the Raw Data
- 28.3 Step 2 – Get Data and Transform in Power Query
- 28.4 Step 3 – Build the Data Model
- 28.5 Step 4 – Create the Measures
- 28.6 Step 5 – Design the Report Pages
- 28.7 Step 6 – Security
- 28.8 Step 7 – Check Performance and Quality
- 28.9 Step 8 – Publish and Automate
Show 13 concepts
- 29.1 Modules 1–2: Introduction and Interface
- 29.2 Modules 3–5: Getting Data, Databases, Web and Google Sheets
- 29.3 Modules 6–7: Power Query Essentials and Data Cleaning
- 29.4 Module 8: Add Column, Calculated Columns and Measures
- 29.5 Modules 9–10: Folder Combine and Parameters
- 29.6 Modules 11–12: Data Modelling, Hierarchies and Groups
- 29.7 Module 13: DAX (with answer hints)
- 29.8 Modules 14–15: Visuals, Formatting and Maps
- 29.9 Modules 16–19: Drill, Drill Through, Tooltips and Bookmarks
- 29.10 Modules 20–22: Dynamic Text and Colour, Dynamic Charts, Filters and Slicers
- 29.11 Modules 23–24: Design, Reports and Dashboards
- 29.12 Modules 25–27: Service, RLS and Performance
- 29.13 Final Assignment: "Blinkit vs Amazon Now – City Performance Report"
Show 10 concepts
- 30.1 Fundamentals
- 30.2 Data Connectivity and Power Query
- 30.3 Data Modelling
- 30.4 DAX
- 30.5 Visualization, Service and Security
- 30.6 Data Cleaning and Add Column
- 30.7 Folders, Parameters, Databases and Web
- 30.8 Hierarchies, Groups, Drill, Tooltips and Navigation
- 30.9 Visuals, Dynamic Formatting, Maps, Filters and Dashboards
- 30.10 Your First Week in a Power BI Job and a Mini Portfolio
Show 12 concepts
- 31.1 How to Answer in Interviews
- 31.2 Deloitte
- 31.3 EY
- 31.4 KPMG
- 31.5 PwC
- 31.6 TCS
- 31.7 Infosys, Wipro and Accenture
- 31.8 Capgemini, Tech Mahindra, HCLTech and LTIMindtree
- 31.9 Genpact, Mu Sigma, Fractal, Amazon and FedEx India
- 31.10 SQL and Excel Questions Paired with Power BI Rounds
- 31.11 Frequently Asked Across MNC Interviews
- 31.12 From Offer Letter to Week 1 on an MNC Client Project
Show 1 concepts
Show 10 concepts
Show 20 concepts
- 36.1 How to Read a KPI
- 36.2 Retail and Quick Commerce
- 36.3 E-commerce
- 36.4 Sales
- 36.5 Finance and Accounting
- 36.6 Banking
- 36.7 Insurance
- 36.8 Healthcare
- 36.9 Pharma
- 36.10 Manufacturing
- 36.11 Inventory and Supply Chain
- 36.12 Logistics
- 36.13 HR
- 36.14 Marketing and Digital Ads
- 36.15 Education
- 36.16 Hospitality
- 36.17 Real Estate
- 36.18 Telecom
- 36.19 IT Services
- 36.20 Government and NGO
Part 3 · Advanced Service & DAX
Show 1 concepts
Show 1 concepts
Show 1 concepts
Show 1 concepts
Show 1 concepts
Show 1 concepts
Show 1 concepts
Show 1 concepts
Course series
Extra series that sit with the handbook — every link kept.
Start here & appendices
Classroom chapters 30
Kept compact so the main course chapters stay first.
Show classroom chapters
- What Is Power BI Desktop vs Service vs Mobile? A Beginner's Tour of Views, Visuals and Saving a .pbix File
- How to Fix US Dates with Locale, Keep ID Columns as Text and Use Fixed Decimal Number in Power Query
- How to Clean Messy Sales Data in Power BI Power Query
- How to Fix DataFormat.Error We Couldn't Convert to Number in Power Query
- How to Create Column and Bar Charts with Date Hierarchy and Drill Down in Power BI
- How to Show Total Orders, Revenue and Sales with Card Visuals in Power BI
- How to Append Multiple Years of Sales Data in Power BI Power Query
- How to Stop Power BI Changing Data Types Automatically and Fix Slow Loading
- How to Clean Text Columns in Power Query with Split, Trim, Clean and Lowercase
- How to Merge Tables in Power BI Power Query (Left Outer vs Inner Join)
- How to Use Filters in Power BI: Visual, Page and Report Level Filters with Top N and Advanced Filtering
- How to Create a Custom Hierarchy and Drill Down by Category in Power BI
- How to Set Up Drill Through to Another Page in Power BI
- How to Create a Custom Report Page Tooltip in Power BI
- How to Clean Store Location Data in Power Query: Remove Units, Split Columns and Capitalize Each Word
- How to Show Top 5 and Bottom 5 in Power BI with Data Labels and Format Painter
- How to Create Relationships in Power BI Instead of Merging Tables (One-to-Many)
- How to Use Column From Examples in Power Query (Get Day Name from a Date)
- How to Add Custom Columns in Power Query: GST, Final Price and Discount Formulas
- How to Create a Conditional Column in Power BI: Weekday vs Weekend (Power Query and DAX IF)
- How to Add an Index Column in Power Query (From 0, From 1 and Custom Start)
- How to Create Your First DAX Measure in Power BI: SUM, Card Visual and Explicit vs Implicit Measures
- How to Change Card Color and Text Dynamically in Power BI (Above or Below Target with DAX IF)
- How to Show Revenue, Sales and Orders in One Chart with Field Parameters in Power BI
- How to Use CALCULATE in Power BI: Show One State's Revenue That Ignores the Slicer (Filter Context Explained)
- How to Create a Measures Table in Power BI and Test DAX in DAX Query View (EVALUATE, SELECTCOLUMNS)
- How to Use Filters and Slicers in Power BI: Visual, Page and All-Pages Filters and Date Slicers
- Clustered vs Stacked Column Chart in Power BI: Bar vs Column, Legend, 100% Stacked and Small Multiples
- How to Format a Column Chart in Power BI: Conditional Color with fx, Axis Range and Data Labels
- How to Use a Line Chart in Power BI: Date Hierarchy, Drill Down and Find Anomalies
Guides, dashboards & more
Every guide, dashboard and template link from the old hub - kept here so the chapters stay near the top.
New here? Start with Power BI vs Tableau
Not sure whether to learn Power BI or Tableau? This easy guide explains the difference, the price and which one to pick, before you begin the course.
Power BI vs Tableau: Differences, Price and Which One to Choose →
Power BI dashboards for 10 industries
Build ten industry dashboards in Power BI Desktop from free Excel practice data: banking, hospitals, retail, education, logistics, hotels and more.
Top 50 company dashboards in Power BI
One Power BI dashboard for each of 50 world-famous companies, built from free example data with tested DAX measures. 50 are live now.
Free guides for this course
Short guides that answer one question each, with the exact steps. Read them next to the chapters.
- Getting startedPower BI vs Tableau: Which One to ChooseWhat a BI tool is · price with a calculator · which one fits you.
- Getting startedInstall Power BI Desktop and Build Your First ReportDownload, then install, then Get data, then one visual, then save .pbix.
- Getting startedBuild Your First Power BI DashboardReport in Desktop, then Publish, then Pin tiles, then arrange dashboard.
- DAX formulasWhat Is DAX? Beginner Guide for Power BIDAX = formulas over the model · start with simple measures.
- DAX formulasMeasures vs Calculated Columns in Power BIColumn = stored per row at refresh · Measure = on-demand with filters.
- DAX formulasHow CALCULATE Works with Filter ContextFilter context = what rows are visible · CALCULATE can change that.
- Power Query and data modellingStar Schema in Power BIFact in the centre · dimensions around · keys relate them.
Frequently asked questions
Is this Power BI course free?
Yes. All 52 chapters and 382 concept pages are free to read online, and you do not need an account.
Is the Power BI course in Marathi?
The lessons on this website are written in simple English with some Marathi phrases in the trainer's voice. In his online and offline classes, Ravindra Bagale teaches in Marathi, with some Hindi.
What does the Power BI course cover?
Getting data, Power Query and data cleaning A–Z, parameters, data modelling, DAX, visuals and formatting, maps, drill, tooltips, bookmarks, filters and slicers, dashboards, the Power BI Service, security, performance, an end-to-end project, industry KPIs with worked fictional sample rows, and interview questions, with Blinkit and Amazon Now sample data (fictional, for learning).
Is this Power BI course for beginners?
Yes. It goes from beginner to job-ready, starting with 1. Introduction to Business Intelligence and Power BI and 2. Installation and Interface Tour.
Which sample data is used?
Blinkit and Amazon Now style sample data. It is fictional and only for learning.
Are there Power BI interview questions?
Yes: 30. Interview Questions and Answers and 31. Interview Questions Asked in MNC Interviews, plus 29. Practice Exercises and Final Assignment.
How do I join online or offline Power BI classes?
Send an enquiry on the enquiry page, or chat on WhatsApp. Ravindra Bagale runs online and offline batches for Power BI, Excel and Data Analytics.
Is this Power BI course available in Marathi?
Yes. The course explains Power BI in Marathi and Hindi as well as English, so you can learn in the language you are comfortable with.
Join an online / offline batch — Enquire now
Ravindra Bagale runs online and offline batches for AWS Cloud, DevOps, DevSecOps, Power BI, Excel, Data Analytics, Data Science and Cyber Security.
Ravi Sir's Cards: Power BI revision, interview and comparison cards · मराठी cards