Introduction to Power BI
Power BI is Microsoft's industry-leading business intelligence platform that transforms raw data into stunning, interactive visualizations and actionable insights. Whether you are a data analyst, business user, or IT professional, Power BI enables you to connect to hundreds of data sources, clean and shape your data, build data models, and create compelling reports and dashboards — all without writing a single line of code.
In this chapter, you will learn what Business Intelligence is, explore the Power BI ecosystem and its editions, install Power BI Desktop, navigate the interface, and build your very first report.
What is Business Intelligence?
Definition
Business Intelligence (BI) refers to the technologies, strategies, and practices used for collecting, integrating, analyzing, and presenting business data. The primary goal of BI is to support better decision-making by turning raw data into meaningful and actionable information.
Why BI Matters
Organizations today generate massive amounts of data from sales transactions, customer interactions, supply chain operations, marketing campaigns, and more. Without BI, this data remains scattered across systems and formats, making it nearly impossible to extract value from it.
BI matters because it:
- Eliminates guesswork — Decisions are backed by data, not intuition
- Identifies trends and patterns — Spot emerging opportunities before competitors
- Improves operational efficiency — Find bottlenecks and optimize processes
- Enhances customer understanding — Segment customers and personalize experiences
- Accelerates reporting — Replace manual spreadsheet reports with automated dashboards
- Enables self-service analytics — Business users can explore data without relying on IT
The BI Workflow
The business intelligence workflow follows a clear progression from raw data to decisions:
| Stage | Description | Example |
|---|---|---|
| 1. Data Collection | Gather data from various sources | Sales database, CRM, web analytics, spreadsheets |
| 2. Data Integration | Combine data from multiple sources into a unified view | Merge sales data with customer data |
| 3. Data Cleaning | Remove duplicates, fix errors, standardize formats | Correct misspelled city names, fill missing values |
| 4. Data Modeling | Structure data with relationships and calculations | Create a star schema with fact and dimension tables |
| 5. Data Visualization | Present data through charts, graphs, and dashboards | Bar chart showing sales by region |
| 6. Insights & Decisions | Interpret visualizations to make informed decisions | Increase marketing spend in top-performing region |
This workflow is exactly what Power BI is designed to support — from getting data all the way to sharing insights with stakeholders.
What is Power BI?
Overview
Power BI is a suite of business analytics tools developed by Microsoft that lets you connect to data sources, transform and clean data, build data models, create interactive visualizations, and share reports and dashboards across your organization.
Originally released in July 2015, Power BI has grown into the most widely used BI platform in the world. According to Gartner's Magic Quadrant for Analytics and Business Intelligence Platforms, Microsoft has been named a Leader for over fifteen consecutive years.
A Brief History
- 2010 — Microsoft releases Power Pivot as an Excel add-in, introducing the xVelocity in-memory engine and DAX (Data Analysis Expressions) language
- 2012 — Power Query is introduced as an Excel add-in for data extraction and transformation
- 2013 — Power View and Power Map add visualization capabilities to Excel
- 2015 — Microsoft launches Power BI as a standalone product, combining Power Query, Power Pivot, and Power View into a unified desktop application with a cloud service
- 2016–2019 — Rapid feature additions: custom visuals marketplace, AI visuals, paginated reports, dataflows, composite models
- 2020–2023 — Introduction of deployment pipelines, goals/metrics, datamarts, Direct Lake mode, and Copilot AI integration
- 2024–2026 — Enhanced Fabric integration, expanded Copilot capabilities, advanced semantic models, and real-time analytics improvements
Why Power BI Dominates the Market
Power BI's dominance stems from several key advantages:
- Cost-effective — Power BI Desktop is completely free; Pro licenses are significantly cheaper than competitors
- Microsoft ecosystem integration — Seamless connection with Excel, Azure, SharePoint, Teams, and Dynamics 365
- Massive connector library — 200+ native data connectors out of the box
- DAX and M languages — Powerful formula languages for advanced calculations and data transformation
- Active community — Millions of users, extensive forums, free learning resources, and regular community events
- Monthly updates — Microsoft releases new features and improvements every single month
- AI-powered features — Smart narratives, Q&A natural language queries, anomaly detection, key influencers, decomposition tree
- Enterprise scalability — From individual analysts to organization-wide deployments with governance and security
Power BI Ecosystem
Power BI is not a single product — it is an ecosystem of interconnected tools and services. Understanding each component is essential for leveraging the full power of the platform.
Components Overview
| Component | Type | Purpose | Cost |
|---|---|---|---|
| Power BI Desktop | Windows application | Author reports and data models | Free |
| Power BI Service | Cloud platform (app.powerbi.com) | Publish, share, collaborate on reports and dashboards | Free / Pro / Premium |
| Power BI Mobile | iOS, Android, Windows apps | View and interact with reports on mobile devices | Free (requires Pro/Premium for shared content) |
| Power BI Report Server | On-premises server | Host reports behind your firewall for organizations that cannot use cloud | Premium license required |
| Power BI Embedded | Azure service | Embed Power BI visuals into custom applications | Pay-as-you-go Azure pricing |
| Power BI Paginated Reports | Report Builder application | Create pixel-perfect, printable reports (invoices, statements) | Premium Per User or Premium Per Capacity |
Power BI Desktop
Power BI Desktop is the free Windows application where you do most of your development work. It is the primary authoring tool for:
- Connecting to data sources
- Transforming data with Power Query
- Building data models with relationships
- Writing DAX measures and calculated columns
- Designing report pages with interactive visuals
Power BI Desktop saves files in the .pbix format. Once your report is ready, you publish it to the Power BI Service for sharing.
Power BI Service
The Power BI Service (also called Power BI Online) is the cloud-based platform where reports are published, shared, and consumed. Key features include:
- Workspaces — Collaborative spaces where teams organize reports and datasets
- Dashboards — Pin visuals from multiple reports onto a single dashboard
- Scheduled Refresh — Automatically refresh data on a schedule
- Row-Level Security (RLS) — Control which data users can see based on their role
- Apps — Package and distribute collections of reports and dashboards
- Dataflows — Reusable data preparation logic in the cloud
- Deployment Pipelines — Dev → Test → Production workflows for enterprise governance
Power BI Mobile
The Power BI Mobile app is available for iOS, Android, and Windows devices. It allows users to:
- View and interact with reports and dashboards on the go
- Receive data-driven alerts when metrics cross thresholds
- Annotate and share report snapshots
- Use barcode scanning to filter reports
- Access reports offline (with Premium)
Power BI Report Server
Power BI Report Server is an on-premises solution for organizations that cannot or prefer not to store data in the cloud. It supports:
- Power BI reports (.pbix)
- Paginated reports (.rdl)
- Excel workbooks
- KPIs and mobile reports
Power BI Embedded
Power BI Embedded is an Azure service that allows developers to embed Power BI visuals, reports, and dashboards into custom web applications. This is ideal for ISVs (Independent Software Vendors) who want to offer analytics within their products without requiring users to have Power BI licenses.
Power BI vs Other BI Tools
Choosing a BI tool is a critical decision. Here is a detailed comparison of Power BI with its main competitors:
| Feature | Power BI | Tableau | Looker (Google) | Qlik Sense |
|---|---|---|---|---|
| Pricing | Free Desktop; Pro at ~$10/user/month | Creator at ~$75/user/month | Custom enterprise pricing | ~$30/user/month |
| Ease of Use | Very intuitive; Excel-like experience | Moderate; drag-and-drop focused | Requires LookML knowledge | Moderate learning curve |
| Data Connectivity | 200+ connectors | 80+ connectors | Google-centric; custom connectors | 100+ connectors |
| Data Transformation | Power Query (excellent built-in ETL) | Tableau Prep (separate tool) | LookML modeling | Data Manager |
| Visualization Quality | Excellent; 100+ visual types + custom visuals | Industry-leading visuals | Good; limited chart types | Good; smart visualizations |
| Formula Language | DAX (powerful but steep learning curve) | Calculated fields (simpler) | LookML + SQL | Set analysis expressions |
| Cloud/On-Premises | Both (Service + Report Server) | Both (Online + Server) | Cloud-only | Both (Cloud + Enterprise) |
| AI/ML Integration | Built-in AI visuals, Copilot, Azure ML | TabPy, Einstein Discovery | Looker ML | AutoML, Insight Advisor |
| Mobile Support | Dedicated apps (iOS, Android, Windows) | Dedicated apps | Browser-based | Dedicated apps |
| Microsoft Integration | Excellent (Excel, Teams, SharePoint, Azure) | Limited | Limited | Limited |
| Community & Resources | Massive community; extensive free content | Large community | Growing community | Moderate community |
| Best For | Organizations using Microsoft stack; cost-conscious teams | Data visualization specialists; complex visual analytics | Google Cloud-centric organizations | Complex data association analysis |
Key Takeaway
Power BI offers the best value for most organizations, especially those already invested in the Microsoft ecosystem. Tableau excels in advanced visualization scenarios, Looker is ideal for Google Cloud users who prefer a code-first approach, and Qlik Sense stands out for its associative data engine.
Power BI Editions
Microsoft offers Power BI in several editions to accommodate different needs and budgets:
| Feature | Free | Pro | Premium Per User (PPU) | Premium Per Capacity |
|---|---|---|---|---|
| Monthly Cost | $0 | ~$10/user | ~$20/user | Starting ~$4,995/month |
| Power BI Desktop | Yes | Yes | Yes | Yes |
| Publish to Service | Limited (My Workspace only) | Yes | Yes | Yes |
| Share Reports | No | Yes (with other Pro users) | Yes (with other PPU users) | Yes (free users can consume) |
| Workspace Collaboration | No | Yes | Yes | Yes |
| Data Refresh Frequency | 1x/day | 8x/day | 48x/day | 48x/day |
| Max Dataset Size | 1 GB | 1 GB | 100 GB | 400 GB |
| Paginated Reports | No | No | Yes | Yes |
| Deployment Pipelines | No | No | Yes | Yes |
| AI Features | Basic | Basic | Advanced | Advanced |
| XMLA Endpoint | No | No | Yes (read/write) | Yes (read/write) |
| Dataflows | No | Basic | Advanced (Gen2) | Advanced (Gen2) |
| Auto Page Refresh | No | 30 min minimum | 1 second minimum | 1 second minimum |
Which Edition Should You Choose?
- Free — Perfect for individual learning and personal projects. You can build reports in Desktop but sharing is very limited.
- Pro — Ideal for teams that need to share reports and collaborate. Most common choice for small to mid-size organizations.
- Premium Per User (PPU) — Best for teams that need advanced features (paginated reports, large datasets, higher refresh rates) without the high cost of capacity-based Premium.
- Premium Per Capacity — Designed for large enterprises that need to distribute content to many users (including free license holders), require massive datasets, and need the highest performance.
Installing Power BI Desktop
System Requirements
Before installing Power BI Desktop, ensure your system meets these requirements:
| Requirement | Minimum |
|---|---|
| Operating System | Windows 10 version 1809+ / Windows 11 / Windows Server 2019+ |
| Processor | 1 GHz 64-bit (x64) processor |
| RAM | 2 GB minimum (4 GB+ recommended) |
| Display | 1440 x 900 or higher resolution |
| Disk Space | ~1.5 GB for installation |
| .NET Framework | 4.6.2 or later |
| Internet | Required for installation, updates, and publishing |
Note: Power BI Desktop is only available for Windows. Mac users can use Power BI through a virtual machine (Parallels, VMware Fusion), Windows 365 Cloud PC, or access the Power BI Service through a web browser.
Step-by-Step Installation
-
Open your web browser and navigate to the official Power BI download page at
https://powerbi.microsoft.com/desktop -
Click "Download free" — You will be redirected to the Microsoft Store (recommended method) or you can choose the standalone installer (.exe) via the advanced download options
-
Microsoft Store method (recommended):
- Click "Get" in the Microsoft Store
- The download and installation will proceed automatically
- Benefits: Automatic updates, no admin rights needed, side-by-side language support
-
Standalone installer method:
- Select your language and click "Download"
- Choose the 64-bit installer (PBIDesktopSetup_x64.exe)
- Run the installer and follow the wizard:
- Accept the license agreement
- Choose the installation directory (default is recommended)
- Optionally create a desktop shortcut
- Click "Install" and wait for completion
-
Launch Power BI Desktop — After installation, open the application. You will see a welcome screen with options to:
- Get data
- Open recent files
- View tutorials and learning resources
-
Sign in (optional) — Click "Sign in" in the top-right corner to connect with your Microsoft 365 or Power BI account. This is required for publishing reports to the Power BI Service.
Keeping Power BI Updated
Microsoft releases monthly updates (usually in the third week of each month). If you installed from the Microsoft Store, updates are automatic. For the standalone installer, you will receive update notifications within the application.
The Power BI Desktop Interface
Understanding the Power BI Desktop interface is crucial for productive report development. Let's explore each area in detail.
The Three Views
Power BI Desktop has three main views, accessible from the left sidebar icons:
1. Report View (default)
The Report View is where you design your reports. This is the primary workspace for creating visualizations and arranging them on report pages.
Key areas in Report View:
- Canvas — The large central area where you place and arrange visuals
- Visualizations Pane (right side) — Select visual types, configure fields, and format visuals
- Fields Pane (far right) — Browse all tables and columns in your data model
- Filters Pane (right side, collapsible) — Apply filters at visual, page, or report level
- Pages Bar (bottom) — Navigate between report pages; right-click to add, rename, duplicate, or delete pages
2. Data View
The Data View displays your data in a tabular format, similar to an Excel spreadsheet. Use it to:
- Inspect your data after loading
- Verify data types and formatting
- Create and test calculated columns
- Add and modify DAX measures
- Check for data quality issues
3. Model View
The Model View shows a visual representation of your data model — all tables and the relationships between them. Use it to:
- View and manage table relationships
- Create new relationships by dragging columns between tables
- Set relationship cardinality (one-to-one, one-to-many, many-to-many)
- Configure cross-filter direction
- Hide columns from the Report View
- Organize tables spatially for clarity
The Ribbon Tabs
The ribbon at the top of Power BI Desktop is organized into several tabs:
Home Tab
The most frequently used commands:
| Button | Purpose |
|---|---|
| Get Data | Connect to data sources (Excel, SQL, Web, etc.) |
| Excel Workbook | Quick shortcut to connect to an Excel file |
| SQL Server | Quick shortcut to connect to SQL Server |
| Enter Data | Manually type data into a table |
| Dataverse | Connect to Microsoft Dataverse |
| Recent Sources | Quickly reconnect to recently used data sources |
| Transform Data | Open Power Query Editor |
| New Visual | Add a new visualization to the canvas |
| Text Box | Add a text box for annotations |
| Button | Add interactive buttons (back, navigation, bookmark) |
| Image | Insert an image |
| Shapes | Add shapes (rectangles, ovals, lines, arrows) |
| Publish | Publish the report to the Power BI Service |
Insert Tab
Additional objects you can add to your report:
- New Visual / New Page — Add visuals or pages
- Text Box / Button / Image / Shapes — Decorative and interactive elements
- Power Apps / Power Automate — Embed Power Platform components
- Q&A — Add a natural language query visual
- Paginated Reports — Add paginated report visuals
Modeling Tab
Data modeling tools:
| Button | Purpose |
|---|---|
| New Measure | Create a DAX measure |
| New Column | Create a calculated column using DAX |
| New Table | Create a calculated table using DAX |
| Quick Measure | Use a wizard to create common measures |
| Manage Roles | Set up Row-Level Security (RLS) |
| View As | Test RLS by viewing the report as a specific role |
| New Parameter | Create what-if parameters with slicers |
| Manage Relationships | View and edit all relationships |
View Tab
Controls the appearance and behavior of the design surface:
- Themes — Apply built-in or custom themes
- Mobile Layout — Design mobile-optimized report layouts
- Bookmarks — Create and manage bookmarks for navigation
- Selection — Show/hide/reorder objects on the page
- Sync Slicers — Configure slicers to apply across multiple pages
- Page Size / Gridlines / Snap to Grid — Canvas layout settings
- Performance Analyzer — Measure the rendering time of each visual
Help Tab
Access documentation, community forums, training videos, and support options.
The Visualizations Pane
The Visualizations pane is divided into three sections:
-
Visual gallery — Icons for all available visual types (bar chart, line chart, pie chart, map, table, matrix, card, slicer, etc.). The three-dot icon at the bottom accesses the custom visuals marketplace.
-
Fields section — After selecting a visual, this area shows the field wells (e.g., Axis, Legend, Values, Tooltips) where you drag and drop columns to configure the visual.
-
Format section — Two sub-tabs:
- Visual — Format the visual itself (colors, labels, titles, legend, data labels)
- General — Format the container (size, position, border, shadow, background, alt text)
The Fields Pane
The Fields pane lists all tables and their columns/measures in your data model. Key features:
- Tables are shown with a table icon and can be expanded to reveal columns
- Columns show their data type icon (text Σ for numeric, calendar for dates)
- Measures are indicated with a calculator icon
- Hierarchies can be created by dragging columns onto each other
- Search box at the top lets you quickly find fields
- Right-click any field for options like rename, hide, create hierarchy, new measure, etc.
The Filters Pane
The Filters pane allows you to apply filters at three levels:
| Filter Level | Scope | Example |
|---|---|---|
| Visual Level | Applies only to the selected visual | Show only "Electronics" category in a specific bar chart |
| Page Level | Applies to all visuals on the current page | Filter entire page to show only 2025 data |
| Report Level | Applies to all visuals on all pages | Filter the entire report to a specific region |
For each filter, you can use:
- Basic filtering (select values from a list)
- Advanced filtering (contains, starts with, is greater than, etc.)
- Top N filtering (show top 10 by a measure)
- Relative date filtering (last 30 days, this quarter, etc.)
Your First Report
Let's build your first Power BI report step by step using sample data.
Step 1: Load Sample Data
- Open Power BI Desktop
- Click Get Data on the Home tab
- Select Excel Workbook (or use the built-in sample data)
- If you do not have sample data, click Enter Data to create a manual table
- Enter the following sample sales data:
| Region | Product | Quarter | Sales | Units |
|-----------|-------------|---------|---------|-------|
| North | Laptops | Q1 | 125000 | 250 |
| North | Laptops | Q2 | 142000 | 284 |
| North | Phones | Q1 | 89000 | 445 |
| North | Phones | Q2 | 96000 | 480 |
| South | Laptops | Q1 | 110000 | 220 |
| South | Laptops | Q2 | 128000 | 256 |
| South | Phones | Q1 | 72000 | 360 |
| South | Phones | Q2 | 85000 | 425 |
| East | Laptops | Q1 | 98000 | 196 |
| East | Laptops | Q2 | 115000 | 230 |
| East | Phones | Q1 | 67000 | 335 |
| East | Phones | Q2 | 78000 | 390 |
| West | Laptops | Q1 | 135000 | 270 |
| West | Laptops | Q2 | 152000 | 304 |
| West | Phones | Q1 | 91000 | 455 |
| West | Phones | Q2 | 103000 | 515 |
- Name the table Sales and click Load
Step 2: Create a Clustered Bar Chart
- Ensure you are in Report View (first icon on the left sidebar)
- In the Visualizations pane, click the Clustered Bar Chart icon
- From the Fields pane, drag Region to the Y-axis (or Axis) field well
- Drag Sales to the X-axis (or Values) field well
- The chart now shows total sales by region
- Drag Product to the Legend field well to see a breakdown by product category
What you should see: A horizontal bar chart with four bars (one per region), each bar split into two colors representing Laptops and Phones.
Step 3: Add a Card Visual
- Click on an empty area of the canvas (to deselect the bar chart)
- In the Visualizations pane, click the Card visual icon
- Drag Sales to the Fields well
- The card now displays the total sales value (e.g., 1,686,000)
Formatting the Card:
- With the card selected, click the Format icon (paint roller) in the Visualizations pane
- Under Callout value, change the font size to 28
- Under Category label, toggle it off (since we only have one field)
- Under General > Title, toggle it on and type "Total Sales"
Step 4: Add a Donut Chart
- Click on an empty area of the canvas
- Select the Donut Chart visual
- Drag Product to the Legend field well
- Drag Units to the Values field well
- The donut chart now shows the proportion of units sold by product category
Step 5: Format Your Report
- Add a title: Go to Insert > Text Box, type "Sales Performance Dashboard", format with larger font and bold
- Apply a theme: Go to View > Themes and select a built-in theme (e.g., "Executive" or "Innovation")
- Align visuals: Select multiple visuals (Ctrl+click), then use Format > Align to align them neatly
- Add a background: Select the canvas (click empty area), then in Format pane under Canvas background, choose a light color
Step 6: Save Your File
- Click File > Save As
- Choose a location and name your file (e.g., "My First Report.pbix")
- Click Save
Congratulations! You have created your first Power BI report with a bar chart, card visual, and donut chart.
Power BI File Types
Understanding the different file types in Power BI helps you work efficiently and collaborate effectively:
| File Extension | Name | Description | Use Case |
|---|---|---|---|
| .pbix | Power BI Report | The standard Power BI Desktop file containing data model, queries, and report visuals | Day-to-day report development |
| .pbit | Power BI Template | A template file that contains the report layout, data model structure, and queries but no data | Sharing report templates without sensitive data; parameterized templates |
| .rdl | Report Definition Language | Paginated report files created in Power BI Report Builder | Pixel-perfect printable reports (invoices, statements, operational reports) |
| .pbids | Power BI Data Source | A JSON file that defines a data source connection | Simplifying data source connections for users |
| .pbip | Power BI Project | A folder-based format (introduced for developer workflows) containing separate JSON files for the report, model, and queries | Source control (Git) integration and CI/CD pipelines |
PBIX vs PBIT
The key difference between .pbix and .pbit files:
- PBIX contains everything — data, model, queries, visuals. File size can be large depending on data volume.
- PBIT contains the structure but excludes the actual data. When someone opens a
.pbitfile, Power BI prompts them to connect to the data source and load data fresh. This is ideal for:- Sharing templates across teams
- Protecting sensitive data
- Creating parameterized connections where each user points to their own data source
Creating a Template
To create a .pbit template from your report:
- Open your
.pbixfile in Power BI Desktop - Go to File > Export > Power BI Template
- Optionally add a description
- Click OK and choose where to save the file
Key Terminology
Mastering Power BI vocabulary is essential for effective communication and understanding documentation:
| Term | Definition |
|---|---|
| Dataset (Semantic Model) | A collection of data imported into or connected from Power BI. Contains tables, relationships, measures, and calculated columns. Microsoft is transitioning the term to "Semantic Model." |
| Report | A collection of one or more pages of visualizations built on top of a dataset. Created in Power BI Desktop or the Service. |
| Dashboard | A single-page canvas in the Power BI Service containing pinned visuals (tiles) from one or more reports. Dashboards are unique to the Service — they cannot be created in Desktop. |
| Workspace | A collaborative container in the Power BI Service where teams store, manage, and share reports, datasets, and dashboards. |
| Dataflow | A reusable collection of Power Query transformations defined and managed in the Power BI Service. Enables ETL logic to be shared across multiple datasets. |
| Gateway | A bridge that facilitates secure data transfer between on-premises data sources and the Power BI Service. Required for scheduled refresh of on-premises data. |
| Tile | An individual visual pinned to a dashboard. Each tile represents a snapshot of a visual from a report. |
| App | A packaged collection of related dashboards and reports designed for distribution to a broad audience within an organization. |
| Paginated Report | A report type designed for printing or PDF generation, with pixel-perfect layout control. Created using Power BI Report Builder. |
| DAX | Data Analysis Expressions — the formula language used for creating measures, calculated columns, and calculated tables in the data model. |
| Power Query (M Language) | The data transformation engine and its underlying functional language used for ETL (Extract, Transform, Load) operations. |
| Relationships | Connections between tables in the data model that define how data is related, enabling cross-table calculations and filtering. |
| Measure | A dynamic DAX calculation that is evaluated at query time based on the filter context. Unlike calculated columns, measures do not add data to the table. |
| Calculated Column | A DAX expression that adds a new column to a table, evaluated row by row during data refresh. The values are stored in the model. |
| Slicer | An interactive visual that allows users to filter other visuals on the page by selecting values (e.g., selecting a year, region, or product category). |
| Drill-down | The ability to navigate from a high-level view to more detailed data within a visual hierarchy (e.g., Year → Quarter → Month → Day). |
| Bookmark | A saved state of a report page, including filters, slicer selections, and visual visibility. Used for navigation and storytelling. |
| Row-Level Security (RLS) | A feature that restricts data access at the row level based on user roles and DAX filter expressions. |
| Composite Model | A data model that combines Import and DirectQuery tables, or connects to multiple DirectQuery sources. |
| Deployment Pipeline | A tool in the Power BI Service for managing the lifecycle of content through Development, Test, and Production stages. |
The Power BI Workflow
The end-to-end Power BI workflow follows six stages. Understanding this workflow provides a roadmap for your learning journey:
Stage 1: Get Data
Connect to your data sources using Power BI's 200+ connectors. Sources include files (Excel, CSV), databases (SQL Server, Oracle), cloud services (SharePoint, Salesforce), web pages, and APIs.
Tool: Power BI Desktop → Home → Get Data
Stage 2: Transform Data (Power Query)
Clean, shape, and transform your raw data using the Power Query Editor. Common tasks include removing duplicates, changing data types, splitting columns, merging tables, filtering rows, and pivoting/unpivoting data.
Tool: Power BI Desktop → Home → Transform Data → Power Query Editor
Stage 3: Model Data
Design your data model by creating relationships between tables, defining calculated columns and measures with DAX, setting up hierarchies, and organizing tables into a star schema.
Tool: Power BI Desktop → Model View + Modeling Tab
Stage 4: Visualize Data
Create interactive reports by adding visuals (charts, tables, maps, cards), configuring slicers and filters, applying themes and formatting, and arranging visuals across multiple report pages.
Tool: Power BI Desktop → Report View
Stage 5: Publish
Publish your completed report to the Power BI Service. This uploads the .pbix file to a workspace in the cloud.
Tool: Power BI Desktop → Home → Publish
Stage 6: Share & Collaborate
Share reports and dashboards with colleagues. Options include:
- Workspace access — Add members to a workspace with specific roles
- Apps — Package reports into an app for broad distribution
- Share links — Generate direct links to specific reports
- Embed — Embed reports in SharePoint, Teams, or custom web apps
- Export — Export to PDF, PowerPoint, or Excel
- Subscribe — Set up email subscriptions for automated report delivery
Tool: Power BI Service (app.powerbi.com)
Workflow Diagram
┌─────────────┐ ┌─────────────┐ ┌─────────────┐
│ GET DATA │──▶│ TRANSFORM │──▶│ MODEL │
│ (Connectors)│ │(Power Query)│ │ (DAX) │
└─────────────┘ └─────────────┘ └─────────────┘
│
▼
┌─────────────┐ ┌─────────────┐ ┌─────────────┐
│ SHARE & │◀──│ PUBLISH │◀──│ VISUALIZE │
│ COLLABORATE │ │ (to Service)│ │ (Reports) │
└─────────────┘ └─────────────┘ └─────────────┘
Practice Exercises
Test your understanding of the concepts covered in this chapter with the following exercises.
Exercise 1: Explore the Interface
Objective: Familiarize yourself with the three views and all ribbon tabs.
Instructions:
- Open Power BI Desktop
- Switch between Report View, Data View, and Model View using the left sidebar icons
- Click through every ribbon tab (Home, Insert, Modeling, View, Help) and note the available buttons
- Hover over each button to read its tooltip description
- Write down three features you find most interesting and want to learn more about
Exercise 2: Build a Report with Enter Data
Objective: Create a simple report using manually entered data.
Instructions:
- Click Home → Enter Data
- Create a table called "Employees" with these columns: Name (text), Department (text), Salary (number), Hire Year (number)
- Enter at least 8 rows of sample data across 3 different departments
- Click Load
- Create the following visuals:
- A Clustered Column Chart showing total salary by department
- A Card showing the total number of employees (hint: use Count of Name)
- A Table visual showing all employee details
- A Slicer using the Department column to filter the page
- Apply a theme of your choice
- Save the file as "Employee_Report.pbix"
Exercise 3: Compare Power BI Editions
Objective: Determine the right Power BI edition for different scenarios.
Instructions: For each scenario below, identify the most appropriate Power BI edition (Free, Pro, PPU, or Premium Per Capacity) and explain your reasoning:
- A college student learning data visualization for personal projects
- A team of 15 analysts who need to share reports with each other
- A department that needs paginated reports and 100 GB datasets but has a limited budget
- An enterprise with 5,000 employees where most users only need to view (not create) reports
Exercise 4: Identify Interface Elements
Objective: Test your knowledge of the Power BI Desktop interface.
Instructions: Open Power BI Desktop and identify the following elements. For each one, write where it is located and what it is used for:
- The Visualizations pane
- The Fields pane
- The Filters pane
- The Pages bar
- The Formula bar (hint: enable it in the View tab)
- The Performance Analyzer (hint: it is in the View tab)
Exercise 5: Create a Template File
Objective: Understand the difference between .pbix and .pbit files.
Instructions:
- Open the report you created in Exercise 2
- Go to File → Export → Power BI Template
- Add a description: "Employee report template"
- Save the .pbit file
- Close Power BI Desktop
- Open the .pbit file — notice how it prompts for data source parameters
- Compare the file sizes of the .pbix and .pbit files
- Write down three advantages of using template files
Summary
In this chapter, you learned the foundational concepts of Power BI:
- Business Intelligence is the process of turning raw data into actionable insights that drive better decisions
- Power BI is Microsoft's comprehensive BI platform that has dominated the market due to its affordability, integration with the Microsoft ecosystem, and powerful features
- The Power BI ecosystem consists of Desktop (authoring), Service (cloud sharing), Mobile (on-the-go access), Report Server (on-premises), and Embedded (custom apps)
- Power BI competes favorably against Tableau, Looker, and Qlik Sense, offering the best value for most organizations
- Four editions serve different needs — Free for learning, Pro for team collaboration, PPU for advanced features, and Premium Per Capacity for enterprise scale
- Installation is straightforward via the Microsoft Store or standalone installer (Windows only)
- The interface has three views (Report, Data, Model), a ribbon with five tabs, and essential panes (Visualizations, Fields, Filters)
- Building your first report involves loading data, adding visuals, formatting, and saving as a
.pbixfile - Key file types include
.pbix(reports),.pbit(templates),.rdl(paginated reports), and.pbip(project folders) - The Power BI workflow follows six stages: Get Data → Transform → Model → Visualize → Publish → Share
In the next chapter, you will dive deeper into the first stage — Getting Data — where you will learn how to connect Power BI to various data sources including Excel, CSV, SQL Server, web data, and more.