r/analytics • u/SanyamGulati • 15h ago
Discussion Analytics lead, 10 years in. The roadmap I'd follow if I was starting today
I see a "how do I get into analytics" post here almost every day, so here's what I'd actually do if I was starting over now.
Quick context: when I started, everything was manual. Now AI can write a lot of the SQL for you. The technical bar to get in is lower than ever, and what separates people is whether they understand the business problem. Plan for that.
1. Learn the basics, don't overthink the course
Udemy or YouTube is fine (Alex the Analyst is great, and free). SQL first, then Excel, then Power BI or Tableau. Aim for "I can pull data, clean it and chart it", not mastery.
2. Don't start applying yet. Solve problems.
Biggest mistake I see: everyone grabs Superstore, builds the same sales dashboard, and ends up with the same portfolio as thousands of other applicants.
Don't build a dashboard. Solve a case study. Start from a question a manager would actually ask, work it out, and write down what you'd recommend.
Full disclosure, I'm building one of the places to do this, Trialday.co . You run analytics for a simulated company end to end: messy data, questions from colleagues, decisions that change what happens next. It's free during early access (invite only, there's a waitlist). If you'd rather not, Danny Ma's 8 Week SQL Challenge is also free and good.
3. Put the thinking on your resume, not the tools
"Found X was driving Y, recommended Z" beats "Built a dashboard in Power BI." With AI doing more of the technical work, showing you can solve a business problem end to end is what stands out.
4. Skip the HR queue
Instead of hitting apply 200 times, message the analytics manager or director where there's an opening. Short, specific, one project link. In my experience the reply rate is way higher, because they're the ones feeling the empty seat.
Happy to answer questions in the comments.