📘 What is Data?

(Foundation Concept – In Depth)

🔹 1. Definition of Data
Data is a collection of raw facts, values, or observations collected
from the real world.
➡️Raw means:
 Not processed
 Not organized
 Not analyzed
 Not interpreted
📌 Key idea:
👉 Data alone does NOT tell a story.

🔹 2. Why Data Has “No Meaning by Itself”

Let’s understand this with a simple example.
Example 1:
100
250
300
Ask students:
 100 what?
 250 of which product?
 300 for which month?
❌ We cannot answer anything
➡️So this is data, not information

Example 2:
Sales in January = ₹300
Now we know:
 What? → Sales
 When? → January
 Value? → ₹300
✅ This has context
➡️So it becomes information

🔹 3. Data vs Information (Conceptual Difference)

🔸 Data
 Raw facts
 No context
 Cannot support decisions
 Difficult to understand
🔸 Information
 Processed data
 Has meaning
 Can be analyzed
 Supports decision-making
🧾 Tabular Explanation
Data Information
45 Student scored 45 marks
2025-01-10 Exam held on 10 Jan 2025
5 5 products sold today
1200 Monthly salary is ₹1200
📌 Rule:
Data + Context = Information

🔹 4. Real-Life Analogy (Very Effective for Teaching)

🍅 Grocery Example
 Data → “5, 10, 15”
 Information → “Tomato costs ₹15 per kg”

🧑‍🎓 Student Example

 Data → “78”
 Information → “Student scored 78 marks in Data Visualization
exam”

🚗 Speed Example
 Data → “80”
 Information → “Car speed is 80 km/h”
🔹 5. Types of Data (Based on Nature)
🔸 a) Quantitative Data (Numerical)
 Can be measured
 Used in calculations
📌 Examples:
 Marks
 Sales amount
 Temperature

🔸 b) Qualitative Data (Descriptive)

 Describes something
 Cannot be calculated directly
📌 Examples:
 Student name
 City
 Product category

🔹 6. Data in Business Context

In business, data comes from:
 Sales transactions
 Customer records
 Website visits
  Attendance systems
📌 Example:
Date Product Quantity Price
This table is data

After Processing:
Total sales in January = ₹1,50,000
This is information

🔹 7. Why Data is Important

Data is important because it helps to:
 Understand past performance
 Identify trends
 Compare results
 Make predictions
 Take decisions
📌 Without data:
 Decisions are based on guesswork
 High risk of mistakes

🔹 8. Data → Information → Knowledge → Decision

This is the data value chain (very important for BI).
1️⃣ Data
Raw facts
⬇️
2️⃣ Information
Organized & meaningful
⬇️
3️⃣ Knowledge
Patterns & insights
⬇️
4️⃣ Decision
Action taken

Example:
 Data → Daily sales numbers
 Information → Monthly sales report
 Knowledge → Sales drop in Week 3
 Decision → Launch discount offer

🔹 9. Role of Data in Data Visualization

Data Visualization:
 Takes raw data
 Converts it into charts & graphs
 Makes information easy to understand
📌 Example:
 Data → Sales numbers in Excel
  Visualization → Bar chart showing monthly sales
 Insight → March has highest sales

🔹 10. One-Line Summary (Exam-Ready)

Data is a collection of raw facts and figures which, when processed and
given context, becomes meaningful information that supports analysis
and decision-making.

🎓 Teaching Tip
In class, ask:
“If I show you a number, is it data or information?”
Let students answer — it makes the concept stick.
📘 Measures and Dimensions (In-Depth Explanation)

🔹 1. What are Dimensions?

📌 Definition
Dimensions are descriptive attributes that give context to data.
They describe who, what, when, where, or which category.
👉 Dimensions do not get calculated; they are used to group, filter, or
slice data.

🔹 Characteristics of Dimensions
 Text or date-based
 Categorical in nature
  Used on axes, rows, columns, filters
 Answer: What / Who / When / Where

🔹 Examples of Dimensions
Dimension Meaning
Date When did it happen?
Product What was sold?
Region Where was it sold?
Customer Who bought it?
Category Which type?

🔹 Real-Life Example
Student Marks Table
Roll No Name Subject Marks
1 Asha Math 78
 Roll No → Dimension
 Name → Dimension
 Subject → Dimension

🔹 2. What are Measures?

