Now, let’s move to the next topic:

Views (Virtual Tables)

🧠 1. What is a VIEW?

A VIEW is a virtual table based on a SQL query

👉 It does NOT store data
👉 It stores the query

Think like this 👇
👉 “Saved SQL query → reuse anytime”

⚡ 2. Why Use Views?

- Simplify complex queries
- Reuse logic
- Hide sensitive data
- Improve readability

⚡ 3. Create a VIEW

CREATE VIEW high_salary_emp AS
SELECT name, salary
FROM employees
WHERE salary > 50000;

🔍 4. Use a VIEW

SELECT FROM high_salary_emp;

✔ Works like a normal table

🔄 5. Update a VIEW

CREATE OR REPLACE VIEW high_salary_emp AS
SELECT name, salary, department
FROM employees
WHERE salary > 50000;

❌ 6. Drop a VIEW

DROP VIEW high_salary_emp;

🎯 7. Real Example

👉 Create view for department-wise average salary

CREATE VIEW dept_avg_salary AS
SELECT department, AVG(salary) AS avg_salary
FROM employees
GROUP BY department;

👉 Use it:
SELECT FROM dept_avg_salary;

⚡ 8. Important Points

- View does NOT store data
- Changes in table → reflect in view
- Can be used like a table

🎯 9. Practice Tasks

1. Create view for employees with salary > 40k
2. Create view for IT department employees
3. Create view for avg salary per department
4. Query data using created views
5. Drop a view

🔥 Here are the solutions for VIEW practice tasks

✅ 1. Create view for employees with salary > 40k
CREATE VIEW high_salary_emp AS
SELECT
FROM employees
WHERE salary > 40000;

✅ 2. Create view for IT department employees
CREATE VIEW it_employees AS
SELECT
FROM employees
WHERE department = 'IT';

✅ 3. Create view for avg salary per department
CREATE VIEW dept_avg_salary AS
SELECT department, AVG(salary) AS avg_salary
FROM employees
GROUP BY department;

✅ 4. Query data using created views
SELECT FROM high_salary_emp;

SELECT FROM it_employees;

SELECT FROM dept_avg_salary;

✅ 5. Drop a view
DROP VIEW high_salary_emp;

⚡ Mini Challenge 🔥

👉 Create a view to show top 3 highest salary employees

⚡ Mini Challenge Solution

CREATE VIEW top_3_salary AS
SELECT
FROM employees
ORDER BY salary DESC
LIMIT 3;

👉 Use the view:

SELECT FROM top_3_salary;

🔥 Pro Tip:
Views are heavily used in:
👉 Dashboards
👉 Reporting systems
👉 Data analytics projects

Because they simplify complex SQL 💯

👉 Table → stores data
👉 View → stores query

Double Tap ❤️ For More

Now, let’s move to the next topic:

Indexes 🚀

🧠 1. What is an INDEX?

An INDEX is used to make data retrieval faster

👉 Think like a book 📚
- Without index → scan every page
- With index → jump directly to topic

Same happens in databases 💯

⚡ 2. Why Use Indexes?

✔ Faster SELECT queries
✔ Faster searching
✔ Better performance on large tables

❌ But:
- Uses extra storage
- INSERT/UPDATE become slightly slower

📊 Visual Understanding

⚡ 3. Create an INDEX
CREATE INDEX idx_salary
ON employees(salary);
👉 Creates index on salary column

🔍 4. Query Using Indexed Column
SELECT FROM employees
WHERE salary > 50000;
✔ Faster because of index

❌ 5. Drop an INDEX
DROP INDEX idx_salary ON employees;

🔥 6. Primary Key Automatically Creates Index
CREATE TABLE employees (
emp_id INT PRIMARY KEY,
name VARCHAR(50)
);

✔ PRIMARY KEY → automatically indexed

⚡ 7. Types of Indexes

- Primary Index: Created on primary key
- Unique Index: Prevent duplicate values
- Composite Index: Index on multiple columns

