90‑Day Data Analytics Roadmap

You’ve probably heard that data is the new oil, but you’re still stuck watching spreadsheets from the sidelines. In a world where every company wants to turn numbers into insight, a solid plan can get you from “I’m curious” to “I’m hiring” in just three months. Let’s break it down, step by step, so you can start building real, market‑ready analytics skills without feeling overwhelmed.

Why 90 Days Works

Three months is long enough to cover the basics, practice a few projects, and build a portfolio, yet short enough to keep the momentum high. It forces you to focus, set clear milestones, and avoid the endless rabbit hole of “just one more tutorial.” Think of it as a sprint rather than a marathon—intense, purposeful, and rewarding.

The Roadmap at a Glance

Below each phase, I’ll walk you through the exact actions, resources, and checkpoints you need.

Phase 1 – Foundations (Weeks 1‑2)

1. Define Your Why

Before you open a textbook, write a one‑sentence statement about why you want to move into analytics. Is it to switch careers, boost your current role, or launch a freelance side hustle? A clear purpose will keep you on track when the learning curve feels steep.

2. Get Comfortable with Core Concepts

• Data Types – numbers, text, dates, and categories. Know the difference between nominal, ordinal, interval, and ratio data.
• Descriptive Statistics – mean, median, mode, variance, and standard deviation. These are the building blocks for any analysis.
• Visualization Basics – bar charts for comparisons, line charts for trends, and scatter plots for relationships.

Resources: Khan Academy’s “Statistics and probability” series (about 5 hours total) and the free “Data Literacy” course on Coursera.

3. Set Up Your Learning Environment

• Install Google Sheets (free) for quick practice.
• Sign up for a free GitHub account – you’ll need it later to showcase code.
• Create a dedicated folder on your computer called “DataAnalytics90” and sub‑folders for “Notes,” “Exercises,” and “Projects.”

Checkpoint: By the end of week 2, you should be able to explain the difference between a histogram and a bar chart, and you should have a one‑page cheat sheet of key statistical terms.

Phase 2 – Tools & Techniques (Weeks 3‑5)

4. Master Excel (or Google Sheets)

Spend a full week learning the most common functions:

• SUM, AVERAGE, COUNTIF – basic aggregation.
• VLOOKUP / XLOOKUP – pulling data from other tables.
• Pivot Tables – summarizing large data sets in seconds.
• Conditional Formatting – visual cues for outliers.

Practice: Download a public dataset (e.g., NYC taxi trips) and answer three business questions, such as “Which hour of the day has the most rides?” Document your steps in a short write‑up.

5. Dive into SQL

SQL (Structured Query Language) is the lingua franca of databases. Focus on:

• SELECT, FROM, WHERE – basic data retrieval.
• GROUP BY, HAVING – aggregations.
• JOINs – combining tables.

Free Platform: Use the “SQLZoo” interactive tutorials or the “Mode Analytics SQL Tutorial” which gives you a real‑world data set to query.

Practice: Write a query that finds the top 5 customers by total spend in a sample e‑commerce dataset. Save the query and results in your “Projects” folder.

6. Intro to Python for Data

Python is the go‑to language for deeper analytics and automation. Install Anaconda (includes Jupyter Notebook) and learn:

• Pandas – data frames, cleaning, and manipulation.
• Matplotlib / Seaborn – quick visualizations.
• NumPy – numerical operations.

Course: “Python for Data Analysis” on DataCamp (first 10 hours are free). Follow along with the built‑in exercises.

Practice: Load the same taxi dataset you used in Excel, clean missing values, and plot a line chart of rides per day. Save the notebook as “Week5_TaxiAnalysis.ipynb”.

Checkpoint: By the end of week 5 you should be able to write a simple SQL query, build a pivot table in Excel, and run a basic Pandas script that cleans and visualizes data.

Phase 3 – Real‑World Projects (Weeks 6‑8)

7. Choose Two Projects That Show Impact

Pick topics that matter to you—maybe a personal finance dashboard or an analysis of public health data. The key is to demonstrate the full workflow:

1. Problem Statement – What question are you trying to answer?
2. Data Collection – Where does the data come from? (Kaggle, public APIs, or CSV files)
3. Cleaning & Exploration – Use Python or SQL to tidy the data.
4. Analysis – Apply statistical methods or simple models.
5. Visualization & Storytelling – Create charts that a non‑technical audience can read.
6. Conclusion & Recommendations – What should the viewer do with the insight?

8. Document Everything

• Write a short “ReadMe” for each project that explains the goal, tools used, and key findings.
• Push the code and notebooks to a public GitHub repo.
• Export the final dashboards as PDFs or interactive web pages (Google Data Studio is free and easy).

9. Get Feedback

Share your projects with a friend in a different field or post them in a data‑focused Slack community (like r/learnpython). Ask for two concrete pieces of feedback and iterate.

Checkpoint: By week 8 you should have two polished projects live on GitHub, each with a clear business story and visual output.

Phase 4 – Polish & Position (Weeks 9‑12)

10. Build a Mini Portfolio Site

Use a simple static site generator like GitHub Pages or a free website builder. Include:

• A brief bio (your “why” statement from week 1).
• Links to the two projects with screenshots.
• A short “Skills” section listing Excel, SQL, Python, and any visualization tools you used.

11. Craft Your Data Analyst Narrative

Employ the classic “STAR” format (Situation, Task, Action, Result) to describe each project on your resume and LinkedIn. Example:

• Situation: Company X needed to understand monthly churn.
• Task: Analyze customer usage data to identify churn drivers.
• Action: Cleaned 200k rows with Python, built a churn prediction model, visualized key factors in Tableau.
• Result: Provided insights that reduced churn by 12% in the next quarter.

12. Targeted Job Search

• Identify 5‑10 companies that list “Data Analyst” or “Business Analyst” in their openings.
• Tailor your resume to each posting, swapping in the most relevant project.
• Prepare for common interview questions: “Explain a time you turned messy data into a clear insight,” or “How would you explain a statistical concept to a non‑technical stakeholder?”

13. Keep Learning, Keep Updating

The 90‑day sprint is just the start. Set a habit of spending 30 minutes each week on a new skill—maybe Power BI, basic machine learning, or storytelling with data. Add any new work to your portfolio, and you’ll stay ahead of the curve.

Final Thoughts

A 90‑day roadmap isn’t a magic bullet, but it gives you a clear path, measurable milestones, and a tangible showcase of what you can do. When you finish, you’ll have more than a certificate—you’ll have a story, a portfolio, and the confidence to walk into a data‑driven role.

Remember, learning is a journey, not a destination. The steps above are the first leg of yours. Keep the curiosity alive, and let the data guide you forward.