🟡
Updated this quarter
Last updated:

Last week, I helped a fresher build their first Power BI dashboard and land a data analyst job at ₹6 LPA. This tutorial is the exact step-by-step process I taught them — no fluff, just what you need to know to get started.

Power BI looks intimidating with all those buttons and panels. But here’s the truth: you only need 20% of the features to do 80% of the work. This tutorial focuses on that 20%.

What is Power BI?

Power BI is Microsoft’s business intelligence tool. Think of it as Excel on steroids for creating dashboards. You connect to data, transform it, and create interactive visualizations that update automatically.

Power BI Components

  • Power BI Desktop: Free Windows app for building reports
  • Power BI Service: Cloud platform for sharing reports
  • Power BI Mobile: View dashboards on phone

Getting Started: Your First Dashboard

Step 1: Install Power BI Desktop

  1. Go to powerbi.microsoft.com/desktop
  2. Download the free Desktop version
  3. Install it (Windows only, Mac users need a VM)

Step 2: Connect to Data

For this tutorial, we’ll use a simple Excel file:

  1. Open Power BI Desktop
  2. Click “Get Data” → “Excel”
  3. Select your file and click “Open”
  4. Check the sheet you want and click “Load”

Step 3: Build Your First Visual

  1. On the right, you’ll see your fields (columns)
  2. Drag “Sales” to the canvas (it creates a bar chart)
  3. Drag “Region” to the Axis field
  4. You now have sales by region!

Power Query: Transforming Data

Most real data is messy. Power Query fixes that before it reaches your report.

Common Transformations

Remove Columns

  1. Click “Transform Data” in Home tab
  2. Select columns you don’t need
  3. Right-click → “Remove Columns”

Split Columns

  1. Select the “Name” column
  2. Transform → Split Column → By Delimiter
  3. Choose “Space” to split “First Last” into two columns

Change Data Types

  1. Select column
  2. Click the icon in column header (ABC, 123, calendar)
  3. Choose correct type (Text, Number, Date)

DAX: The Secret Sauce

DAX (Data Analysis Expressions) is how you create calculations in Power BI. Don’t worry — basic DAX is easier than Excel formulas.

Creating Your First Measure

  1. Click “New Measure” in Home tab
  2. Type: Total Sales = SUM(Sales[Amount])
  3. Press Enter

Common DAX Functions

SUM, AVERAGE, COUNT

Total Revenue = SUM(Sales[Revenue])
Avg Price = AVERAGE(Products[Price])
Num Customers = COUNT(Customers[ID])

CALCULATE (Most Important)

Sales 2025 = CALCULATE(SUM(Sales[Amount]), Sales[Year] = 2025)

Time Intelligence

Sales LY = CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR('Date'[Date]))
Sales YTD = TOTALYTD(SUM(Sales[Amount]), 'Date'[Date])

Building an Interactive Dashboard

Best Practices

  • One message per page: Don’t cram everything
  • Use slicers: Let users filter by date, region, category
  • Drill through: Click a bar to see details
  • Conditional formatting: Color-code high/low values

Dashboard Components

1. KPI Cards

Show key metrics at the top:

  • Total Revenue
  • Growth %
  • Top Product

2. Trend Charts

Line charts for trends over time

3. Comparison Charts

Bar charts for comparing categories

4. Details Table

Matrix or table for drill-down

Power BI Service: Sharing Reports

Publishing

  1. Click “Publish” in Home tab
  2. Sign in to your Microsoft account
  3. Select a workspace (or create one)
  4. Your report is now in the cloud!

Setting Up Refresh

  1. In Power BI Service, go to your dataset
  2. Click “Schedule Refresh”
  3. Set frequency (daily, hourly)
  4. Install Gateway if data is on-premises

Common Mistakes to Avoid

1. Not Setting Relationships

If your visuals show the same number everywhere, you’re missing relationships. Go to Model view and connect your tables.

2. Using Calculated Columns Instead of Measures

Calculated columns increase file size. Use measures whenever possible.

3. Ignoring Data Types

Power BI treats dates as text, sums as text, and breaks calculations. Always check data types after loading.

Practice Exercises

Beginner

  1. Create a bar chart showing sales by month
  2. Add a slicer for region
  3. Create a card showing total sales

Intermediate

  1. Calculate year-over-year growth
  2. Create a drill-through from summary to details
  3. Implement row-level security

Next Steps

📞 Need help? Call +91 8610964691

💬 WhatsApp us

SkilBrill Logo
Written by
· 4 min read