🎯 8. Composite Index Example
CREATE INDEX idx_dept_salary
ON employees(department, salary);

✔ Useful when filtering both columns together

🎯 9. Practice Tasks
1. Create index on employee name
2. Create index on department column
3. Create composite index on department + salary
4. Query employees using indexed column
5. Drop created index

⚡ Mini Challenge 🔥

👉 Create a unique index on email column

🔥 Indexes improve READ speed but may slow down INSERT / UPDATE

Double Tap ❤️ For More

🚀 Top 100 Data Analyst Interview Questions

🧠 Data Analyst Role Basics

1. What does a data analyst do in a company?
2. What is the difference between a data analyst, data scientist, and BI analyst?
3. What is the typical workflow of a data analyst (from requirement to insight)?
4. What are the main goals of data analysis (descriptive, diagnostic, predictive, prescriptive)?
5. What is KPI and why is it important?
6. What is the difference between metrics and KPIs?
7. What is a dashboard vs a report?
8. What is exploratory data analysis (EDA)?
9. What is the difference between raw data and processed data?
10. How do you prioritize which analysis to work on first?

📊 SQL Databases

11. What is SQL and why is it critical for data analysts?
12. How do SELECT, WHERE, ORDER BY, LIMIT work?
13. How do you join two tables (INNER, LEFT, RIGHT, FULL joins)?
14. How do GROUP BY and aggregate functions (SUM, AVG, COUNT, MAX, MIN) work?
15. How do you write subqueries and CTEs?
16. How do you calculate running totals or rolling averages with window functions?
17. How do you clean and filter data directly in SQL?
18. How do you handle duplicates and NULL values in SQL?
19. How do you optimize a slow query?
20. How do you design a simple schema for a business domain (e.g., orders, users)?

🧮 Excel Spreadsheets

21. How do you use Excel for quick data cleaning and analysis?
22. How do you use SUMIF, COUNTIF, VLOOKUP / XLOOKUP in Excel?
23. How do you remove duplicates and standardize text in Excel?
24. How do you use PivotTables for summarizing data?
25. How do you build simple dashboards in Excel (charts + slicers)?
26. How do you use conditional formatting for insights?
27. How do you export data to CSV or share formatted reports?
28. How do you handle large datasets in Excel vs a database?
29. How do you avoid common Excel pitfalls (e.g., hard‑coded numbers, no labels)?
30. How do you document your Excel analyses?

📈 Data Visualization BI Tools

31. What is the purpose of data visualization?
32. When do you use bar charts, line charts, pie charts, histograms?
33. What are best practices for labeling, colors, and readability?
34. How do you design a dashboard for a non‑technical stakeholder?
35. What is the difference between a report and a self‑service dashboard?
36. How do you use Power BI / Tableau / Looker / Google Data Studio for dashboards?
37. How do you filter and slice data in a BI tool?
38. How do you handle measures and dimensions in BI tools?
39. How do you share dashboards and control access?
40. How do you tell a “data story” using charts and annotations?

📊 Descriptive Statistics EDA

41. What are mean, median, and mode?
42. What is standard deviation and variance?
43. What are quartiles and IQR?
44. How do you detect outliers and what should you do with them?
45. What is a distribution and how do you inspect it (histograms, boxplots)?
46. What is skewness and kurtosis?
47. How do you calculate growth rate, percentage change, CAGR?
48. How do you compute cohort‑style metrics (e.g., retention by signup month)?
49. How do you summarize categorical vs numerical data?
50. How do you structure an EDA notebook or report?

🛠️ Python (or R) for Data Analysis

51. Why do data analysts use Python instead of (or along with) Excel?
52. How do you load data from CSV or SQL into a pandas DataFrame?
53. How do you inspect the first/last rows, shape, data types, and missing values?
54. How do you clean missing values (dropna, fillna, interpolation)?
55. How do you filter, sort, and group data with pandas?
56. How do you calculate aggregates and pivots with groupby and pivot_table?

