Learn how to collect, clean, analyze, visualize and interpret data using the tools used across modern business and analytics teams.
Start with Excel and statistics, learn to extract data using SQL, analyze it with Python, and build professional dashboards using Power BI and Tableau. Develop the analytical thinking and communication skills needed to turn data into business decisions.
Data Analytics is the process of examining raw data to identify patterns, answer questions, measure performance and support better decisions. A Data Analyst connects data with business problems.
What does a Data Analyst do?
Collect data from spreadsheets, databases and business applications.
Clean inconsistent, incomplete and duplicate records.
Analyze trends, patterns and performance indicators.
Build reports and dashboards for stakeholders.
Translate business questions into analytical queries.
Communicate findings and recommend actions.
Example: An e-commerce business
A company notices that its monthly revenue has declined. A Data Analyst investigates the problem by examining:
Revenue by month, region and product category.
Number of orders and average order value.
Customer acquisition and repeat purchases.
Product returns and cancellation rates.
Marketing channel performance.
The analyst identifies the likely drivers and presents findings to the business team.
The key idea: Data Analytics is not simply creating charts or writing SQL queries. The objective is to answer meaningful questions using accurate data, appropriate methods and clear communication.
2. Understand the four types of Data Analytics
A Data Analyst should understand what kind of question a business is asking before deciding which analysis to perform.
01 · Descriptive
What happened?
Summarizes historical data to understand past performance.
Example: Total sales last quarter were ₹45 lakh, which was 8% higher than the previous quarter.
02 · Diagnostic
Why did it happen?
Investigates causes, relationships and contributing factors.
Example: Revenue increased because the electronics category experienced higher sales in two regions.
03 · Predictive
What might happen?
Uses statistical methods and predictive models to estimate future outcomes.
Example: Forecast next month's sales using historical trends and seasonal patterns.
04 · Prescriptive
What should we do?
Evaluates possible actions and recommends decisions based on objectives and constraints.
Example: Recommend inventory allocation across regions to reduce stockouts and holding costs.
3. The Data Analyst workflow
A typical analytics project follows a sequence of activities. The exact process may vary depending on the organization, data sources and business problem.
1
Understand the problemDefine the business question and KPIs.
2
Collect dataExcel, databases, APIs and business systems.
3
Clean the dataMissing values, duplicates and inconsistencies.
4
Explore the dataPatterns, distributions and anomalies.
5
AnalyzeCalculate metrics and test hypotheses.
6
VisualizeCharts, reports and interactive dashboards.
7
InterpretExplain findings and business impact.
8
CommunicatePresent recommendations and next steps.
End-to-end example: A retail manager asks why sales are falling. You extract order data using SQL, clean it with Python, analyze product and regional performance, create a Power BI dashboard and present the key findings with recommendations.
4. Prerequisites: What should you know?
You do not need advanced programming or mathematics to begin Data Analytics. However, basic computer skills, logical thinking and a willingness to work with data are important.
Computer fundamentals
Files, folders, spreadsheets, installing software, working with CSV and Excel files, and navigating applications.
Basic mathematics
Percentages, ratios, averages, fractions, basic algebra and interpreting numerical values.
Logical thinking
Breaking a problem into smaller questions, comparing alternatives and identifying patterns.
Communication
Understanding stakeholder questions, explaining results and writing clear observations.
Prerequisite self-assessment
Mark the skills you already understand. Your progress is saved in this browser.
0 of 6 skills completed
5. The complete Data Analyst roadmap
Explore the stages in sequence. Each stage includes concepts, practical examples, tools and a milestone to help you measure your learning.
01
Data Analytics Fundamentals and Business UnderstandingEstimated time: 1–2 weeks · Foundation
⌄
Start by understanding what data is, how organizations use it and how analytics supports business decisions. This foundation helps you understand the purpose behind every technical tool you learn.
Introduction to data
Data, information, insights, records, observations, variables and datasets.
Types of data
Structured, semi-structured and unstructured data; quantitative and qualitative data.
Data sources
Spreadsheets, databases, APIs, CRM systems, ERP systems, websites and business applications.
Analytics lifecycle
Problem definition, collection, preparation, analysis, visualization and communication.
Business metrics and KPIs
Revenue, profit, growth, conversion rate, retention, churn, customer acquisition cost and average order value.
Data quality
Accuracy, completeness, consistency, validity, uniqueness and timeliness.
Example: Sales analytics A company wants to understand its sales performance. Before opening Excel or writing SQL, clarify what "sales performance" means: revenue, number of orders, units sold, profit, growth or achievement against target.
Milestone: Take a business scenario and define at least five meaningful questions and KPIs that can be answered using data.
02
Microsoft Excel for Data AnalysisEstimated time: 3–4 weeks · Foundation
⌄
Excel is one of the most widely used tools for everyday business analysis. Learn to organize, clean, calculate, summarize and present data using spreadsheets.
Excel interface and data handling
Workbooks, worksheets, rows, columns, cells, ranges, tables, data types, sorting and filtering.
Basic formulas
SUM, AVERAGE, COUNT, COUNTA, MIN, MAX, ROUND and absolute versus relative cell references.
Logical functions
IF, IFS, AND, OR, IFERROR and nested conditions for business rules.
Conditional aggregation
SUMIF, SUMIFS, COUNTIF, COUNTIFS and AVERAGEIF.
Lookup functions
VLOOKUP, HLOOKUP, XLOOKUP, INDEX and MATCH for matching information across tables.
TODAY, NOW, DATE, YEAR, MONTH, DAY, EOMONTH and date differences.
Data cleaning
Remove duplicates, handle blanks, fix inconsistent formats, split columns and use data validation.
PivotTables and PivotCharts
Summarize large datasets, group dates, aggregate measures and create interactive reports.
Dashboard creation
Charts, slicers, timelines, conditional formatting, KPI cards and report layouts.
Power Query in Excel
Import, transform, combine and refresh data through repeatable steps.
Advanced Excel concepts
Dynamic arrays, FILTER, SORT, UNIQUE, LET, named ranges and introductory Power Pivot.
Example: Employee salary analysis Imagine an employee dataset with Employee ID, Department, Salary, Joining Date and Location. Use XLOOKUP to retrieve department details, COUNTIF to count employees, AVERAGEIF to calculate department-wise average salary, and PivotTables to compare headcount and salary by location.
Example: Monthly sales report Use SUMIFS to calculate revenue for a particular month and region. Create a PivotTable to summarize category-wise sales, then add a slicer so a manager can filter the report by region.
Tools
Microsoft ExcelPower QueryPower PivotGoogle Sheets
Milestone: Take a messy sales workbook, clean it, use formulas and PivotTables, and create a one-page interactive Excel dashboard.
03
Statistics and Mathematics for Data AnalyticsEstimated time: 2–3 weeks · Foundation
⌄
Statistics helps analysts summarize data, understand variation, compare groups and make evidence-based conclusions. You do not need advanced mathematics to begin, but you should understand the following concepts.
Descriptive statistics
Mean, median, mode, range, variance, standard deviation and interquartile range.
Percentages and ratios
Percentage change, growth rate, proportions, margins, ratios and contribution analysis.
Probability
Events, sample spaces, conditional probability, independent events and basic probability rules.
Distributions
Normal, binomial and uniform distributions; skewness, kurtosis and distribution shapes.
Sampling
Population, sample, random sampling, sampling bias and sample size.
Inferential statistics
Confidence intervals, standard error, hypothesis testing, p-values and statistical significance.
Correlation
Pearson and Spearman correlation, direction, strength and limitations of correlation analysis.
Regression fundamentals
Linear relationships, dependent and independent variables, residuals and basic regression interpretation.
A/B testing
Control and treatment groups, experiment design, conversion rates and interpretation of results.
Example: Average salary Consider salaries of ₹20,000, ₹22,000, ₹25,000, ₹27,000 and ₹1,50,000. The mean is ₹48,800, while the median is ₹25,000. The unusually high salary pulls the mean upward. This illustrates why analysts should inspect distributions instead of relying on a single metric.
Example: Conversion rate A website receives 10,000 visitors and 400 purchases. Conversion rate = 400 / 10,000 × 100 = 4%. If a redesigned page converts 450 visitors out of 10,000, the observed conversion rate is 4.5%. A properly designed experiment is needed before concluding that the redesign caused the improvement.
Milestone: Analyze a numerical dataset using descriptive statistics, distributions, correlation and a simple hypothesis-testing scenario.
04
SQL for Data Extraction and Database AnalysisEstimated time: 4–5 weeks · Intermediate
⌄
SQL is a core skill for Data Analysts because business data is often stored in relational databases. Learn to retrieve, filter, combine, summarize and analyze data directly from tables.
Database fundamentals
Databases, tables, records, columns, data types, schemas and relational database concepts.
Keys and relationships
Primary keys, foreign keys, one-to-one, one-to-many and many-to-many relationships.
Basic SQL queries
SELECT, DISTINCT, FROM, WHERE, ORDER BY, LIMIT and aliases.
Filtering conditions
AND, OR, NOT, IN, BETWEEN, LIKE, IS NULL and comparison operators.
Aggregate functions
COUNT, SUM, AVG, MIN, MAX and DISTINCT counts.
Grouping
GROUP BY, HAVING and conditional aggregation using CASE WHEN.
Joins
INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN and SELF JOIN.
Subqueries and CTEs
Nested queries, correlated subqueries and Common Table Expressions using WITH.
Window functions
ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, SUM OVER and PARTITION BY.
Date and string functions
Date extraction, date differences, formatting, concatenation and text manipulation.
Advanced SQL analysis
Running totals, ranking, moving averages, cohort-style analysis and conditional metrics.
Views and query performance
Views, indexes, execution plans, query readability and basic optimization.
Example: Find total sales by region SELECT region, SUM(sales_amount) AS total_sales FROM orders GROUP BY region ORDER BY total_sales DESC; This query groups orders by region, calculates total sales and ranks regions by revenue.
Example: Find the top three products in each category Use ROW_NUMBER() or DENSE_RANK() with PARTITION BY category and order products by sales. This is a common business analytics and SQL interview problem.
Example: Customer analysis Combine customers and orders using JOINs. Calculate total spending, number of orders, first purchase date and last purchase date to identify repeat customers and high-value segments.
Tools and databases
PostgreSQLMySQLSQL ServerSQLiteDBeaverpgAdmin
Milestone: Solve at least 40 SQL business questions involving filtering, aggregation, joins, CTEs and window functions.
05
Python Programming for Data AnalystsEstimated time: 3–4 weeks · Intermediate
⌄
Python allows analysts to automate repetitive tasks, process larger datasets, perform flexible analysis and create reproducible workflows.
Python fundamentals
Variables, data types, operators, input/output, type conversion and comments.
Control flow
Conditional statements, for loops, while loops, break, continue and logical expressions.
Data structures
Lists, tuples, sets, dictionaries, indexing, slicing and comprehensions.
Functions
Defining functions, parameters, return values, default arguments and lambda expressions.
File handling
Read and write CSV, text and JSON files; work with file paths and exceptions.
Modules and packages
Importing modules, pip, virtual environments and package management.
NumPy
Arrays, dimensions, indexing, slicing, vectorized operations and numerical calculations.
Pandas introduction
Series, DataFrames, reading files, inspecting data and understanding tabular datasets.
Example: Automate a sales calculation Instead of manually calculating total revenue for thousands of rows, write a Python program that reads a CSV file, validates the sales column and calculates total revenue automatically.
Example: DataFrame A Pandas DataFrame represents tabular data with rows and columns, similar to an Excel worksheet or a database query result. You can filter, transform, group and combine data using Python code.
Tools
PythonJupyter NotebookGoogle ColabAnacondaVS Code
Milestone: Write a Python program that reads multiple CSV files, performs calculations and produces a summarized output.
06
Data Cleaning, Wrangling and Exploratory Data AnalysisEstimated time: 3–4 weeks · Intermediate
⌄
Real-world data is rarely analysis-ready. It may contain missing values, duplicate rows, inconsistent categories, incorrect data types and unusual observations. This stage teaches you how to prepare data before drawing conclusions.
Data inspection
head, tail, sample, shape, info, describe, dtypes and value_counts.
Missing values
isna, notna, fillna, dropna and selecting an appropriate missing-data strategy.
Duplicate records
duplicated, drop_duplicates and identifying business-key duplication.
Data type conversion
astype, to_numeric, to_datetime and categorical data.
Data filtering
Boolean indexing, loc, iloc, query and conditional selection.
Data transformation
apply, map, replace, rename, assign and derived columns.
Combining datasets
merge, join, concat and understanding keys and join cardinality.
Grouping and reshaping
groupby, agg, pivot_table, melt, stack and unstack.
Outlier analysis
Boxplots, IQR, z-scores and domain-based investigation of unusual values.
Exploratory analysis
Univariate, bivariate and multivariate analysis; trends, correlations and patterns.
Example: Customer dataset cleanup A customer file contains duplicate customer IDs, blank ages, inconsistent city names such as "Delhi", "delhi" and "DELHI", and dates stored as text. Use Pandas to inspect the data, standardize categories, investigate missing values, convert dates and document every transformation.
Example: Sales EDA Analyze monthly revenue, product category performance, regional distribution, order size and customer purchase frequency. Identify trends and unusual changes before building a dashboard.
Tools
PandasNumPyJupyterOpenRefine
Milestone: Perform complete EDA on a real-world dataset and produce a documented data-quality report with key observations.
07
Data Visualization and Analytical StorytellingEstimated time: 2–3 weeks · Intermediate
⌄
Visualization helps communicate patterns that may be difficult to understand from raw tables. Learn to select the right chart, avoid misleading visuals and explain what the data means.
Bar charts, grouped bars, stacked bars and dot plots.
Trend charts
Line charts, area charts, time-series plots and moving averages.
Distribution charts
Histograms, boxplots, density plots and violin plots.
Relationship charts
Scatter plots, bubble charts, correlation heatmaps and pair plots.
Composition charts
Stacked bars, treemaps and carefully selected proportion charts.
Matplotlib
Figures, axes, subplots, labels, annotations, legends and chart customization.
Seaborn and Plotly
Statistical visualizations, categorical plots and interactive charts.
Data storytelling
Context, observation, evidence, business implication and recommended action.
Example: Monthly revenue A line chart can show how revenue changes over time. A bar chart can compare revenue across product categories. A boxplot can reveal whether order values contain unusually high or low observations.
Example: Avoiding misleading visuals If a bar chart compares sales across regions, a truncated vertical axis can exaggerate small differences. Use appropriate scales, clear labels and enough context for the viewer to interpret the comparison correctly.
Tools
MatplotlibSeabornPlotlyPandas plotting
Milestone: Create a visualization report containing at least eight appropriate charts and explain the business insight behind each one.
08
Microsoft Power BI for Business IntelligenceEstimated time: 4–5 weeks · Intermediate
⌄
Power BI is a business intelligence platform used to connect data sources, transform data, build analytical models and publish interactive reports. Learn the complete workflow rather than focusing only on chart creation.
Power BI fundamentals
Power BI Desktop, report view, data view, model view, workspaces and basic publishing concepts.
Data connectivity
Connect Excel, CSV, SQL databases, web sources and supported cloud data sources.
Power Query
Import, clean, filter, merge, append, pivot, unpivot and transform data using repeatable steps.
Data modeling
Fact and dimension tables, relationships, cardinality, filter direction and star schema.
DAX fundamentals
Measures, calculated columns, row context, filter context and basic expressions.
DAX functions
SUM, AVERAGE, COUNTROWS, DISTINCTCOUNT, CALCULATE, FILTER, RELATED and DIVIDE.
Time intelligence
Year-to-date, month-to-date, previous period, year-over-year and rolling calculations.
Report visuals
Cards, tables, matrices, bar charts, line charts, maps, slicers and KPI visuals.
Interactive reporting
Drill-down, drill-through, tooltips, bookmarks, buttons and cross-filtering.
Power BI Service
Publish reports, dashboards, workspaces, refresh schedules and sharing permissions.
Row-level security
Role definitions, user-based filtering and controlled access to report data.
Performance and governance
Model optimization, efficient DAX, refresh reliability and data-source permissions.
Example: Sales performance dashboard Connect an orders table and a product table. Clean the data in Power Query, create relationships, then build measures for Total Revenue, Total Orders, Average Order Value and Year-over-Year Growth. Create a report with regional, product and monthly filters.
Example: DAX measure Total Revenue = SUM(Orders[SalesAmount]) This measure calculates total sales in the current filter context. Selecting a region or month in the report changes the result based on the active filters.
Tools
Power BI DesktopPower QueryDAXPower BI Service
Milestone: Build and publish an interactive Power BI dashboard with a star-schema data model, DAX measures, slicers and drill-through.
09
Tableau for Data Visualization and AnalyticsEstimated time: 3–4 weeks · Intermediate
⌄
Tableau is a widely used analytics and visualization platform. Learn how to connect to data, create visualizations, develop interactive dashboards and communicate insights through analytical stories.
Tableau fundamentals
Tableau Desktop, Tableau Public, Tableau Cloud, workbooks, worksheets and dashboards.
Dimensions and measures
Discrete and continuous fields, data types, geographic roles and field organization.
Data connections
Excel, CSV, relational databases, extracts, live connections and data source management.
Visual analytics
Bar charts, line charts, maps, scatter plots, histograms, heatmaps and highlight tables.
Filters and sorting
Dimension filters, measure filters, context filters, date filters and sorting.
Calculated fields
IF, CASE, string functions, date functions, logical calculations and aggregations.
Table calculations
Running totals, percent of total, rank, moving averages and difference calculations.
Parameters and sets
Dynamic user inputs, set actions, parameter actions and interactive analysis.
Level of Detail expressions
FIXED, INCLUDE and EXCLUDE expressions for controlling calculation granularity.
Dashboard design
Containers, layouts, actions, filters, tooltips and device-specific presentation.
Stories and presentation
Story points, annotations, dashboards and communicating a sequence of insights.
Publishing and sharing
Tableau Public, Tableau Cloud, permissions, extracts and refresh considerations.
Example: Regional sales analysis Create a map showing revenue by state, a trend chart showing monthly sales, and a category comparison chart. Add a region filter and dashboard actions so selecting a state updates the other visualizations.
Example: Dynamic target comparison Create a parameter that allows the user to select a sales target. Use a calculated field to compare actual sales against the selected target and highlight regions that are below target.
Tools
Tableau DesktopTableau PublicTableau Cloud
Milestone: Create an interactive Tableau dashboard using calculated fields, filters, parameters and at least one advanced calculation.
10
Business Analytics, KPI Analysis and Data StorytellingEstimated time: 2–3 weeks · Advanced
⌄
Technical skills help you analyze data, but business understanding helps you analyze the right data. Learn to translate stakeholder requirements into meaningful metrics, explain the results and recommend action.
Requirement gathering
Stakeholder questions, business objectives, reporting requirements and analytical scope.
KPI design
Metric definitions, formulas, targets, dimensions, owners and reporting frequency.
Sales analytics
Revenue, average order value, sales growth, product performance and target achievement.
Retention, churn, repeat purchases, customer lifetime value and segmentation.
Financial analytics
Revenue, cost, gross margin, operating expenses, budget variance and profitability.
Operations analytics
Inventory turnover, delivery time, service levels, capacity and operational efficiency.
Storytelling with data
Executive summaries, insight statements, evidence, implications and recommendations.
Example: Marketing campaign analysis A campaign generated 100,000 impressions, 5,000 clicks and 250 conversions. CTR = 5%, and click-to-conversion rate = 5%. The analyst should also consider spend, customer quality and revenue before deciding whether the campaign was successful.
Example: Executive presentation Instead of saying "Sales declined by 12%", explain which regions and product categories contributed most to the decline, whether the change is seasonal, what evidence supports the explanation and which actions should be investigated.
Milestone: Present an analytical report to a hypothetical business stakeholder with clearly defined KPIs, findings and actionable recommendations.
11
Advanced Analytics, Forecasting and AutomationEstimated time: 3–4 weeks · Advanced
⌄
After mastering the core analyst toolkit, explore advanced analytical techniques that help answer more complex questions and reduce repetitive work.
Time-series analysis
Trends, seasonality, moving averages, rolling statistics and time-based comparisons.
Forecasting fundamentals
Baseline forecasts, trend extrapolation, moving averages and introductory forecasting models.
Regression analysis
Linear regression, coefficient interpretation, residuals and model limitations.
Customer segmentation
RFM analysis, rule-based segments and introductory clustering concepts.
Cohort analysis
Group customers by acquisition period and analyze retention or repeat behavior over time.
A/B testing
Experiment design, sample comparison, statistical interpretation and practical significance.
Automation
Automate reports, recurring data cleaning, scheduled scripts and repeatable workflows.
APIs and data extraction
HTTP requests, JSON responses, API authentication and importing data into analytical workflows.
Example: Sales forecasting Use historical monthly sales to identify trend and seasonal patterns. Build a baseline forecast and compare predicted values with actual sales as new data becomes available.
Example: Customer retention Group customers by their first purchase month and calculate what percentage made another purchase in subsequent months. This helps the business understand how retention changes across acquisition cohorts.
Milestone: Complete one forecasting or cohort-analysis project and automate at least one recurring analytical task.
12
Portfolio Development, Interview Preparation and Professional ReadinessEstimated time: 3–4 weeks · Advanced
⌄
Build a portfolio that demonstrates your ability to solve business problems. Employers need evidence that you can work with raw data, select appropriate tools, explain your analysis and communicate useful conclusions.
Portfolio projects
Complete projects using Excel, SQL, Python, Power BI and Tableau.
Project documentation
Problem statement, dataset source, cleaning steps, methodology, findings and recommendations.
Git and GitHub
Version control, repositories, README files, notebooks and project organization.
Resume preparation
Present analytical skills, projects, tools, measurable outcomes and relevant experience.
SQL interview preparation
Joins, aggregations, CTEs, subqueries, window functions and business query problems.
Excel and BI interviews
Formulas, PivotTables, data modeling, DAX, Tableau calculations and dashboard scenarios.
Case studies
Understand ambiguous business questions, define metrics and explain analytical decisions.
Professional practices
Data privacy, responsible reporting, documentation, reproducibility and stakeholder communication.
Example interview case: "An online retailer has seen a 15% decline in repeat purchases. How would you investigate?" A strong response should clarify the metric, define the comparison period, inspect customer cohorts, segment by channel and region, investigate product and operational factors, validate the data and present evidence-backed findings.
Milestone: Publish at least three well-documented projects, prepare a concise resume and complete mock interviews covering SQL, Excel, Python and BI tools.
6. Understand the five core Data Analyst tools
Excel, SQL, Python, Power BI and Tableau are complementary. Each tool has a different role in the analytics workflow.
Tool
Primary purpose
Typical tasks
Example output
Excel
Spreadsheet analysis and reporting.
Formulas, lookups, PivotTables, data cleaning and quick summaries.
Monthly sales report.
SQL
Extract and analyze database records.
Filtering, joins, aggregation, ranking and database analysis.
Customer purchase summary.
Python
Flexible analysis and automation.
Data cleaning, EDA, statistical analysis and repeatable scripts.
Customer segmentation analysis.
Power BI
Business intelligence and reporting.
Data modeling, DAX, interactive dashboards and report sharing.
Executive performance dashboard.
Tableau
Visual analytics and data storytelling.
Interactive charts, calculated fields, dashboards and stories.
Regional performance analysis.
Learning recommendation: Become proficient in Excel and SQL first. Add Power BI as your primary BI platform, learn Python for deeper analysis and automation, and then learn Tableau. The order can change depending on your target role and workplace tools.
7. Excel vs SQL vs Python: When should you use each?
Use Excel when...
You need quick calculations and summaries.
You are reviewing a relatively small or manageable dataset.
You need to prepare a business report.
Stakeholders need a familiar spreadsheet.
Use SQL when...
Data is stored in relational databases.
You need to combine multiple database tables.
You need to filter and aggregate large datasets efficiently.
You need repeatable database queries.
Use Python when...
You need repeatable data-cleaning workflows.
You need more flexible statistical analysis.
You need to automate recurring work.
You need custom analysis beyond spreadsheet workflows.
Use Power BI or Tableau when...
Business users need interactive reports.
Metrics need to be monitored regularly.
Multiple data sources need to be modeled.
Insights need to be communicated visually.
8. Data Analyst project roadmap
Build projects that demonstrate a progression from spreadsheet analysis to complete business intelligence solutions. Aim to document the business problem, cleaning process, analysis, findings and recommendations for every project.
Beginner · Excel
1. Employee Data Analysis
Analyze employee headcount, salary distribution, department size and attrition indicators.
Skills: Excel formulas, lookups, PivotTables and charts.
Beginner · Excel
2. Personal Finance Tracker
Analyze monthly income, spending categories, savings and budget variance.
Skills: SUMIFS, IF, charts and dashboard design.
Beginner · Excel
3. Retail Sales Dashboard
Compare monthly revenue, product sales, regional performance and targets.
Skills: PivotTables, slicers and conditional formatting.
Intermediate · SQL
4. E-commerce Database Analysis
Analyze orders, customers, products, revenue and repeat purchases using multiple tables.
Skills: SQL joins, aggregation, CTEs and window functions.
Intermediate · SQL
5. Customer Segmentation
Identify high-value, frequent and inactive customers based on purchase behavior.
Skills: SQL, CTEs, ranking and RFM concepts.
Intermediate · Python
6. Netflix or Streaming Content Analysis
Analyze content type, release trends, genres, countries and ratings.
Skills: Pandas, EDA and visualization.
Intermediate · Python
7. Student Performance Analysis
Explore attendance, assessment scores and performance patterns across student groups.
Skills: Data cleaning, statistics and Seaborn.
Intermediate · Power BI
8. Sales Performance Dashboard
Build a management dashboard for revenue, profit, product performance and regional trends.
Skills: Power Query, data modeling and DAX.
Intermediate · Power BI
9. HR Analytics Dashboard
Analyze employee count, attrition, tenure, department and hiring patterns.
Skills: DAX, KPI design and interactive reporting.
Intermediate · Tableau
10. Global Superstore Analysis
Explore sales, profit, discounts, shipping and regional performance.
Skills: Tableau charts, filters, parameters and dashboards.
Advanced · Python
11. Marketing Campaign Analysis
Analyze campaign performance, conversion rates, customer response and return on ad spend.
Skills: Pandas, statistics and A/B testing concepts.
Advanced · Python
12. Retail Sales Forecasting
Explore historical trends and build a baseline forecast for future sales.
Skills: Time-series analysis and forecasting.
Advanced · BI
13. Financial Performance Dashboard
Analyze revenue, cost, profit margin, budget variance and financial trends.
Skills: SQL, Power BI or Tableau.
Advanced · End-to-end
14. Supply Chain Analytics
Analyze inventory, delivery performance, supplier performance and stockout patterns.
Skills: SQL, Python and BI dashboards.
Capstone
15. End-to-End Business Analytics Project
Collect data, clean it, query it, analyze business performance and publish a stakeholder-ready dashboard.
Skills: Excel, SQL, Python, Power BI or Tableau.
9. One business problem, five tools
A strong Data Analyst does not treat each tool as an isolated subject. The real value comes from combining them to solve one business problem.
Business problem: Why are monthly sales declining?
1
ExcelInspect the initial sales file and check data quality.
2
SQLExtract orders, products and customer information.
3
PythonClean, explore and analyze sales patterns.
4
Power BIBuild a KPI dashboard for management.
5
TableauCreate an alternative visual exploration and story.
Possible findings: Revenue has declined mainly in one region. The number of orders is stable, but average order value has fallen. A specific product category contributes most to the decline. Further investigation may reveal discounting, product mix or customer purchasing changes.
Final deliverable: A documented analysis, a dashboard, a short executive summary and evidence-backed recommendations. The objective is not to use all five tools for the sake of it, but to use the right tool at the right stage.
10. Data Analyst technology stack
The following tools cover the most useful capabilities for a modern Data Analyst. You do not need to master every tool in each category.
Category
Tools
Purpose
Spreadsheets
Microsoft Excel, Google Sheets
Spreadsheet analysis, reporting and quick calculations.
Databases
PostgreSQL, MySQL, SQL Server, SQLite
Store, retrieve and query structured data.
Programming
Python, Jupyter Notebook, VS Code
Automate and perform analytical workflows.
Data manipulation
Pandas, NumPy
Clean, transform and analyze data.
Visualization
Matplotlib, Seaborn, Plotly
Create statistical and interactive visualizations.
Business intelligence
Power BI, Tableau
Build reports and interactive dashboards.
Version control
Git, GitHub
Track changes and publish project work.
Data preparation
Power Query, OpenRefine
Clean, transform and combine data.
Collaboration
Power BI Service, Tableau Cloud
Publish, share and manage analytical reports.
11. Learn to build dashboards that answer business questions
A professional dashboard should help a user understand performance quickly. It should prioritize relevant KPIs, trends, comparisons and exceptions rather than simply displaying as many charts as possible.
Executive dashboard
Revenue, profit, growth, target achievement and business trends.
Management
Sales dashboard
Orders, revenue by product, regional performance and sales targets.
Sales team
Marketing dashboard
Campaign spend, CTR, conversion, customer acquisition and ROAS.
Marketing
HR dashboard
Headcount, hiring, attrition, department distribution and tenure.
Human resources
Finance dashboard
Revenue, expenses, margins, budget variance and cash flow indicators.
Finance
Operations dashboard
Inventory, delivery time, fulfillment, productivity and service levels.
Operations
Dashboard design checklist: Use clear titles, consistent metric definitions, appropriate chart types, readable labels, sensible filters and a visible reporting period. Include the source and refresh date when relevant.
12. Career opportunities in Data Analytics
The exact responsibilities vary across organizations. Some roles emphasize reporting, while others focus on SQL, business analysis, visualization or advanced analytics.
Data Analyst
Collects, cleans and analyzes data to answer business questions and communicate findings.
Business Analyst
Works with stakeholders to understand business requirements, processes and opportunities for improvement.
Business Intelligence Analyst
Develops reports, dashboards, data models and business performance metrics.
MIS Analyst
Prepares recurring reports, operational summaries and management information systems.
Reporting Analyst
Maintains reporting workflows, prepares performance reports and validates business metrics.
Power BI Developer
Builds Power BI data models, DAX measures, reports and dashboards.
Tableau Developer
Creates Tableau visualizations, calculated fields, dashboards and analytical stories.
Product Analyst
Analyzes user behavior, product usage, engagement, conversion and retention.
Marketing Analyst
Measures campaign performance, customer acquisition, conversion and marketing effectiveness.
13. What should you prepare for Data Analyst interviews?
Interview preparation should combine technical exercises, business case studies and communication skills.
Excel questions
Explain relative and absolute references.
When would you use XLOOKUP instead of VLOOKUP?
How do PivotTables work?
How would you clean duplicate records?
SQL questions
Explain WHERE vs HAVING.
Compare INNER JOIN and LEFT JOIN.
Find the second-highest salary.
Use window functions to rank products.
Python questions
Explain Series and DataFrame.
How do you handle missing values?
Compare merge and concat.
How do you group and aggregate data?
Power BI and Tableau
Explain relationships and star schema.
What is the difference between a measure and calculated column?
Explain filter context in DAX.
How do parameters and dashboard actions work?
Statistics questions
Mean vs median: when should each be used?
What is standard deviation?
Does correlation imply causation?
What does a p-value represent?
Business case studies
Why might revenue decline while orders increase?
How would you measure customer retention?
How would you evaluate a marketing campaign?
How would you investigate an unusual KPI change?
14. How long does it take to become a Data Analyst?
The timeline depends on your starting point, study hours, practice quality and project experience. This is an illustrative learning plan for someone starting with basic computer skills.
Phase
Duration
Focus
Expected output
Phase 1
Weeks 1–2
Analytics fundamentals and business KPIs.
Business problem and metric definitions.
Phase 2
Weeks 3–6
Excel and spreadsheet analysis.
Excel reporting dashboard.
Phase 3
Weeks 7–9
Statistics and probability.
Statistical analysis exercise.
Phase 4
Weeks 10–14
SQL and relational databases.
SQL business analysis project.
Phase 5
Weeks 15–18
Python fundamentals and Pandas.
Python data analysis notebook.
Phase 6
Weeks 19–21
EDA and visualization.
Exploratory analysis report.
Phase 7
Weeks 22–26
Power BI and DAX.
Interactive Power BI dashboard.
Phase 8
Weeks 27–29
Tableau.
Interactive Tableau dashboard.
Phase 9
Weeks 30–32
Business case studies and portfolio.
Portfolio and interview preparation.
Calculate your learning timeline
Adjust your weekly study time to estimate how long a 240-hour learning and project plan might take.
Estimated duration: 24 weeks
This is an illustrative estimate. It does not guarantee mastery or employment readiness.
15. Your Data Analyst readiness checklist
Track your progress as you complete the roadmap. Mark a skill only when you can demonstrate it through an exercise or project.
0 of 20 skills completed
16. Test your Data Analytics knowledge
Answer these questions to check your understanding of the concepts covered in this roadmap.
Question 1 of 10
Which tool is primarily used to query relational databases?
17. Data Analytics glossary
A quick reference to commonly used terms across analytics and business intelligence.
DatasetA collection of related data records.
Data CleaningIdentifying and correcting data quality issues.
EDAExploratory Data Analysis.
KPIKey Performance Indicator.
MetricA measurable value used to track performance.
PivotTableA tool for summarizing and reorganizing tabular data.
SQLStructured Query Language.
JOINCombines rows from related tables.
CTECommon Table Expression.
Window FunctionCalculates across related rows while retaining row-level results.
DataFrameA two-dimensional tabular data structure in Pandas.
OutlierAn observation that differs substantially from other values.
CorrelationA measure of association between variables.
DAXData Analysis Expressions.
Power QueryA data connection and transformation technology.
Star SchemaA dimensional data model with fact and dimension tables.
DimensionA descriptive attribute used to categorize or filter data.
MeasureA calculation evaluated in a reporting context.
DashboardA visual display of important metrics and insights.
ETLExtract, Transform and Load.
Data StorytellingCommunicating insights through data, context and narrative.
Data GovernancePolicies and controls for managing data responsibly.
ChurnThe rate at which customers stop using a service.
Conversion RateThe percentage of users who complete a target action.
18. Where can you go after becoming a Data Analyst?
Data Analytics can be a foundation for several specialized career paths. Your next step depends on whether you prefer business intelligence, programming, statistics, business strategy or machine learning.
Business Analytics
Go deeper into business strategy, KPI design, financial analysis, operations and decision support.
Business Intelligence Engineering
Specialize in data modeling, reporting architecture, BI platforms and enterprise dashboards.
Data Science
Build on Python, statistics and analytical skills to learn machine learning and predictive modeling.
