Learning Resources for Self-learning Data Analysts
1. Excel:
Leila Gharani: Xelplus (her website) and Udemy Courses as below:
(1) Excel Chars
(2) Advanced Excel
(3) Excel Dashboards
(4) Excel VBA and Marco
(5) Power Query
This is her newest one. I found lots of practical problems can be done without writing complicated formulae.
2. SQL:
Jose Portilla:
(1) The Complete SQL Bootcamp
(2) Practice: Leetcode & HackerRank
Useful Github links for answers for above questions
\
3. Python:
(1) Philipp Muellauer:
Complete Data Science & Machine Learning Bootcamp
(2) Jose Portilla:
Python for Time Series Data Analysis
(3) Explanations for Machine Learning Algorithms
(4) Soledad Galli:
Feature Engineering for Machine Learning
(5) For practice:
Check any Python Libraries when coming across unknown methods.
Learn from others’ notebooks on Kaggle.
Design your own project targeting a practical problem relevant to your education background.
\
4. Tableau /PowerBI
Anthony B. Smoak:
Youtube Channel
Tableau Public