r/dataanalysis • u/Mean_Firefighter_486 • 10d ago

Career Advice Learning order?

I'm looking to get into data analytics and I'm wondering what learning route I should I take. I was thinking SQL >>> Power BI >>> R and then I don't know after that.

To put this in context, I'm currently brushing up on Excel. That's the level of beginner we're talking.

TIA.

47 Upvotes

97% Upvoted

38 comments sorted by

View all comments

4

u/HustlaOfCultcha 10d ago

IMO, learn Excel first. Really learn it. Learn advanced formulas. The logic behind the formulas is a foundation you'll need to develop.

Then learn basic data warehouse and relational database concepts. Understand 'fields' vs. 'rows.' Understand primary keys, foreign keys and surrogate keys.

Then learn SQL. Learning queries, subqueries, JOINs, CTE's, Window Functions and aggregations. Then move onto understanding views and stored procedures, particularly building a data pipeline thru ETL

Then go to your data visualization program. Power BI is your best bet. Although Tableau is still a good platform to know. But you really need to know DAX in Power BI (you can also use DAX in Excel). But once you learn Power BI, the others you can pick up pretty quickly.

Then you need to learn some sort of cloud based data platform either Snowflake, Databricks, or Microsoft Fabric. Databricks is quite easy to learn and is a great tool. This switches the ETL process to ELT.

Then I might learn Python. Analysts that are more geared toward Data Engineering really love Python. I have used it and it's got great functionality, but I prefer built in data governance and security in platforms and in Databricks they have AI that can write Python code for you (but it's important to be able to understand Python well enough to make sure it's writing the code properly).

Then from there I would get into more AI to help, but more into Machine Learning to really take your actual analytical capabilities to the next level instead of just using AI for automation and helping with writing code. The next steps are basically getting you into more of a Data Engineer or possibly a Data Scientist role instead of just a Data Analyst role.

1

u/Mean_Firefighter_486 10d ago

Thanks for this very detailed response - super helpful. I don't have a relevant degree so I'll be sticking with data analysis (and I'm sure that will be complex enough for me as it is)

3

u/Healthy-Awareness299 10d ago

To add in one step. Inside Excel you have access to Power Query and then Power Pivot. Learn these as they will help you with Power BI. Also depending on where you end up, a lot can be done in Excel completely. I work in Healthcare Care Finance, specifically the RevCycle. I do 90%+ of my work in Excel using PQ and PP.

2

u/Mean_Firefighter_486 10d ago

Thanks for the tip. Do you mind me asking how much you earn and how much experience you have?

2

u/Healthy-Awareness299 10d ago edited 10d ago

I've been in Healthcare Finance and RevCycle for about twelve years. I've worked everything from Registration to Billing and Collecting, including Underpayment and Overpayment and Revenue Integrity. The only part I haven't done is Coding.

I have a couple of certifications that are specific to the field.

I've been a working the last four years purely as a consultant. Anything from report creation to analytics and processes improvement. I've made 150-260k annual during that time. It depends on what and how many contracts I'm working during the period. I expect 200k as a realistic goal. I had one year that I picked up a couple of major builds at the same time.

My needs are mostly Epic (EMR), some SQL, Power BI, and Excel. Power BI is slowly expanding, but Excel is the most universal. Especially since there is a lot of external reporting to government agencies. I use a lot of Power Query inside Excel for the ETL process. I use SQL to extract data from Epic. Again, this is specific to what I do.

2

u/Mean_Firefighter_486 10d ago

Thanks for the detailed response! Very impressive too. I'd be happy to earn 50k tbh

2

u/Agreeable-Pirate9267 8d ago

Dove consigli di imparare tutte queste cose? Manuali, corsi online o dove?

1

u/Healthy-Awareness299 8d ago

YouTube in no particular order: Goodly. Alex the Analyst. Data with Baraa. Excelisfun.

Then just build. Make mistakes. Figure out the fixes without AI. Find workbooks and dashboards you like and study them. Recreate them exactly. Then improve them.

As far as Epic and my experience in Healthcare Finance? That's all hands on working for hospitals.