60. How do you compute month-on-month or week-on-week growth?
61. How do you write a query to calculate retention / churn?
62. How do you calculate LTV (lifetime value) conceptually?
63. How do you write a funnel analysis query (e.g., sign-up → activation → purchase)?
64. How do you handle time-based aggregations (daily, weekly, monthly)?
65. How do you compare cohorts (e.g., users by month of acquisition)?
66. How do you calculate lead-time, cycle-time, or other business-process metrics?
67. How do you implement A/B test-style analysis in SQL?
68. How do you approximate segmentation (RFM-style) in SQL?
69. How do you document and version your SQL queries?

🧠 Behavioral Business-Sense Questions

70. Walk me through a real-world analysis you did end-to-end.
71. Tell me about a time you presented insights to a non-technical audience.
72. Tell me about a time your analysis changed a decision or strategy.
73. Tell me about a time you found a data quality issue and how you fixed it.
74. How do you translate a vague business question into a concrete analysis?
75. How do you handle conflicting priorities from stakeholders?
76. How do you collaborate with product, marketing, and engineering teams?
77. How do you validate your analysis before sharing it?
78. How do you explain statistical or technical concepts in simple language?
79. How do you stay updated with data-analysis trends and tools?

📊 Real-World Case-Study / Scenario-Style Questions

80. Design an analysis to track product usage or feature adoption.
81. Design an analysis to evaluate marketing campaign performance.
82. Design a churn / retention dashboard for a SaaS product.
83. Design a sales-performance report for a regional team.
84. Design a customer-segmentation analysis (e.g., high-value vs low-value).
85. How would you analyze a sudden drop in website traffic or orders?
86. How would you analyze a pricing change or discount test?
87. How would you analyze customer support ticket volume and trends?
88. How would you design a simple A/B test and its success metrics?
89. How would you explain results and next steps to a manager?

🧠 Tooling, Processes Best Practices

90. What tools do you use most often as a data analyst?
91. How do you version your code and SQL (e.g., Git, folder structure)?
92. How do you document queries, dashboards, and assumptions?
93. How do you handle data privacy and PII in your analyses?
94. How do you manage permissions and access to dashboards?
95. How do you automate repetitive reports (scheduled exports, SQL jobs, etc.)?
96. How do you handle ad-hoc vs recurring analyses?
97. How do you get feedback on your dashboards and improve them?
98. What are your top 5 productivity shortcuts / habits as a data analyst?
99. What skills do you want to improve most in the next 6–12 months?

🚀 Double Tap ♥️ For Detailed Answers

🚀 Data Analyst Interview Questions with Answers — Part 1

🧠 Data Analyst Role & Basics

1. What does a data analyst do in a company?

A data analyst collects, cleans, analyzes, and interprets data to help businesses make better decisions. They create reports, dashboards, and insights that improve performance, reduce costs, and identify opportunities.

2. What is the difference between a data analyst, data scientist, and BI analyst?

✅ Data Analyst → Focuses on analyzing historical data, creating reports, dashboards, and business insights.

✅ Data Scientist → Works on advanced analytics, machine learning, predictive modeling, and AI solutions.

✅ BI Analyst → Primarily focuses on business intelligence tools like Power BI/Tableau to build dashboards and monitor KPIs.

3. What is the typical workflow of a data analyst?

A common workflow is:

1️⃣ Understand business requirements
2️⃣ Collect data from databases/files/APIs
3️⃣ Clean and preprocess data
4️⃣ Analyze data using SQL/Excel/Python
5️⃣ Create dashboards or visualizations
6️⃣ Present insights to stakeholders
7️⃣ Monitor results and improve analysis

4. What are the main goals of data analysis?

📊 Descriptive Analysis → What happened?
📈 Diagnostic Analysis → Why did it happen?
🔮 Predictive Analysis → What may happen next?
🎯 Prescriptive Analysis → What action should be taken?

