๐ Data Analyst Interview Questions with Answers โ Part 7
๐ Advanced Analytics & SQL Patterns
61. How do you compute month-on-month or week-on-week growth?
Growth compares current performance with a previous period.
๐ Formula:
Growth % = (Current Period - Previous Period) / Previous Period * 100
โ Example SQL Query:
SELECT month,
revenue,
LAG(revenue) OVER (ORDER BY month) AS previous_month,
ROUND(
((revenue - LAG(revenue) OVER (ORDER BY month))
/ LAG(revenue) OVER (ORDER BY month)) * 100,
2
) AS mom_growth
FROM sales;
This calculates month-on-month growth percentage.
62. How do you write a query to calculate retention or churn?
๐ Retention: Users who continue using the product
๐ Churn: Users who stop using the product
Example retention query:
SELECT signup_month,
COUNT(DISTINCT retained_user_id) * 100.0 /
COUNT(DISTINCT user_id) AS retention_rate
FROM retention_table
GROUP BY signup_month;
Retention analysis helps measure customer loyalty and product success.
63. How do you calculate LTV (Lifetime Value) conceptually?
LTV estimates the total revenue generated by a customer during their relationship with a business.
๐ Basic Formula:
LTV = Average Purchase Value Average Purchase Frequency Average Customer Lifespan
Businesses use LTV to evaluate customer acquisition and retention strategies.
64. How do you write a funnel analysis query?
Funnel analysis tracks user progression through stages.
Example funnel:
Signup โ Activation โ Purchase
Example SQL:
SELECT
COUNT(DISTINCT signup_user) AS signups,
COUNT(DISTINCT activated_user) AS activations,
COUNT(DISTINCT purchased_user) AS purchases
FROM funnel_data;
Funnels help identify where users drop off.
65. How do you handle time-based aggregations?
Time aggregations summarize data daily, weekly, or monthly.
Example:
SELECT DATE_TRUNC('month', order_date) AS month,
SUM(revenue) AS total_revenue
FROM orders
GROUP BY month
ORDER BY month;
This helps track trends over time.
66. How do you compare cohorts?
Cohort analysis compares groups of users based on a shared characteristic.
Examples:
โ๏ธ Users acquired in January vs February
โ๏ธ Retention by signup month
โ๏ธ Revenue by acquisition channel
Cohorts help measure long-term user behavior.
67. How do you calculate lead-time, cycle-time, or business-process metrics?
๐ Lead Time: Total time from request to completion
๐ Cycle Time: Time spent actively working on a task
Example Formula:
Lead Time = Completion Date - Request Date
Cycle Time = End Work Time - Start Work Time
These metrics help improve operational efficiency.
68. How do you implement A/B test-style analysis in SQL?
A/B testing compares two groups to measure performance differences.
Example:
SELECT test_group,
AVG(conversion_rate) AS avg_conversion
FROM experiment_results
GROUP BY test_group;
Analysts compare metrics such as:
โ๏ธ Conversion rate
โ๏ธ Revenue
โ๏ธ Click-through rate
โ๏ธ Retention
69. How do you approximate segmentation (RFM-style) in SQL?
RFM segmentation classifies customers using:
๐ Recency: How recently they purchased
๐ Frequency: How often they purchase
๐ Monetary: How much they spend
Example:
SELECT customer_id,
MAX(order_date) AS last_purchase,
COUNT(order_id) AS frequency,
SUM(amount) AS monetary
FROM orders
GROUP BY customer_id;
RFM helps identify high-value customers.
70. How do you document and version your SQL queries?
Best practices include:
โ Use meaningful query names
โ Add comments in SQL scripts
โ Store queries in Git repositories
โ Maintain version history
โ Document assumptions and business logic
โ Organize queries by project or folder structure
Proper documentation improves collaboration and maintainability.
๐ Double Tap โค๏ธ For Part-8
๐ Advanced Analytics & SQL Patterns
61. How do you compute month-on-month or week-on-week growth?
Growth compares current performance with a previous period.
๐ Formula:
Growth % = (Current Period - Previous Period) / Previous Period * 100
โ Example SQL Query:
SELECT month,
revenue,
LAG(revenue) OVER (ORDER BY month) AS previous_month,
ROUND(
((revenue - LAG(revenue) OVER (ORDER BY month))
/ LAG(revenue) OVER (ORDER BY month)) * 100,
2
) AS mom_growth
FROM sales;
This calculates month-on-month growth percentage.
62. How do you write a query to calculate retention or churn?
๐ Retention: Users who continue using the product
๐ Churn: Users who stop using the product
Example retention query:
SELECT signup_month,
COUNT(DISTINCT retained_user_id) * 100.0 /
COUNT(DISTINCT user_id) AS retention_rate
FROM retention_table
GROUP BY signup_month;
Retention analysis helps measure customer loyalty and product success.
63. How do you calculate LTV (Lifetime Value) conceptually?
LTV estimates the total revenue generated by a customer during their relationship with a business.
๐ Basic Formula:
LTV = Average Purchase Value Average Purchase Frequency Average Customer Lifespan
Businesses use LTV to evaluate customer acquisition and retention strategies.
64. How do you write a funnel analysis query?
Funnel analysis tracks user progression through stages.
Example funnel:
Signup โ Activation โ Purchase
Example SQL:
SELECT
COUNT(DISTINCT signup_user) AS signups,
COUNT(DISTINCT activated_user) AS activations,
COUNT(DISTINCT purchased_user) AS purchases
FROM funnel_data;
Funnels help identify where users drop off.
65. How do you handle time-based aggregations?
Time aggregations summarize data daily, weekly, or monthly.
Example:
SELECT DATE_TRUNC('month', order_date) AS month,
SUM(revenue) AS total_revenue
FROM orders
GROUP BY month
ORDER BY month;
This helps track trends over time.
66. How do you compare cohorts?
Cohort analysis compares groups of users based on a shared characteristic.
Examples:
โ๏ธ Users acquired in January vs February
โ๏ธ Retention by signup month
โ๏ธ Revenue by acquisition channel
Cohorts help measure long-term user behavior.
67. How do you calculate lead-time, cycle-time, or business-process metrics?
๐ Lead Time: Total time from request to completion
๐ Cycle Time: Time spent actively working on a task
Example Formula:
Lead Time = Completion Date - Request Date
Cycle Time = End Work Time - Start Work Time
These metrics help improve operational efficiency.
68. How do you implement A/B test-style analysis in SQL?
A/B testing compares two groups to measure performance differences.
Example:
SELECT test_group,
AVG(conversion_rate) AS avg_conversion
FROM experiment_results
GROUP BY test_group;
Analysts compare metrics such as:
โ๏ธ Conversion rate
โ๏ธ Revenue
โ๏ธ Click-through rate
โ๏ธ Retention
69. How do you approximate segmentation (RFM-style) in SQL?
RFM segmentation classifies customers using:
๐ Recency: How recently they purchased
๐ Frequency: How often they purchase
๐ Monetary: How much they spend
Example:
SELECT customer_id,
MAX(order_date) AS last_purchase,
COUNT(order_id) AS frequency,
SUM(amount) AS monetary
FROM orders
GROUP BY customer_id;
RFM helps identify high-value customers.
70. How do you document and version your SQL queries?
Best practices include:
โ Use meaningful query names
โ Add comments in SQL scripts
โ Store queries in Git repositories
โ Maintain version history
โ Document assumptions and business logic
โ Organize queries by project or folder structure
Proper documentation improves collaboration and maintainability.
๐ Double Tap โค๏ธ For Part-8
โค15๐1
๐ฃ๐ฎ๐ ๐๐ณ๐๐ฒ๐ฟ ๐ฃ๐น๐ฎ๐ฐ๐ฒ๐บ๐ฒ๐ป๐ ๐ฃ๐ฟ๐ผ๐ด๐ฟ๐ฎ๐บ ๐ง๐ผ ๐๐ฒ๐ฐ๐ผ๐บ๐ฒ ๐ฎ ๐๐ผ๐ฏ-๐ฅ๐ฒ๐ฎ๐ฑ๐ ๐ฆ๐ผ๐ณ๐๐๐ฎ๐ฟ๐ฒ ๐๐ฒ๐๐ฒ๐น๐ผ๐ฝ๐ฒ๐ฟ๐ฅ
No upfront fees. Learn first, pay only after you get placed! ๐ผโจ
๐ What Youโll Get:
โ Full Stack Development Training
โ GenAI + Real Industry Projects
โ Live Classes & 1:1 Mentorship
โ Mock Interviews & Resume Support
โ 500+ Hiring Partners
โ Average Package: 7.4 LPA
๐ฏ Ideal for:- Freshers , College Students, Career Switchers & Anyone looking to enter Tech
๐ป Learn In-Demand Skills & Build Your Dream Tech Career!
๐๐๐ ๐ข๐ฌ๐ญ๐๐ซ ๐๐จ๐ฐ ๐:-
https://pdlink.in/42WOE5H
Hurry! Limited seats are available.๐โโ๏ธ
No upfront fees. Learn first, pay only after you get placed! ๐ผโจ
๐ What Youโll Get:
โ Full Stack Development Training
โ GenAI + Real Industry Projects
โ Live Classes & 1:1 Mentorship
โ Mock Interviews & Resume Support
โ 500+ Hiring Partners
โ Average Package: 7.4 LPA
๐ฏ Ideal for:- Freshers , College Students, Career Switchers & Anyone looking to enter Tech
๐ป Learn In-Demand Skills & Build Your Dream Tech Career!
๐๐๐ ๐ข๐ฌ๐ญ๐๐ซ ๐๐จ๐ฐ ๐:-
https://pdlink.in/42WOE5H
Hurry! Limited seats are available.๐โโ๏ธ
โค3๐3
โ
SQL for Data Analytics ๐๐ง
Mastering SQL is essential for analyzing, filtering, and summarizing large datasets. Here's a quick guide with real-world use cases:
1๏ธโฃ SELECT, WHERE, AND, OR
Filter specific rows from your data.
2๏ธโฃ ORDER BY & LIMIT
Sort and limit your results.
โถ๏ธ Top 5 highest salaries
3๏ธโฃ GROUP BY + Aggregates (SUM, AVG, COUNT)
Summarize data by groups.
4๏ธโฃ HAVING
Filter grouped data (use after GROUP BY).
5๏ธโฃ JOINs
Combine data from multiple tables.
6๏ธโฃ CASE Statements
Create conditional logic inside queries.
7๏ธโฃ DATE Functions
Analyze trends over time.
8๏ธโฃ Subqueries
Nested queries for advanced filters.
9๏ธโฃ Window Functions (Advanced)
โถ๏ธ Rank employees within each department
๐ก Used In:
โข Marketing: campaign ROI, customer segments
โข Sales: top performers, revenue by region
โข HR: attrition trends, headcount by dept
โข Finance: profit margins, cost control
SQL For Data Analytics: https://whatsapp.com/channel/0029Vb6hJmM9hXFCWNtQX944
๐ฌ Tap โค๏ธ for more
Mastering SQL is essential for analyzing, filtering, and summarizing large datasets. Here's a quick guide with real-world use cases:
1๏ธโฃ SELECT, WHERE, AND, OR
Filter specific rows from your data.
SELECT name, age
FROM employees
WHERE department = 'Sales' AND age > 30;
2๏ธโฃ ORDER BY & LIMIT
Sort and limit your results.
SELECT name, salary
FROM employees
ORDER BY salary DESC
LIMIT 5;
โถ๏ธ Top 5 highest salaries
3๏ธโฃ GROUP BY + Aggregates (SUM, AVG, COUNT)
Summarize data by groups.
SELECT department, AVG(salary) AS avg_salary
FROM employees
GROUP BY department;
4๏ธโฃ HAVING
Filter grouped data (use after GROUP BY).
SELECT department, COUNT(*) AS emp_count
FROM employees
GROUP BY department
HAVING emp_count > 10;
5๏ธโฃ JOINs
Combine data from multiple tables.
SELECT e.name, d.name AS dept_name
FROM employees e
JOIN departments d ON e.dept_id = d.id;
6๏ธโฃ CASE Statements
Create conditional logic inside queries.
SELECT name,
CASE
WHEN salary > 70000 THEN 'High'
WHEN salary > 40000 THEN 'Medium'
ELSE 'Low'
END AS salary_band
FROM employees;
7๏ธโฃ DATE Functions
Analyze trends over time.
SELECT MONTH(join_date) AS join_month, COUNT(*)
FROM employees
GROUP BY join_month;
8๏ธโฃ Subqueries
Nested queries for advanced filters.
SELECT name, salary
FROM employees
WHERE salary > (SELECT AVG(salary) FROM employees);
9๏ธโฃ Window Functions (Advanced)
SELECT name, department, salary,
RANK() OVER(PARTITION BY department ORDER BY salary DESC) AS dept_rank
FROM employees;
โถ๏ธ Rank employees within each department
๐ก Used In:
โข Marketing: campaign ROI, customer segments
โข Sales: top performers, revenue by region
โข HR: attrition trends, headcount by dept
โข Finance: profit margins, cost control
SQL For Data Analytics: https://whatsapp.com/channel/0029Vb6hJmM9hXFCWNtQX944
๐ฌ Tap โค๏ธ for more
โค5
๐ Want to Excel at Data Analytics? Master These Essential Skills! โ๏ธ
Core Concepts:
โข Statistics & Probability โ Understand distributions, hypothesis testing
โข Excel โ Pivot tables, formulas, dashboards
Programming:
โข Python โ NumPy, Pandas, Matplotlib, Seaborn
โข R โ Data analysis & visualization
โข SQL โ Joins, filtering, aggregation
Data Cleaning & Wrangling:
โข Handle missing values, duplicates
โข Normalize and transform data
Visualization:
โข Power BI, Tableau โ Dashboards
โข Plotly, Seaborn โ Python visualizations
โข Data Storytelling โ Present insights clearly
Advanced Analytics:
โข Regression, Classification, Clustering
โข Time Series Forecasting
โข A/B Testing & Hypothesis Testing
ETL & Automation:
โข Web Scraping โ BeautifulSoup, Scrapy
โข APIs โ Fetch and process real-world data
โข Build ETL Pipelines
Tools & Deployment:
โข Jupyter Notebook / Colab
โข Git & GitHub
โข Cloud Platforms โ AWS, GCP, Azure
โข Google BigQuery, Snowflake
Hope it helps :)
Core Concepts:
โข Statistics & Probability โ Understand distributions, hypothesis testing
โข Excel โ Pivot tables, formulas, dashboards
Programming:
โข Python โ NumPy, Pandas, Matplotlib, Seaborn
โข R โ Data analysis & visualization
โข SQL โ Joins, filtering, aggregation
Data Cleaning & Wrangling:
โข Handle missing values, duplicates
โข Normalize and transform data
Visualization:
โข Power BI, Tableau โ Dashboards
โข Plotly, Seaborn โ Python visualizations
โข Data Storytelling โ Present insights clearly
Advanced Analytics:
โข Regression, Classification, Clustering
โข Time Series Forecasting
โข A/B Testing & Hypothesis Testing
ETL & Automation:
โข Web Scraping โ BeautifulSoup, Scrapy
โข APIs โ Fetch and process real-world data
โข Build ETL Pipelines
Tools & Deployment:
โข Jupyter Notebook / Colab
โข Git & GitHub
โข Cloud Platforms โ AWS, GCP, Azure
โข Google BigQuery, Snowflake
Hope it helps :)
โค7๐1
๐ FREE Live Masterclass for Future Business Analysts!
๐ 4 Steps to Become a Successful Business Analyst in 2026
๐ May 20th, 2026
โฐ 7:00 PM ๐ English
๐ก Learn:
โ Core Business Analytics Skills & AI usage
โ Real-World Case Studies
โ Career Roadmap for 2026
โ Tools Used by Top Companies
๐ฅ Perfect for:
Students | Freshers | Working Professionals | Career Switchers
๐ Register Now:
https://rebrand.ly/free-businessanalyst-webinar
๐ 4 Steps to Become a Successful Business Analyst in 2026
๐ May 20th, 2026
โฐ 7:00 PM ๐ English
๐ก Learn:
โ Core Business Analytics Skills & AI usage
โ Real-World Case Studies
โ Career Roadmap for 2026
โ Tools Used by Top Companies
๐ฅ Perfect for:
Students | Freshers | Working Professionals | Career Switchers
๐ Register Now:
https://rebrand.ly/free-businessanalyst-webinar
โค5
๐ Data Analyst Interview Questions with Answers โ Part 8
71. Walk me through a real-world analysis you did end-to-end.
A strong answer should follow a structured approach:
โ Business problem
โ Data collection
โ Data cleaning
โ Analysis process
โ Insights discovered
โ Recommendations
โ Business impact
Example:
โI analyzed customer churn data for a subscription business. After cleaning and combining data from multiple sources using SQL and Python, I identified that customers with low product engagement had a much higher churn rate. I built a dashboard in Microsoft Power BI to monitor retention metrics and recommended targeted engagement campaigns, which improved retention over the next quarter.โ
72. Tell me about a time you presented insights to a non-technical audience.
Interviewers want to assess communication skills.
Good approach:
โ๏ธ Use simple language
โ๏ธ Focus on business impact
โ๏ธ Avoid technical jargon
โ๏ธ Use charts and visuals
Example:
โI presented sales insights to the marketing team using a simple dashboard and explained trends using business examples instead of technical terminology. This helped stakeholders quickly understand which campaigns were performing best.โ
73. Tell me about a time your analysis changed a decision or strategy.
A good response should highlight measurable impact.
Example:
โWhile analyzing customer-purchase behavior, I found that most repeat purchases came from mobile users. Based on this insight, the company prioritized mobile app improvements, which increased customer engagement and conversions.โ
74. Tell me about a time you found a data-quality issue and how you fixed it.
Interviewers want to know your problem-solving ability.
Example:
โI noticed duplicate customer records causing incorrect sales totals. I used SQL deduplication techniques and validation checks to clean the dataset and coordinated with the engineering team to prevent the issue from recurring.โ
75. How do you translate a vague business question into a concrete analysis?
A data analyst should clarify requirements before starting analysis.
Steps usually include:
1๏ธโฃ Understand the business goal
2๏ธโฃ Define KPIs and metrics
3๏ธโฃ Identify required data sources
4๏ธโฃ Break the problem into smaller questions
5๏ธโฃ Choose analysis methods and tools
Clear communication is critical.
76. How do you handle conflicting priorities from stakeholders?
Best practices:
โ Understand business impact
โ Discuss deadlines and urgency
โ Align with company goals
โ Communicate transparently
โ Prioritize high-impact tasks first
Strong prioritization skills are important for analysts working with multiple teams.
77. How do you collaborate with product, marketing, and engineering teams?
Collaboration involves:
โ๏ธ Understanding team objectives
โ๏ธ Sharing dashboards and reports
โ๏ธ Explaining insights clearly
โ๏ธ Gathering feedback
โ๏ธ Ensuring data accuracy
Data analysts often act as a bridge between technical and business teams.
78. How do you validate your analysis before sharing it?
Validation steps include:
โ Cross-checking calculations
โ Comparing results with source systems
โ Testing filters and assumptions
โ Reviewing outliers and anomalies
โ Peer-reviewing dashboards or queries
Accuracy is extremely important in decision-making.
79. How do you explain statistical or technical concepts in simple language?
Good analysts simplify complex topics using:
๐ Real-world examples
๐ Visualizations
๐ Analogies
๐ Simple business terms
Example:
โInstead of saying standard deviation measures dispersion, I explain it as how spread out the data values are from the average.โ
80. How do you stay updated with data-analysis trends and tools?
Common ways include:
๐ Reading blogs and documentation
๐ Practicing projects
๐ Following industry experts
๐ Taking online courses
๐ Participating in communities
๐ Exploring new tools and dashboards
Continuous learning is essential in the data field.
๐ Double Tap โค๏ธ For Part-9
71. Walk me through a real-world analysis you did end-to-end.
A strong answer should follow a structured approach:
โ Business problem
โ Data collection
โ Data cleaning
โ Analysis process
โ Insights discovered
โ Recommendations
โ Business impact
Example:
โI analyzed customer churn data for a subscription business. After cleaning and combining data from multiple sources using SQL and Python, I identified that customers with low product engagement had a much higher churn rate. I built a dashboard in Microsoft Power BI to monitor retention metrics and recommended targeted engagement campaigns, which improved retention over the next quarter.โ
72. Tell me about a time you presented insights to a non-technical audience.
Interviewers want to assess communication skills.
Good approach:
โ๏ธ Use simple language
โ๏ธ Focus on business impact
โ๏ธ Avoid technical jargon
โ๏ธ Use charts and visuals
Example:
โI presented sales insights to the marketing team using a simple dashboard and explained trends using business examples instead of technical terminology. This helped stakeholders quickly understand which campaigns were performing best.โ
73. Tell me about a time your analysis changed a decision or strategy.
A good response should highlight measurable impact.
Example:
โWhile analyzing customer-purchase behavior, I found that most repeat purchases came from mobile users. Based on this insight, the company prioritized mobile app improvements, which increased customer engagement and conversions.โ
74. Tell me about a time you found a data-quality issue and how you fixed it.
Interviewers want to know your problem-solving ability.
Example:
โI noticed duplicate customer records causing incorrect sales totals. I used SQL deduplication techniques and validation checks to clean the dataset and coordinated with the engineering team to prevent the issue from recurring.โ
75. How do you translate a vague business question into a concrete analysis?
A data analyst should clarify requirements before starting analysis.
Steps usually include:
1๏ธโฃ Understand the business goal
2๏ธโฃ Define KPIs and metrics
3๏ธโฃ Identify required data sources
4๏ธโฃ Break the problem into smaller questions
5๏ธโฃ Choose analysis methods and tools
Clear communication is critical.
76. How do you handle conflicting priorities from stakeholders?
Best practices:
โ Understand business impact
โ Discuss deadlines and urgency
โ Align with company goals
โ Communicate transparently
โ Prioritize high-impact tasks first
Strong prioritization skills are important for analysts working with multiple teams.
77. How do you collaborate with product, marketing, and engineering teams?
Collaboration involves:
โ๏ธ Understanding team objectives
โ๏ธ Sharing dashboards and reports
โ๏ธ Explaining insights clearly
โ๏ธ Gathering feedback
โ๏ธ Ensuring data accuracy
Data analysts often act as a bridge between technical and business teams.
78. How do you validate your analysis before sharing it?
Validation steps include:
โ Cross-checking calculations
โ Comparing results with source systems
โ Testing filters and assumptions
โ Reviewing outliers and anomalies
โ Peer-reviewing dashboards or queries
Accuracy is extremely important in decision-making.
79. How do you explain statistical or technical concepts in simple language?
Good analysts simplify complex topics using:
๐ Real-world examples
๐ Visualizations
๐ Analogies
๐ Simple business terms
Example:
โInstead of saying standard deviation measures dispersion, I explain it as how spread out the data values are from the average.โ
80. How do you stay updated with data-analysis trends and tools?
Common ways include:
๐ Reading blogs and documentation
๐ Practicing projects
๐ Following industry experts
๐ Taking online courses
๐ Participating in communities
๐ Exploring new tools and dashboards
Continuous learning is essential in the data field.
๐ Double Tap โค๏ธ For Part-9
โค14
๐ ๐๐ฅ๐๐ ๐๐ฒ๐ด๐ถ๐ป๐ป๐ฒ๐ฟ ๐ง๐ฒ๐ฐ๐ต ๐๐ผ๐๐ฟ๐๐ฒ๐ ๐ง๐ผ ๐จ๐ฝ๐ด๐ฟ๐ฎ๐ฑ๐ฒ ๐ฌ๐ผ๐๐ฟ ๐๐ฎ๐ฟ๐ฒ๐ฒ๐ฟ ๐ฅ
Still confused where to start in tech? ๐ค
These FREE beginner-friendly courses can help you build job-ready skills in 2026 ๐
โจ Learn in-demand skills like:
โ๏ธ Programming & Tech Basics
โ๏ธ Data & Digital Skills ๐
โ๏ธ Career-Boosting Concepts ๐ก
โ๏ธ Industry-Relevant Fundamentals
๐ฏ Beginner Friendly + FREE Certificates ๐
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:
https://pdlink.in/4d4b1uK
๐ผ Perfect for Students, Freshers & Career Switchers
Still confused where to start in tech? ๐ค
These FREE beginner-friendly courses can help you build job-ready skills in 2026 ๐
โจ Learn in-demand skills like:
โ๏ธ Programming & Tech Basics
โ๏ธ Data & Digital Skills ๐
โ๏ธ Career-Boosting Concepts ๐ก
โ๏ธ Industry-Relevant Fundamentals
๐ฏ Beginner Friendly + FREE Certificates ๐
๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:
https://pdlink.in/4d4b1uK
๐ผ Perfect for Students, Freshers & Career Switchers
โค2
๐ Data Analyst Interview Questions with Answers โ Part 9
๐ Real-World Case-Study & Scenario Questions
81. Design an analysis to track product usage or feature adoption.
A product-usage analysis usually includes:
โ Daily/Monthly Active Users (DAU/MAU)
โ Feature usage frequency
โ Session duration
โ Retention metrics
โ Funnel conversion rates
Steps:
1๏ธโฃ Define success metrics
2๏ธโฃ Collect event-tracking data
3๏ธโฃ Segment users by behavior
4๏ธโฃ Build dashboards for monitoring trends
5๏ธโฃ Identify drop-off points and improvement opportunities
82. Design an analysis to evaluate marketing campaign performance.
Key campaign metrics include:
๐ Click-Through Rate (CTR)
๐ Conversion Rate
๐ Cost Per Acquisition (CPA)
๐ Return on Ad Spend (ROAS)
๐ Customer Lifetime Value (LTV)
Example approach:
โ๏ธ Compare campaign performance by channel
โ๏ธ Analyze customer segments
โ๏ธ Track conversion funnels
โ๏ธ Measure ROI and engagement trends
83. Design a churn or retention dashboard for a SaaS product.
Important KPIs:
๐ Monthly churn rate
๐ Retention rate
๐ Active users
๐ Subscription renewals
๐ Customer lifetime value
Dashboard sections may include:
โ๏ธ Cohort analysis
โ๏ธ Retention trends
โ๏ธ User-engagement metrics
โ๏ธ Revenue impact of churn
Tools commonly used:
๐ Microsoft Power BI
๐ Tableau
84. Design a sales-performance report for a regional team.
A sales dashboard/report should track:
โ Revenue by region
โ Monthly sales trends
โ Top-performing products
โ Sales targets vs achievement
โ Representative-wise performance
Visualizations may include:
๐ Trend charts
๐ Bar charts
๐บ๏ธ Regional maps
85. Design a customer-segmentation analysis.
Customer segmentation groups users based on behavior or value.
Common segmentation methods:
โ๏ธ RFM Analysis
โ๏ธ Demographic segmentation
โ๏ธ Behavioral segmentation
โ๏ธ Geographic segmentation
Goal:
๐ Identify high-value customers
๐ Improve marketing personalization
๐ Increase retention and revenue
86. How would you analyze a sudden drop in website traffic or orders?
A structured investigation usually includes:
1๏ธโฃ Check tracking/data issues
2๏ธโฃ Compare trends by source/channel
3๏ธโฃ Analyze recent product or website changes
4๏ธโฃ Review seasonality and external events
5๏ธโฃ Identify affected customer segments
Possible causes may include:
๐ซ Technical bugs
๐ซ SEO ranking drops
๐ซ Marketing campaign issues
๐ซ Payment failures
87. How would you analyze a pricing change or discount test?
Key metrics to compare:
๐ Conversion rate
๐ Revenue
๐ Average order value
๐ Customer retention
๐ Profit margin
Approach:
โ๏ธ Compare before vs after performance
โ๏ธ Segment customers by behavior
โ๏ธ Analyze statistical significance if running an A/B test
88. How would you analyze customer-support ticket volume and trends?
Important metrics:
๐ Ticket volume by day/week
๐ Average resolution time
๐ Most common issue categories
๐ Customer satisfaction score (CSAT)
The goal is to identify operational bottlenecks and improve support quality.
89. How would you design a simple A/B test and its success metrics?
Steps to design an A/B test:
1๏ธโฃ Define hypothesis
2๏ธโฃ Split users into control and test groups
3๏ธโฃ Choose success metrics
4๏ธโฃ Run experiment for a sufficient duration
5๏ธโฃ Analyze results statistically
Common success metrics:
โ๏ธ Conversion rate
โ๏ธ Revenue
โ๏ธ Engagement
โ๏ธ Retention
90. How would you explain results and next steps to a manager?
A good presentation should include:
โ Business objective
โ Key findings
โ Supporting charts and KPIs
โ Business impact
โ Actionable recommendations
Focus should always remain on business value rather than technical complexity.
๐ Double Tap โค๏ธ For Part-10
๐ Real-World Case-Study & Scenario Questions
81. Design an analysis to track product usage or feature adoption.
A product-usage analysis usually includes:
โ Daily/Monthly Active Users (DAU/MAU)
โ Feature usage frequency
โ Session duration
โ Retention metrics
โ Funnel conversion rates
Steps:
1๏ธโฃ Define success metrics
2๏ธโฃ Collect event-tracking data
3๏ธโฃ Segment users by behavior
4๏ธโฃ Build dashboards for monitoring trends
5๏ธโฃ Identify drop-off points and improvement opportunities
82. Design an analysis to evaluate marketing campaign performance.
Key campaign metrics include:
๐ Click-Through Rate (CTR)
๐ Conversion Rate
๐ Cost Per Acquisition (CPA)
๐ Return on Ad Spend (ROAS)
๐ Customer Lifetime Value (LTV)
Example approach:
โ๏ธ Compare campaign performance by channel
โ๏ธ Analyze customer segments
โ๏ธ Track conversion funnels
โ๏ธ Measure ROI and engagement trends
83. Design a churn or retention dashboard for a SaaS product.
Important KPIs:
๐ Monthly churn rate
๐ Retention rate
๐ Active users
๐ Subscription renewals
๐ Customer lifetime value
Dashboard sections may include:
โ๏ธ Cohort analysis
โ๏ธ Retention trends
โ๏ธ User-engagement metrics
โ๏ธ Revenue impact of churn
Tools commonly used:
๐ Microsoft Power BI
๐ Tableau
84. Design a sales-performance report for a regional team.
A sales dashboard/report should track:
โ Revenue by region
โ Monthly sales trends
โ Top-performing products
โ Sales targets vs achievement
โ Representative-wise performance
Visualizations may include:
๐ Trend charts
๐ Bar charts
๐บ๏ธ Regional maps
85. Design a customer-segmentation analysis.
Customer segmentation groups users based on behavior or value.
Common segmentation methods:
โ๏ธ RFM Analysis
โ๏ธ Demographic segmentation
โ๏ธ Behavioral segmentation
โ๏ธ Geographic segmentation
Goal:
๐ Identify high-value customers
๐ Improve marketing personalization
๐ Increase retention and revenue
86. How would you analyze a sudden drop in website traffic or orders?
A structured investigation usually includes:
1๏ธโฃ Check tracking/data issues
2๏ธโฃ Compare trends by source/channel
3๏ธโฃ Analyze recent product or website changes
4๏ธโฃ Review seasonality and external events
5๏ธโฃ Identify affected customer segments
Possible causes may include:
๐ซ Technical bugs
๐ซ SEO ranking drops
๐ซ Marketing campaign issues
๐ซ Payment failures
87. How would you analyze a pricing change or discount test?
Key metrics to compare:
๐ Conversion rate
๐ Revenue
๐ Average order value
๐ Customer retention
๐ Profit margin
Approach:
โ๏ธ Compare before vs after performance
โ๏ธ Segment customers by behavior
โ๏ธ Analyze statistical significance if running an A/B test
88. How would you analyze customer-support ticket volume and trends?
Important metrics:
๐ Ticket volume by day/week
๐ Average resolution time
๐ Most common issue categories
๐ Customer satisfaction score (CSAT)
The goal is to identify operational bottlenecks and improve support quality.
89. How would you design a simple A/B test and its success metrics?
Steps to design an A/B test:
1๏ธโฃ Define hypothesis
2๏ธโฃ Split users into control and test groups
3๏ธโฃ Choose success metrics
4๏ธโฃ Run experiment for a sufficient duration
5๏ธโฃ Analyze results statistically
Common success metrics:
โ๏ธ Conversion rate
โ๏ธ Revenue
โ๏ธ Engagement
โ๏ธ Retention
90. How would you explain results and next steps to a manager?
A good presentation should include:
โ Business objective
โ Key findings
โ Supporting charts and KPIs
โ Business impact
โ Actionable recommendations
Focus should always remain on business value rather than technical complexity.
๐ Double Tap โค๏ธ For Part-10
โค14
๐ Data Analyst Interview Questions with Answers โ Part 10
๐ง Tooling, Processes & Best Practices
91. What tools do you use most often as a data analyst?
Common tools used by data analysts include:
๐ SQL for querying databases
๐ Excel for quick analysis and reporting
๐ Python or R for automation and advanced analytics
๐ Microsoft Power BI and Tableau for dashboards
๐ Git for version control
๐ Cloud platforms like Amazon Web Services or Google Cloud
The choice depends on company requirements and project scale.
92. How do you version your code and SQL?
Versioning helps track changes and collaboration.
Best practices:
โ๏ธ Use Git repositories
โ๏ธ Write meaningful commit messages
โ๏ธ Organize files by project
โ๏ธ Maintain separate folders for SQL, dashboards, and scripts
โ๏ธ Use branches for experimentation
Common platforms include:
๐ GitHub
๐ GitLab
93. How do you document queries, dashboards, and assumptions?
Good documentation includes:
โ Business definitions of KPIs
โ Data-source information
โ Query explanations
โ Dashboard filters and logic
โ Assumptions used in calculations
โ Refresh schedules and ownership details
Proper documentation improves transparency and maintainability.
94. How do you handle data privacy and PII in your analyses?
PII (Personally Identifiable Information) should always be protected.
Best practices:
๐ Limit access to sensitive data
๐ Mask or anonymize personal information
๐ Follow company compliance policies
๐ Share only required fields
๐ Use secure storage and permissions
Data privacy is critical in analytics projects.
95. How do you manage permissions and access to dashboards?
Access management usually includes:
โ Role-based permissions
โ Row-level security
โ Workspace access control
โ Restricted sharing settings
โ Audit and usage monitoring
This ensures only authorized users can access sensitive business data.
96. How do you automate repetitive reports?
Automation methods include:
โก Scheduled SQL jobs
โก Automated dashboard refreshes
โก Python scripts
โก Email scheduling tools
โก Cloud workflows and APIs
Automation saves time and reduces manual errors.
97. How do you handle ad-hoc vs recurring analyses?
๐ Ad-hoc analysis โ One-time business questions requiring quick insights
๐ Recurring analysis โ Regular reports and dashboards monitored over time
Analysts usually automate recurring tasks while handling ad-hoc requests based on priority and business impact.
98. How do you get feedback on your dashboards and improve them?
Improvement process:
โ๏ธ Gather stakeholder feedback
โ๏ธ Monitor dashboard usage
โ๏ธ Identify confusing visuals or KPIs
โ๏ธ Simplify layouts if necessary
โ๏ธ Add requested filters or metrics
โ๏ธ Continuously optimize performance and usability
Good dashboards evolve based on user needs.
99. What are your top 5 productivity shortcuts or habits as a data analyst?
Examples of strong productivity habits:
โ Automating repetitive tasks
โ Using keyboard shortcuts
โ Writing reusable SQL and Python scripts
โ Maintaining organized folders and documentation
โ Validating data before sharing reports
Efficient workflows improve speed and accuracy.
100. What skills do you want to improve most in the next 6โ12 months?
A strong answer should show growth mindset and career direction.
Example:
โI want to improve my advanced SQL optimization, statistical analysis, and dashboard storytelling skills. Iโm also focusing on learning more about cloud analytics and automation tools to become more efficient in large-scale data projects.โ
๐ Double Tap โค๏ธ For More
๐ง Tooling, Processes & Best Practices
91. What tools do you use most often as a data analyst?
Common tools used by data analysts include:
๐ SQL for querying databases
๐ Excel for quick analysis and reporting
๐ Python or R for automation and advanced analytics
๐ Microsoft Power BI and Tableau for dashboards
๐ Git for version control
๐ Cloud platforms like Amazon Web Services or Google Cloud
The choice depends on company requirements and project scale.
92. How do you version your code and SQL?
Versioning helps track changes and collaboration.
Best practices:
โ๏ธ Use Git repositories
โ๏ธ Write meaningful commit messages
โ๏ธ Organize files by project
โ๏ธ Maintain separate folders for SQL, dashboards, and scripts
โ๏ธ Use branches for experimentation
Common platforms include:
๐ GitHub
๐ GitLab
93. How do you document queries, dashboards, and assumptions?
Good documentation includes:
โ Business definitions of KPIs
โ Data-source information
โ Query explanations
โ Dashboard filters and logic
โ Assumptions used in calculations
โ Refresh schedules and ownership details
Proper documentation improves transparency and maintainability.
94. How do you handle data privacy and PII in your analyses?
PII (Personally Identifiable Information) should always be protected.
Best practices:
๐ Limit access to sensitive data
๐ Mask or anonymize personal information
๐ Follow company compliance policies
๐ Share only required fields
๐ Use secure storage and permissions
Data privacy is critical in analytics projects.
95. How do you manage permissions and access to dashboards?
Access management usually includes:
โ Role-based permissions
โ Row-level security
โ Workspace access control
โ Restricted sharing settings
โ Audit and usage monitoring
This ensures only authorized users can access sensitive business data.
96. How do you automate repetitive reports?
Automation methods include:
โก Scheduled SQL jobs
โก Automated dashboard refreshes
โก Python scripts
โก Email scheduling tools
โก Cloud workflows and APIs
Automation saves time and reduces manual errors.
97. How do you handle ad-hoc vs recurring analyses?
๐ Ad-hoc analysis โ One-time business questions requiring quick insights
๐ Recurring analysis โ Regular reports and dashboards monitored over time
Analysts usually automate recurring tasks while handling ad-hoc requests based on priority and business impact.
98. How do you get feedback on your dashboards and improve them?
Improvement process:
โ๏ธ Gather stakeholder feedback
โ๏ธ Monitor dashboard usage
โ๏ธ Identify confusing visuals or KPIs
โ๏ธ Simplify layouts if necessary
โ๏ธ Add requested filters or metrics
โ๏ธ Continuously optimize performance and usability
Good dashboards evolve based on user needs.
99. What are your top 5 productivity shortcuts or habits as a data analyst?
Examples of strong productivity habits:
โ Automating repetitive tasks
โ Using keyboard shortcuts
โ Writing reusable SQL and Python scripts
โ Maintaining organized folders and documentation
โ Validating data before sharing reports
Efficient workflows improve speed and accuracy.
100. What skills do you want to improve most in the next 6โ12 months?
A strong answer should show growth mindset and career direction.
Example:
โI want to improve my advanced SQL optimization, statistical analysis, and dashboard storytelling skills. Iโm also focusing on learning more about cloud analytics and automation tools to become more efficient in large-scale data projects.โ
๐ Double Tap โค๏ธ For More
โค11
๐๐/๐ ๐ ๐ฟ๐ผ๐น๐ฒ๐ ๐ฎ๐ฟ๐ฒ ๐ณ๐ฎ๐๐๐ฒ๐๐-๐ด๐ฟ๐ผ๐๐ถ๐ป๐ด ๐ฐ๐ฎ๐ฟ๐ฒ๐ฒ๐ฟ ๐ณ๐ถ๐ฒ๐น๐ฑ ๐ถ๐ป ๐ฎ๐ฌ๐ฎ๐ฒ๐
The demand is real, salaries are high, and the talent gap is wide open
Enrol for AI/ML Certification Program by CCE, IIT Mandi!
Eligibility: Open to everyone
Duration: 6 Months
Program Mode: Online
Taught By: IIT Mandi Professors
Deadline :- 23rd May
๐ฅ๐ฒ๐ด๐ถ๐๐๐ฒ๐ฟ ๐ก๐ผ๐๐ :-
https://pdlink.in/4nmI024
.
๐Get Placement Assistance With 5000+ Companies
The demand is real, salaries are high, and the talent gap is wide open
Enrol for AI/ML Certification Program by CCE, IIT Mandi!
Eligibility: Open to everyone
Duration: 6 Months
Program Mode: Online
Taught By: IIT Mandi Professors
Deadline :- 23rd May
๐ฅ๐ฒ๐ด๐ถ๐๐๐ฒ๐ฟ ๐ก๐ผ๐๐ :-
https://pdlink.in/4nmI024
.
๐Get Placement Assistance With 5000+ Companies
โค2
๐ Complete Data Analyst Roadmap ๐๐ฅ
๐ง STEP 1: Learn Spreadsheet Basics
โ Data Entry & Cleaning
โ Formulas & Functions
โ Sorting & Filtering
โ Charts & Dashboards
๐ Tools to Learn:
โ Microsoft Excel
โ Google Sheets
๐ STEP 2: Master SQL
โ SELECT & WHERE
โ JOINS & GROUP BY
โ Window Functions
โ CTEs & Subqueries
โ Query Optimization
๐ Databases to Learn:
โ MySQL
โ PostgreSQL
โ SQL Server
๐ STEP 3: Learn Python for Data Analysis
โ Data Cleaning
โ Data Analysis
โ Automation
โ Visualization
๐ Libraries to Learn:
โ Pandas
โ NumPy
โ Matplotlib
โ Seaborn
๐ STEP 4: Learn Data Visualization
โ Interactive Dashboards
โ KPIs & Metrics
โ Data Storytelling
โ Business Insights
๐ Tools to Learn:
โ Power BI
โ Tableau
๐ STEP 5: Learn Statistics Basics
โ Mean, Median & Mode
โ Probability Basics
โ Correlation
โ Hypothesis Testing
โ A/B Testing
โ๏ธ STEP 6: Learn Business & Domain Knowledge
โ Business Metrics
โ Customer Analytics
โ Sales Analytics
โ Financial Reporting
โ KPI Analysis
๐ STEP 7: Learn Data Cleaning & ETL
โ Handling Missing Data
โ Removing Duplicates
โ Data Transformation
โ Data Validation
๐ Tools to Learn:
โ Power Query
โ Alteryx
๐ฅ STEP 8: Build Real Projects
โ Sales Dashboard
โ HR Analytics Dashboard
โ Customer Churn Analysis
โ Financial Analytics Report
โ Netflix Data Analysis Project
๐ก The best way to become a Data Analyst:
๐ Learn SQL โ Analyze Data โ Create Dashboards โ Build Projects
๐ฌ Tap โค๏ธ if this helped you!
๐ง STEP 1: Learn Spreadsheet Basics
โ Data Entry & Cleaning
โ Formulas & Functions
โ Sorting & Filtering
โ Charts & Dashboards
๐ Tools to Learn:
โ Microsoft Excel
โ Google Sheets
๐ STEP 2: Master SQL
โ SELECT & WHERE
โ JOINS & GROUP BY
โ Window Functions
โ CTEs & Subqueries
โ Query Optimization
๐ Databases to Learn:
โ MySQL
โ PostgreSQL
โ SQL Server
๐ STEP 3: Learn Python for Data Analysis
โ Data Cleaning
โ Data Analysis
โ Automation
โ Visualization
๐ Libraries to Learn:
โ Pandas
โ NumPy
โ Matplotlib
โ Seaborn
๐ STEP 4: Learn Data Visualization
โ Interactive Dashboards
โ KPIs & Metrics
โ Data Storytelling
โ Business Insights
๐ Tools to Learn:
โ Power BI
โ Tableau
๐ STEP 5: Learn Statistics Basics
โ Mean, Median & Mode
โ Probability Basics
โ Correlation
โ Hypothesis Testing
โ A/B Testing
โ๏ธ STEP 6: Learn Business & Domain Knowledge
โ Business Metrics
โ Customer Analytics
โ Sales Analytics
โ Financial Reporting
โ KPI Analysis
๐ STEP 7: Learn Data Cleaning & ETL
โ Handling Missing Data
โ Removing Duplicates
โ Data Transformation
โ Data Validation
๐ Tools to Learn:
โ Power Query
โ Alteryx
๐ฅ STEP 8: Build Real Projects
โ Sales Dashboard
โ HR Analytics Dashboard
โ Customer Churn Analysis
โ Financial Analytics Report
โ Netflix Data Analysis Project
๐ก The best way to become a Data Analyst:
๐ Learn SQL โ Analyze Data โ Create Dashboards โ Build Projects
๐ฌ Tap โค๏ธ if this helped you!
โค15๐2
๐ Complete Excel Roadmap for Data Analytics ๐๐ฅ
๐ง STEP 1: Learn Excel Basics
โ Rows, Columns & Cells
โ Formatting & Shortcuts
โ Sorting & Filtering
โ Basic Charts
๐ Skills to Learn:
โ Data Entry
โ Freeze Panes
โ Conditional Formatting
โ Data Validation
๐ STEP 2: Master Excel Formulas
โ SUM, AVERAGE, COUNT
โ IF & Nested IF
โ VLOOKUP & XLOOKUP
โ INDEX + MATCH
โ TEXT Functions
โก STEP 3: Learn Data Cleaning
โ Remove Duplicates
โ Text to Columns
โ Flash Fill
โ Find & Replace
โ Handle Missing Data
๐ Tools to Learn:
โ Microsoft Excel Power Query
โ Pivot Tables
โ Named Ranges
๐ STEP 4: Learn Data Visualization
โ Interactive Dashboards
โ Charts & Graphs
โ KPI Reports
โ Data Storytelling
๐ Charts to Learn:
โ Bar Chart
โ Line Chart
โ Pie Chart
โ Scatter Plot
โ Combo Charts
๐งฎ STEP 5: Learn Advanced Excel
โ Pivot Tables
โ Pivot Charts
โ What-If Analysis
โ Goal Seek
โ Scenario Manager
โ๏ธ STEP 6: Learn Automation
โ Macros Basics
โ VBA Introduction
โ Automating Reports
โ Repetitive Task Automation
๐ Skills to Learn:
โ Record Macros
โ Basic VBA Scripts
โ Buttons & Forms
๐ STEP 7: Learn Business Reporting
โ Sales Reports
โ HR Reports
โ Financial Reports
โ Inventory Dashboards
โ KPI Tracking
๐ฅ STEP 8: Build Real Projects
โ Sales Dashboard
โ Expense Tracker
โ Attendance System
โ Financial Report
โ Data Cleaning Project
๐ก Excel Videos: https://xn--r1a.website/excel_data
๐ฌ Tap โค๏ธ if this helped you!
๐ง STEP 1: Learn Excel Basics
โ Rows, Columns & Cells
โ Formatting & Shortcuts
โ Sorting & Filtering
โ Basic Charts
๐ Skills to Learn:
โ Data Entry
โ Freeze Panes
โ Conditional Formatting
โ Data Validation
๐ STEP 2: Master Excel Formulas
โ SUM, AVERAGE, COUNT
โ IF & Nested IF
โ VLOOKUP & XLOOKUP
โ INDEX + MATCH
โ TEXT Functions
โก STEP 3: Learn Data Cleaning
โ Remove Duplicates
โ Text to Columns
โ Flash Fill
โ Find & Replace
โ Handle Missing Data
๐ Tools to Learn:
โ Microsoft Excel Power Query
โ Pivot Tables
โ Named Ranges
๐ STEP 4: Learn Data Visualization
โ Interactive Dashboards
โ Charts & Graphs
โ KPI Reports
โ Data Storytelling
๐ Charts to Learn:
โ Bar Chart
โ Line Chart
โ Pie Chart
โ Scatter Plot
โ Combo Charts
๐งฎ STEP 5: Learn Advanced Excel
โ Pivot Tables
โ Pivot Charts
โ What-If Analysis
โ Goal Seek
โ Scenario Manager
โ๏ธ STEP 6: Learn Automation
โ Macros Basics
โ VBA Introduction
โ Automating Reports
โ Repetitive Task Automation
๐ Skills to Learn:
โ Record Macros
โ Basic VBA Scripts
โ Buttons & Forms
๐ STEP 7: Learn Business Reporting
โ Sales Reports
โ HR Reports
โ Financial Reports
โ Inventory Dashboards
โ KPI Tracking
๐ฅ STEP 8: Build Real Projects
โ Sales Dashboard
โ Expense Tracker
โ Attendance System
โ Financial Report
โ Data Cleaning Project
๐ก Excel Videos: https://xn--r1a.website/excel_data
๐ฌ Tap โค๏ธ if this helped you!
โค16๐1
๐ Data Analytics AโZ Important Terms ๐๐ฅ
๐ ฐ๏ธ Analytics โ Process of analyzing data for insights
๐ ฑ๏ธ Business Intelligence (BI) โ Turning data into business decisions
๐ ฒ CSV โ Comma-separated file used to store tabular data
๐ ณ Dashboard โ Visual representation of data & KPIs
๐ ด ETL โ Extract, Transform & Load process for data pipelines
๐ ต Forecasting โ Predicting future trends using data
๐ ถ Graphs โ Visual charts used for data storytelling
๐ ท Histogram โ Chart showing data distribution
๐ ธ Insights โ Meaningful conclusions from data analysis
๐ น JOIN โ SQL operation to combine multiple tables
๐ บ KPI (Key Performance Indicator) โ Metric used to measure performance
๐ ป Lookup โ Finding related data using formulas/functions
๐ ผ Machine Learning โ AI models learning patterns from data
๐ ฝ Normalization โ Organizing database data efficiently
๐ พ๏ธ Outlier โ Data point significantly different from others
๐ ฟ๏ธ Pivot Table โ Tool used to summarize & analyze data
๐ Query โ Request to fetch data from a database
๐ Regression โ Technique used for prediction & trend analysis
๐ SQL โ Language used to manage & query databases
๐ Tableau โ Popular data visualization tool
๐ Unstructured Data โ Data without fixed format
๐ Visualization โ Representing data through charts & graphs
๐ Warehouse (Data Warehouse) โ Central storage for large-scale data
๐ XLOOKUP โ Advanced Excel lookup function
๐ YAML โ Configuration language often used in data pipelines
๐ Zero Filling โ Replacing missing values with zeros in datasets
๐ก Data Analytics is not just about chartsโฆ itโs about solving business problems using data.
๐ฌ Tap โค๏ธ if this helped you!
๐ ฐ๏ธ Analytics โ Process of analyzing data for insights
๐ ฑ๏ธ Business Intelligence (BI) โ Turning data into business decisions
๐ ฒ CSV โ Comma-separated file used to store tabular data
๐ ณ Dashboard โ Visual representation of data & KPIs
๐ ด ETL โ Extract, Transform & Load process for data pipelines
๐ ต Forecasting โ Predicting future trends using data
๐ ถ Graphs โ Visual charts used for data storytelling
๐ ท Histogram โ Chart showing data distribution
๐ ธ Insights โ Meaningful conclusions from data analysis
๐ น JOIN โ SQL operation to combine multiple tables
๐ บ KPI (Key Performance Indicator) โ Metric used to measure performance
๐ ป Lookup โ Finding related data using formulas/functions
๐ ผ Machine Learning โ AI models learning patterns from data
๐ ฝ Normalization โ Organizing database data efficiently
๐ พ๏ธ Outlier โ Data point significantly different from others
๐ ฟ๏ธ Pivot Table โ Tool used to summarize & analyze data
๐ Query โ Request to fetch data from a database
๐ Regression โ Technique used for prediction & trend analysis
๐ SQL โ Language used to manage & query databases
๐ Tableau โ Popular data visualization tool
๐ Unstructured Data โ Data without fixed format
๐ Visualization โ Representing data through charts & graphs
๐ Warehouse (Data Warehouse) โ Central storage for large-scale data
๐ XLOOKUP โ Advanced Excel lookup function
๐ YAML โ Configuration language often used in data pipelines
๐ Zero Filling โ Replacing missing values with zeros in datasets
๐ก Data Analytics is not just about chartsโฆ itโs about solving business problems using data.
๐ฌ Tap โค๏ธ if this helped you!
โค21
๐๐ฎ๐๐ฎ ๐ฆ๐ฐ๐ถ๐ฒ๐ป๐ฐ๐ฒ ๐๐ถ๐๐ต ๐๐ ๐๐ฒ๐ฟ๐๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป ๐๐ผ๐๐ฟ๐๐ฒ | ๐ญ๐ฌ๐ฌ% ๐๐ผ๐ฏ ๐๐๐๐ถ๐๐๐ฎ๐ป๐ฐ๐ฒ๐
Build Python, Machine Learning, and AI Skills
๐ซ60+ Hiring Drives Every Month | Receive 1-on-1 mentorship
12.65 Lakhs Highest Salary | 500+ Partner Companies
๐๐ผ๐ผ๐ธ ๐ฎ ๐๐ฅ๐๐ ๐ฆ๐ฒ๐๐๐ถ๐ผ๐ป :- ๐:-
Online :- https://pdlink.in/4fdWxJB
๐น Hyderabad :- https://pdlink.in/4kFhjn3
๐น Pune:- https://pdlink.in/45p4GrC
๐น Noida :- https://linkpd.in/DaNoida
Hurry Up ๐โโ๏ธ! Limited seats are available.
Build Python, Machine Learning, and AI Skills
๐ซ60+ Hiring Drives Every Month | Receive 1-on-1 mentorship
12.65 Lakhs Highest Salary | 500+ Partner Companies
๐๐ผ๐ผ๐ธ ๐ฎ ๐๐ฅ๐๐ ๐ฆ๐ฒ๐๐๐ถ๐ผ๐ป :- ๐:-
Online :- https://pdlink.in/4fdWxJB
๐น Hyderabad :- https://pdlink.in/4kFhjn3
๐น Pune:- https://pdlink.in/45p4GrC
๐น Noida :- https://linkpd.in/DaNoida
Hurry Up ๐โโ๏ธ! Limited seats are available.
โค7
๐ Complete Power BI Roadmap ๐๐ฅ
๐ง STEP 1: Learn Power BI Basics
โ Power BI Interface
โ Importing Data
โ Data Connections
โ Basic Visualizations
๐ Tools to Learn:
โ Power BI Desktop
โ Microsoft Excel
๐ STEP 2: Learn Data Cleaning
โ Remove Duplicates
โ Handle Missing Data
โ Data Transformation
โ Merge & Append Queries
๐ Features to Learn:
โ Power Query Editor
โ Data Types
โ Conditional Columns
โ Custom Columns
๐ STEP 3: Learn Data Modeling
โ Relationships
โ Star Schema
โ Snowflake Schema
โ Fact & Dimension Tables
๐ Concepts to Learn:
โ One-to-Many Relationships
โ Cross Filter Direction
โ Data Cardinality
โก STEP 4: Learn DAX (Data Analysis Expressions)
โ Calculated Columns
โ Measures
โ Aggregation Functions
โ Time Intelligence
๐ DAX Functions to Learn:
โ SUM & AVERAGE
โ CALCULATE
โ FILTER
โ IF & SWITCH
โ RELATED & LOOKUPVALUE
๐ STEP 5: Learn Data Visualization
โ KPI Dashboards
โ Interactive Reports
โ Drill Through
โ Conditional Formatting
๐ Visuals to Learn:
โ Bar & Line Charts
โ Pie & Donut Charts
โ Maps
โ Cards & Gauges
โ Matrix Tables
โ๏ธ STEP 6: Learn Power BI Service
โ Publishing Reports
โ Dashboards Sharing
โ Workspaces
โ Scheduled Refresh
๐ Concepts to Learn:
โ Power BI Service
โ Gateways
โ Cloud Reports
โ Collaboration
๐ STEP 7: Learn Advanced Features
โ Row-Level Security
โ Bookmarks
โ Parameters
โ Incremental Refresh
๐ Advanced Skills:
โ Performance Optimization
โ Custom Visuals
โ Dataflows
๐ฅ STEP 8: Build Real Projects
โ Sales Dashboard
โ HR Analytics Dashboard
โ Financial Dashboard
โ Customer Insights Report
โ Executive KPI Dashboard
๐ก The best way to master Power BI:
๐ Clean Data โ Build Models โ Write DAX โ Create Dashboards
Power BI Resources: https://whatsapp.com/channel/0029Vai1xKf1dAvuk6s1v22c
๐ฌ Tap โค๏ธ if this helped you!
๐ง STEP 1: Learn Power BI Basics
โ Power BI Interface
โ Importing Data
โ Data Connections
โ Basic Visualizations
๐ Tools to Learn:
โ Power BI Desktop
โ Microsoft Excel
๐ STEP 2: Learn Data Cleaning
โ Remove Duplicates
โ Handle Missing Data
โ Data Transformation
โ Merge & Append Queries
๐ Features to Learn:
โ Power Query Editor
โ Data Types
โ Conditional Columns
โ Custom Columns
๐ STEP 3: Learn Data Modeling
โ Relationships
โ Star Schema
โ Snowflake Schema
โ Fact & Dimension Tables
๐ Concepts to Learn:
โ One-to-Many Relationships
โ Cross Filter Direction
โ Data Cardinality
โก STEP 4: Learn DAX (Data Analysis Expressions)
โ Calculated Columns
โ Measures
โ Aggregation Functions
โ Time Intelligence
๐ DAX Functions to Learn:
โ SUM & AVERAGE
โ CALCULATE
โ FILTER
โ IF & SWITCH
โ RELATED & LOOKUPVALUE
๐ STEP 5: Learn Data Visualization
โ KPI Dashboards
โ Interactive Reports
โ Drill Through
โ Conditional Formatting
๐ Visuals to Learn:
โ Bar & Line Charts
โ Pie & Donut Charts
โ Maps
โ Cards & Gauges
โ Matrix Tables
โ๏ธ STEP 6: Learn Power BI Service
โ Publishing Reports
โ Dashboards Sharing
โ Workspaces
โ Scheduled Refresh
๐ Concepts to Learn:
โ Power BI Service
โ Gateways
โ Cloud Reports
โ Collaboration
๐ STEP 7: Learn Advanced Features
โ Row-Level Security
โ Bookmarks
โ Parameters
โ Incremental Refresh
๐ Advanced Skills:
โ Performance Optimization
โ Custom Visuals
โ Dataflows
๐ฅ STEP 8: Build Real Projects
โ Sales Dashboard
โ HR Analytics Dashboard
โ Financial Dashboard
โ Customer Insights Report
โ Executive KPI Dashboard
๐ก The best way to master Power BI:
๐ Clean Data โ Build Models โ Write DAX โ Create Dashboards
Power BI Resources: https://whatsapp.com/channel/0029Vai1xKf1dAvuk6s1v22c
๐ฌ Tap โค๏ธ if this helped you!
โค5๐1
๐จ๐ฅ ๐ ๐๐๐ฅ๐ข๐ฆ๐ข๐๐ง ๐๐๐๐ฅ๐๐ = ๐ ๐ข๐๐๐ฅ๐ก ๐๐๐ง๐ ๐๐ก๐๐๐ก๐๐๐ฅ๐๐ก๐ ๐ฅ๐จ
Most professionals still donโt even realize that ๐ ๐ถ๐ฐ๐ฟ๐ผ๐๐ผ๐ณ๐ ๐๐ฎ๐ฏ๐ฟ๐ถ๐ฐ is becoming a major part of ๐ ๐ผ๐ฑ๐ฒ๐ฟ๐ป ๐๐ฎ๐๐ฎ ๐๐ป๐ด๐ถ๐ป๐ฒ๐ฒ๐ฟ๐ถ๐ป๐ด.
Just like Azure exploded after 2018โฆ
Microsoft Fabric is now entering the same growth phase. ๐
๐๐ผ๐บ๐ฝ๐ฎ๐ป๐ถ๐ฒ๐ ๐ฎ๐ฟ๐ฒ ๐ฎ๐ด๐ด๐ฟ๐ฒ๐๐๐ถ๐๐ฒ๐น๐ ๐บ๐ผ๐๐ถ๐ป๐ด ๐๐ผ๐๐ฎ๐ฟ๐ฑ๐:
โ OneLake
โ Lakehouse
โ Real-Time Analytics
โ Fabric Pipelines
โ PySpark & Notebooks
โ Power BI + Fabric Integration
๐ฅ 500+ Professionals Already Trained
๐ฅ Real-Time Industry Projects
๐ฅ Practical Hands-on Sessions
๐ฅ Interview Preparation & Career Guidance
๐ฅ Placement & Collaboration Support Efforts
๐จ ๐ก๐ฒ๐ ๐๐ฎ๐๐ฐ๐ต ๐ฆ๐๐ฎ๐ฟ๐๐ถ๐ป๐ด: 3rd June 2026
โฐ ๐ง๐ถ๐บ๐ถ๐ป๐ด: 8 AM โ 9 AM IST
๐ Live Online Sessions
โ ๏ธ Early movers always get the biggest advantage before the market becomes crowded.
๐ฉ ๐๐ผ๐ถ๐ป ๐๐ต๐ถ๐ ๐ฐ๐ผ๐บ๐บ๐๐ป๐ถ๐๐ ๐ณ๐ผ๐ฟ ๐ณ๐๐ฟ๐๐ต๐ฒ๐ฟ ๐ฑ๐ฒ๐๐ฎ๐ถ๐น๐ & ๐ฟ๐ฒ๐ด๐ถ๐๐๐ฟ๐ฎ๐๐ถ๐ผ๐ป:
WhatsApp Community๏ฟผ
https://chat.whatsapp.com/H7wG27XRZ6vChKR6xfIL9S
Most professionals still donโt even realize that ๐ ๐ถ๐ฐ๐ฟ๐ผ๐๐ผ๐ณ๐ ๐๐ฎ๐ฏ๐ฟ๐ถ๐ฐ is becoming a major part of ๐ ๐ผ๐ฑ๐ฒ๐ฟ๐ป ๐๐ฎ๐๐ฎ ๐๐ป๐ด๐ถ๐ป๐ฒ๐ฒ๐ฟ๐ถ๐ป๐ด.
Just like Azure exploded after 2018โฆ
Microsoft Fabric is now entering the same growth phase. ๐
๐๐ผ๐บ๐ฝ๐ฎ๐ป๐ถ๐ฒ๐ ๐ฎ๐ฟ๐ฒ ๐ฎ๐ด๐ด๐ฟ๐ฒ๐๐๐ถ๐๐ฒ๐น๐ ๐บ๐ผ๐๐ถ๐ป๐ด ๐๐ผ๐๐ฎ๐ฟ๐ฑ๐:
โ OneLake
โ Lakehouse
โ Real-Time Analytics
โ Fabric Pipelines
โ PySpark & Notebooks
โ Power BI + Fabric Integration
๐ฅ 500+ Professionals Already Trained
๐ฅ Real-Time Industry Projects
๐ฅ Practical Hands-on Sessions
๐ฅ Interview Preparation & Career Guidance
๐ฅ Placement & Collaboration Support Efforts
๐จ ๐ก๐ฒ๐ ๐๐ฎ๐๐ฐ๐ต ๐ฆ๐๐ฎ๐ฟ๐๐ถ๐ป๐ด: 3rd June 2026
โฐ ๐ง๐ถ๐บ๐ถ๐ป๐ด: 8 AM โ 9 AM IST
๐ Live Online Sessions
โ ๏ธ Early movers always get the biggest advantage before the market becomes crowded.
๐ฉ ๐๐ผ๐ถ๐ป ๐๐ต๐ถ๐ ๐ฐ๐ผ๐บ๐บ๐๐ป๐ถ๐๐ ๐ณ๐ผ๐ฟ ๐ณ๐๐ฟ๐๐ต๐ฒ๐ฟ ๐ฑ๐ฒ๐๐ฎ๐ถ๐น๐ & ๐ฟ๐ฒ๐ด๐ถ๐๐๐ฟ๐ฎ๐๐ถ๐ผ๐ป:
WhatsApp Community๏ฟผ
https://chat.whatsapp.com/H7wG27XRZ6vChKR6xfIL9S
โค2๐ฅ1
๐๐ & ๐ ๐ ๐๐ฒ๐ฟ๐๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป ๐ฃ๐ฟ๐ผ๐ด๐ฟ๐ฎ๐บ ๐ฏ๐ ๐๐๐, ๐๐๐ง ๐ ๐ฎ๐ป๐ฑ๐ถ๐
Freshers get 15 LPA Average Salary with AI & ML Skills!
- Eligibility: Open to everyone
- Duration: 6 Months
- Program Mode: Online
- Taught By: IIT Mandi Professors
90% Resumes without AI + ML skills are being rejected.
๐๐ฝ๐ฝ๐น๐ ๐ก๐ผ๐๐ :-
https://pdlink.in/4nmI024
Get Placement Assistance With 5000+ Companies
Freshers get 15 LPA Average Salary with AI & ML Skills!
- Eligibility: Open to everyone
- Duration: 6 Months
- Program Mode: Online
- Taught By: IIT Mandi Professors
90% Resumes without AI + ML skills are being rejected.
๐๐ฝ๐ฝ๐น๐ ๐ก๐ผ๐๐ :-
https://pdlink.in/4nmI024
Get Placement Assistance With 5000+ Companies
โค3
๐ Complete SQL Roadmap ๐๐ฅ
๐ง STEP 1: Learn SQL Basics
โ What is SQL?
โ Databases & Tables
โ SELECT Statement
โ WHERE Clause
โ ORDER BY
๐ Databases to Practice:
โ MySQL
โ PostgreSQL
โ SQL Server
๐ STEP 2: Learn Filtering & Aggregation
โ DISTINCT
โ LIMIT & TOP
โ COUNT, SUM, AVG
โ MIN & MAX
โ GROUP BY & HAVING
โก STEP 3: Master SQL JOINS
โ INNER JOIN
โ LEFT JOIN
โ RIGHT JOIN
โ FULL JOIN
โ SELF JOIN
๐ Concepts to Learn:
โ Primary Key
โ Foreign Key
โ Relationships
๐ STEP 4: Learn Advanced SQL
โ Subqueries
โ Common Table Expressions (CTEs)
โ CASE WHEN
โ UNION & UNION ALL
โ EXISTS & IN
๐ฅ STEP 5: Learn Window Functions
โ ROW_NUMBER()
โ RANK()
โ DENSE_RANK()
โ LEAD() & LAG()
โ PARTITION BY
๐ง STEP 6: Learn Database Design
โ Normalization
โ Schema Design
โ Indexing
โ Constraints
โ Data Integrity
โ๏ธ STEP 7: Learn SQL Optimization
โ Query Optimization
โ Execution Plans
โ Index Optimization
โ Performance Tuning
๐ Tools to Learn:
โ DBeaver
โ pgAdmin
โ MySQL Workbench
๐ STEP 8: Build Real SQL Projects
โ Sales Database Analysis
โ Employee Management System
โ E-commerce Database
โ Customer Analytics
โ Inventory Management
๐ก SQL Notes: https://whatsapp.com/channel/0029VbCyzS02ZjCwoShXXc2j
๐ฌ Tap โค๏ธ if this helped you!
๐ง STEP 1: Learn SQL Basics
โ What is SQL?
โ Databases & Tables
โ SELECT Statement
โ WHERE Clause
โ ORDER BY
๐ Databases to Practice:
โ MySQL
โ PostgreSQL
โ SQL Server
๐ STEP 2: Learn Filtering & Aggregation
โ DISTINCT
โ LIMIT & TOP
โ COUNT, SUM, AVG
โ MIN & MAX
โ GROUP BY & HAVING
โก STEP 3: Master SQL JOINS
โ INNER JOIN
โ LEFT JOIN
โ RIGHT JOIN
โ FULL JOIN
โ SELF JOIN
๐ Concepts to Learn:
โ Primary Key
โ Foreign Key
โ Relationships
๐ STEP 4: Learn Advanced SQL
โ Subqueries
โ Common Table Expressions (CTEs)
โ CASE WHEN
โ UNION & UNION ALL
โ EXISTS & IN
๐ฅ STEP 5: Learn Window Functions
โ ROW_NUMBER()
โ RANK()
โ DENSE_RANK()
โ LEAD() & LAG()
โ PARTITION BY
๐ง STEP 6: Learn Database Design
โ Normalization
โ Schema Design
โ Indexing
โ Constraints
โ Data Integrity
โ๏ธ STEP 7: Learn SQL Optimization
โ Query Optimization
โ Execution Plans
โ Index Optimization
โ Performance Tuning
๐ Tools to Learn:
โ DBeaver
โ pgAdmin
โ MySQL Workbench
๐ STEP 8: Build Real SQL Projects
โ Sales Database Analysis
โ Employee Management System
โ E-commerce Database
โ Customer Analytics
โ Inventory Management
๐ก SQL Notes: https://whatsapp.com/channel/0029VbCyzS02ZjCwoShXXc2j
๐ฌ Tap โค๏ธ if this helped you!
โค6๐2
๐ ๐ถ๐ฐ๐ฟ๐ผ๐๐ผ๐ณ๐ ๐๐ฅ๐๐ ๐๐ฒ๐ฟ๐๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป ๐๐ผ๐๐ฟ๐๐ฒ๐๐
โจ Learn In-Demand Tech Skills
โจ Boost Your Resume & LinkedIn Profile
โจ Improve Career Opportunities
โจ Self-Paced Online Learning
โจ Great for Freshers & Students
๐ ๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:
https://pdlink.in/49p31Uh
๐ฅ Start learning today and prepare for high-paying tech careers with Microsoft free certification programs
โจ Learn In-Demand Tech Skills
โจ Boost Your Resume & LinkedIn Profile
โจ Improve Career Opportunities
โจ Self-Paced Online Learning
โจ Great for Freshers & Students
๐ ๐๐ป๐ฟ๐ผ๐น๐น ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:
https://pdlink.in/49p31Uh
๐ฅ Start learning today and prepare for high-paying tech careers with Microsoft free certification programs
โค6
๐ Python Roadmap for Data Analytics ๐๐๐ฅ
๐ง STEP 1: Learn Python Basics
โ Variables & Data Types
โ Loops & Functions
โ Lists, Tuples & Dictionaries
โ File Handling
โ Exception Handling
๐ Tools to Learn:
โ Jupyter Notebook
โ Visual Studio Code
๐ STEP 2: Learn Data Handling
โ Reading CSV & Excel Files
โ Data Cleaning
โ Handling Missing Values
โ Data Transformation
๐ Libraries to Learn:
โ Pandas
โ NumPy
๐ STEP 3: Learn Data Visualization
โ Line Charts
โ Bar Charts
โ Pie Charts
โ Heatmaps
โ Interactive Dashboards
๐ Visualization Libraries:
โ Matplotlib
โ Seaborn
โ Plotly
๐ง STEP 4: Learn Statistics Basics
โ Mean, Median & Mode
โ Probability
โ Correlation
โ Hypothesis Testing
โ A/B Testing
โก STEP 5: Learn SQL with Python
โ Database Connections
โ SQL Queries
โ Fetching Data
โ Data Integration
๐ Libraries to Learn:
โ sqlite3
โ SQLAlchemy
โ PyMySQL
๐ค STEP 6: Learn Basic Machine Learning
โ Regression
โ Classification
โ Clustering
โ Model Evaluation
๐ Frameworks to Learn:
โ Scikit-learn
โ XGBoost
๐ STEP 7: Learn Automation & Reporting
โ Automating Reports
โ Excel Automation
โ API Data Collection
โ Scheduling Tasks
๐ Libraries to Learn:
โ openpyxl
โ requests
โ schedule
๐ฅ STEP 8: Build Real Projects
โ Sales Data Analysis
โ HR Analytics Dashboard
โ Customer Churn Analysis
โ Financial Analytics
โ Netflix Dataset Analysis
Python Resources: https://whatsapp.com/channel/0029VaiM08SDuMRaGKd9Wv0L
๐ฌ Tap โค๏ธ if this helped you!
๐ง STEP 1: Learn Python Basics
โ Variables & Data Types
โ Loops & Functions
โ Lists, Tuples & Dictionaries
โ File Handling
โ Exception Handling
๐ Tools to Learn:
โ Jupyter Notebook
โ Visual Studio Code
๐ STEP 2: Learn Data Handling
โ Reading CSV & Excel Files
โ Data Cleaning
โ Handling Missing Values
โ Data Transformation
๐ Libraries to Learn:
โ Pandas
โ NumPy
๐ STEP 3: Learn Data Visualization
โ Line Charts
โ Bar Charts
โ Pie Charts
โ Heatmaps
โ Interactive Dashboards
๐ Visualization Libraries:
โ Matplotlib
โ Seaborn
โ Plotly
๐ง STEP 4: Learn Statistics Basics
โ Mean, Median & Mode
โ Probability
โ Correlation
โ Hypothesis Testing
โ A/B Testing
โก STEP 5: Learn SQL with Python
โ Database Connections
โ SQL Queries
โ Fetching Data
โ Data Integration
๐ Libraries to Learn:
โ sqlite3
โ SQLAlchemy
โ PyMySQL
๐ค STEP 6: Learn Basic Machine Learning
โ Regression
โ Classification
โ Clustering
โ Model Evaluation
๐ Frameworks to Learn:
โ Scikit-learn
โ XGBoost
๐ STEP 7: Learn Automation & Reporting
โ Automating Reports
โ Excel Automation
โ API Data Collection
โ Scheduling Tasks
๐ Libraries to Learn:
โ openpyxl
โ requests
โ schedule
๐ฅ STEP 8: Build Real Projects
โ Sales Data Analysis
โ HR Analytics Dashboard
โ Customer Churn Analysis
โ Financial Analytics
โ Netflix Dataset Analysis
Python Resources: https://whatsapp.com/channel/0029VaiM08SDuMRaGKd9Wv0L
๐ฌ Tap โค๏ธ if this helped you!
โค6