Power BI Tutorial for Beginners — Your First Dashboard

Power BI is Microsoft's business intelligence platform that transforms raw data into interactive dashboards and reports.

Why Power BI?

The Problem It Solves:

• Excel tables are static and hard to update
• Stakeholders ask the same questions repeatedly ("What were last month's sales?")
• Creating charts manually for every request takes hours
• Data lives in multiple places (Excel, SQL databases, cloud services)

The Power BI Solution:

• Connect to multiple data sources (Excel, SQL, Google Sheets, APIs)
• Transform data once, refresh with one click
• Create interactive dashboards (click to filter, drill down, explore)
• Share with stakeholders (web, mobile, embedded in apps)
• Automatic refresh (dashboard updates daily/hourly without manual work)

Real Example: Swiggy Order Dashboard

Before Power BI:

• Order data exported from database to Excel weekly
• Analyst creates pivot tables and charts manually
• Emails static PDF to managers
• Managers reply: "Can you also show this by city?" → Start over

After Power BI:

• Database connected to Power BI (auto-refresh daily)
• Interactive dashboard with filters (date, city, restaurant)
• Managers self-serve: Click city → See city-specific metrics
• Analyst saves 5 hours/week, stakeholders get instant answers

Power BI Ecosystem

Power BI Desktop (Windows app) — Where you build reports

• Connect to data sources
• Transform data (clean, merge, create calculations)
• Create visualizations
• Design dashboard layouts

Power BI Service (Web app) — Where you share and collaborate

• Publish reports from Desktop
• Share with team members
• Set up automatic data refresh
• View on web or mobile

Power BI Mobile (iOS/Android) — Dashboards on the go

• View reports on phone/tablet
• Receive data alerts
• Touch-optimized interactions

Download and Install

Power BI Desktop is FREE (no credit card, no trial limitations).

1. Download: Go to https://powerbi.microsoft.com/desktop
2. Install: Run the installer (requires Windows 10 or later)
3. Launch: Open Power BI Desktop from Start menu

System Requirements:

• Windows 10 or 11 (Power BI Desktop is Windows-only)
• 4 GB RAM minimum (8 GB recommended)
• 2 GB disk space

Mac Users: Use Parallels Desktop or Boot Camp to run Windows, or use Power BI Service (web version, limited features)

Interface Overview

When you open Power BI Desktop, you'll see:

Key Areas:

1. Ribbon Menu (top) — Main commands (Get Data, Transform, Publish)
2. Canvas (center) — Your dashboard workspace (add charts here)
3. Fields Pane (right) — List of your data tables and columns
4. Visualizations Pane (right) — Chart types and formatting options
5. Filters Pane (right) — Apply filters to visuals or entire page

Get Sample Data

For this tutorial, we'll use sample sales data:

Option 1: Use Power BI's Built-in Sample

1. Click Home → Get Data → Sample Reports
2. Select Financial Sample → Load
3. You now have a dataset to practice with

Option 2: Download CSV (more realistic for learning)

1. Download this sample dataset: Flipkart Sales Data (CSV)
2. Save to your computer (e.g., Desktop/sales.csv)
3. We'll load this in the next step

Power BI connects to 100+ data sources. Let's start with CSV (the most common for beginners).

Load CSV File

1. Click Home → Get Data → Text/CSV
2. Navigate to your sales.csv file → Open
3. Preview window opens showing first 200 rows
4. Check data looks correct (columns make sense, values look right)
5. Click one of these buttons:
   • Load — Import data as-is (quick start)
   • Transform Data — Clean/modify data first (recommended)

For this tutorial, click Transform Data. This opens Power Query Editor.

Power Query Editor — Transform Data

Power Query is where you clean and shape data BEFORE visualizing.

Common Transformations:

1. Remove Unnecessary Columns

