“‘I want to move into data’ is not a career plan — it’s a direction. The professionals who actually make the switch pick a specific archetype, build one project, and stop trying to learn everything at once.” — Sandeep Anand
Kavya spent six years in operations at a logistics company in Chennai, working with spreadsheets daily but never with the title “analyst.” She’d been telling people she wanted to “move into data” for over a year, enrolling in two separate online courses she never finished, overwhelmed by the sheer breadth of what “data” seemed to require — Python, machine learning, statistics, SQL, cloud platforms.
The breakthrough wasn’t more courses. It was realising that most job postings for “Data Analyst” in the US, UK, and India are actually asking for one of three very different things, and her six years of operations reporting mapped almost perfectly onto one of them already.
The 3 Data Analyst Archetypes
Most people trying to break into data attempt to prepare for all three at once, which is exactly why the process feels endless. Picking one archetype based on your existing background focuses 100% of your learning time on what actually gets you hired for that specific type of role.
Reframing Experience You Already Have
Operations, finance, and marketing experience already contains data work
- Weekly reporting, KPI tracking, and budget reconciliation are data analysis, described in non-data language
- List every instance where you used data to make or influence a decision, regardless of what the task was officially called
- Translate each into data-analyst resume language: “tracked and reported on X” becomes “built and maintained recurring performance dashboards”
The one portfolio project that substitutes for a missing degree
- Use a real, business-relevant dataset — ideally from your current or a past role, not a generic public dataset everyone has used
- Complete one full project: define a business question, analyse the data, and recommend a specific action based on the finding
- Document the project clearly with the “before” question and “after” recommendation — this single project outperforms five shallow tutorial projects
The 30-Day Starter Plan
Pick your archetype and learn the two core tools
- Choose your archetype based on your existing strengths and target industry, not what sounds most impressive
- Build working fluency in advanced Excel or Google Sheets and SQL — these appear in the overwhelming majority of postings regardless of archetype
Build your one project and reframe your resume
- Complete your single business-relevant portfolio project from question to recommendation
- Rewrite your resume and LinkedIn headline in data-analyst language matching your chosen archetype
- Begin applying specifically to roles matching that archetype, not generic “data analyst” postings across all three types
The Non-Analyst’s Roadmap to a Data Analytics Role
Which of the three real data analyst archetypes companies actually hire for fits your background, how to reframe existing experience into resume language that reads as data experience, the one portfolio project that substitutes for a missing degree, and a 30-day action plan.
₹1,999 ₹6,999 | $49 $199
Are You Actually Ready to Start? A Quick Check
Have you picked one specific archetype instead of preparing for all three?
Have you listed every instance of data-based decision-making in your current or past roles?
Do you have working fluency in spreadsheets and SQL, at minimum?
Do you have one complete, documented portfolio project — not five half-finished ones?
Is your resume written in the language of your target archetype, not your current title?
Frequently Asked Questions
Yes. Most companies hiring data analysts care far more about your ability to turn data into a clear business decision than a formal technical degree. A single strong portfolio project, paired with practical tool fluency, substitutes for a missing degree in most postings.
Companies generally hire for three archetypes: the reporting analyst who builds dashboards, the business analyst who translates data into strategic recommendations, and the product or growth analyst who studies user behaviour. Identifying which fits your background focuses your learning instead of trying to cover everything.
Use a real dataset from your current or a past role and build one complete project that identifies a business question, analyses the data, and recommends a specific action. One well-documented, business-relevant project outperforms five generic tutorial-based projects.
Start with advanced Excel or Google Sheets and SQL, since these appear in the overwhelming majority of data analyst postings across the US, UK, and India. Add a visualisation tool like Tableau or Power BI once comfortable with the first two.
It’s a digital guide that identifies which archetype fits your background, shows how to reframe existing experience into data-analyst resume language, provides the one portfolio project that substitutes for a missing degree, and includes a 30-day action plan. Available at sandeepanand.in/coaching/the-non-analysts-roadmap-to-a-data-analytics-role/.
