Data Analytical Roadmap

Data Analytics
Roadmap July Cohort 2023
Building Profile & Portfolio Projects
This roadmap contains 14 Chapters that can be completed in 8 weeks, whether you
are a fresher in the field or an experienced professional who wants to transition into
Data Analytics.
Himanshu Ramchandani
Data & Engineering Consultant

This is how we are going to prepare for the Data Analyst profile:
https://god-level-python.notion.site/Data-Analytics-Roadmap-Buildi
ng-Profile-Portfolio-July-Cohort-ec381aac7a9944e2a529e281c0d2aaf
8?pvs=4
🔹 1 | Python Programming
🔹 2 | Understanding NumPy
🔹 3 | Exploratory Data Analysis (EDA) with Pandas
🔹 4 | Data Visualization with Matplotlib and Seaborn
🔹 5 | Working with Different Types of Datasets - Projects
🔹 6 | Statistics and Statistical Models
🔹 7 | Machine Learning - Basics & Predictive Analytics
🔹 8 | Time Series Analysis & Forecasting
🔹 9 | SQL - Structured Query Language
🔹 10 | Excel for Analyst
🔹 11 | Data Storytelling with Tableau
🔹 12 | Business Case Studies & Analysis
🔹 13 | Data Analyst Interview
🔹 14 | Resume Resources
We will need 8 Weeks to complete each topic and be ready for the job interview.
Week 1 - Python Programming & Logic

Building
1 | Python Programming
1 | While Loops, Lists, Strings
2 | For Loop, Dictionary, Tuples, Set
3 | Functions
4 | Modules, Packages, and PIP
5 | Virtual Environment, Flask, and Python Web Scrapping
Week 2 - Data Analysis with Python &

Pandas
2 | Understanding NumPy
NumPy basics
Working with Matrix
Linear Algebra operations
Descriptive Statistics
Normal Distribution Operations
Mean, Variance, and Standard Deviation

Reshaping arrays
3 | Exploratory Data Analysis (EDA) with Pandas
Pandas
Data Analysis basics
Dataframe operations
Working with 2-dimensional data
Data Cleaning
Data Grouping
Working with Datasets
4 | Data Visualization with Matplotlib and Seaborn
Matplotlib
Plot Basics
Format Strings
Label and Legends
Bar Chart
Pie Chart
Week 3 - Statistical Analysis
6 | Working with Different Types of Datasets - Projects
5 | Statistics and Statistical Models
Descriptive Statistics
● Measure of Frequency and Central Tendency

● Measure of Dispersion
● Probability Distribution
● Gaussian Normal Distribution
● Skewness and Kurtosis
● Regression Analysis
● Continuous and Discrete Functions
● Goodness of Fit
● ANOVA
Inferential Statistics
● t-Test
● z-Test
● Hypothesis Testing
● Type I and Type II errors
● t-Test and its types
● One way ANOVA
● Two way ANOVA
● Chi-Square Test
● Implementation of continuous and categorical data
Week 4 - Predictive Analytics and
Machine Learning
7 | Machine Learning - Basics & Predictive Analytics
Machine Learning
Linear Regression
Logistic Regression
Projects for Building ML Model
8 | Time Series Analysis & Forecasting

Time series data visualization
Time series decomposition
Stationarity
Autocorrelation
ARIMA models
Exponential smoothing models
Prophet
LSTM models
Evaluation metrics
Week 5 - Database Management with
SQL and Excel
9 | SQL - Structured Query Language
Roadmap
1 | Fundamentals to SQL and Installation
2 | Creating Tables - modifiers, altering table
3 | Retrieving Data - SELECT
4 | Aggregating Data using Functions
5 | Subqueries - retrieving data with conditions
6 | JOINS
Project
10 | Excel for Analyst

Week 6 - Data Storytelling, Visualization
and Business Case Studies
11 | Data Storytelling with Tableau
12 | Business Case Studies & Analysis
Week 7 - Interview Preparation,

Resume Building and Portfolio
13 | Data Analyst Interview
14 | Resume Resources
Are you interested in Joining my Live Batch?
Join Cohort
Use ANALYTICS25 to get 25% OFF.
If you are from India Join Here:
Join Cohort
Use ANALYTICS25 to get 25% OFF.
● Mentorship calls
● Analytical skills: Python, SQL, Excel, Tableau, NumPy, Pandas, ML, Time Series
forecasting
● Building Projects and Portfolio
● 45 Hours of Live sessions
● Lifetime access to recordings
● Resume Building
● LinkedIn Personal Branding for 10x Growth
● 100+ Interview Questions and Preparation
● Closed community of professionals with the same mindset
● Study Group on Discord

Join Telegram:
https://t.me/+sREuRiFssMo4YWJl
Are you interested in these topics:
Python🐍 Machine Learning🤖 Data Science🥼

Data Engineering🧑‍💻 Computer Vision🖥️
NLP🤍 Business Problems🚀
Follow Himanshu Ramchandani and get amazing content in the data

field.

Data Analytical Roadmap

Uploaded by

Copyright:

Available Formats

Data Analytical Roadmap

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Data Analytical Roadmap

Uploaded by

Copyright:

Available Formats

Data Analytics

Roadmap July Cohort 2023

Building Profile & Portfolio Projects

Data & Engineering Consultant

Week 1 - Python Programming & Logic

1 | While Loops, Lists, Strings

2 | For Loop, Dictionary, Tuples, Set

4 | Modules, Packages, and PIP

5 | Virtual Environment, Flask, and Python Web Scrapping

Week 2 - Data Analysis with Python &

Working with Matrix

Linear Algebra operations

Normal Distribution Operations

Mean, Variance, and Standard Deviation

3 | Exploratory Data Analysis (EDA) with Pandas

Data Analysis basics

Working with 2-dimensional data

Working with Datasets

4 | Data Visualization with Matplotlib and Seaborn

Label and Legends

5 | Statistics and Statistical Models

● Measure of Frequency and Central Tendency

7 | Machine Learning - Basics & Predictive Analytics

Projects for Building ML Model

8 | Time Series Analysis & Forecasting

Time series decomposition

Exponential smoothing models

9 | SQL - Structured Query Language

1 | Fundamentals to SQL and Installation

2 | Creating Tables - modifiers, altering table

3 | Retrieving Data - SELECT

4 | Aggregating Data using Functions

5 | Subqueries - retrieving data with conditions

10 | Excel for Analyst

11 | Data Storytelling with Tableau

12 | Business Case Studies & Analysis

Week 7 - Interview Preparation,

13 | Data Analyst Interview

If you are from India Join Here:

● Building Projects and Portfolio

● 45 Hours of Live sessions

● Lifetime access to recordings

● LinkedIn Personal Branding for 10x Growth

● 100+ Interview Questions and Preparation

● Closed community of professionals with the same mindset

● Study Group on Discord

Are you interested in these topics:

Python🐍 Machine Learning🤖 Data Science🥼

NLP🤍 Business Problems🚀

Follow Himanshu Ramchandani and get amazing content in the data

You might also like