Power BI – Data Visualization (2025)

What is Power BI – Business Intelligence

Power BI is an advanced interactive data visualization tool developed by Microsoft that helps transform raw data from multiple sources into meaningful insights through charts, graphs, and dashboards. As a Business Intelligence (BI) solution, Power BI enables users to collect, clean, and visualize data without extensive programming knowledge.

Key Features of Power BI:

  • Connect to multiple data sources simultaneously
  • Clean and transform data easily
  • Create interactive visualizations
  • Build comprehensive dashboards
  • Share insights across organizations

How to Download and Install Power BI Desktop

Method 1: Download from Microsoft Store

  1. Open Microsoft Store on your Windows PC
  2. Search for “Power BI Desktop”
  3. Click Install button
  4. Wait for automatic installation

Method 2: Download from Official Website (Recommended)

  1. Visit: https://www.microsoft.com/en-us/download/details.aspx?id=58494
  2. Click Download button
  3. File Details:
    • File Name: PBIDesktopSetup_x64.exe
    • File Size: 826.2 MB
    • Latest Version: 2.148.878.0
  4. Run the installer and follow on-screen instructions

💡 Tip: Download from the official website for the latest features and updates.

Supported Data Sources in Power BI

Power BI connects to numerous data sources, making it incredibly versatile:

1. Excel Files (.xlsx, .xls)

Most commonly used for small to medium datasets

2. SQL Databases

  • Oracle
  • MySQL
  • PostgreSQL
  • SQL Server

3. Text Files

  • CSV (Comma-Separated Values)
  • TSV (Tab-Separated Values)
  • TXT files

4. XML Files

Structured data format

5. JSON Files

Web-based data format

6. PDF Files

Extract tables from PDF documents

7. Folders

Import multiple files at once (Excel + CSV + TXT combined)

8. Microsoft Access

Access database files

9. Azure Cloud Services

Cloud-based data storage

Dataset Details

Sheet IndexSheet Name
1ADM 22
2ADM 23
3ADM 24
4Bills

Step-by-Step: Importing Data into Power BI

Understanding Import Options

When importing data, Power BI offers three options:

  1. Load – Directly import data without cleaning
  2. Transform Data – Clean data before importing
  3. Combine & Transform – Merge multiple files and clean (only for multiple files)

Best Practice for Beginners:

✅ Always choose “Combine & Transform Data” to ensure clean, quality data

Data Cleaning in Power Query Editor

After clicking “Transform Data” the Power Query Editor opens. This is your data preparation workspace.

Understanding the Power Query Interface:

Top Section: Ribbon with tools and options

Left Panel: List of all queries/data sources

Center: Data preview

Right Panel: Applied Steps (shows all transformations)

⚠️ Important: No direct Undo button available – use “Delete” on Applied Steps instead

Essential Data Cleaning Steps

1. Remove Unwanted Columns

Steps:

  • Hold Ctrl key
  • Click to select multiple unwanted columns
  • Go to Home Tab → Click Remove Columns

Why?

Reduces file size and improves performance

2. Detect and Fix Data Types

Steps:

  • Go to Transform Tab
  • Click Detect Data Type
  • Power BI automatically assigns correct data types (Text, Number, Date, etc.)

Common Data Types:

  • Text (ABC)
  • Whole Number (123)
  • Decimal Number (1.23)
  • Date (MM/DD/YYYY)
  • Boolean (True/False)

3. Split Column Values

Example: Column contains “Rephel21” (Name + Number)

Steps:

  1. Right-click the column
  2. Select Split Column
  3. Choose Non-Digit to Digit
  4. Data splits into “Rephel” and “21”

4. Text Transformation – Capitalize Each Word

Steps:

  1. Right-click the column (e.g., student name)
  2. Select Transform
  3. Choose Capitalize Each Word
  4. “john doe” becomes “John Doe”

5. Rename Columns for Clarity

Steps:

  1. Double-click column header
  2. Type new name (e.g., “Student Name”)
  3. Press Enter

6. Remove Duplicate Rows

Steps:

  1. Right-click on the column (usually ID column)
  2. Select Remove Duplicates
  3. Only unique records remain

💡 Best Practice: Always remove duplicates before loading data

7. Add Additional Data Sources

Example: Adding “fees_details.xlsx”

Steps:

  1. In Power Query Editor, click New Source
  2. Select Excel
  3. Browse and select file
  4. Check all required sheets
  5. Click OK

