Power BI Tutorial for Beginners India 2026
Data Model, DAX, Dashboards & Publishing — Step by Step

What Power BI Is and How to Install It

Connecting Data — CSV, Excel, and SQL Database

-- When connecting to SQL Server, use a custom query to pre-aggregate:
-- This loads a summarised table instead of millions of raw rows

SELECT
    city,
    FORMAT(order_date, 'yyyy-MM') AS month,
    SUM(amount)                   AS total_revenue,
    COUNT(*)                      AS order_count,
    COUNT(DISTINCT customer_id)   AS unique_customers
FROM orders
WHERE order_date >= '2025-04-01'
GROUP BY city, FORMAT(order_date, 'yyyy-MM')

-- In Power BI: Home → Get Data → SQL Server
-- Advanced Options → paste this query → OK

Power Query — Cleaning Data Before It Enters the Model

Power Query transformations (done via the visual interface — no coding needed):

1. Fix a date column stored as text "DD-MM-YYYY":
   → Right-click column → Change Type → Using Locale → Date → Indian format

2. Remove ₹ and commas from "₹1,50,000" amount column:
   → Transform → Replace Values → "₹" → (empty)
   → Replace Values → "," → (empty)
   → Change Type → Decimal Number

3. Unpivot monthly budget columns:
   Before: | Category | Apr | May | Jun | Jul |...
   After:  | Category | Month | Amount |

   → Select the Category column → Right-click → Unpivot Other Columns
   → Rename "Attribute" → "Month", "Value" → "Budget_Amount"

4. Merge two tables (like VLOOKUP):
   → Home → Merge Queries → select lookup table
   → Pick the matching columns → choose Join Kind (Left Outer)
   → Expand the new column to bring in the fields you need

The Data Model — Relationships and Star Schema

// Create a Date Table in DAX (Modeling → New Table):

DateTable =
ADDCOLUMNS(
    CALENDARAUTO(),
    "Year",           YEAR([Date]),
    "Month Number",   MONTH([Date]),
    "Month Name",     FORMAT([Date], "MMM"),
    "Quarter",        "Q" & QUARTER([Date]),
    "Financial Year", IF(MONTH([Date]) >= 4,
                        "FY" & YEAR([Date]) & "-" & RIGHT(YEAR([Date])+1, 2),
                        "FY" & YEAR([Date])-1 & "-" & RIGHT(YEAR([Date]), 2)),
    "FY Month",       IF(MONTH([Date]) >= 4,
                        MONTH([Date]) - 3,
                        MONTH([Date]) + 9),
    "Week Day",       FORMAT([Date], "ddd"),
    "Is Weekend",     WEEKDAY([Date], 2) >= 6
)

// After creating: right-click the table in Model view
// → Mark as Date Table → select the Date column
// This tells Power BI to use this table for time intelligence

DAX Basics — Your First Measures

// 1. Basic aggregation — always start here
Total Revenue = SUM(Sales[Amount])

// 2. Conditional aggregation — equivalent of SUMIFS in Excel
Revenue Delhi = CALCULATE([Total Revenue], Sales[City] = "Delhi")

// 3. Count distinct — unique customers, not total orders
Unique Customers = DISTINCTCOUNT(Sales[CustomerID])

// 4. Percentage of total — each city as % of all India revenue
Revenue % = DIVIDE([Total Revenue], CALCULATE([Total Revenue], ALL(Sales[City])), 0)

// 5. Month-over-month growth using time intelligence
MoM Growth % =
VAR CurrentMonth = [Total Revenue]
VAR PrevMonth    = CALCULATE([Total Revenue], PREVIOUSMONTH(DateTable[Date]))
RETURN
    DIVIDE(CurrentMonth - PrevMonth, PrevMonth, 0)

// IMPORTANT: MoM Growth only works if:
// (a) You have a Date Table marked as Date Table
// (b) The Date Table is related to your Sales table

Building Visuals — Choosing the Right Chart

Visual selection guide for common Indian analytics tasks:

Sales by city this month       → Clustered Bar Chart (horizontal, categories on Y axis)
Revenue trend over 12 months   → Line Chart (Date on X axis, Revenue on Y axis)
Monthly target vs actual       → Clustered Column + Line combo chart
Top 10 products by revenue     → Bar Chart + TopN filter (Visual filter → Top 10 by Revenue)
KPI tiles at top of dashboard  → Card visuals (3-4 across the top)
Detailed order breakdown       → Table or Matrix visual
Regional comparison map        → Filled Map (use State/City field with location category set)
Month/region cross-tab         → Matrix visual (months as columns, regions as rows)

