Power BI Fundamentals: From Install to Your First Report

What You Will Learn

By the end of this module you will be able to:

• Explain what Power BI is and why it matters
• Identify the three main components of Power BI
• Download and install Power BI Desktop
• Navigate the Power BI Desktop interface
• Connect to your first dataset and create a simple report

---

1.1 What Is Power BI?

Power BI is Microsoft's business analytics platform. It lets you connect to data from hundreds of sources, clean and transform that data, build interactive visualizations, and share insights across your organization — all without writing code (unless you want to).

Think of it as a pipeline:

Raw Data → Connect → Transform → Model → Visualize → Share

Power BI sits inside the Microsoft Fabric ecosystem, which is Microsoft's all-in-one analytics platform. If you use Azure, Excel, or Microsoft 365, Power BI integrates seamlessly with tools you already know.

Why Power BI?

---

1.2 The Three Main Components

Understanding these three pieces will prevent a lot of confusion as you learn:

Power BI Desktop

• A free Windows application you install on your computer
• This is where you build reports — connect to data, transform it, model it, and create visuals
• Saves files as .pbix

Power BI Service (app.powerbi.com)

• A cloud-based web app
• This is where you publish and share reports
• Requires a free or paid license
• Accessible from any browser

Power BI Mobile

• iOS and Android apps
• For viewing reports and dashboards on the go
• Supports push notifications and offline mode

Rule of thumb: Build in Desktop → Publish to Service → View on Mobile

---

1.3 Power BI Licensing at a Glance

For this tutorial you only need Power BI Desktop (free) for Modules 1–5. You will need a Pro or PPU license to follow along with Module 6 (sharing).

---

1.4 Installing Power BI Desktop

Option A — Microsoft Store (recommended)

1. Open the Microsoft Store on Windows
2. Search for "Power BI Desktop"
3. Click Get — it installs and updates automatically

Option B — Direct Download

1. Go to https://powerbi.microsoft.com/desktop
2. Click Download free
3. Run the .msi installer and follow the prompts

System requirements: Windows 10 or later, 2 GB RAM minimum (8 GB recommended), 1.5 GB disk space

---

1.5 Navigating the Interface

When you open Power BI Desktop for the first time you will see the Start screen offering sample reports and recent files. Close it to see the main workspace.

The Three Views (left sidebar icons)

Key UI Areas

┌────────────────────────────────────────────────────────┐
│  Ribbon (File / Home / Insert / Modeling / View / ...)  │
├──────┬──────────────────────────────┬───────────────────┤
│      │                              │  Fields pane      │
│ View │     Report Canvas            │  (your tables     │
│ Icons│     (drag visuals here)      │   and columns)    │
│      │                              ├───────────────────┤
│      │                              │  Visualizations   │
│      │                              │  pane (chart      │
│      │                              │   type picker)    │
├──────┴──────────────────────────────┴───────────────────┤
│  Page tabs (Page 1, Page 2 …)        Status bar         │
└────────────────────────────────────────────────────────┘

Ribbon tabs you will use constantly:

• Home — Get Data, Refresh, New Visual, Publish
• Insert — Text box, Image, Buttons, Shapes
• Modeling — New Measure, New Column, Manage Relationships
• View — Page view size, Gridlines, Themes

---

1.6 Hands-On: Your First Report in 5 Minutes

Let's build something real right now using Power BI's built-in sample data.

Step 1 — Get Sample Data

1. Click Home → Get Data → More…
2. In the search box type "OData" and select OData feed
3. Paste this URL (Microsoft's public Northwind dataset):
   https://services.odata.org/V3/Northwind/Northwind.svc/
4. Click OK, then select these tables: Orders, Order_Details, Products, Categories
5. Click Load

Simpler alternative: Download the free Contoso Sales .xlsx from Microsoft and use Home → Get Data → Excel workbook

Step 2 — Create a Bar Chart

1. In the Visualizations pane click the Clustered bar chart icon
2. From the Fields pane drag CategoryName to the Y-axis well
3. Drag UnitPrice (from Products) to the X-axis well
4. You now have a bar chart of average prices by category

Step 3 — Add a Slicer

1. Click an empty area of the canvas
2. Select the Slicer visual from the Visualizations pane
3. Drag CategoryName into the Field well
4. Click different categories — watch the bar chart filter automatically

Step 4 — Save Your Work

• Press Ctrl + S and save as My First Report.pbix

Congratulations — you just built an interactive report!

---

1.7 Core Concepts to Remember

---

Module 1 Summary

You now know:

• Power BI connects, transforms, models, and visualizes data
• Desktop = build; Service = share; Mobile = view
• The interface has Report, Table, and Model views
• You can create an interactive report in under 5 minutes

---

Knowledge Check

1. What is the file extension for a Power BI Desktop file?
2. Which component of Power BI would you use to schedule a data refresh?
3. What is the difference between a Report and a Dashboard in Power BI?
4. Is Power BI Desktop free? What about the Power BI Service?

---

Next Module

➡️ Module 2 – Data Connection & Power Query
Learn how to connect to 100+ data sources and transform messy data into clean, analysis-ready tables.