Follow Sajib Khan on LinkedIn For More
Data Analytics Roadmap 2026
Kickstart your 6-month roadmap to Data Analytics: a journey combining deep technical knowledge, hands-on projects, and shared resources.
1,557
2,404
Scroll down for more
Month 1
Excel & Google Sheet
- ●Get familiar with the UX of Excel & Google Sheets and understand data types
- ●Master basic Excel functions: COUNT, COUNTA, IF, IFS, SUM, SUMIF, SUMIFS, COUNTIFS
- ●Work with dynamic functions: UNIQUE, SORT, FILTER
- ●Text & date functions: LEN, LEFT, RIGHT, TRIM, SUBSTITUTE, CONCATENATE, TEXTJOIN, DAYS
- ●Understand and apply conditional functions
- ●Analyze data using Pivot Tables and Pivot Charts
- ●Advanced lookup functions: XLOOKUP, VLOOKUP, HLOOKUP, INDEX, MATCH
- ●Use Power Pivot to handle large datasets
- ●Build an end-to-end interactive dashboard
- ●Automate tasks using Excel Macros and Google Apps Script
Resources
Projects
- A complete dynamic Excel dashboard in any business domain
- An end-to-end money management tool in Google Sheets using Apps Script
- A cohort analysis project using Excel or Google Sheets
Month 2-3
Power BI
- ●Introduction to Power BI ecosystem (Desktop, Service, Mobile)
- ●Connecting to multiple data sources (Excel, CSV, SQL, Web)
- ●Data cleaning and transformation using Power Query
- ●Data modeling: relationships, star schema, cardinality
- ●DAX fundamentals: calculated columns vs measures
- ●Most-used DAX functions: SUM, AVERAGE, MIN, MAX, COUNT, DISTINCTCOUNT
- ●Context & logic functions: CALCULATE, FILTER, ALL, ALLEXCEPT, VALUES, IF, SWITCH
- ●Time intelligence functions: DATEADD, DATEDIFF, TOTALYTD, TOTALMTD, TOTALQTD, SAMEPERIODLASTYEAR
- ●Ranking & aggregation: RANKX, TOPN
- ●Building interactive reports with slicers, drill-down & drill-through
- ●Visual best practices and dashboard design principles
- ●Publishing reports and sharing via Power BI Service
Resources
Projects
- Sales performance dashboard with KPIs and time intelligence
- A Cohort Analysis project with RFM Segmentation
- Executive-level dashboard with drill-through analysis
Month 3-4
SQL & Metabase
- ●Explore database fundamentals: RDBMS, ACID properties, normalization, SQL vs NoSQL
- ●Learn core SQL commands: SELECT, WHERE, GROUP BY, HAVING, ORDER BY
- ●Practice data filtering, aggregation, NULL handling, type casting, and date & string functions
- ●Understand schema design: fact & dimension tables, relationships, and indexing
- ●Work with advanced JOINs and set operations: LEFT, RIGHT, FULL, SELF JOIN, UNION, UNION ALL
- ●Compare CTEs and subqueries with real-world use cases
- ●Analyze data using window functions: ROW_NUMBER, RANK, DENSE_RANK, NTILE, LEAD, LAG & explore running totals, moving Average & cumulative sum procedure using window function
- ●Apply data pivoting techniques and analytical SQL patterns
- ●Learn triggers and audit log management for automation
- ●Explore Google BigQuery and modern data warehousing concepts
- ●Build advanced analytics projects using BigQuery (RFM segmentation)
- ●Get started with Metabase: GUI queries, native SQL, filters, and variables
- ●Create dynamic dashboards with drill-through and embedding
- ●Automate reporting using Metabase Pulse and subscriptions
- ●Build simple CRUD applications using low-code tools (Appsmith / Retool) with SQL
Resources
Projects
- Build a Dynamic Dashboard in Metabase using SQL
- Complete a RFM Segmentation or Cohort Analysis Project
- Build End To End Web Application using SQL CRUD operation in Appsmith or Retool
Month 6
Python for Data Analytics
- ●Get started with Python fundamentals for data analysis
- ●Work with data types, variables, conditions, loops, and functions
- ●Analyze data using NumPy for numerical computing
- ●Manipulate and transform data with Pandas
- ●Clean data: handling missing values, duplicates, and outliers
- ●Perform exploratory data analysis (EDA)
- ●Visualize data using Matplotlib and Seaborn
- ●Work with dates, times, and text data in Pandas
- ●Read and write data from CSV, Excel, JSON, and databases
- ●Apply basic statistics for data analysis
- ●Optimize analysis workflows using Jupyter & Google Colab
- ●Build end-to-end data analysis projects using real datasets
Resources
Projects
- Exploratory Data Analysis (EDA) on a real-world dataset
- Sales and performance analysis using Python
- End-to-end Python data analytics project for portfolio
Month 7 (Bonus)
Advanced Analytics with Python & Intro To Data Science
- ●Introduction to Machine Learning for data analysts
- ●Supervised vs unsupervised learning concepts
- ●Statistical testing in Python: hypothesis testing, A/B testing, ANOVA
- ●Regression analysis using Python
- ●Classification algorithms and model evaluation
- ●Clustering algorithms for data segmentation
- ●Time series analysis and real-world business use cases
- ●Time series components: trend, seasonality, and noise
- ●Date-time handling and time indexing in Python
- ●Rolling statistics and moving averages
- ●Stationarity concepts and transformations
- ●Autocorrelation and partial autocorrelation (ACF & PACF)
- ●Forecasting models using ARIMA and SARIMA
- ●Business forecasting using Prophet
- ●Model evaluation and performance metrics
- ●Handling real-world challenges: missing data, outliers, and seasonality
Resources
Projects
- A/B testing and statistical analysis project in Python
- Regression and classification project using real data
- Customer segmentation using clustering algorithms
- Time series forecasting project for business metrics
It's time to dive for job!
You've built the skills, now let's get you hired. Use these resources to prepare your brand and master the interview process.
1
Build a strong resume
ATS-Friendly Templates
Keyword Optimization
Quantifiable Achievements
2
Design an eye-catching portfolio
Live Project Links
Technical Case Studies
Mobile-Ready UI
Resources
3
Practice SQL For Job Interview
Window Functions
Complex Joins & CTEs
Data Analysis Patterns
4
Prepare for interview
STAR Method Answers
Data Metrics & KPIs
Technical Concept Recaps
Handbooks
Resources
5
Start applying
LinkedIn Networking
Custom Cover Letters
Daily Job Tracking
Resources
Recommended Courses
Accelerate your learning with these comprehensive courses
Online
Live
7000 TK10000 TK
6+ Batches Completed
Data Analytics and Power BI Career Path
Tools & Technologies
ExcelGoogle SheetPower PivotMySQLPythonPower BISnowflakeBig DataR
★★★★★
4.7(112)1500+ Completed
13+ Projects
Online
Live
3500 TK5000 TK
3+ Batches Completed
Zero to Advanced SQL with BigQuery & Metabase: For All Data Professionals
Tools & Technologies
SQLPostgreSQLBigQueryMetabaseSupabaseDockerAppsmtih/RetoolCloudBig DataTrigger
★★★★★
4.6(22)320+ Completed
5+ Projects
Got Questions?
I'm always happy to hear from you. If you have any questions, suggestions or opinions, please do not hesitate to reach out to me.