• Right-click column header → Remove (delete columns you don't need)
• Example: Remove "Internal_ID", "Legacy_Code" (technical fields not used in reports)

2. Change Data Types

• Power BI auto-detects types (sometimes wrong)
• Click column header → Data Type dropdown
• Common types: Text, Whole Number, Decimal Number, Date, Currency

Example: Order_Date showing as text? Change to Date.

3. Filter Rows

• Click dropdown arrow on column header
• Uncheck values to exclude
• Example: Filter out "Cancelled" orders (only show "Delivered")

4. Replace Values

• Right-click column → Replace Values
• Example: Replace "N/A" with blank, or standardize city names ("Mumbia" → "Mumbai")

5. Create Calculated Columns

• Add Column tab → Custom Column
• Example: Create "Profit" = [Revenue] - [Cost]

Example: Clean Sales Data

Let's clean the Flipkart sales dataset:

What Just Happened?

• You created a transformation script (applied every time data refreshes)
• Original CSV file unchanged (transformations are in Power BI, not source)
• Click "Transform Data" anytime to edit your cleaning steps

Now that data is clean, let's build charts.

Create Your First Visual

Example: Revenue by Product Category (Bar Chart)

1. Click blank area on canvas (deselect any selected visual)
2. In Visualizations pane, click Stacked Bar Chart icon
3. Empty visual appears on canvas
4. From Fields pane, drag:
   • Category → Y-axis well (rows)
   • Revenue → X-axis well (bars)
5. Chart appears! Bars show revenue per category

Resize and Move:

• Click visual → Drag corner handles to resize
• Click visual → Drag to move
• Snap to grid (align with other visuals)

Common Chart Types

Bar Chart / Column Chart — Compare categories

Line Chart — Show trends over time

Pie Chart / Donut Chart — Show composition (use sparingly)

Card — Show single KPI number

Table / Matrix — Show detailed data

Map — Show geographic data

Build a Multi-Visual Dashboard

Let's create a typical sales dashboard with 5 visuals:

Visual 1: Total Revenue (Card)

1. Visualizations → Card
2. Fields → Drag Revenue to Fields well
3. Card shows sum of all revenue (e.g., ₹45.2M)
4. Resize: Small (top-left corner)

Visual 2: Revenue Trend (Line Chart)

1. Visualizations → Line Chart
2. Fields → Drag Order_Date to X-axis, Revenue to Y-axis
3. Line shows daily revenue over time
4. Resize: Wide (top-center, takes up 2/3 of top row)

Visual 3: Orders by City (Bar Chart)

1. Visualizations → Stacked Bar Chart
2. Fields → Drag City to Y-axis, Order_ID (count) to X-axis
3. Bars show order volume per city
4. Sort: Click "More options" (…) → Sort descending
5. Resize: Left column (middle height)

Visual 4: Revenue by Category (Pie Chart)

1. Visualizations → Pie Chart
2. Fields → Drag Category to Legend, Revenue to Values
3. Pie shows revenue share by category
4. Resize: Right column (middle height)

Visual 5: Top 10 Products (Table)

1. Visualizations → Table
2. Fields → Drag Product_Name, Revenue, Quantity to Values
3. Table shows product details
4. Sort: Click Revenue column header → Sort descending
5. Filter to Top 10: Filters pane → Add filter on this visual → Product_Name → Filter type: Top N → Show items: Top 10 by Revenue
6. Resize: Bottom row (full width)

Your dashboard now has:

• KPI card (total revenue)
• Trend line (revenue over time)
• Two comparison charts (city, category)
• Detailed table (top products)

Power BI's magic is cross-filtering: Click one visual, others update automatically.

Test Cross-Filtering

Try this:

1. Click a bar in "Revenue by Category" (e.g., Electronics)
2. Watch: All other visuals filter to show ONLY Electronics
   • Line chart → Electronics revenue trend
   • City bar chart → Cities' Electronics orders
   • Product table → Top Electronics products
3. Click bar again to deselect (back to all data)

This is the power of Power BI: Stakeholders explore data themselves instead of requesting custom reports.

Add Slicers (Filters)

Slicers are visual filters — add them to your dashboard:

Date Range Slicer:

1. Click blank area on canvas
2. Visualizations → Slicer icon
3. Fields → Drag Order_Date to Field well
4. Slicer appears with date range slider
5. Resize and place at top of dashboard
6. Users can now: Drag slider to filter dashboard to specific date range

City Dropdown Slicer:

1. Visualizations → Slicer
2. Fields → Drag City to Field well
3. Change style: Click slicer → Format pane → Slicer settings → Style: Dropdown (instead of list)
4. Users can now: Select city from dropdown to filter dashboard

Category Multi-Select Slicer:

1. Visualizations → Slicer
2. Fields → Drag Category to Field well
3. Enable multi-select: Format pane → Selection → Multi-select with Ctrl: On
4. Users can now: Ctrl+Click to select multiple categories

Page-Level Filters

Filters that apply to entire page (all visuals):

1. Click blank area (deselect all visuals)
2. Filters pane → Filters on this page section
3. Drag field (e.g., Order_Status) to this section
4. Set filter: Select "Delivered" (exclude Cancelled orders from entire page)

When to use slicers vs filters:

• Slicers → Visible on dashboard (users control)
• Page filters → Hidden background filters (analyst control)

Drill-Down Hierarchies

Create hierarchies for drill-down (e.g., Year → Quarter → Month):

1. Fields pane → Right-click Order_Date → New hierarchy
2. Power BI auto-creates: Year, Quarter, Month, Day
3. In visual: Drag Order_Date Hierarchy to axis (instead of flat date)
4. Click drill-down arrows on visual:
   • ⬇️ Drill down one level (Year → Quarter)
   • ⬆️ Drill up (Quarter → Year)
   • ⤵️ Expand all levels (show Year + Quarter together)

Use case: Executive sees yearly trend, clicks drill-down to see quarterly breakdown, clicks again for monthly detail.

DAX (Data Analysis Expressions) is Power BI's formula language — like Excel formulas but more powerful.

Calculated Columns vs Measures

Calculated Column: Row-level calculation (like Excel column formula)

• Created in Data view → Add Column
• Computes once when data loads
• Example: Profit = [Revenue] - [Cost] (per row)
• Use for: Creating new dimensions (categories, flags)

Measure: Aggregated calculation (like Excel pivot table formula)

• Created in Report view → Right-click table → New Measure
• Computes dynamically based on filters
• Example: Total Revenue = SUM(Sales[Revenue])
• Use for: KPIs, aggregations, ratios

Rule of thumb: If it's per-row, use column. If it's a summary stat, use measure.

Create Your First Measure

Total Revenue Measure:

Total Revenue = SUM(Sales[Revenue])

How to create:

1. Fields pane → Right-click Sales table → New Measure
2. Formula bar (top) → Type: Total Revenue = SUM(Sales[Revenue])
3. Press Enter
4. Measure appears in Fields pane (with calculator icon)
5. Use it: Drag to Card visual or Table

Essential DAX Formulas

1. Count Distinct (e.g., Unique Customers)

Total Customers = DISTINCTCOUNT(Sales[Customer_ID])

2. Average

Average Order Value = AVERAGE(Sales[Revenue])

3. Conditional Calculation (e.g., High-Value Orders)

High Value Orders = CALCULATE(
    COUNTROWS(Sales),
    Sales[Revenue] > 5000
)

• CALCULATE changes filter context
• Counts rows WHERE Revenue > 5000

4. Percentage of Total

Revenue % of Total =
DIVIDE(
    SUM(Sales[Revenue]),
    CALCULATE(SUM(Sales[Revenue]), ALL(Sales[Category]))
)

• ALL removes filters (gives grand total)
• DIVIDE handles division (safe from divide-by-zero)

5. Year-over-Year Growth

Revenue YoY Growth =
VAR CurrentYearRevenue = SUM(Sales[Revenue])
VAR PreviousYearRevenue =
    CALCULATE(
        SUM(Sales[Revenue]),
        SAMEPERIODLASTYEAR(Calendar[Date])
    )
RETURN
DIVIDE(CurrentYearRevenue - PreviousYearRevenue, PreviousYearRevenue)

• VAR stores intermediate calculations
• SAMEPERIODLASTYEAR gets same date range, previous year
• Returns growth rate (e.g., 0.15 = 15% growth)

Format Measures

After creating measure, format it:

1. Click measure in Fields pane
2. Measure Tools ribbon appears
3. Format dropdown → Choose:
   • Currency: ₹ (Indian Rupee)
   • Percentage: % (auto-multiplies by 100)
   • Whole Number: No decimals
4. Decimal places → Set to 0, 1, or 2

Example: Format "Total Revenue" as Currency (₹) with 2 decimals → Shows as ₹45.23M instead of 45234567.89