Skip to content

Latest commit

 

History

History
269 lines (173 loc) · 12.9 KB

README.md

File metadata and controls

269 lines (173 loc) · 12.9 KB
Raw

Data Analyst RoadMap

Here, I will post the road-maps of the skills needed to become a Data Analyst. These resources will be free of cost which I have used to learn myself. I assure, you don't need to go anywhere else to learn these tools (for free). I have got you covered everything you need to know.

Table of Contents

  1. Excel Complete Roadmap
  2. Power BI Complete Roadmap
  3. SQL Complete Roadmap
  4. Python Complete Roadmap
  5. Contact Details

Excel Complete Roadmap

Table of Contents

  1. Excel Tutorials
  2. Excel Websites

Excel Tutorials

  1. Excel Basics Course
  2. Excel Crash Course - Data Cleaning in Excel - Microsoft Excel Tutorial
  3. Data Cleaning in Excel - Text Functions and Power Query in Excel!
  4. Introduction to Data Analysis with Excel: 2-Hour Training Tutorial
  5. Excel Projects
  6. Excel Advanced Course
  7. Microsoft 365 Excel Complete Class (Optional)

Excel Websites

11 Free Websites Will 100X Your Excel Skills

  1. Excel Basement
  2. Excel Jet
  3. Mr. Excel
  4. Chandoo
  5. Trump Excel
  6. The Smart Method
  7. Contextures
  8. Excel Campus
  9. Excel Exposure
  10. Excel Easy
  11. My Excel Online

Power BI Complete Roadmap

Table of Contents

  1. Power BI Tutorials
  2. Bonus Resource

Power BI Tutorials

  1. PQB: Power Query Basics from A to Z - Full Course, 5 hours, 17 topics, 25+ Examples
  2. Power BI Full Course in 8 Hours | Learn Power BI Pavan Lalwani Power BI Tutorial for Beginners
  3. Power BI Projects for Beginners
  4. Learn Power Pivot & DAX for Power BI with 20 Beginner to PRO Examples (Sample file included)
  5. Introduction to Data Modeling for Power BI Video Course
  6. Introducing DAX Video Course
  7. Complete Power BI DAX End to End - Power BI DAX Tutorial - {End to End} Full Course
  8. Complete Power BI Services - {End to End} Full Course
  9. Power BI Advanced Projects
  10. Power BI Projects (Optional)

Bonus Resource

SQL Complete Roadmap

Table of Contents

SQL Videos

  1. SQL Tutorial for Beginners [Ultimate Full Course]

  2. SQL Course | Beginners to Advanced

  3. Advanced SQL Course for Data Analytics

SQL Theoretical Learning Websites

  1. MySQL Tutorial (tutorialspoint.com)

  2. SQL Tutorial - Essential SQL For The Beginners

  3. MySQL Tutorial: Master the Essentials of Database Management (geeksforgeeks.org)

SQL Practice Websites

  1. SQLCourse: Beginner & Advanced Interactive SQL Tutorials

  2. SQLBolt - Learn SQL - Introduction to SQL

  3. Learn SQL - Online SQL Terminal - Practice SQL Queries (sql-practice.com)

  4. MySQL Exercises, Practice, Solution - w3resource

  5. HackerRank

    1. HackerRank Certifications
    2. Solve SQL Questions
    3. HackerRank Interview Preparation Kit

  6. MySQL Tutorial (w3schools.com)

  7. LeetCode

    1. Problems - LeetCode
    2. SQL 50 - Study Plan - LeetCode
    3. Top Interview 150 - Study Plan - LeetCode

  8. DataLemur

    1. Free SQL Tutorial for Data Analysts & Data Scientists (datalemur.com)
    2. SQL Interview Questions | DataLemur

  9. StrataScratch

    1. SQL Data Manipulation for Data Scientists - StrataScratch
    2. SQL Time & Date Manipulation for Data Scientists - StrataScratch

