A list of self-learning in data science and data analysis (cont updating)
Recently, I am upgrading and updating my DA skillset. I would like to share what I learned from a variety of online resources.
SQL:
https://sqlzoo.net/ is quite abstract for DA need--only focused on queries. At least finish all those quizzes.
https://www.educba.com/category/data-science/data-science-tutorials/sql-tutorial/ Not as structured as sqlzoo. However, it covers more complete knowledge of a relational DB. Those interview questions can be useful if you know how-do in front of a screen, but cannot speak out those concepts fluently.
https://www.runoob.com/sql/sql-syntax.html
https://www.w3school.com.cn/sql/index.asp
Excel:
Essential Math for Data Analysis using Excel Online
Microsoft's Data Analysis: Essential Skills
Analyzing and Visualizing Data with Excel
Power BI:
https://mp.weixin.qq.com/s/m9MSiaNPY4RzKmnAY3Uu-w
https://technovids.com/power-bi-storage-modes/
https://www.powerbigeek.com/evaluate/
https://www.powerbigeek.com/?aff=779
https://docs.microsoft.com/zh-cn/power-bi/guided-learning/
https://www.youtube.com/playlist?list=PL1N57mwBHtN0JFoKSR0n-tBkUJHeMP2cP
Tableau:
Tableau Training: View Training Courses
Tableau and R for Analytics Projects
Python:
Python for Data Science(Free)
https://courses.cognitiveclass.ai/courses/course-v1:Cognitiveclass+PY0101EN+v2/
Data Analysis with Python(Free)
https://courses.cognitiveclass.ai/courses/course-v1%3ACognitiveClass%2BDA0101EN%2B2017/
For practice and demo project, which is the most important part for really grasp those tools and skills:
https://www.dataoptimal.com/data-science-projects-2018/
https://www.quora.com/What-are-some-data-analysis-projects-I-can-do-as-a-data-science-beginner
Others:
Highly recommanded to listen this podcast which I personal feel they are mindblowing.
#datascience #dataanalysis #learning