5. What is KPI and why is it important?

KPI (Key Performance Indicator) is a measurable metric used to track business performance.

Examples:
✔️ Revenue Growth
✔️ Customer Retention
✔️ Conversion Rate
✔️ Website Traffic

KPIs help companies measure progress toward goals and make data-driven decisions.

6. What is the difference between metrics and KPIs?

📌 Metrics = Any measurable value
Example: Number of website visitors

📌 KPIs = Critical metrics tied to business goals
Example: Monthly customer conversion rate

👉 All KPIs are metrics, but not all metrics are KPIs.

7. What is a dashboard vs a report?

📊 Dashboard
• Interactive
• Real-time or frequently updated
• High-level overview of KPIs

📄 Report
• Detailed and static
• Often shared weekly/monthly
• Used for deep analysis

8. What is exploratory data analysis (EDA)?

EDA is the process of exploring and understanding data before detailed analysis or modeling.

It includes:
✔️ Finding missing values
✔️ Detecting outliers
✔️ Understanding distributions
✔️ Identifying trends and patterns

Tools commonly used: SQL, Excel, Python, Power BI.

9. What is the difference between raw data and processed data?

📌 Raw Data → Original uncleaned data directly from sources.
Example: Duplicate rows, missing values, inconsistent formats.

📌 Processed Data → Cleaned and transformed data ready for analysis.

10. How do you prioritize which analysis to work on first?

A data analyst usually prioritizes tasks based on:

✅ Business impact
✅ Urgency
✅ Stakeholder requirements
✅ Revenue/customer impact
✅ Time and resource availability

High-impact and time-sensitive analyses are handled first.

🚀 Double Tap ❤️ For More

🚀 Data Analyst Interview Questions with Answers — Part 2

📊 SQL & Databases

11. What is SQL and why is it critical for data analysts?
SQL (Structured Query Language) is used to communicate with databases. It helps analysts retrieve, filter, clean, and analyze data efficiently.

It is critical because most business data is stored in databases, and SQL allows analysts to extract insights directly from large datasets.

12. How do "SELECT", "WHERE", "ORDER BY", and "LIMIT" work?
✅ "SELECT" → Used to choose columns from a table

SELECT name, salary FROM employees;

✅ "WHERE" → Filters rows based on conditions

SELECT FROM employees
WHERE salary > 50000;

✅ "ORDER BY" → Sorts data ascending or descending

SELECT FROM employees
ORDER BY salary DESC;

✅ "LIMIT" → Restricts the number of rows returned

SELECT FROM employees
LIMIT 5;

13. How do you join two tables ("INNER", "LEFT", "RIGHT", "FULL" joins)?

📌 "INNER JOIN" → Returns matching records from both tables

📌 "LEFT JOIN" → Returns all records from the left table + matching rows from the right table

📌 "RIGHT JOIN" → Returns all records from the right table + matching rows from the left table

📌 "FULL JOIN" → Returns all matching and non-matching records from both tables

Example:
SELECT customers.name, orders.order_id
FROM customers
INNER JOIN orders
ON customers.id = orders.customer_id;

14. How do "GROUP BY" and aggregate functions work?

Aggregate functions summarize data.

Common functions:
✔️ "SUM()"
✔️ "AVG()"
✔️ "COUNT()"
✔️ "MAX()"
✔️ "MIN()"

Example:
SELECT department, AVG(salary)
FROM employees
GROUP BY department;

This groups employees by department and calculates average salary.

15. How do you write subqueries and CTEs?
📌 Subquery → Query inside another query

SELECT name
FROM employees
WHERE salary > (
SELECT AVG(salary)
FROM employees
);

📌 CTE (Common Table Expression) → Temporary result set that improves readability

WITH high_salary AS (
SELECT
FROM employees
WHERE salary > 50000
)
SELECT FROM high_salary;