📌 Definition
Measures are numerical values that can be aggregated or calculated.
👉 Measures answer:
 How much?
 How many?

🔹 Characteristics of Measures
 Numeric values
 Used for calculations
 Can be summed, averaged, counted
 Change based on dimension selection

🔹 Examples of Measures
Measure Description
Sales Total sales amount
Quantity Units sold
Profit Revenue − Cost
Marks Student score
Attendance % Calculated value

🔹 Real-Life Example
Student Marks Table (same data)
Roll No Name Subject Marks
1 Asha Math 78
  Marks → Measure

🔹 3. Key Difference Between Dimensions and Measures

Dimension Measure
Descriptive Quantitative
Text / Date Numeric
Used for grouping Used for calculation
Do not aggregate Aggregate (SUM, AVG, etc.)
Axis / Filter Values

🔹 4. Why This Concept Is So Important in Data Visualization

🔸 Example: Sales Dashboard
Date Region Product Sales
 Date → Dimension
 Region → Dimension
 Product → Dimension
 Sales → Measure
📊 Bar Chart:
 X-axis → Product (Dimension)
 Y-axis → Sales (Measure)
👉 No measure → no chart value
👉 No dimension → no comparison
🔹 5. How Dimensions Control Measures (Very Important)
Measures change automatically based on dimensions selected.
Example:
 Total Sales = ₹10,000
 Sales by Region:
o Pune → ₹4,000
o Mumbai → ₹6,000
👉 Measure is same (Sales)
👉 Dimension changes (Region)

🔹 6. Simple Analogy (Best for Students)

🍰 Cake Analogy
 Cake type (Chocolate, Vanilla) → Dimension
 Number of cakes sold → Measure

🧾 Grocery Bill
 Item name → Dimension
 Price → Measure
 Quantity → Measure

🔹 7. Common Mistakes Students Make

❌ Treating numeric IDs as measures
✔ Roll number is a dimension, not a measure
❌ Trying to sum names or categories
✔ Text fields are dimensions
❌ Confusing date as measure
✔ Date is always a dimension

🔹 8. Measures vs Calculated Measures (Intro Level)

 Base Measure: Sales, Quantity
 Calculated Measure:
o Profit = Sales − Cost
o Average Marks
📌 Introduced deeply in Unit-III (DAX)

🔹 9. Power BI Perspective (Tool Awareness)

 Dimensions → Fields used in:
o Axis
o Legend
o Filters
 Measures → Fields used in:
o Values
o Tooltips
o KPIs

🔹 10. Exam-Ready One-Line Definitions

Dimension:
A dimension is a descriptive attribute used to categorize and filter data.
Measure:
A measure is a numerical value used for calculation and aggregation in
data analysis.

🔹 11. Unit-I Question Alignment (Quick)

2–3 Marks:
 Define measures and dimensions
 Give two examples of each
5 Marks:
 Differentiate between measures and dimensions with examples
Viva:
 Is “Date” a measure or dimension? Why?
 Can a measure exist without a dimension?

🎓 Teaching Tip
Ask students:
“If I want to compare, what do I need?”
They’ll say: Categories + Numbers
➡️That’s Dimensions + Measures
📘 3️⃣ Basics of Excel (Minimum Required Knowledge) – In Depth

🔹 1. Excel Structure (Foundation)

📌 Workbook
 A workbook is an Excel file
 Extension: .xlsx
 One workbook can contain multiple sheets
📎 Example:
Sales_Data.xlsx → Workbook

📌 Worksheet (Sheet)
 A sheet is a single page inside a workbook
 Used to store data in tabular format
📎 Example:
 Sheet1 → January Sales
 Sheet2 → February Sales

📌 Rows and Columns

 Rows → Horizontal (1, 2, 3…)
 Columns → Vertical (A, B, C…)
📎 Intersection of row and column = Cell
Example: B2
📌 Column Header = Field Name (VERY IMPORTANT)
 First row usually contains headers
 Headers describe the data in that column
Example:
Date Product Region Sales
📌 These headers become fields in Power BI

🔹 2. Important Excel Concepts (For Data Cleaning)

These are exactly the same steps done in Power Query later.

🔸 a) Sorting Data
Sorting arranges data in a specific order.
Types:
 A → Z (Ascending)
 Z → A (Descending)
📎 Example:
 Sort sales from lowest to highest
 Sort names alphabetically