Formatting tips for professional dashboards:
• Use one consistent font (Segoe UI is the Power BI default)
• Keep background white or very light grey
• Use your company's brand colour as the primary chart colour
• Add data labels only when the chart has fewer than 8 bars
• Always add a title to every visual — never leave it blank

Slicers, Drill-Through, and Interactivity

Key interactivity features and where to find them:

SLICERS
• Add slicer: click Slicer visual → drag field onto canvas
• Make it a dropdown: Format → Slicer Settings → Style → Dropdown
• Enable search: Format → Slicer Header → Search → On
• Sync slicers across pages: View → Sync Slicers

DRILL-THROUGH
• Create a detail page (e.g. "Product Detail")
• Add a field to the Drill-through well (e.g. Product Name)
• Users right-click any product in any visual → Drill through → Product Detail
• Add a Back button: Insert → Buttons → Back

CROSS-FILTER CONTROL
• Click the visual you want to control
• Format → Edit Interactions (appears in ribbon)
• Click the filter or highlight icon on each other visual
  - Filter icon = fully filters that visual
  - Highlight icon = dims non-matching values
  - None icon = this visual ignores clicks on the source visual

BOOKMARKS (for guided storytelling)
• View → Bookmarks → Add Bookmark at each state
• Assign bookmarks to buttons for a guided dashboard tour

Your First Complete Dashboard — Indian Sales Report

Dashboard checklist before your interview or submission:

STRUCTURE
☐ 3 pages minimum with clear, descriptive page names
☐ Page 1 is the executive summary — KPIs + high-level trends
☐ Each page has a consistent title text box at the top
☐ A date slicer appears on every page (synced)

DAX MEASURES
☐ Total Revenue (SUM)
☐ Total Orders (COUNT or COUNTROWS)
☐ Unique Customers (DISTINCTCOUNT)
☐ MoM Revenue Growth % (PREVIOUSMONTH)
☐ Return Rate % = DIVIDE(Returned Orders, Total Orders)
☐ YTD Revenue (DATESYTD with Indian FY end date "3-31")

DATA MODEL
☐ Star schema: Sales fact table + Date, Product, Customer dimensions
☐ Date Table created and marked as Date Table
☐ All relationships are one-to-many (dimension → fact)
☐ No many-to-many or bidirectional relationships unless intentional

FORMATTING
☐ Consistent font and colour theme throughout
☐ All visuals have titles
☐ Numbers formatted as ₹ with Indian number format (lakhs/crores)
☐ KPI cards show % change vs previous period

Is Power BI free to learn in India?

Yes — Power BI Desktop is completely free to download and use for learning, building dashboards, and practising DAX. You can connect to CSV files, Excel files, and local databases without any paid license. The free version lets you build full dashboards and save .pbix files locally. Publishing dashboards to the web (Power BI Service) and sharing with others requires a paid Pro license (approximately ₹650 per user per month) or a Premium capacity. For learning and interview preparation, the free Desktop version is entirely sufficient.

What is the difference between Power BI Desktop and Power BI Service?

Power BI Desktop is the free Windows application where you build reports — connect data, create the data model, write DAX measures, and design visuals. It saves files as .pbix locally on your computer. Power BI Service (app.powerbi.com) is the cloud platform where you publish reports so others can view and interact with them via a browser. You need a Power BI Pro or Premium Per User license to publish to the Service. For interviews and learning, focus on Desktop — it is what companies test you on. Publishing to Service is a workflow detail you learn on the job.

How long does it take to learn Power BI for a data analyst job in India?

With 1–2 hours of daily practice, most beginners can reach interview-ready Power BI skill in 6–8 weeks. The first 2 weeks cover loading data, transforming it in Power Query, and creating basic visuals. Weeks 3–4 cover the data model (relationships, star schema) — the most important conceptual step. Weeks 5–6 cover DAX basics: CALCULATE, SUMX, time intelligence. Weeks 7–8 cover dashboard design, slicers, drill-through, and row-level security basics. The fastest way to learn is to build a real dashboard on your own data — not follow along with tutorial files.

What Power BI skills are tested in Indian data analyst interviews?

Indian data analyst interviews test Power BI at two levels. Junior roles test: connecting a CSV or Excel file, building 4–5 visuals, adding slicers, and creating a basic DAX measure like Total Sales = SUM(Sales[Amount]). Mid-level roles test: data model design (star schema, relationships), intermediate DAX (CALCULATE with filters, time intelligence for Indian financial year April–March, RANKX), drill-through pages, row-level security, and Power Query transformations. The most common practical assessment format is: here is a messy CSV — clean it, model it, build a 3-page dashboard. You typically have 90–120 minutes.