Motorola 68000 posted:

I dabble a little in data analysis, mainly HR related. Currently getting my master’s degree in business Intelligence as well.

Start with SQL (Any flavor will do) and then focus on Python. R is great, I prefer it over Python but in a business setting they only use python mainly.

After that Learn Power BI (DAX + Power Query as well).

It’s very important to have basic statistical knowledge because that is the main way you are going to get conclusions from your data that you can later pass on to management. Understanding and testing regressions is fundamental and how to explain the results as if the person were 5 years old.

Dashboards should always be simple, make sure there are lots of white spaces, so the eyes get pulled to relevant KPIs. Most important info on top always. (One Dashboard should only have max 4 graphs, or 2 graphs and some KPIs).

KPIs are only good if they are monitored.

I learned most programming from DataCamp and Udemy.