16. How do you calculate running totals or rolling averages with window functions?

Window functions perform calculations across rows without collapsing data.

Example — Running Total:
SELECT order_date,
sales,
SUM(sales) OVER (ORDER BY order_date) AS running_total
FROM orders;
Example — Rolling Average:
SELECT order_date,
AVG(sales) OVER (
ORDER BY order_date
ROWS BETWEEN 2 PRECEDING AND CURRENT ROW
) AS rolling_avg
FROM orders;

17. How do you clean and filter data directly in SQL?

Data cleaning in SQL includes:
✔️ Removing duplicates
✔️ Handling NULL values
✔️ Standardizing text
✔️ Filtering invalid rows

Example:
SELECT TRIM(LOWER(name))
FROM customers
WHERE email IS NOT NULL;

18. How do you handle duplicates and NULL values in SQL?

✅ Remove duplicates using "DISTINCT"
SELECT DISTINCT city
FROM customers;

✅ Find NULL values
SELECT
FROM employees
WHERE salary IS NULL;

✅ Replace NULL values
SELECT COALESCE(salary, 0)
FROM employees;

19. How do you optimize a slow query?
Common optimization techniques:

🚀 Use indexes
🚀 Avoid unnecessary columns in "SELECT *"
🚀 Filter data early using "WHERE"
🚀 Optimize joins
🚀 Use proper aggregations
🚀 Analyze execution plans

Efficient queries improve performance and reduce database load.

20. How do you design a simple schema for a business domain?

A schema organizes data into related tables.

Example for an e-commerce business:
📌 "Customers" table
📌 "Orders" table
📌 "Products" table
📌 "Payments" table

Relationships are created using primary keys and foreign keys to maintain data integrity.

🚀 Double Tap ❤️ For Part-3

🚀 Data Analyst Interview Questions with Answers — Part 3

🧮 Excel & Spreadsheets

21. How do you use Excel for quick data cleaning and analysis?
Excel is widely used for fast data cleaning and exploration.

Common tasks include:
- Removing duplicates
- Filtering and sorting data
- Using formulas
- Creating PivotTables
- Applying conditional formatting
- Cleaning text using functions like TRIM, UPPER, LOWER

It is useful for quick business analysis without writing code.

22. How do you use "SUMIF", "COUNTIF", "VLOOKUP", and "XLOOKUP" in Excel?

✅ SUMIF → Adds values based on a condition
=SUMIF(A:A,"Sales",B:B)

✅ COUNTIF → Counts cells matching a condition
=COUNTIF(C:C,">500")

✅ VLOOKUP → Searches vertically for a value
=VLOOKUP(101,A:D,2,FALSE)

✅ XLOOKUP → Modern replacement for VLOOKUP with more flexibility
=XLOOKUP(101,A:A,B:B)

23. How do you remove duplicates and standardize text in Excel?

📌 Remove duplicates using: Data → Remove Duplicates

📌 Standardize text using functions:
=TRIM(A2)
=UPPER(A2)
=LOWER(A2)
=PROPER(A2)

These functions help clean inconsistent formatting.

24. How do you use PivotTables for summarizing data?
PivotTables quickly summarize large datasets without formulas.

They help with:
- Total sales by region
- Average revenue by product
- Monthly trends
- Category-wise counts

Steps:
1. Select dataset
2. Insert → PivotTable
3. Drag fields into Rows, Columns, and Values

25. How do you build simple dashboards in Excel?
A basic Excel dashboard usually contains:
- Charts
- KPIs
- PivotTables
- Slicers
- Conditional formatting

Dashboards help stakeholders track important business metrics visually.

26. How do you use conditional formatting for insights?
Conditional formatting highlights patterns automatically.

Examples:
- Highlight top performers
- Show duplicate values
- Identify low sales
- Use color scales for trends

Example:
Home → Conditional Formatting → Highlight Cell Rules

