MBA-II Semester-III

Unit 1: Ge ng Started with Power BI

1. Introduc on to Power BI

Power BI is a Business Intelligence (BI) and Data Visualiza on tool developed by Microso that
enables users to connect, transform, analyze, and visualize data from various sources and
share insights through interac ve dashboards and reports.

Objec ves of Power BI

Convert Raw Data into Meaningful Insights
Meaning

Raw data refers to unprocessed facts and figures collected from various sources such as
sales transac ons, customer records, surveys, or system logs. By itself, raw data has no
direct meaning.
Conver ng raw data into meaningful insights involves cleaning, processing, analyzing,
and visualizing data so that it supports decision-making.

Steps to Convert Raw Data into Meaningful Insights

1. Data Collec on

 Data is collected from mul ple sources such as Excel files, databases, CRM systems, or
online pla orms.

 Example sources: sales records, customer feedback, website traffic.

2. Data Cleaning

 Removal of duplicate records

 Handling missing or null values

 Correc ng data types (date, currency, text)

Purpose: Ensure accuracy and consistency.

 3. Data Transforma on

 Sor ng and filtering data

 Grouping values (monthly, quarterly, region-wise)

 Crea ng calculated fields such as totals, averages, or growth rate

4. Data Analysis

 Applying calcula ons and aggrega ons

 Iden fying trends, pa erns, and outliers

 Comparing performance across me, regions, or products

5. Data Visualiza on

 Represen ng data using charts, tables, KPIs, and dashboards

 Helps users understand insights quickly

6. Insight Genera on

 Interpre ng analyzed data to support business decisions

 Answering ques ons like What happened? Why did it happen? What should be done
next?

Role of Power BI in Conver ng Raw Data into Insights

Power BI helps in:

 Connec ng mul ple data sources

 Cleaning and transforming data using Power Query

 Crea ng measures using DAX

 Visualizing data through interac ve dashboards

 Sharing insights with stakeholders

Example

Raw Data (Sales Table)

Date Product Region Sales Amount

01-01-2024 Laptop West 45,000

02-01-2024 Laptop West 45,000

02-01-2024 Mouse East NULL

This data is raw and unstructured:

 Duplicate entries

 Missing values

 No summary informa on

Processed Data (A er Cleaning & Transforma on)

Month Product Region Total Sales

Jan Laptop West 90,000

Jan Mouse East 8,000

Meaningful Insights Generated

 Laptop sales in the West region are high

 Mouse sales are low in the East region

 West region contributes more revenue

Business Decision Based on Insight

 Increase inventory of laptops in West region

 Launch promo onal offers for mouse in East region

Conclusion

Conver ng raw data into meaningful insights helps organiza ons:

 Understand business performance

 Iden fy opportuni es and risks

 Take informed and data-driven decisions

Power BI plays a crucial role by providing tools for data cleaning, analysis, and
visualiza on, transforming raw data into ac onable insights

Enable Data-Driven Decision-Making

Meaning

Data-driven decision-making refers to the process of making business decisions based

on data analysis, facts, and insights rather than intui on or personal experience. It
involves collec ng, analyzing, and interpre ng data to support accurate, objec ve, and
mely decisions.

Importance of Data-Driven Decision-Making

 Reduces guesswork and bias

 Improves accuracy and consistency

 Helps iden fy trends and pa erns

 Enhances organiza onal performance

 Supports strategic planning

Process of Data-Driven Decision-Making

1. Data Collec on
 Collect data from mul ple sources such as sales systems, CRM, ERP, surveys, and
websites.

 Data may be structured or unstructured.

2. Data Cleaning and Prepara on

 Remove duplicates and errors

 Handle missing values

 Standardize formats

Purpose: Ensure reliable and accurate data.

3. Data Analysis

 Apply calcula ons and aggrega ons

 Compare historical and current performance

 Iden fy trends, correla ons, and outliers

4. Data Visualiza on

 Use charts, dashboards, and KPIs

 Makes complex data easy to understand

 Enables quick interpreta on

5. Decision Making

 Managers interpret insights

 Ac ons are taken based on evidence

 Results are monitored for improvement

Role of Power BI in Enabling Data-Driven Decision-Making

 Power BI supports data-driven decisions by:

 Integra ng data from mul ple sources

 Transforming data using Power Query

 Crea ng measures using DAX

 Providing real- me interac ve dashboards

 Sharing insights across the organiza on

Example

Scenario: Retail Sales Performance

A retail company collects daily sales data from different regions.

Raw Data Includes:

 Product sales

 Region-wise revenue

 Monthly targets

Analysis Using Power BI

 Sales trends are visualized using line charts

 Region-wise performance shown using bar charts

 KPIs indicate target achievement

Insights Generated

 South region consistently underperforms

 Electronics category shows high growth

 Weekend sales are higher than weekdays

Decision Based on Data

 Increase promo ons in South region

 Focus marke ng on electronics

 Extend weekend store hours

Benefits Achieved

 Improved sales performance

 Be er resource alloca on

 Faster and more confident decisions

Advantages of Data-Driven Decision-Making

 Objec ve and reliable decisions

 Improved efficiency

 Be er risk management

 Compe ve advantage

Conclusion

Enabling data-driven decision-making helps organiza ons move from intui on-based
decisions to evidence-based strategies. Tools like Power BI play a crucial role by
conver ng data into insights that support faster, smarter, and more effec ve business
decisions.

 Provide real- me analy cs

 Meaning

 Real- me analy cs refers to the analysis of data as soon as it is generated or updated,

enabling organiza ons to monitor current performance, detect issues instantly, and
take immediate ac on. Unlike tradi onal repor ng, which relies on historical data, real-
me analy cs focuses on live or near-real- me data processing.


 Need for Real-Time Analy cs

 Rapidly changing business environments

 Need for immediate decision-making

 Monitoring opera onal performance

 Detec ng risks and opportuni es instantly

 Improving customer experience

 Key Characteris cs of Real-Time Analy cs

 Con nuous data processing

 Minimal data latency

 Up-to-date dashboards and KPIs

 Instant alerts and no fica ons

 Supports opera onal and tac cal decisions

 How Real-Time Analy cs Works

 1. Data Genera on

 Data generated from transac onal systems, IoT devices, websites, sensors, or ERP
systems.

 Example: Online sales transac ons, website clicks, inventory updates.

 2. Data Streaming or Live Connec on

 Data is connected using DirectQuery or live connec ons.

 Data remains in the source system and is queried in real me.

 3. Data Processing

 Data is processed dynamically without storing it in Power BI.

 Queries are executed whenever the dashboard is refreshed.

 4. Visualiza on and Monitoring

 Real- me dashboards show current metrics and KPIs.

 Automa c refresh ensures up-to-date informa on.

 5. Decision and Ac on

 Managers analyze live data.

 Immediate correc ve or strategic ac ons are taken.

 Role of Power BI in Providing Real-Time Analy cs

 Power BI supports real- me analy cs through:

 DirectQuery Mode – retrieves live data from source

 Streaming Datasets – push data in real me

 Auto Page Refresh – frequent updates

 Dashboards & KPIs – monitor live performance

 Alerts – no fy users when thresholds are crossed

 Power BI Data Modes for Real-Time Analy cs

 Mode  Descrip on

 Import  Scheduled refresh, not real- me

 DirectQuery  Queries live data

 Live Connec on  Real- me connec on to models

 Streaming Dataset  Con nuous data flow


 Example

 Scenario: Online E-Commerce Pla orm

 An e-commerce company wants to track live sales performance.

 Data Source

 Website transac ons

 Payment gateway logs

 Power BI Implementa on

 DirectQuery connec on to sales database

 Dashboard shows:

 Live sales amount

 Orders per minute

 Product availability

 Insights Generated

 Sudden drop in sales detected

 Inventory running low for popular products

 Spike in traffic during promo ons

 Business Decisions

 Trigger immediate stock replenishment

 Resolve payment gateway issues

 Adjust promo onal strategy instantly

 Advantages of Real-Time Analy cs

 Faster decision-making

 Reduced opera onal risks

 Improved customer sa sfac on

 Be er monitoring of KPIs

 Compe ve advantage

 Challenges of Real-Time Analy cs

 High system and infrastructure cost

 Performance issues with large data

 Dependency on source system availability

 Complex implementa on

 Applica ons of Real-Time Analy cs

 Financial markets

 Supply chain management

 Fraud detec on

 Website traffic monitoring

 Manufacturing opera ons

 Conclusion

 Providing real- me analy cs enables organiza ons to respond instantly to business

events, improve efficiency, and reduce risks. Power BI facilitates real- me analy cs
through DirectQuery, live dashboards, and alerts, making it a powerful tool for modern,
data-driven enterprises.

 Enable self-service BI for business users

Meaning

 Self-Service Business Intelligence (Self-Service BI) refers to the ability of non-technical

business users (such as managers, analysts, and execu ves) to access, analyze, and
 visualize data on their own without depending heavily on IT teams. It empowers users
to create reports, dashboards, and insights using intui ve tools like Power BI.

 Need for Self-Service BI

 Increasing volume and variety of business data

 Delay in decision-making due to IT dependency

 Need for quick insights by managers

 Demand for flexibility and customiza on in reports

 Key Features of Self-Service BI

 User-friendly and interac ve interface

 Drag-and-drop visualiza ons

 Minimal coding or technical knowledge required

 Real- me and ad-hoc repor ng

 Secure data access

 How Self-Service BI Works

 1. Data Access

 Business users connect to pre-approved data sources.

 Data is made available through shared datasets or models.

 2. Data Prepara on

 Users can clean and transform data using tools like Power Query.

 Common tasks include filtering, sor ng, and renaming columns.

 3. Data Modeling
 Simple rela onships and calcula ons can be created.

 Measures and KPIs are defined using DAX.

 4. Visualiza on

 Users create charts, tables, KPIs, and dashboards.

 Interac ve features such as slicers and filters are applied.

 5. Insight Sharing

 Reports and dashboards are shared via Power BI Service.

 Users collaborate and discuss insights.

 Role of Power BI in Enabling Self-Service BI

 Power BI supports self-service BI by:

 Providing an intui ve user interface

 Allowing drag-and-drop report crea on

 Enabling data transforma on without coding

 Offering built-in DAX func ons

 Suppor ng secure data sharing and collabora on

 Example

 Scenario: Sales Manager

 A sales manager wants to analyze monthly sales performance.

 Without Self-Service BI

 Requests IT team for reports

 Waits for days

 Limited flexibility
 With Self-Service BI (Power BI)

 Imports sales data directly

 Creates region-wise and product-wise dashboards

 Uses slicers for me and region

 Gets instant insights

 Insights Generated

 Iden fica on of top-performing regions

 Detec on of underperforming products

 Comparison of actual sales vs targets

 Business Decisions

 Adjust sales targets

 Plan promo ons

 Allocate resources effec vely

 Advantages of Self-Service BI

 Faster decision-making

 Reduced dependency on IT

 Improved produc vity

 Enhanced data literacy among users

 Be er alignment with business goals

 Challenges of Self-Service BI

 Risk of data inconsistency

 Security and governance issues

  Requires proper training

 Possibility of incorrect interpreta ons

 Best Prac ces for Self-Service BI

 Use centralized and trusted datasets

 Apply role-based security

 Provide training to users

 Define data governance policies

 Conclusion

 Enabling self-service BI allows business users to take ownership of data analysis, leading
to faster insights and smarter decisions. Tools like Power BI play a vital role by offering
easy-to-use features while maintaining data security and governance.

Dear Students, just Like above, you have to prepare

notes on each following topic

 Key Features

 Interac ve dashboards and reports

 Integra on with Excel, Azure, SQL Server

 Cloud-based sharing and collabora on

 Advanced analy cs using DAX

2. Components of Power BI

a) Power BI Desktop

 Free Windows applica on

  Used for data loading, transforma on, modeling, and report crea on

 Supports Power Query and DAX

 Reports saved as .pbix files

Users: Data analysts, BI developers

b) Power BI Service

 Cloud-based SaaS pla orm

 Used for publishing, sharing, and collabora on

 Provides dashboards, workspaces, scheduled refresh, security

Users: Managers, decision makers

c) Power BI Mobile

 Mobile app for Android and iOS

 Provides real- me access to dashboards

 Supports alerts and touch interac on

3. Power BI Interface and Naviga on

Main Views

1. Report View – Create and format visuals

2. Data View – View table data and columns

3. Model View – Manage table rela onships

Important Panes

 Ribbon (Home, Insert, Modeling, View)

 Visualiza ons Pane

 Fields Pane

 Filters Pane
4. Data Sources and Data Connec vity

Power BI supports mul ple data source types:

File-based Sources

 Excel

 CSV/Text

 XML, JSON

 PDF

Database Sources

 SQL Server

 Oracle

 MySQL

 PostgreSQL

Online / Cloud Sources

 SharePoint

 Azure SQL Database

 Google Analy cs

 Salesforce

5. Impor ng and Transforming Data using Power Query