📌 Why important?
 Helps identify highest, lowest, duplicates, trends

🔸 b) Filtering Data
Filtering shows only required data and hides the rest.
📎 Example:
 Show sales only for “Pune”
 Show students with marks > 60
📌 Why important?
 Helps focus on specific conditions
 Used heavily in dashboards

🔸 c) Removing Duplicates
Duplicate data means:
 Same record appears more than once
📎 Example:
 Same student entered twice
 Same invoice repeated
📌 Why important?
 Duplicates cause wrong totals
 Affects accuracy of analysis

🔸 d) Blank Cells & Errors

Blank Cells:
 Missing data
 Causes incorrect calculations
Common Errors:
 #N/A
 #VALUE
 #DIV/0!
📌 Why important?
 Power BI may fail or give wrong results
 Blank values affect averages and totals

🔹 3. Basic Excel Functions (Conceptual Understanding)

These functions help students understand aggregation, which is core to
BI.

🔸 SUM()
Adds numeric values.
📎 Example:
=SUM(D2:D10)
➡️Total sales

🔸 COUNT()
Counts number of numeric values.
📎 Example:
=COUNT(D2:D10)
➡️Number of transactions
🔸 AVERAGE()
Calculates mean value.
📎 Example:
=AVERAGE(D2:D10)
➡️Average sales

🔸 MIN() and MAX()

 MIN() → smallest value
 MAX() → largest value
📎 Example:
=MAX(D2:D10)
➡️Highest sale

📌 These functions later become:

 Aggregations in visuals
 DAX measures in Unit-III

🔹 4. Table vs Range (VERY IMPORTANT FOR POWER BI)

This is where many students struggle — so teach clearly.

🔸 Range
 Normal selected cells
  No structure
 Headers may or may not exist
Example:
A1:D10
❌ Problems:
 Errors in filtering
 Data breaks when rows added
 Not BI-friendly

🔸 Table
 Structured data
 Created using Ctrl + T
 Always has headers
Example:
Date Product Sales
✔ Advantages:
 Automatically expands
 Easy filtering
 Perfect for Power BI import

🔹 Comparison Table
Table Range
Structured Unstructured
Headers mandatory Headers optional
Auto-expand Manual expand
BI friendly Error-prone

🔹 5. Why Excel Knowledge Is Required Before Power BI

Excel teaches:
 How data is organized
 How errors affect analysis
 How aggregation works
 Why clean data is important
📌 Power BI assumes students already know this.

🔹 6. Real-World Example (End-to-End)

Excel data:
Date City Sales
1-Jan Pune 500
1-Jan Pune 500
➡ Duplicate exists
➡ Wrong total = 1000 instead of 500
After cleaning:
  Remove duplicate
 Fill blanks
 Convert to table
➡ Correct analysis

🔹 7. Exam-Ready Definitions
Workbook:
A workbook is an Excel file containing one or more worksheets.
Worksheet:
A worksheet is a grid of rows and columns used to store data.
Sorting:
Sorting arranges data in ascending or descending order.
Filtering:
Filtering displays only selected data based on conditions.

🔹 8. Unit-I Question Alignment (Quick)

2–3 Marks
 Define workbook and worksheet
 What is filtering?
 What is sorting?
5 Marks
 Explain basic Excel operations used in data cleaning
 Differentiate between table and range
Viva
 Why should data be converted into a table?
 What happens if Excel data has blank values?

🎓 Teaching Tip
Tell students:
“If your Excel data is clean, Power BI work becomes 50% easier.”
📘 4️⃣ Introduction to Databases & SQL
(Conceptual Understanding – In Depth)

🔹 1. What is a Database?
📌 Definition
A database is an organized collection of related data stored
electronically so that it can be:
 Easily accessed
 Easily managed
 Easily updated
 Secure and reliable
👉 Databases are designed to handle large amounts of data efficiently.

🔹 Why Databases Are Needed

Imagine storing:
 Student records of an entire university
  Sales data of 5 years
 Online shopping transactions
❌ Excel becomes slow and error-prone
✔ Database handles this smoothly

🔹 Examples of Databases
 Student Management System
 Bank account system
 Railway reservation system
 College attendance system

🔹 2. What is a Table?
📌 Definition
A table is a structured format to store data in rows and columns inside
a database.

