Skip to content

NarimanAbdo/Data_Analysis_tutorial

Repository files navigation

Math & Statics

Data_Structures & Algorithms

Data warehouse:

  1. Book: https://www.pdfdrive.com/the-data-warehouse-toolkit-the-definitive-guide-to-dimensional-modeling-e157742453.html
  2. Youtube: https://www.youtube.com/playlist?list=PLrbIyvYCdg0iAUQoxG5vI_yKqzZ2AcgGe
  3. https://www.youtube.com/@ahmedelsayed8467
  4. https://www.youtube.com/watch?v=Yv1Ic0rPXN0

SQL

_Top SQL Learning Platforms for Problem-solving:-

  1. SQLZoo – Interactive lessons for beginners.
  2. HackerRank – Challenge your SQL knowledge with real-world problems.
  3. LeetCode – Solve SQL problems asked in top tech interviews.
  4. Mode Analytics – Practice SQL with live data sets.
  5. SQL Bolt – Step-by-step SQL tutorials.
  6. GeeksforGeeks – In-depth SQL articles by Sandeep Jain.
  7. LearnSQL – Structured SQL learning paths.
  8. NamasteSQL – SQL mastery by Ankit Bansal.
  9. StrataScratch – Tackle real interview questions.
  10. DataLemur – Ace SQL & Data Interviews with Nick Singh.
  11. sql-practice – Practical SQL problems.
  12. Dataford – Hands-on SQL for data analysis.
  13. Interview Query – SQL interview insights.
  14. LearnMode – Learn SQL at your own pace.

Business Intelligence (BI) Career

  1. Roadmap: https://www.youtube.com/watch?v=v38syyZqzkw 2.ITI M. Rami: https://www.youtube.com/playlist?list=PLSGEGD0dbMKpih5QzGQfwU86d8TB-O24a
  2. English: SQL + SSIS + SSAS + Power BI: https://www.youtube.com/watch?v=eNxbMwUGl1g
  3. Business Intelligence | SSIS | SSAS | Cubes | SSRS [Arabic]
  4. SSIS [English]: https://www.youtube.com/playlist?list=PLNIs-AWhQzcmPg_uV2BZi_KRG4LKs6cRs

Power BI:

  1. https://www.youtube.com/@GuyInACube/playlists
  2. https://youtube.com/@curbalen?si=j0LziawC2ZOqMd3k
  3. https://youtube.com/@learnwidgiggs?si=0mTEuywNezH8ycYN
  4. Power BI Quick Tips: https://www.youtube.com/playlist?list=PLs93rgE5erT5Hu5XkzTk_ZEMdvB9yFaFH
  5. https://www.youtube.com/@PowerBIPro/playlists

DAX

  1. https://www.daxformatter.com
  2. https://dax.guide/
  3. YouTube playlist to learn:
  4. https://www.youtube.com/playlist?list=PL1myWUzvmmDGmLfty3BDluz8nzme1dZxg
  5. https://www.youtube.com/playlist?list=PLjNd3r1KLjQuVWrPuygE8QwEmCL6rrUrx
  6. https://www.youtube.com/playlist?list=PLcwrIWK7WBcQmoBMuBRnRv1LaGUEdbYCT

projects to build your portfolio

FREE DATASET BUILDING YOUR PORTFOLIO ⭐️

  1. Supermarket Sales - https://lnkd.in/e86UpCMv
  2. Credit Card Fraud Detection - https://lnkd.in/eFTsZDCW
  3. FIFA 22 complete player dataset - https://lnkd.in/eDScdUUM
  4. Walmart Store Sales Forecasting - https://lnkd.in/eVT6h-CT
  5. Netflix Movies and TV Shows - https://lnkd.in/eZ3cduwK
  6. LinkedIn Data Analyst jobs listings - https://lnkd.in/ezqxcmrE
  7. Top 50 Fast-Food Chains in USA - https://lnkd.in/esBjf5u4
  8. Amazon and Best Buy Electronics - https://lnkd.in/e4fBZvJ3
  9. Forecasting Book Sales - https://lnkd.in/eXHN2XsQ
  10. Real / Fake Job Posting Prediction - https://lnkd.in/e5SDDW9G

Cloud computing:

  1. AWS: https://www.youtube.com/watch?v=E3nLSHQtLes&list=PLOoZRfEtk6kWSM_l9xMjDh-_MJXl03-pf
  2. MS Azure: https://www.youtube.com/watch?v=C-KJRwRqXK8&list=PLCIJjtzQPZJ-CDaKOAlm3JfpL2kddIhRA
  3. Azure Cloud Computing: https://www.youtube.com/watch?v=DeDiDgAlOnU&list=PLCIJjtzQPZJ-lhz8fL-OAI7Gun4B37xcs
  4. Databricks Quick Course 2024: https://www.youtube.com/playlist?list=PLfDCRTtObbI6YE7hr1sk0rddzIkbSq7kL
  5. DB-spark: https://www.youtube.com/@GarageEducation/playlists

Big Data:

  1. Hadoop & MapReduce | https://www.youtube.com/watch?v=3PAl0y067Ag&list=PLrooD4hY1QqAK5pbBpcthLuMa-cXnXJLE
  2. Big Data Engineering In Depth | https://www.youtube.com/watch?v=p_jl-gFinlA&list=PLxNoJq6k39G_m6DYjpz-V92DkaQEiXxkF
  3. Hadoop & Distributed Systems | https://www.youtube.com/watch?v=Ot63tlh0PaE&list=PLxNoJq6k39G8Ak39PDC-oYvp6ZRvIn3Pa
  4. Big Data Full Course 2022 | https://www.youtube.com/watch?v=KCEPoPJ8sWw

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published