27. How do you export data to CSV or share formatted reports?

✅ Save files as .csv for database imports or system sharing
File → Save As → CSV

✅ Share formatted reports using:
- Excel files
- PDFs
- Shared OneDrive/Google Drive links

Always ensure formatting and labels are clear before sharing.

28. How do you handle large datasets in Excel vs a database?

📌 Excel is good for: smaller datasets and quick analysis.

📌 Databases are better for:
- Millions of rows
- Faster querying
- Multi-user access
- Better performance and security

Analysts often use SQL databases for large-scale analysis.

29. How do you avoid common Excel pitfalls?

Common best practices:
- Avoid hard-coded numbers in formulas
- Avoid merged cells
- Don’t leave blank headers
- Avoid inconsistent formatting

Do instead:
- Use proper labels
- Keep raw data separate from analysis
- Document formulas clearly

30. How do you document your Excel analyses?

Good documentation includes:
- Sheet descriptions
- Formula explanations
- Data-source details
- Assumptions used
- KPI definitions
- Date/version tracking

Proper documentation improves collaboration and reduces confusion.

🚀 Double Tap ❤️ For Part-4

🚀 Data Analyst Interview Questions with Answers — Part 4

📈 Data Visualization & BI Tools

31. What is the purpose of data visualization?
Data visualization helps transform raw data into charts and visuals that are easier to understand.

It helps businesses:
✔️ Identify trends
✔️ Detect patterns
✔️ Compare performance
✔️ Make faster decisions
✔️ Communicate insights clearly

Good visualizations simplify complex data.

32. When do you use bar charts, line charts, pie charts, and histograms?
📊 Bar Chart → Compare categories
Example: Sales by region

📈 Line Chart → Show trends over time
Example: Monthly revenue growth

🥧 Pie Chart → Show proportions or percentages
Example: Market share distribution

📉 Histogram → Show data distribution
Example: Customer age distribution

Choosing the correct chart improves readability and insight quality.

33. What are best practices for labeling, colors, and readability?
✅ Use clear titles and labels
✅ Keep charts simple and uncluttered
✅ Use consistent colors
✅ Highlight important insights
✅ Avoid excessive colors or 3D effects
✅ Ensure fonts are readable
✅ Add legends only when necessary

The goal is to make insights easy to understand quickly.

34. How do you design a dashboard for a non-technical stakeholder?
A stakeholder-friendly dashboard should:

✔️ Focus on business KPIs
✔️ Use simple language
✔️ Avoid technical jargon
✔️ Include filters and slicers
✔️ Show summary insights first
✔️ Use intuitive charts and layouts

Dashboards should answer business questions immediately.

35. What is the difference between a report and a self-service dashboard?
📄 Report
• Static and detailed
• Usually scheduled weekly/monthly
• Used for deep analysis

📊 Self-Service Dashboard
• Interactive
• Users can filter and explore data themselves
• Real-time or frequently updated

Self-service dashboards improve decision-making speed.

36. How do you use Power BI, Tableau, Looker, or Google Data Studio for dashboards?
These BI tools help analysts:

✔️ Connect multiple data sources
✔️ Build interactive dashboards
✔️ Create KPIs and measures
✔️ Apply filters and drill-downs
✔️ Share reports with teams

Popular tools include:
📌 Microsoft Power BI
📌 Tableau
📌 Looker
📌 Google Data Studio

37. How do you filter and slice data in a BI tool?
Filters and slicers allow users to interact with dashboards dynamically.

Examples:
✔️ Filter by date range
✔️ Select region or product category
✔️ Drill down into specific KPIs

This helps users analyze data without modifying the original report.

38. How do you handle measures and dimensions in BI tools?
📌 Dimensions → Qualitative fields used for categorization
Examples: Product, Region, Customer Name

📌 Measures → Numerical fields used for calculations
Examples: Revenue, Profit, Quantity Sold

Dimensions segment the data, while measures calculate insights.

