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 Installation Guide

Learn how to download and install Power BI Desktop, launch the application, and complete the initial setup.

1. Learning Objectives

  • Understand what Power BI Desktop is and how it is used.
  • Identify official options for downloading Power BI Desktop.
  • Check basic system requirements before installation.
  • Run the setup file and install the application.
  • Launch Power BI Desktop and understand the welcome screen.
  • Identify common installation problems.
Tip: Always use an official Microsoft source. Avoid downloading software from unknown websites.

2. The Power BI Installation Process

The installation process is straightforward: download the application from an official source, run the setup, install the application, and then launch it.

Step 1 Official Download Step 2 Run Setup File Step 3 Install Application Step 4 Launch Power BI Download → Setup → Install → Open
Figure 1: The basic Power BI Desktop installation workflow.

3. How to Download Power BI Desktop

Power BI Desktop is a Windows application used to connect to data, transform data, build data models, and design reports.

Download Steps

  1. Open a web browser on your Windows computer.
  2. Visit the official Microsoft Power BI Desktop download page.
  3. Review the available installation options carefully.
  4. Choose an option that suits your computer and your organization’s policies.
  5. Wait for the download to finish.

Official download page: Microsoft Power BI Desktop

The Microsoft Store may also be available. Installation permissions or IT policies may apply to organization-managed computers.

Important: Avoid random download websites, unknown executable files, and modified installers. If you are using an office or institute computer, obtain permission from the administrator before installing software.

4. Verify the Download Source

powerbi.microsoft.com/desktop/ Power BI Desktop Microsoft data analysis and reporting tool Official Download Illustration only — the actual website layout may vary.
Figure 2: Verify the official Microsoft source before downloading.

5. Check Your System Before Installation

Before starting the installation, check your computer’s basic specifications. Exact requirements may vary by Power BI Desktop version.

Check What to Check Why It Matters
Operating System Confirm that your Windows version is supported. Ensures application compatibility.
System Type Check the system architecture in Windows settings and review the available installer options. Helps you choose the correct installation option.
Memory (RAM) Check available memory and overall system performance. Supports performance when working with large datasets.
Storage Confirm that sufficient disk space is available. Needed for downloads, installation, and project files.
Permissions Confirm that you have permission to install applications. Installation may be blocked on a managed computer.
Internet Use a stable connection for downloading the installer. Needed to download the installer and use online features.
Practical example: If Samadhan does not have installation permission on his computer, he should contact the administrator or IT support. He should not attempt to bypass the restriction.

6. Installation Checklist

Before You Install Official source verified Supported Windows version Enough free storage Installation permission checked
Figure 3: Complete this checklist before running the installer.

7. How to Install Power BI Desktop

Method A: Using the Downloaded Installer

  1. Locate the downloaded installer file.
  2. Verify the file name and download source.
  3. Open the installer. If Windows displays a permission prompt, verify the source before proceeding.
  4. Read the setup wizard instructions carefully.
  5. Review the license terms and installation options.
  6. Select Install if you have the required permission.
  7. Wait for the installation to complete.
  8. When setup finishes, open Power BI Desktop from the Start menu.

Method B: Using the Microsoft Store

  1. Open the Microsoft Store if it is available on your computer.
  2. Search for Power BI Desktop.
  3. Verify the publisher and application details.
  4. Select Get or Install if the option is available.
  5. Launch the application after installation completes.

Availability, update processes, and permissions may differ depending on the system and organization.

If the installer displays an error, record the message. Check system requirements, Windows updates, available storage, and administrator permissions. Contact Microsoft Support or your IT administrator if necessary.

8. Launch Power BI Desktop for the First Time

After installation, search for Power BI Desktop in the Start menu and open it. The first launch may display a welcome screen, sign-in prompt, or update message. The screen may vary by version.

Power BI Desktop Welcome New report Open report Welcome to Power BI Desktop Connect data, build a model and create reports. Create a report Illustrative mockup — actual screen may vary by version. First launch: start a new report or open an existing file
Figure 4: An illustrative example of the Power BI Desktop welcome screen.

What to Do After the First Launch

  • Identify the application name and version.
  • If a sign-in prompt appears, follow the requirements for your account and task.
  • Locate the New Report or blank report option.
  • For practice, start a new report instead of modifying existing files.

9. Common Installation Problems

Problem Possible Reason What To Do
The installer does not start The download may be incomplete, the file may be blocked, or the setup may be unsupported. Download the file again from the official source and check compatibility.
Permission error The user account does not have installation rights. Contact the administrator or IT support.
Storage error There is not enough disk space. Check available storage and remove only files you are permitted to delete.
The application is slow System resources may be limited or too many applications may be running. Verify the system requirements and close unnecessary applications.
Application open nahi hoti There may be a compatibility, installation, or system issue. Record the error details, check for updates, and seek official support.

10. Classroom Practical Activity

Activity: Power BI Readiness Check

At CIIT TRANING INSTITUTE, Samiksha, Omkar, and Neha can complete this activity during practical class.

  1. Check the Windows version on the computer.
  2. Open the official Microsoft Power BI Desktop page.
  3. Identify the available download options.
  4. Complete the installation with the instructor’s permission.
  5. Launch Power BI Desktop from the Start menu.
  6. Locate the New Report option on the welcome screen.
  7. Report the installation status to the instructor and mention any errors.

Practice Questions

  1. What is the main purpose of Power BI Desktop?
  2. Why is it important to download software from an official source?
  3. Which system checks should be completed before installation?
  4. How might installation using a downloaded installer differ from installation through the Microsoft Store?
  5. What should you do if you receive a permission error?
  6. How do you launch the application after installation?

Summary

In this lesson, we learned how to download Power BI Desktop from an official Microsoft source, check system readiness, and install the application using a downloaded installer or the Store option.

We also covered the first launch, the welcome screen, and common installation issues. Always use an official source, verify system requirements, and contact an administrator if you encounter permission problems.