8. Close & Apply

After all cleaning:

  1. Click Close & Apply button (top-left)
  2. Data loads into Power BI
  3. View loaded data in Data panel (right side)

Understanding Power BI Interface: 4 Essential Views

1. Report View (Default)

  • Create visualizations
  • Design dashboards
  • Most-used view for building reports

Shortcut: Click report icon (left sidebar)

2. Table View (Data View)

  • See raw data in table format
  • Check data quality
  • Verify import success

Shortcut: Click table icon (left sidebar)

3. Model View

  • View relationships between tables
  • Check connection keys
  • Manage data model

Example: In your dataset, Enrollment Number connects Student and Fees tables

How to Check Relationships:

  1. Click Model View icon
  2. See lines connecting tables in center
  3. Check relationship details in right panel

4. DAX Query View (Advanced)

  • Write custom calculations
  • For advanced users
  • Use DAX (Data Analysis Expressions) language

Managing Multiple Pages in Reports

Add New Pages:

  1. Look at bottom-left of screen
  2. Click “+” button next to page tabs
  3. Rename pages: Right-click → Rename

Use Cases:

  • Page 1: Overview Dashboard
  • Page 2: Student Details
  • Page 3: Fees Analysis

Saving Your Power BI File

Steps to Save:

  1. Click File → Save
  2. Choose location
  3. Enter file name
  4. File Extension: .pbix

💾 Best Practice: Save frequently (Ctrl + S)

Making Corrections After Loading Data

Need to fix something?

Steps:

  1. Go to Home Tab
  2. Click Transform Data
  3. Power Query Editor reopens
  4. Make changes
  5. Click Close & Apply

✅ All changes reflect automatically in reports

Navigation Tips

Zoom Controls:

  • Zoom In: Ctrl + Plus (+)
  • Zoom Out: Ctrl + Minus (-)
  • Scroll Zoom: Use mouse wheel

Creating Your First Visualization: 3 Methods

Method 1: Automatic Creation (Easiest for Beginners)

Steps:

  1. Go to Data Field Panel (right side)
  2. Check the boxes next to columns you want
  3. Power BI automatically creates appropriate visual

Example: Check “Course” and “Student Count” → Creates bar chart

Method 2: Manual Selection

Steps:

  1. Click desired visual from Visualization Panel (right side)
  2. Example: Select Clustered Column Chart
  3. Drag onto canvas
  4. Drag fields from Data Panel to visual areas:
    • X-axis: Category (e.g., Course Name)
    • Y-axis: Values (e.g., Student Count)

Method 3: Build Visual First

Steps:

  1. Click Build Visual button in Visualization Panel
  2. Select chart type
  3. Add data fields
  4. Customize as needed

Advanced Visualization Features

1. Date Hierarchy (Automatic Drill-Down)

Power BI automatically creates date levels:

  • Year (2024)
    • Quarter (Q1, Q2, Q3, Q4)
      • Month (Jan, Feb, Mar…)
        • Day (1, 2, 3…)

How to Use:

  1. Add date field to visual
  2. Click drill-down arrows on chart
  3. Navigate through time levels

Example: View last 3 years → drill to quarters → drill to months

2. Course Enrollment by Month

Create This Visual:

  1. Select Line Chart
  2. X-axis: Date (Month level)
  3. Y-axis: Course Count
  4. Legend: Course Name

Customizing Visuals: Format Options

Accessing Format Options:

  1. Select your visual
  2. Click Format Visual icon (paint roller icon) in Visualization Panel
  3. Explore customization options

Key Customization Options:

A. Font Styling

  • Font Color
  • Font Size
  • Font Family
  • Bold/Italic

B. Legend Settings

  • Position (Top, Bottom, Left, Right)
  • Show/Hide Legend
  • Legend Title

C. Axis Settings

  • Axis Title
  • Axis Range
  • Grid Lines
  • Labels

D. Colors

  • Data Colors
  • Background Color
  • Border Color

E. Title

  • Chart Title Text
  • Title Font Size
  • Title Alignment

💡 Pro Tip: Experiment with different options to find what works best

Creating a Donut Chart: Count of Students by Age

Step-by-Step Instructions:

Step 1: Create the Visual

  1. Unselect any existing visual (click blank area)
  2. Click Donut Chart icon in Visualization Panel
  3. Visual appears on canvas