39. How do you share dashboards and control access?
Dashboards are usually shared through:

✔️ Cloud workspaces
✔️ Scheduled email reports
✔️ Embedded links
✔️ Organization portals

Access control is managed using:
🔒 User permissions
🔒 Row-level security
🔒 Workspace roles

This ensures sensitive data is protected.

40. How do you tell a “data story” using charts and annotations?
Data storytelling combines visuals with business context.

A good data story should:
📌 Start with the business problem
📌 Present key findings clearly
📌 Use charts to support insights
📌 Add annotations for important trends
📌 End with recommendations or actions

The goal is not just showing numbers, but explaining what they mean for the business.

🚀 Double Tap ❤️ For Part-5

🚀 Data Analyst Interview Questions with Answers — Part 5

📊 Descriptive Statistics & EDA

41. What are mean, median, and mode?
📌 Mean → Average value of data
Mean = Sum of all values / Number of values

📌 Median → Middle value when data is sorted

📌 Mode → Most frequently occurring value

These measures help summarize data quickly.

42. What is standard deviation and variance?
📌 Variance measures how far data points spread from the mean.

📌 Standard Deviation is the square root of variance and shows data variability in the same unit as the data.

Low standard deviation → data points are close to the mean.
High standard deviation → data points are more spread out.

43. What are quartiles and IQR?
📌 Quartiles divide data into four equal parts.
• Q1 → 25th percentile
• Q2 → Median (50th percentile)
• Q3 → 75th percentile

📌 IQR (Interquartile Range) measures the spread of the middle 50% of data.
IQR = Q3 - Q1

IQR is commonly used to detect outliers.

44. How do you detect outliers and what should you do with them?
Outliers are unusual data points that differ significantly from other observations.

Common detection methods:
✔️ Boxplots
✔️ Z-score
✔️ IQR method

Possible actions:
📌 Remove incorrect data
📌 Investigate business reasons
📌 Transform data if needed
📌 Keep them if they are valid business cases

45. What is a distribution and how do you inspect it?
A distribution shows how data values are spread.

Common ways to inspect distributions:
📊 Histograms
📊 Boxplots
📊 Density plots

These help analysts understand patterns, skewness, and variability.

46. What is skewness and kurtosis?
📌 Skewness measures asymmetry in data distribution.
• Positive skew → Tail on the right
• Negative skew → Tail on the left

📌 Kurtosis measures how heavy or light the tails of a distribution are compared to normal distribution.

These metrics help understand data behavior.

47. How do you calculate growth rate, percentage change, and CAGR?
📌 Percentage Change Formula:
Percentage Change = (New Value - Old Value) / Old Value * 100

📌 CAGR (Compound Annual Growth Rate):
CAGR = (Ending Value / Beginning Value)^(1/n) - 1
Where n = number of years

These metrics are widely used in finance and business performance tracking.

48. How do you compute cohort-style metrics?
Cohort analysis groups users based on a shared characteristic such as signup month.

Example:
📌 Retention rate by signup month
📌 Revenue by customer acquisition month

It helps businesses analyze user behavior over time.

49. How do you summarize categorical vs numerical data?
📌 Categorical Data → Summarized using counts, percentages, and frequency tables.
Examples:
✔️ Gender
✔️ Country
✔️ Product Category

📌 Numerical Data → Summarized using statistical measures.
Examples:
✔️ Mean
✔️ Median
✔️ Standard deviation
✔️ Minimum and maximum values

50. How do you structure an EDA notebook or report?
A good EDA structure usually includes:

1️⃣ Business problem statement
2️⃣ Data overview
3️⃣ Data cleaning steps
4️⃣ Missing-value analysis
5️⃣ Outlier detection
6️⃣ Univariate and bivariate analysis
7️⃣ Visualizations
8️⃣ Key insights and recommendations

Well-structured EDA improves clarity and collaboration.

🚀 Double Tap ❤️ For Part-6