The story of a fresh graduate pivoting from data science to data analysis is not a detour, it's a strategic recalibration, and one we see far too often undervalued. This user has two years of Python under their belt, a solid grasp of Excel formulas and sorting, and a clear-eyed view of a market that demands experience for specialized roles. That is not a weakness; it is a foundation most entry-level analysts would envy. The instinct to rush into VBA and macros, however, deserves a pause.
VBA and macros are not complex in the way that Python or DAX are complex. They are verbose, clunky, and built for a world that is already receding. A couple of weeks of focused practice can give you a functional grip, recording actions, editing recorded code, looping through ranges. But here is the honest truth: the time you spend mastering VBA is time you could spend deepening your Power BI fluency or sharpening your Python for data manipulation. The market is not asking for more macros. It is asking for analysts who can connect spreadsheets to databases, automate workflows with Python, and build dashboards that tell a story without requiring a manual. Your Python background already positions you ahead of that curve.
The real transferable skill here is not the specific formula or tool. It is the mindset of structured problem-solving you developed while aiming for data science and LLM engineering. That logic carries directly into Excel's lookup functions, Power BI's DAX measures, and any relational database you encounter. The formulas you already know, text manipulation, filtering, sorting, are the same operations that underpin SQL queries and pandas DataFrames. You are not starting over. You are translating fluency from one language to another. The syntax changes; the logic does not.
So here is our firm advice: skip the deep VBA dive for now. Learn enough to understand what it does, then redirect your energy to Power BI and DAX, where your Python intuition for logic and data structures will pay off immediately. The market for experienced analysts is wide open to someone who can move between a spreadsheet and a script without losing momentum. You already have that skill. Now apply it deliberately.