Step 2: Add Data

  1. Drag Age field to Legend
  2. Drag Student Count to Values

Grouping Ages for Better Insights

Why Group? Instead of showing every age (18, 19, 20…), group into ranges (18-20, 21-23, etc.)

Steps to Create Age Groups:

  1. Select Age Range:
    • Click top value in Age column
    • Hold Shift
    • Click bottom value
    • All ages selected
  2. Create Group:
    • Right-click selection
    • Choose Group
    • Power BI creates age ranges
  3. Rename Group:
    • Double-click group name
    • Type new name (e.g., “Age Groups”)
    • Press Enter

Result: Cleaner visualization with age ranges instead of individual ages

Important Best Practices for Beginners

✅ Do’s:

  1. Always unselect existing visuals before creating new ones
    • Click blank canvas area
    • Prevents accidental modifications
  2. Save your work frequently
    • Use Ctrl + S
    • Prevents data loss
  3. Test different visualizations
    • Same data looks different in various charts
    • Find what tells your story best
  4. Use meaningful names
    • Rename columns clearly
    • Rename pages descriptively
  5. Check relationships in Model View
    • Ensures accurate data analysis

❌ Don’ts:

  1. Don’t skip data cleaning
    • Bad data = bad insights
  2. Don’t remove Applied Steps randomly
    • Can break your data model
  3. Don’t ignore data types
    • Wrong types cause calculation errors
  4. Don’t overcrowd dashboards
    • Keep visualizations simple and clear

Common Visualization Types and When to Use Them

1. Clustered Column Chart

Best For: Comparing categories Example: Students per course

2. Line Chart

Best For: Trends over time Example: Enrollment growth over months

3. Donut/Pie Chart

Best For: Parts of a whole Example: Age distribution percentage

4. Bar Chart

Best For: Ranking and comparison Example: Top 10 performing courses

5. Table

Best For: Detailed data display Example: Student roster with details

6. Card

Best For: Single key metrics Example: Total student count

7. Map

Best For: Geographic data Example: Students by location

Troubleshooting Common Issues

Problem 1: Visual Not Showing Data

Solutions:

  • Check if fields are in correct areas (X-axis, Y-axis, Values)
  • Verify data relationships in Model View
  • Check for filters applied

Problem 2: Wrong Data Type

Solution:

  • Go to Transform Data
  • Select column
  • Transform Tab → Data Type → Choose correct type

Problem 3: Can’t See All Data

Solution:

  • Check visual filters (Filter pane on right)
  • Adjust axis ranges
  • Check for empty values

Problem 4: Slow Performance

Solutions:

  • Remove unnecessary columns
  • Reduce data rows if possible
  • Close unused applications

Next Steps After Creating Your First Report

1. Explore More Visuals

  • Try different chart types
  • Combine multiple visuals
  • Create interactive dashboards

2. Learn DAX

  • Create calculated columns
  • Build custom measures
  • Advanced calculations

3. Share Your Reports

  • Publish to Power BI Service
  • Share with colleagues
  • Create mobile views

4. Advanced Features

  • Parameters
  • Bookmarks
  • Drill-through pages
  • Custom visuals

Sample Chart Suggestions (Correct, Beginner Friendly, Meaningful)

(use these exact visuals — avoid complex ones)

Use CaseChart TypeAxisLegendWhy this is correct
Compare admission counts across 3 yearsColumn ChartX = Year / MonthY = # AdmissionsView trend immediately
Compare branch wise performanceBar ChartX = Admission CountY = Branch NamesEasy to compare high / low
Course wise popularityDonut / PieValues = AdmissionsCategory = Course TypeGood for share of total
Revenue growthLine ChartX = MonthY = Revenue / FeesShows spike and drop cleanly
Year wise conversion winnerStacked Column ChartX = YearY = AdmissionsLegend = Branch

Meaningful Insight Structure for Power BI (Beginner Friendly)

Story Order of Report Pages (this makes smooth narrative)

  1. Year Wise Admissions Trend (22 vs 23 vs 24)
  2. Center / Branch Wise Admission Contribution
  3. Course Category Wise Admission
  4. Fees / Revenue Growth Trend
  5. Month Wise conversion pattern
  6. Which area needs immediate improvement

This flow makes client understand:

  • When we grew
  • Where we grew
  • Which Course actually works
  • Is the revenue matching admission growth

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *