DATA ANALYTICS
WITH AI ROADMAP
A comprehensive 6-month learning journey from fundamentals to advanced predictive analytics. Master data analytics with AI integration, perfect for Marketing, Sales, and Risk Analytics careers.
Your Journey to Data Mastery
Designed for beginners transitioning into Data Analytics with strong AI integration, predictive modeling, and modern generative AI tools
Four Learning Pillars
Data Analytics Knowledge
Master statistics, business metrics, and analytical frameworks that form the foundation of data-driven decision making
Data Tools & Technologies
Excel, SQL, Python, Power BI, Tableau - become proficient in the essential toolkit of modern data analysts
AI & Machine Learning
Predictive analytics, ML algorithms, AutoML, and Generative AI integration for cutting-edge insights
Soft Skills & Business Acumen
Communication, storytelling, stakeholder management - translate data insights into business impact
Your Learning Roadmap
A structured path from fundamentals to advanced analytics, designed to build skills progressively with hands-on projects at every step
FUNDAMENTAL
Months 1-2 • Building Strong Foundations
Month 1: Business Statistics & Excel For Analysis
4 weeksWeek 1-2: Data Analytics foundations, business statistics, Excel fundamentals
Week 3-4: Advanced Excel (Pivot tables, VLOOKUP, INDEX-MATCH), data visualization basics, Power Pivot, Interactive dashboard
Month 2: SQL For Data Analysis
4 weeksWeek 5-6: SQL fundamentals (SELECT, JOINs, aggregations), database concepts, CTEs
Week 7-8: Advanced SQL: Window functions, Views, Database manipulation
INTERMEDIATE
Months 3-4 • Deepening Technical Skills
Month 3: Analytical Thinking & BI Tools (Power BI)
4 weeksWeek 9-10: Build automatic dashboard with Power/Tableu, Data modeling, DAX
Week 11-12: Apply Analytical Thinking into Data Analysis cases
Month 4: Python Analytics Foundation
4 weeksWeek 13-14: Advanced Pandas & NumPy, data cleaning, customer churn analysis project
Week 15-16: Data visualization (Matplotlib/Seaborn), EDA
ADVANCED
Months 5-6 • Mastering Predictive Analytics & AI
Month 5: Machine Learning Mastery With AI
4 weeksWeek 17-18: Basic ML algorithms for business analytics cases
Week 19-20: Advanced ML algorithms (classification, regression, clustering), model evaluation, customer LTV prediction
Month 6: Industry Apps & Portfolio
4 weeksWeek 21-22: Domain-specific applications (Marketing/Sales/Risk Analytics), end-to-end capstone project
Week 23-24: Advanced AI tools, LLM integration, portfolio building, resume optimization, final capstone
Generative AI Assistants
Leverage cutting-edge AI assistants to accelerate your data analytics workflow
From code generation to complex data analysis
ChatGPT
OpenAI
The most popular AI assistant for data analytics. Advanced Data Analysis mode enables CSV processing, statistical analysis, and instant visualizations with natural language commands.
Code generation (SQL, Python, R)
Data cleaning & preprocessing
Statistical analysis & visualization
Best For
Quick data exploration, writing SQL queries, debugging code
Claude
Anthropic
Advanced AI with exceptional reasoning capabilities and 200K context window. Artifacts feature creates interactive dashboards and comprehensive analytical reports in real-time.
Long-form data analysis (200K context)
Complex reasoning & insights
Interactive dashboards with Artifacts
Best For
Analyzing large datasets, generating comprehensive reports, complex reasoning
Gemini
Google's multimodal AI with deep integration into Google Workspace. Seamlessly works with Google Sheets, BigQuery, and Looker for end-to-end analytics workflows.
Google Workspace integration
BigQuery SQL assistance
Multimodal data analysis (text, images, code)
Best For
Google ecosystem users, BigQuery queries, collaborative analytics
GitHub Copilot
GitHub
AI pair programmer that lives in your IDE. Intelligent code suggestions and completions specifically trained on data analysis patterns and best practices.
Real-time code completion
Context-aware suggestions
IDE integration (VS Code, Jupyter)
Best For
Writing data analysis scripts, Python/R development, code efficiency
Business Statistics & Excel Mastery
Build a solid foundation in data analytics, master Excel techniques, and understand core statistical concepts
Data Analytics Foundations & Statistics
- What is Data Analytics? Types: Descriptive, Diagnostic, Predictive, Prescriptive
- Data types: Quantitative vs Qualitative, Structured vs Unstructured
- Basic statistics: Mean, median, mode, variance, standard deviation,
- Inferential statistics: Sampling, Hypothesis testing, Probability
Advanced Excel & Data Visualization Basics
- Pivot tables, VLOOKUP, XLOOKUP, INDEX-MATCH
- Conditional formatting and data validation
- Charts and dashboards in Excel, Power Pivot, Power Query
- Data visualization principles (choosing the right chart)
SQL For Data Analysis + First AI Tools
Master database querying with SQL, and leverage AI tools for accelerated learning
SQL Fundamentals
- Database concepts: Tables, rows, columns, keys
- SELECT, WHERE, GROUP BY, ORDER BY
- JOINs (INNER, LEFT, RIGHT, FULL)
- Aggregations: COUNT, SUM, AVG, MAX, MIN
- Subqueries and CTEs (Common Table Expressions)
- Practice: SQLZoo, LeetCode SQL problems
- Book: "Learning SQL" by Alan Beaulieu
- YouTube: Alex The Analyst (SQL Tutorial for Beginners)
- Course SQL For Data Analytics
- Course: SQL for Data Science (Coursera - UC Davis)
- Practice: Mode Analytics SQL Tutorial, SQLBolt
Advanced SQL For Database management & Query
- Performance Optimization & Query Tuning
- Database Design & Management (for Analysts)
- Data Transformation & ETL with SQL
- SQL for BI & Dashboarding
- First AI experience: Using ChatGPT/Claude for code assistance
Soft Skills Development
Essential professional skills for Month 1-2
Analytical Thinking & BI Tools (Power BI)
Master advanced Analytical Thinking techniques, data modeling, and create powerful interactive dashboards with Power BI
Advanced Analytical Thinking & Problem Solving Strategy
- Problem Framing & Business Context Mastery
- Hypothesis-Driven Thinking (Thinking Before Data)
- Structured Problem Decomposition (MECE & Beyond)
- Analytical Strategy Design
- Storytelling & Persuasive Problem Solving
Data Analysis & Build Automatic Dashboard With BI Tools
- Power BI: Data connections, Power Query, DAX basics
- Creating interactive dashboards and reports
- Tableau: Connecting to data, building visualizations
- Dashboard design best practices
- Publishing and sharing reports
Python for Data Analysis
Master Python data manipulation with Pandas, create stunning visualizations.
Advanced Python - Pandas & NumPy
- Pandas: DataFrames, Series, indexing, filtering
- Data cleaning: handling missing values, duplicates, outliers
- GroupBy operations and aggregations
- Merging and joining datasets
- NumPy arrays and vectorization
Data Visualization with Python
- Matplotlib and Seaborn for data visualization
- Exploratory Data Analysis (EDA) techniques
- Introduction to Machine Learning concepts
- Supervised vs Unsupervised learning
- Simple Linear Regression with scikit-learn
Soft Skills Development
Essential professional skills for Month 3-4
- YouTube: Avery Smith (Data Career Tips)
- Platform: LinkedIn for portfolio building
Predictive Analytics & Machine Learning Mastery
Master advanced machine learning algorithms, build predictive models, and leverage cutting-edge AutoML tools
Advanced Machine Learning Algorithms
- Classification: Logistic Regression, Decision Trees, Random Forest
- Regression: Multiple regression, Polynomial regression
- Clustering: K-Means, Hierarchical clustering
- Model evaluation: Accuracy, Precision, Recall, F1-Score, ROC-AUC
- Cross-validation and hyperparameter tuning
AutoML & Modern AI Tools
- Introduction to AutoML: H2O.ai, PyCaret, AutoGluon
- Feature engineering automation
- Model selection and ensemble methods
- Deploying ML models (basics)
- Generative AI for Analytics: Using ChatGPT/Claude for code generation, debugging, insights
- Course: AutoML with H2O.ai (H2O.ai tutorials)
- Documentation: PyCaret official docs
- YouTube: Data Professor (AutoML tutorials)
- AI Tools: ChatGPT Code Interpreter, Claude with coding
Industry Applications & Portfolio Projects
Apply your skills to real-world domains, build an impressive portfolio, and prepare for your data analytics career
Domain-Specific Applications
Marketing Analytics:
- Customer segmentation (RFM analysis, clustering)
- Marketing mix modeling (MMM)
- A/B testing and campaign optimization
- Attribution modeling
Sales Analytics:
- Sales forecasting (time series with Prophet, ARIMA)
- Lead scoring with ML
- Pipeline analysis and conversion optimization
- Sales territory optimization
Risk Analytics:
- Credit risk modeling
- Fraud detection with anomaly detection
- Churn prediction and prevention
- Risk scoring models
Advanced AI & Portfolio Building
- Generative AI deep dive: Prompting strategies for data analysis
- LLM integration: Using GPT-4, Claude API for insights
- AI-powered dashboards and reporting
- Natural Language Processing (NLP) basics for text analytics
- Building your data portfolio: GitHub, portfolio website
- Creating case studies from your projects
- Resume and LinkedIn optimization for data roles
- Course: ChatGPT Prompt Engineering (DeepLearning.AI)
- YouTube: AI Advantage (AI tools for analytics)
- Platform: GitHub for portfolio projects
- AI Tools: Claude Artifacts, ChatGPT Advanced Data Analysis
Soft Skills Development
Essential professional skills for Month 5-6
Build Your Project Portfolio
Hands-on project ideas across Marketing, Sales, and Risk Analytics to showcase your skills
Email Campaign Performance Dashboard
Build an interactive dashboard analyzing email campaign metrics: open rates, click-through rates, conversions, and ROI.
Customer Segmentation - RFM Analysis
Segment customers based on Recency, Frequency, and Monetary value using clustering algorithms for targeted marketing.
Marketing Attribution Model
Build a multi-touch attribution model to understand which marketing channels contribute most to conversions using ML.
Sales Performance Dashboard
Create a comprehensive sales dashboard tracking KPIs: revenue, conversion rates, top products, and sales team performance.
Sales Forecasting Model
Build time series forecasting models to predict future sales using historical data and seasonal patterns.
Customer Lifetime Value Prediction
Predict customer lifetime value using ML to identify high-value customers and optimize acquisition strategies.
Credit Risk Dashboard
Develop a dashboard to monitor credit risk metrics: default rates, credit scores distribution, and risk exposure.
Fraud Detection System
Build an anomaly detection system to identify fraudulent transactions using statistical methods and pattern recognition.
Credit Scoring Model with ML
Develop an ML-based credit scoring model to assess borrower creditworthiness and predict default probability.
Real-World Datasets
Download curated datasets to practice and build your data analytics portfolio projects
Sales Analytics Dataset
Comprehensive sales transaction data including products, customers, regions, and time periods for revenue analysis and forecasting.
HR Analytics Dataset
Employee data covering demographics, performance, satisfaction, and attrition for workforce analytics and retention modeling.
CRM Analytics Dataset
Customer relationship data with interaction history, purchase patterns, and engagement metrics for churn prediction and CLV analysis.
Marketing Analytics Dataset
Multi-channel campaign data with customer journeys, touchpoints, conversions, and attribution data for ROI optimization.
Core Resources
Carefully curated books and courses to build a rock-solid foundation in data analytics
Essential Books
Naked Statistics
Storytelling with Data
Python for Data Analysis
Hands-On Machine Learning
SQL Cookbook
Top Online Courses
Learn & Practice
Top YouTube channels for tutorials and platforms to sharpen your skills through hands-on practice
Top YouTube Channels
Maz The Analyst ⭐
Data Analytics in Vietnamese
StatQuest
Statistics & ML fundamentals
Alex The Analyst
SQL, Python, Career tips
Corey Schafer
Python programming
Keith Galli
Pandas, Data science
Krish Naik
ML & AI tutorials
Guy in a Cube
Power BI tips & tricks
Practice Platforms
The Future Analyst
Comprehensive Vietnamese courses designed to transform you into a proficient data analyst
Ready to Become a Data Analyst?
Join thousands of learners who are transforming their careers with AI-powered data analytics. Your journey to becoming a data professional starts now!