🔹 Structure of a Table
StudentID Name Course City
 Row (Record): One complete entry
 Column (Field): One type of data

🔹 Rows → Records
Each row represents one entity.
📎 Example:
 One student
 One customer
 One transaction

🔹 Columns → Fields
Each column represents one attribute.
📎 Example:
 Name
 Marks
 Price

📌 Tables in databases are similar to Excel tables, but:

 More secure
 More powerful
 Used by multiple users

🔹 3. Keys (Very Important Concept)

Keys maintain accuracy, uniqueness, and relationships in a database.

🔸 a) Primary Key
📌 Definition
A Primary Key is a field that:
  Uniquely identifies each record
 Cannot be NULL
 Cannot have duplicate values

📎 Example: Student Table

StudentID Name Course
101 Asha CS
102 Ravi IT
✔ StudentID → Primary Key

🔸 Why Primary Key Is Important

 Avoids duplicate records
 Identifies records uniquely
 Essential for relationships

🔸 b) Foreign Key
📌 Definition
A Foreign Key is a field in one table that refers to the Primary Key of
another table.

📎 Example: Marks Table

StudentID Subject Marks
101 Math 78
StudentID Subject Marks

102 DBMS 85
✔ StudentID → Foreign Key

🔸 Why Foreign Key Is Important

 Connects two tables
 Maintains data integrity
 Enables joins and relationships

🔹 4. Relationship Between Tables (Core for Power BI)

📌 Why Split Data into Tables?
 Avoid redundancy
 Save storage
 Easy maintenance

🔹 Example
Student Table
StudentID Name Course
Marks Table
StudentID Subject Marks
➡ Relationship formed using StudentID
📌 This is exactly how Power BI data modeling works.

🔹 5. What is SQL? (Intro Only)

📌 Definition
SQL (Structured Query Language) is used to:
 Store data
 Retrieve data
 Update data
 Delete data

🔹 Example (Conceptual)
SELECT * FROM Student;
👉 No need to teach syntax deeply yet
👉 Just explain purpose

🔹 6. Excel vs Database (In Depth Comparison)

Excel Database
Suitable for small data Handles large data
Manual entry Automated systems
Limited security High security
Single user Multi-user
No enforced relationships Strong relationships
Error-prone Reliable
Excel Database

📌 Important Note for Students:

Excel is for analysis, database is for storage

🔹 7. Why This Knowledge Is Critical for Unit-I & Unit-II

🔹 Helps Understand:
 SQL Server as data source
 Direct Query & Live Connection
 Relationships in data model
 One-to-many relationships

🔹 Power BI Mapping
Database Concept Power BI Concept
Table Data table
Primary Key Unique column
Foreign Key Relationship column
Join Model relationship

🔹 8. Common Student Confusions (Clear These)

❌ Thinking Excel = Database
✔ Excel is not a database
❌ Using Name as Primary Key
✔ IDs should be keys
❌ One big table is best
✔ Multiple related tables are better

🔹 9. Exam-Ready Definitions
Database:
A database is an organized collection of data stored electronically for
efficient access and management.
Table:
A table stores data in rows (records) and columns (fields).
Primary Key:
A field that uniquely identifies each record in a table.
Foreign Key:
A field that creates a relationship between two tables.

🔹 10. Unit-I Question Alignment

2–3 Marks
 Define database
 What is a primary key?
 What is a foreign key?
5 Marks
 Explain table structure with example
 Differentiate Excel and database
Viva
 Why keys are required?
 Can Power BI work without relationships?

🎓 Teaching Tip
Tell students:
“Power BI does not store data like Excel; it models data like a
database.”
That line alone builds clarity.
📘 Business Intelligence, BI Lifecycle, Statistics & Data Visualization
(In-Depth Explanation for Unit-I – Semester II)

5️⃣ Business Intelligence (BI) – Core Idea

🔹 What is Business Intelligence (BI)?

Business Intelligence (BI) is a systematic process of:
Collecting → Processing → Analyzing → Visualizing data
to support accurate, timely, and informed business decisions.
📌 BI converts raw data into actionable insights.

🔹 Why BI is Needed (Real-World Context)

Without BI:
 Decisions are based on intuition
  Reports are slow and manual
 Errors go unnoticed
With BI:
 Data-driven decisions
 Real-time dashboards
 Improved accuracy and speed

