Master Power BI From Scratch

Learn Power BI fundamentals, data sources, data transformation, data modeling, DAX, visualizations, reports, and dashboards through structured practical lessons.

COURSE SYLLABUS
1. Power BI Introduction
Introduction to Power BI Power BI Desktop and Service Power BI Workflow Power BI Terminology Power BI Workspace Overview
2. Power BI Installation and Interface
Power BI Installation Power BI Desktop Interface Report, Data and Model Views Power BI File Management Power BI Settings and Options
3. Power BI Data Sources
Excel and CSV Data Sources Text and Folder Data Sources Database Data Sources Web and Online Data Sources Data Source Credentials and Refresh
4. Power BI Data Transformation
Power Query Introduction Data Types and Column Operations Merge and Append Queries Split, Group and Pivot Columns Power Query Applied Steps
5. Power BI Data Cleaning
Missing and Null Values Remove Duplicates and Errors Text and Date Cleaning Replace and Fill Values Data Quality Validation
6. Power BI Data Modeling
Data Modeling Fundamentals Create Table Relationships Cardinality and Filter Direction Star Schema and Dimension Tables Date Tables and Model Optimization
7. DAX
DAX Introduction and Syntax DAX Aggregation Functions DAX Logical and Conditional Functions DAX Filter and Iterator Functions DAX Date and Time Intelligence
8. Power BI Calculations
Calculated Columns Measures and Implicit Measures Row Context and Filter Context Quick Measures and KPI Time-Based Business Calculations
9. Power BI Visualizations
Basic Power BI Charts Pie, Donut and Treemap Charts Cards, Tables and Matrices Maps and Geographic Visuals Advanced and Custom Visuals
10. Power BI Filters and Slicers
Filter Types and Filter Pane Slicers and Sync Slicers Drill Down and Drill Through Cross-Filtering and Highlighting Bookmarks and Buttons
11. Power BI Reports and Dashboards
Report Page Layout and Design Multi-Page Reports Dashboard Creation and Tiles Executive and Business Reports Report Usability and Accessibility
12. Power BI Formatting and Interactivity
Themes and Color Formatting Conditional Formatting Tooltips and Report Page Tooltips Visual Interactions and Edit Interactions Mobile Layout and Responsive Reports
13. Power BI Publishing and Sharing
Publish Reports to Service Workspaces and Apps Scheduled Refresh and Gateway Sharing and Permissions Row-Level Security and Deployment
14. Power BI Projects and Assessment
Sales Dashboard Project Student Performance Project Data Cleaning and Modeling Assignment DAX and Visualization Assessment Final Power BI Project and Assessment

Power BI Desktop and Service

Understand the difference between Power BI Desktop and Power BI Service, learn how they work together, and discover how reports move from development to sharing.

1. What Is Power BI Desktop?

Power BI Desktop is a Windows application used to create data models and interactive reports. It is generally where a report developer starts working with data.

You can connect to files and databases, clean and transform data, create relationships between tables, write calculations using DAX, and design report pages containing charts and tables.

Example for Beginners

Suppose Neha receives an Excel file containing sales information. She opens Power BI Desktop, imports the file, checks the data, creates a sales chart, and builds a report showing sales by product and month.

She can save the report as a Power BI Desktop file with the .pbix extension.

Common tasks in Power BI Desktop

  • Connect to supported data sources.
  • Clean and transform data with Power Query.
  • Build data models and table relationships.
  • Create calculated columns and measures using DAX.
  • Design report pages and interactive visualizations.
  • Save report development work in a PBIX file.
Remember: Desktop is primarily the report development environment. You do not need to publish a report just to start building and exploring it locally.

2. Understanding the Desktop Workspace

Power BI Desktop includes different views that help you work with report pages, data, and relationships. The available interface may vary slightly by version and settings.

Power BI Desktop - Example Workspace R D M Sales Report Total Sales ₹90,000 Products 3 Product Sales Visualizations Data Fields ▸ Sales ▸ Product ▸ Date ▸ Quantity ▸ Region Simplified illustration, not an actual screenshot

Visual 1: A simplified illustration of the report canvas, visualization tools, and data fields.

Three important views

View Purpose
Report view Create report pages and arrange visualizations.
Table/Data view Inspect loaded table data and columns where supported.
Model view Inspect and manage relationships between tables.

3. What Is Power BI Service?

