Data Analyst Roadmap - Data Science Academy

1. Introduction to Data Analysis

Role of analyst in business, key skills, career path

Tools

Microsoft Excel
Google Sheets

Learning Path

Business Intelligence basics
Data roles comparison
Career opportunities

2. Excel & Google Sheets Mastery

Advanced formulas, Pivot Tables, Power Query, VBA

=VLOOKUP(A2, B:C, 2, FALSE)

=SUMIFS(Sales, Region, "North")

Power Query → Transform Data

3. SQL for Analysts

Essential queries for business reporting

SELECT region, SUM(sales) as total_sales

FROM orders

GROUP BY region

ORDER BY total_sales DESC;

4. Data Visualization Principles

Effective charts for business audiences

Bar/Line/Area Charts
Choosing right visualization
Dashboard design
Color theory

5. Power BI Complete

DAX, Data Modeling, Interactive Dashboards

Key Features

DAX Functions
Data Modeling
Visuals & Slicers

Example DAX

Total Sales = SUM(Sales[Amount])

YoY Growth = 

DIVIDE([Total Sales] - CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date])), CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date])))

6. Tableau & Looker Studio

Advanced visualizations and dashboards

Calculated Fields
LOD Expressions
Tableau Prep
Looker Studio

7. Statistics for Business

Practical stats for analysis

Descriptive Statistics
Hypothesis Testing
Correlation vs Causation
A/B Testing

8. Business Insights & Storytelling

Turn data into actionable recommendations

Key Skills

Executive Summary
Stakeholder Communication
Action Recommendations

Story Structure

Business Question
Data Findings
Recommendations

9. Portfolio Projects

Sales Dashboard (Power BI)
HR Analytics (Tableau)
Marketing Campaign Analysis
Financial Reporting Dashboard
E-commerce Sales Analysis

10. Analyst Interview Prep

100+ common questions and case studies

SQL Assessment questions
Excel test scenarios
Dashboard walkthrough
Case study examples

Data Analyst Complete Roadmap

Analyst Roadmap