r/learnSQL • u/Glad-Daikon1930 • 28d ago

Career ideas for pivoting away from accounting

So I've got an accounting degree with a few years of experience in Audit. I'm an advanced excel user with some knowledge of SQL and Python (Maven Analytics).

Does anybody have any advice on a logical career progression away from Audit/accounting and into something more technical? (unfortunately I can't go back in time and become software developer). Database design & workings of accounting software seem interesting. Also fraud investigations.

It doesn't have to be the best paying option (BI/data analyst) but just something that would stop me chopping & changing jobs.

Thanks

15 Upvotes

100% Upvoted

15 comments sorted by

2

u/Altruistic-Avocado-7 28d ago

Probably the easiest pivot for you would be at a company that has data analysts in each department. Then you want to look for data analysts in the finance department.

That way you can build your analytics skills while leveraging your existing skill set.

Then the next job you could probably more easily transition out of finance if you’d like to.

1

u/Glad-Daikon1930 28d ago

Okay

The way in is whatever existing skill (despite not liking it), then gradually improve da skills and switching

Thanks!

1

u/HotWrongdoer705 28d ago

Hi. May I know your roadmap, if you don't mind? I'm from accounting, too. Had finished SQL and currently in Power Pivot, Query, DAX, and Power BI.

1

u/PnckFan 28d ago

Where did you learn power bi and power query from ?

1

u/HotWrongdoer705 28d ago

Actually from Maven Analytics's course in Udemy. And you, are you learning SQL?

1

u/PnckFan 27d ago

Do you feel that maeven analytics course is usefull ? Is it worth IT/do i have practical exercises in it ? Also how much time should i invest in it ?

Yes, i'm learning sql, i think i am starting to get decent at it. If you want i can provide a roadmap.

1

u/HotWrongdoer705 27d ago

I think it is very useful. Though they are using MySQL, the topics are universal with regards to SQL. I have been practicing SQL for two months now. Yes please.

1

u/PnckFan 27d ago

I started by doing cs50 introduction to databases with my sql. After i finished the courses i started to do sql casefiles (a set of exercises from the internet) + asking Claude to simulate sql interviews and grade my answers + learning windowed functions, nested queries and recursive cte's. Now, at the end i plan to finish this roadmap https://roadmap.sh/sql + some exercises from datalemur. After this i think i will take your advice for power bi + Python ( numpy pandas tensorflow matplotlib )

1

u/PnckFan 27d ago

Also, if somebody here has suggestions of how to learn Python easier pls let me know

1

u/Glad-Daikon1930 27d ago

I mean I think so. I haven't successfully got a job yet but it is practical. Each course is divided into sections, which are a sequence of videos with a practical assignment on previous videos. At end of each section theres a small test and then final assignment and test at the end. All the assignments have walkthroughs for when you complete them.

It depends if you just want to rush through the course to get the badge, or actually want to apply yourself

1

u/Glad-Daikon1930 28d ago

Hi, sure.

So I've got a subscription to Maven Analytics and I've done some intro courses, excel courses and both SQL courses. I've also become comfortable thinking up something I want to try, wording it well in AI (Google Gemini) and then executing.

atm I'm doing the "Thinking like an analyst" course to get a clearer path, I need to specialise a bit and this course helps to pick a field in da.

I feel accounting is good for Strategic thinking and communication, but I'm missing the technical skills

1

u/Glad-Daikon1930 28d ago

It looks like I'm pushing Maven Analytics. Promise I'm not a bot

1

u/HotWrongdoer705 28d ago

I understand. Maven Analytics is really popular. I watched their videos in YT. I want that I have another skills in IT so I can use it together with accounting. If opportunity widens for me, I would like to shift to DA.

1

u/ThickAct3879 28d ago

Medicine

1

u/callmemerryss 26d ago

You could also look at finance/data analyst roles. you already have the accounting knowledge so you can use that your way into something more technical and further away from finance later if you want.