🔹 Why BI is Important
1️⃣ Improves Decision-Making
Managers can see facts instead of assumptions.
2️⃣ Identifies Trends
Detects patterns like:
 Increasing sales
 Declining performance
 Seasonal demand
3️⃣ Tracks Performance
Compares:
 Actual vs Target
 Current vs Previous period
4️⃣ Saves Time
Automated dashboards replace manual reports.

🔹 BI Examples (Relatable)
Domain BI Example
Business Monthly sales dashboard
Education Student performance analysis
Retail Inventory tracking
Finance Profit & loss reports
📌 These are exact Power BI use cases.

🔹 BI Tools (Intro Level)

Tool Key Feature
Power BI Microsoft ecosystem
Tableau Strong visual storytelling
QlikView Associative data model
📌 Power BI is most used in industry + academics.

6️⃣ BI Lifecycle (Conceptual Understanding)

🔹 What is BI Lifecycle?
The BI Lifecycle describes the step-by-step flow of data from raw
source to decision.

🔹 BI Lifecycle Stages (Detailed)

1️⃣ Data Collection

  Data gathered from:
o Excel
o Databases
o Web sources
 Data is usually raw and unclean
📌 Example: Sales transactions

2️⃣ Data Cleaning

 Removing:
o Duplicates
o Errors
o Blank values
📌 Clean data = reliable output

3️⃣ Data Transformation

 Converting data into usable form
 Example:
o Changing data types
o Creating new columns
📌 Unit-I focuses heavily here

4️⃣ Data Modeling

  Creating relationships
 Connecting tables
 Defining keys
📌 Covered in Unit-II

5️⃣ Data Visualization

 Charts, tables, KPIs
 Dashboards and reports
📌 Covered in Unit-III

6️⃣ Decision Making

 Business actions based on insights
📌 Example:
Increase marketing where sales are low

🔹 BI Lifecycle Diagram (Explain Verbally)

Data → Clean → Transform → Model → Visualize → Decide

7️⃣ Basic Statistics for Visualization

🔹 Why Statistics is Needed

Visualization is not just drawing charts—it is analyzing numbers.
🔹 Essential Statistical Concepts

🔸 Sum
 Total of values
 Used for:
o Total sales
o Total marks

🔸 Average
 Mean value
 Used to evaluate performance

🔸 Percentage
 Part of a whole
 Used in:
o Growth
o Share
o Performance %

🔸 Growth
 Change over time
📌 Formula:
Growth % = (New − Old) / Old × 100
🔸 Comparison
 Comparing two or more values
 Example:
o Region-wise sales

🔸 Trend
 Direction over time
 Increasing / decreasing / stable

🔹 Example Explained
Sales increased from 100 → 150
Increase = 50
Growth % = (50 / 100) × 100 = 50%
📌 Perfect example for line chart

🔹 Visualization Answers Questions Like:

 Which is highest?
 Which is lowest?
 What changed over time?

8️⃣ Introduction to Data Visualization

🔹 What is Data Visualization?
Data Visualization is the graphical representation of data to:
 Simplify complex data
 Identify patterns
 Communicate insights effectively

🔹 Why Visualization is Needed

 Human brain processes visuals faster than text
 Large datasets become understandable
 Helps non-technical users
📌 A chart explains more than a table of numbers.

🔹 Common Visualization Types

Chart Purpose
Bar Comparison
Line Trend over time
Pie Proportion
Table Exact values
KPI Performance measurement

🔹 Good Visualization Principles

✔ Simple and clear
✔ Proper labels
✔ Right chart for right data
✔ Avoid clutter and overload
📌 Poor visualization = wrong decisions

9️⃣ Files & Data Sources Knowledge

🔹 Common File Formats

Format Description
.xlsx Excel workbook
.csv Text-based table
.txt Plain text
.json Semi-structured data
📌 Power BI supports all these.

🔹 Data Sources in BI
 Excel files
 SQL Server databases
 Web URLs
 Online databases
📌 Used in Unit-I data import

🔟 Basic Internet & Web Data Concepts

🔹 Web as a Data Source
Data can come from:
 APIs
 Government portals
 Public datasets
 Online CSV / JSON files

🔹 Basic Web Concepts

URL
 Address of web resource
Public vs Private Data
 Public → Open access
 Private → Login required
Authentication
 User verification
 API keys, credentials
📌 Important for Web data import in Power BI