Power BI Basics for Beginners

🔹 Introduction

This section introduces you to Power BI, a tool used for data visualization and dashboard creation.
It is designed for beginners with no prior experience.

🔹 STEP 1: Understanding Power BI

Power BI is a tool used to analyze data and create dashboards.
It allows you to turn raw data into meaningful insights using visuals.

🔹 STEP 2: Power BI Interface

When you open Power BI, you will see:
  • Ribbon (top menu)
  • Report view (for creating visuals)
  • Data view (to view data)
  • Model view (relationships)
  • Fields panel (your data columns)
  • Visualizations panel (charts)

🔹 STEP 3: Importing Data

  1. Click on "Get Data"
  1. Select your dataset (Excel or CSV)
  1. Click "Load"

🔹 STEP 4: Transforming Data

Before analyzing data, we need to clean it.
Click on "Transform Data".
This opens Power Query Editor, where data cleaning is done.
Power Query is the part of Power BI where we clean and prepare our data before analysis.
Here, you can:
  • Remove empty rows
  • Rename columns
  • Change data types
  • Remove errors

🔹 STEP 5 : CLEAN AND FIX DATA

Ensure:
  • Dates are in date format
  • Numbers are numeric
  • Text fields are correct
In Power Query:
  • Check for missing values
  • Ensure correct data types:
- Dates → Date format
- Sales → Decimal number
- Quantity → Whole number
If your data is not clean, your analysis will be incorrect.

🔹 STEP 6: CLOSE & APPLY

After cleaning your data:
Click "Close & Apply"
When you click "Close & Apply", Power BI loads your cleaned data into Power BI Desktop.
If there are no errors, your data will load successfully.
If there are errors (such as incorrect data types), Power BI may not load properly, and you will need to fix them in Power Query.
Power Query is used for cleaning data. Power BI Desktop is where we analyze data and build reports.
 

🔹 STEP 7 : CREATE MEASURES (CORE ANALYSIS)

After loading your data, you can now create measures.
Measures are calculations used to analyze data dynamically.
 
🔹 WHAT IS A MEASURE?
A measure is a formula used to calculate values such as total sales, total profit, or averages.
Measures are important because they update automatically based on filters and visuals.
 
🔹 WHY WE USE MEASURES
We use measures because:
  • They allow dynamic calculations
  • They respond to filters and visuals
  • They help summarize large datasets
  • They make dashboards interactive
 
🔹 TYPES OF MEASURES
Some common measures include:
  • SUM → Total values (e.g., total sales)
  • AVERAGE → Average values
  • COUNT → Number of records
  • DIVIDE → Used for ratios (e.g., profit margin)
 
🔹 STEP 8 — CREATE YOUR FIRST MEASURE
To create a measure:
  1. Click on "New Measure"
  1. Type the formula:
Total Sales = SUM(Sales)
This measure calculates the total sales in the dataset.
 
🔹 ADD MORE MEASURES
You can also create:
Total Profit = SUM(Profit)
Total Quantity = SUM(Quantity)
 
🧠 IMPORTANT NOTE
Measures are created in Power BI Desktop after data is loaded, not in Power Query.
 

🔹STEP 9 — WHAT NEXT?

Now that your data is clean and your measures are created, you are ready to build visuals and dashboards.
In the next tutorial, we will learn how to create charts and build a complete dashboard in Power BI.