Watch and Practice SQL

  1. SQL Technical Interview Prep - YouTube

  2. ALL HackerRank SQL Solutions in ONE Video! | Easy Medium Hard Problems - YouTube

  3. EASY SQL LeetCode Interview Questions | Practice (youtube.com)

  4. HackerRank SQL Solutions - YouTube

  5. SQL Certifications - YouTube

Everyday Data Science – YouTube Channel

  1. SQL Practice Questions - YouTube

  2. LeetCode SQL Easy - YouTube

  3. LeetCode SQL Medium - YouTube

  4. LeetCode SQL Hard - YouTube

  5. DataLemur SQL Easy - YouTube

  6. DataLemur SQL Medium - YouTube

  7. DataLemur SQL Hard - YouTube

Python Complete Roadmap

Table of Contents

  1. Python Tutorials
  2. Python Documentation
  3. NumPy Tutorials
  4. NumPy Documentation
  5. Pandas Tutorials
  6. Pandas Documentation

Python Tutorials

  1. Is Python Really Needed For a Data Analyst Job?
  2. Session 1 - Python Fundamentals | CampusX Data Science Mentorship Program | 7th Nov 2022
  3. Session 2 - Operators + If-Else + Loops | CampusX Data Science Mentorship Program | 8th Nov 2022
  4. Session 3 - Python Strings | CampusX Data Science Mentorship Program | 9th Nov 2022
  5. Programming Problems on Strings | Session 3 Supplementary Session
  6. Session 4 - Lists in Python | Data Science Mentorship Program(DSMP) 2022-23
  7. Session 5 - Tuples + Sets + Dictionary | Data Science Mentorship Program(DSMP) 2022-23
  8. Session 6 - Functions in Python | Data Science Mentorship Program(DSMP) 2022-23

Python Documentation

  1. The Python Tutorial — Python 3.12.5 documentation
  2. Python Tutorial | Learn Python Programming - GeeksforGeeks
  3. Python Tutorial (w3schools.com)
  4. Python Tutorial (tutorialspoint.com)
  5. Learn Python - Free Interactive Python Tutorial

NumPy Tutorials

  1. Session 13 - Numpy Fundamentals | Data Science Mentorship Program (DSMP) 2022-23
  2. Session 14 - Advanced Numpy | Data Science Mentorship Program (DSMP) 2022-23
  3. Session 15 - Numpy Tricks | Data Science Mentorship Program (DSMP) 2022-23

NumPy Documentation

  1. What is NumPy? — NumPy v2.0 Manual
  2. Introduction to NumPy (w3schools.com)
  3. NumPy Tutorial (geeksforgeeks.org)
  4. NumPy Tutorial (tutorialspoint.com)
  5. Numpy Arrays - Learn Python - Free Interactive Python Tutorial

Pandas Tutorials

  1. Session 16 - Pandas Series| Data Science Mentorship Program (DSMP) 2022-23
  2. Important Series Methods | Supplementary Session | DSMP 2022-23
  3. Session 17 - Pandas DataFrame | Data Science Mentorship Program (DSMP) 2022-23
  4. Session 18 - Important DataFrame Methods | Data Science Mentorship Program (DSMP) 2022-23
  5. Session 19 - GroupBy Object in Pandas | Data Science Mentorship Program (DSMP) 2022-23
  6. Session 20 - Merging, Joining & Concatenating | DSMP 2022-23
  7. Session 21 - MultiIndex Series and DataFrames | DSMP 2022-23
  8. Session 22 - Vectorized String Operations | DateTime in Pandas | Pivot Table | DSMP 2022-23

Pandas Documentation

  1. 10 minutes to pandas — pandas 2.2.2 documentation (pydata.org)
  2. Getting started — pandas 2.2.2 documentation (pydata.org)
  3. Pandas Introduction - GeeksforGeeks
  4. Pandas Tutorial (w3schools.com)
  5. Pandas Basics - Learn Python - Free Interactive Python Tutorial

Contact Details

Call: +92-318-815444-1
Email: [email protected]
LinkedIn: linkedin.com/in/qamaruddin-khichi/