Power Query is an ETL (Extract, Transform, Load) tool used for preparing data before analysis.

Common Transforma ons

 Remove duplicates and errors

 Replace null values

 Split and merge columns

 Change data types

  Filter rows

Benefits

 Improves data accuracy

 Reduces manual work

 Ensures consistency

6. Data Load Op ons: Import vs DirectQuery

Feature Import Mode DirectQuery

Data storage In Power BI In source

Performance Fast Slower

Data size Limited Large datasets

Refresh Scheduled Real- me

7. Saving and Publishing Reports

 Reports saved as .pbix

 Published to Power BI Service

 Shared via dashboards, apps, or links

Unit 2: Data Prepara on and Modeling

1. Data Cleaning and Shaping (Power Query Editor)

Data prepara on ensures accuracy, consistency, and reliability.

Cleaning Ac vi es

 Remove duplicates

 Handle missing values

 Rename columns
  Filter irrelevant data

2. Crea ng Rela onships and Data Models

Rela onships define how tables are connected.

Types of Rela onships

 One-to-One

 One-to-Many (most common)

 Many-to-Many

Star Schema

 Central fact table

 Surrounding dimension tables

 Improves performance and clarity

3. Calculated Columns and Measures

Calculated Columns Measures

Stored in table Calculated dynamically

Row-level Aggregate-level

Increases model size Efficient

4. Introduc on to DAX

DAX (Data Analysis Expressions) is a formula language used for calcula ons in Power BI.

Uses of DAX

 Create measures

 Create calculated columns

 Perform advanced analy cs

Example:
Total Sales = SUM(Sales[Amount])

5. Hierarchies and Date Tables

 Hierarchies enable drill-down analysis

 Date tables required for me intelligence

Hierarchy Example:
Year → Quarter → Month → Day

6. Managing Data Types, Categories, and Forma ng

 Assign correct data types (Text, Date, Number)

 Set data categories (Geography, URL)

 Apply currency and percentage forma ng

Unit 3: Data Visualiza on and Charts

1. Basic Visualiza ons

 Bar & Column Charts – comparison

 Line Charts – trends

 Pie Charts – propor ons

 Table & Matrix – detailed analysis

2. Advanced Visualiza ons

 Funnel – sales stages

 Gauge – target vs actual

 Waterfall – variance analysis

 KPI – performance tracking

 Maps – geographical insights

3. Condi onal Forma ng and Drill-Through

 Highlights values using color or icons

 Drill-through enables detailed page-level analysis

4. Slicers and Filters

 Interac ve filtering tools

 Visual-level, Page-level, Report-level filters

5. Tool ps, Bookmarks, Bu ons

 Tool ps display extra informa on

 Bookmarks capture report state

 Bu ons enable naviga on

6. Custom Visuals and Themes

 Download from Microso AppSource

 Themes ensure consistent design

Unit 4: Calcula ons and Advanced Analy cs

1. Important DAX Func ons

 SUMX() – row-by-row calcula on

 CALCULATE() – modifies filter context

 FILTER() – applies condi ons

2. Time Intelligence Func ons

 TOTALYTD()
  SAMEPERIODLASTYEAR()

 DATEADD()

3. Calculated Tables and Fields

 Created using DAX

 Used for intermediate calcula ons

4. Aggrega ons and Nested Measures

 Measures built using other measures

 Enhances reusability and performance

5. What-If Analysis

 Scenario analysis using parameters

 Controlled by slicers

6. Analy cs Pane

 Trend lines

 Forecas ng

 Reference and constant lines

Unit 5: Storytelling and Sharing Insights

1. Dashboards and Reports

 Reports: mul ple pages

 Dashboards: single-page summary

2. Layout Op miza on
  Responsive design

 Op mized for desktop and mobile

3. Designing Effec ve Data Stories

 Logical insight flow

 Use bookmarks and naviga on

 Focus on KPIs

4. Embedding Insights

 PowerPoint

 Microso Teams

 SharePoint

5. Expor ng and Sharing

 Export to PDF and PPT

 Share via Power BI Service

6. Best Prac ces

 Simple and clean design

 Consistent colors

 Avoid clu er

 Focus on key metrics

Suggested Reference Books

1. Mastering Microso Power BI – Bre Powell

2. Power Query – Gil Raviv

3. The Defini ve Guide to DAX – Russo & Ferrari

4. Storytelling with Data – Cole Nussbaumer Knaflic