Skip to content
AI360Xpert
Playgrounds
Visuals
Concepts
Learning Paths
Interview Questions
Papers
Explore
Hire Us
Learning Paths
Data Analyst
A comprehensive guide for Data Analyst
""
1
PREREQUISITES & FUNDAMENTALS
2
SPREADSHEET MASTERY
3
RELATIONAL DATABASES AND SQL
4
BUSINESS INTELLIGENCE (BI) AND DATA VISUALIZATION
5
PROGRAMMING FOR DATA ANALYSIS (PYTHON OR R)
6
DATA CLEANING AND PREPARATION
7
ADVANCED STATISTICS AND EXPLORATORY DATA ANALYSIS (EDA)
8
BUSINESS ACUMEN AND SOFT SKILLS
9
BUILDING A PORTFOLIO AND CAREER PREPARATION
Data Analyst
Basic Mathematics and Statistics
Descriptive Statistics
Mean
Median
Mode
Variance
Standard Deviation
Skewness
Kurtosis
Probability Basics
Distributions
Bayes Theorem
Expected Value
Inferential Statistics
Hypothesis Testing
p-values
A/B Testing
Confidence Intervals
Margin of Error
Computer Literacy & Tooling
File Systems and Data
Formats
CSV
JSON
XML
Parquet
Avro
Command Line Basics
Navigating directories
basic shell commands
Version Control Basics
Git
GitHub
Commits
Branches
Pull Requests
Merge Conflicts
Environment Management
Virtual environments
pip
conda
Generative AI for Data
Prompt Engineering
LLM Coding Assistants
like Copilot/ChatGPT
Data Ethics, Privacy, and Governance
Data Privacy Laws
GDPR
CCPA
HIPAA basics
Data Anonymization and
PII Handling
Bias in Data and
Ethical Analysis
Data Governance
Data Catalogs
Access Control
Data Lineage
Basic Operations and Formatting
Data Entry,
Validation, and Data
Types
Cell Formatting,
Conditional
Formatting, and Custom
Formats
Keyboard Shortcuts and
Productivity Hacks
Formulas and Functions
Mathematical and
Statistical Functions
SUM
AVERAGE
COUNT
COUNTIFS
SUMIFS
Logical Functions
IF
AND
OR
IFERROR
IFS
Lookup and Reference
Functions
VLOOKUP
HLOOKUP
INDEX
MATCH
XLOOKUP
Text and Data Cleaning
Functions
LEFT
RIGHT
MID
CONCATENATE
TEXTJOIN
TRIM
FIND
REPLACE
Date and Time
Functions
TODAY
NOW
DATEDIF
EOMONTH
WORKDAY
Modern Dynamic Arrays
FILTER
SORT
UNIQUE
SEQUENCE
Data Analysis Tools in Spreadsheets
Pivot Tables and Pivot
Charts
Data Sorting,
Filtering, and
Advanced Filters
What-If Analysis
Goal Seek
Data Tables
Scenario Manager
Power Query Basics
Importing
transforming
merging
and cleaning data
Automation Basics
Macros
VBA
or Google Apps Script
overview
Database Fundamentals and Modeling
Relational Database
Concepts
Tables
Rows
Columns
Schemas
Keys and Relationships
Primary Keys
Foreign Keys
One-to-Many
Many-to-Many
Normalization (1NF,
2NF, 3NF) and Data
Integrity Rules
Entity-Relationship
Diagrams (ERDs) and
Schema Design
Dimensional Modeling
Deep Dive
Fact vs. Dimension
Tables
Slowly Changing
Dimensions - SCD Types
1/2/3
Basic SQL Queries
Data Retrieval
SELECT
FROM
WHERE clauses
Sorting and Limiting
Results
ORDER BY
LIMIT
TOP
OFFSET
Filtering Data
LIKE
IN
BETWEEN
IS NULL
Boolean Operators
Intermediate SQL
Aggregate Functions
COUNT
SUM
AVG
MIN
MAX
Grouping Data
GROUP BY
HAVING
Aliasing (AS) and Type
Casting
CAST
CONVERT
String, Date, and Math
Manipulation Functions
Advanced SQL
Joins
INNER
LEFT
RIGHT
FULL OUTER
CROSS
SELF
Set Operations
UNION
UNION ALL
INTERSECT
EXCEPT
Subqueries and Common
Table Expressions
CTEs - WITH clause
Window Functions
ROW_NUMBER
RANK
DENSE_RANK
LEAD
LAG
NTILE
OVER
PARTITION BY
Advanced Data Types
Working with JSON and
Arrays in SQL
Dynamic SQL and Stored
Procedures
Basics
Performance, Data Warehousing, and Modern Data Stack
Query Optimization,
Execution Plans, and
SARGable Queries
Indexing Strategies
Clustered vs.
Non-Clustered
Data Warehousing
Concepts
OLTP vs. OLAP
Star and Snowflake
Schemas
Cloud Data Warehouses
Snowflake
BigQuery
Redshift overview
Modern Data Stack and
ELT
dbt
Fivetran
Airbyte basics
Data Visualization Principles
Choosing the Right
Chart Type for the
Data Story
Color Theory,
Typography, and
Accessibility in
Dashboards
Cognitive Load and
Gestalt Principles in
Design
Data Storytelling and
Audience Context
Analysis
BI Tool Fundamentals (Tableau, Power BI, or Looker)
Connecting to Various
Data Sources
Files
Databases
Cloud
Creating Basic
Visualizations
Bar charts
Line charts
Scatter plots
Maps
Heatmaps
Understanding
Dimensions vs.
Measures, Discrete vs.
Continuous Data
Formatting and
Tooltips for
Interactivity
Advanced BI Techniques
Calculated Fields,
Parameters, and Level
of Detail (LOD)
Expressions
Tableau
Data Analysis
Expressions (DAX) and
Data Modeling
Power BI
Building Interactive
Dashboards, Actions,
and Drill-downs
Data Blending,
Relationships, and
Cross-Database Joins
Dashboard Performance
Optimization and
Rendering Best
Practices
Publishing, Scheduling
Extracts, and
Row-Level Security
RLS
Programming Fundamentals
Variables, Data Types,
and Operators
Control Flow
If/Else statements
For/While loops
Functions, Scope,
Lambda Functions, and
Error Handling
Data Structures
Lists
Dictionaries
Tuples
Sets / Vectors
Data Frames
Data Manipulation (Pandas for Python / Tidyverse for R)
Understanding Series
and DataFrames
(Python) / Tibbles
R
Importing and
Exporting Data
read_csv
read_sql
to_excel
read_parquet
Indexing, Selecting,
Filtering, and Sorting
Data
Handling Missing Data
(Imputation, Drop) and
Duplicates
Grouping, Aggregating,
and Transforming Data
Merging, Joining, and
Concatenating Datasets
Reshaping Data
Melt
Pivot / Gather
Spread
Numerical Computing
NumPy Arrays,
Broadcasting, and
Vectorization
Python
Mathematical and
Statistical Operations
on Multi-dimensional
Arrays
Data Visualization in Programming
Matplotlib and Seaborn
Basics (Python) /
ggplot2
R
Customizing Plots
Axes
Legends
Themes
Annotations
Creating Interactive
Plots
Plotly
Bokeh
or Altair
Interactive Environments and Software Engineering Best Practices
Jupyter Notebooks and
JupyterLab
Markdown for
Documentation within
Notebooks
Code Modularity
Transitioning from
Notebooks to .py/.R
scripts
Basic Version Control
in Data Projects
GitHub flows for data
analysis
Data Quality Assessment
Profiling Data and
Identifying
Outliers/Anomalies
Handling Inconsistent
Data Formats and Typos
Validating Data
against Business Rules
Data Transformation Techniques
Data Normalization,
Standardization, and
Scaling
Encoding Categorical
Variables
One-Hot Encoding
Label Encoding
Feature Engineering
Creating new metrics
binning
date extraction
Text Cleaning and
Regular Expressions
Regex
Data Acquisition and APIs
Interacting with REST
APIs
Pagination
Authentication
JSON parsing
Basics of HTML, CSS
Selectors, and HTTP
requests
Web Scraping libraries
BeautifulSoup
Scrapy
Selenium
Data Validation and Automated Testing
Automated Data Testing
Concepts
e.g.
dbt tests
Great Expectations
Schema Validation and
Type Checking
e.g.
Pydantic basics
Comprehensive EDA Process
Univariate Analysis
Examining
distributions
histograms
box plots
Bivariate and
Multivariate Analysis
Scatter plots
correlation matrices
cross-tabulation
Identifying
Correlation vs.
Causation
Spurious correlations
confounders
Applied Statistical Methods
Linear Regression
Simple and Multiple
Regression
R-squared
Residuals
Logistic Regression
Basics of
classification
odds ratios
ROC/AUC
A/B Testing Deep Dive
Sample size
statistical
significance
Type I & II errors
Power analysis
Time Series Analysis
Basics
Trends
Seasonality
Moving Averages
Forecasting
Clustering Basics
K-Means
Customer Segmentation
Cohort Analysis and
Customer Lifetime
Value
CLV
Survival Analysis
Basics
Retention curves
Causal Inference
Basics
Difference-in-Differen
ces
Propensity Score
Matching - Overview
Domain Knowledge and Product Analytics
Understanding Key
Performance Indicators
(KPIs) and Metrics by
Industry
E-commerce
SaaS
Finance
Healthcare
Marketing
Product Analytics
AARRR Metrics
Funnel Analysis
User Engagement
Translating Ambiguous
Business Problems into
Structured Data
Questions
ROI, Impact Analysis,
and Cost-Benefit
Analysis
Communication and Presentation
Presenting Data
Findings to
Non-Technical
Stakeholders
Effectively
Writing Clear,
Concise, and
Actionable Data
Reports/Memos
Executive Summaries
The Art of Persuasion
and Driving Decisions
with Data
Problem Solving, Workflow, and Critical Thinking
Structured Thinking
Frameworks
e.g.
MECE
Issue Trees
Root Cause Analysis
5 Whys
Fishbone Diagrams
Agile/Scrum for Data
Teams
Sprints
Kanban
Jira/Trello basics
Stakeholder Management
and Expectation
Setting
Personal Projects
Finding and Evaluating
Open Datasets
Kaggle
Data.gov
Google Dataset Search
AWS Open Data
End-to-End Analysis
Projects
From raw data
extraction to
actionable business
insights
Documenting Projects
on GitHub
Clear READMEs
well-commented Jupyter
Notebooks
Creating a Public
Dashboard
Tableau Public
Power BI Service
Professional Presence
Optimizing LinkedIn
Profile and Resume for
Applicant Tracking
Systems (ATS) and Data
Roles
Building a Personal
Website or Portfolio
Site
e.g.
GitHub Pages
Notion
Medium
Networking and Tech
Blogging
Sharing insights on
LinkedIn or Medium
Interview Preparation
Technical Screenings
Live SQL querying
Python/Pandas
manipulation
Excel tests
LeetCode for Database
Case Study Interviews
Take-home assignments
presentation rounds
guesstimates
Behavioral Interviews
STAR method for
communicating past
experiences and
cross-functional
collaboration