prashantvermaofficial/data_analyst_learning_path_2022

Config files for my GitHub profile.

Learn data analyst skills step by step in 3 months

---

Following is a schedule to learn data science step by step considering 4 hours of dedicated, focused study every single day. This program is perfect for beginners with no knowledge of data science and programming.

Week 1 and 2: Excel and Statistics

• Excel

  • Google templates gallery for personal finance etc : https://docs.google.com/spreadsheets/u/0/?ftv=1
  • Budget planner: https://www.vertex42.com/ExcelTemplates/budgets.html
  • Chandoo's youtube channel: https://www.youtube.com/channel/UC8uU_wruBMHeeRma49dtZKA
  • Chandoo's website: https://chandoo.org/

• Statistics

  • Khan academy: https://www.khanacademy.org/math/statistics-probability
  • Khan academy youtube: https://www.youtube.com/playlist?list=PL1328115D3D8A2566
  • Statistics by Marin : https://www.youtube.com/playlist?list=PLqzoL9-eJTNBZDG8jaNuhap1C9q6VHyVa
  • Statquest youtube channel: https://www.youtube.com/user/joshstarmer

Week 3, 4, 5: BI tools

• Tableau

  • Codebasics sales insights project: https://www.youtube.com/playlist?list=PLeo1K3hjS3usDI9XeUgjNZs6VnE0meBrL
  • HINDI codebasics sales insights project: https://www.youtube.com/playlist?list=PLPbgcxheSpE2B7YFfOualUTlRhgnQR7Kn
  • Abhishek Agarwal: https://www.youtube.com/playlist?list=PL6_D9USWkG1C4raCOTlTf_oq4XnNNNtm9
  • Bharti consultancy: https://www.youtube.com/playlist?list=PLyD1XCIRA3gQmN73dHwQWr4R08ABZFMtZ

• Power BI (project)

  • codebasics sales insights project: https://www.youtube.com/playlist?list=PLeo1K3hjS3uva8pk1FI3iK9kCOKQdz1I9
  • personal finance project: https://www.youtube.com/watch?v=pqSoCa2NGj4

Week 6 and 7: Python

• Python
  • Codebasics python tutorials (first 16) - https://www.youtube.com/playlist?list=PLeo1K3hjS3uv5U-Lmlnucd7gqF-3ehIh0
  • Codebasics python HINDI tutorials - https://www.youtube.com/playlist?list=PLPbgcxheSpE1DJKfdko58_AIZRIT0TjpO
  • Make sure to work on exercises in these folders: https://github.com/codebasics/py/tree/master/Basics/Hindi

Week 8, 9: Numpy, Pandas, Data Visualization Libraries

• NumPy and Pandas

  • Codebasics Numpy playlist: https://www.youtube.com/playlist?list=PLeo1K3hjS3uset9zIVzJWqplaWBiacTEU
  • Codebasics pandas playlist (first 9): https://www.youtube.com/playlist?list=PLeo1K3hjS3uuASpe-1LjfG5f14Bnozjwy

• Visualization library

  • Matplotlib: codebasics matplotlib playlist: https://www.youtube.com/playlist?list=PLeo1K3hjS3uu4Lr8_kro2AqaO6CFYgKOl
  • Seaborn: codebasics seaborn tutorials: https://www.youtube.com/playlist?list=PLJIOr9Je9wzHT-ptgfelpt2Nyx4VGX_j9

• Kaggle exploratory data analysis

  • Notebooks: https://www.kaggle.com/notebooks
  • Datasets: https://www.kaggle.com/datasets

Week 10, 11, 12: SQL & MongoDB

• SQL

  • kudavenkat playlist (first 16): https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB
  • khanacademy SQL course: https://www.khanacademy.org/computing/computer-programming/sql

• MongoDB

  • https://www.coursera.org/learn/introduction-mongodb

Soft skills

---

• Learn anything effectively: https://www.youtube.com/watch?v=yZFrSDjRvjk

• Group learning

  • Codebasics discord server: https://discord.gg/r42Kbuk
  • Hold each other accountable

Books and other resources

---

• Free book on statistics: http://greenteapress.com/thinkstats/thinkstats.pdf

• Another good book on statistics (not free) Naked Statistics - Charles Wheelan

• Mechanical engineer to data analyst transition success stories https://youtu.be/34-RThWWRHM https://www.youtube.com/watch?v=HgE2yOHl1RU

• BCom to data analyst transition success story https://youtu.be/lqEzYDuTnvU

Resume Guidance

---

• Data analyst resume review session with template resume: https://www.youtube.com/watch?v=YKPFQUvckU0