Power BI Service is Microsoft's online analytics service. Users access it through a web browser to view and work with Power BI content according to their permissions.

Once a report has been published, authorized users can access it in the Service. Teams may use workspaces to organize content and distribute reports through supported sharing methods.

Example for Beginners

After building a sales report in Desktop, Neha publishes it to a workspace in Power BI Service. Her manager can then open the report online if the required access and licensing conditions are satisfied.

Common tasks in Power BI Service

  • Access published reports and semantic models.
  • Organize content in workspaces.
  • Share reports with authorized users.
  • Create dashboards from supported report content.
  • Configure scheduled refresh when supported and required.
  • Manage access and permissions according to organizational policies.
Important: Publishing a report does not automatically make it public. Access depends on workspace permissions, sharing settings, licensing, and your organization's configuration.

4. How Desktop and Service Work Together

Desktop and Service are connected parts of the Power BI workflow. Desktop is commonly used to build the report, while Service is used to publish, access, and distribute it.

Power BI Desktop Connect and prepare data Build the report Publish Power BI Service Organize content Manage access Access Authorized Users View reports Explore insights Sharing and access depend on permissions and licensing. Simplified workflow

Visual 2: The usual development and publishing workflow.

  1. Connect to the required data in Power BI Desktop.
  2. Prepare the data and create the report.
  3. Save your work as a PBIX file.
  4. Publish the report to a suitable workspace in Power BI Service.
  5. Grant the appropriate access so intended users can view it.

5. Power BI Desktop vs Power BI Service

Feature Power BI Desktop Power BI Service
Where it runs Windows desktop application. Online service accessed through a browser and supported experiences.
Main purpose Develop data models and reports. Publish, access, organize, and share content.
Data preparation Power Query is commonly used to transform data. Supports refresh and other online data management features.
Report development Full report authoring environment for many common tasks. Online report editing is available for supported scenarios.
Collaboration Primarily local development. Workspaces, sharing, and collaboration features.
Typical file .pbix Published Power BI content stored in the Service.
Easy way to remember: Desktop is where you commonly build the report. Service is where you publish, access, and share it online.

6. Understanding the PBIX File

A .pbix file is a Power BI Desktop report file. Depending on how the report is built, it can contain report definitions, model information, and imported data.

.PBIX Power BI Desktop File Save your report work Report Design Pages, charts, tables and layout Data Model Tables, relationships and calculations Data, Where Applicable Imported data or model configuration

Visual 3: A simplified view of the elements associated with a PBIX file.

Beginner tips for saving files

  • Use a descriptive file name, such as SalesReport.pbix.
  • Save your work regularly while developing a report.
  • Keep backup copies when making significant changes.
  • Remember that a local PBIX file and a published online report are not the same thing.

7. What Happens After Publishing?

Publishing transfers supported report content from Desktop to a destination in Power BI Service. After publishing, the online report can be managed according to the workspace's capabilities and permissions.

Example: A Sales Manager

Omkar builds a report containing sales by region. He publishes it to his organization's approved workspace. His manager opens the published report in a browser and uses the available filters to examine a particular region.

If the source data changes, the report's data may need to be refreshed. The exact refresh method depends on the source, credentials, connectivity, and configuration.

8. The Publishing Cycle

1. Develop Build the report in Desktop 2. Save Save the PBIX file 3. Publish Send to a workspace 4. Access View and share safely Follow your organization's publishing and access policies. Simplified publishing cycle

Visual 4: From report development to online access.

9. Beginner Practice Questions

Q1. Which application is commonly used to create Power BI reports?

Answer: Power BI Desktop.

Q2. What is Power BI Service?

Answer: Microsoft's online service for accessing, publishing, organizing, and sharing Power BI content.

Q3. What is a PBIX file?

Answer: A Power BI Desktop file that stores report content and associated model information, depending on the report.

Q4. Does publishing automatically make a report public?

Answer: No. Access depends on permissions, sharing settings, licensing, and organizational configuration.

Q5. Why might a published report need a refresh?

Answer: To retrieve updated source data when refresh is required and supported by the source and configuration.

Summary

Power BI Desktop is commonly used to prepare data, build models, write calculations, and create report pages. Power BI Service is used to publish, access, organize, and share content online.

You learned about Desktop views, the PBIX file, the publishing workflow, and why permissions and refresh configuration matter after publication.