Data Analytics Roadmap: A 5-Week, Novice-Friendly Path From Zero to Portfolio

 

If you are new to data analytics and feel overwhelmed by tools like Excel, SQL, Python, and Power BI, this roadmap is designed for you. In just about 5 weeks and 85 focused hours, you can go from complete beginner to having a real, end-to-end analytics project published on GitHub, your blog, and LinkedIn.​

Why This Roadmap Is Different

Most learning plans assume you already know some programming and can magically “pick up” Python while juggling multiple tools. This roadmap slows things down where beginners struggle the most and front-loads the foundation so you actually understand what you are doing instead of copy-pasting code.​

A few key design choices:

• A dedicated 5-hour Pre-Week for Python basics on Kaggle before the main schedule.​
• A novice-paced Python week with smaller concepts and no pressure to master every library.​
• One single capstone project that flows through Excel → SQL → Python → Power BI so your learning feels connected and cumulative.​

By the end, you will have:

• A polished Excel workbook, SQL scripts, Python notebooks, and a Power BI dashboard.​
• A structured GitHub repository showcasing your work.​
• A blog post and LinkedIn update that present your project like a mini case study.​

The Big Picture: 5 Weeks, 85 Hours

Here is how the journey is structured:​

• Pre-Week: Kaggle Python course – 5 hours
• Week 1: Excel + GitHub setup – 20 hours
• Week 2: SQL foundations – 20 hours
• Week 3: Python for data analytics (novice pace) – 20 hours
• Week 4: Power BI + publishing – 20 hours

You are not just learning tools in isolation; you are building a “Retail Sales Performance Dashboard & Insights” project using a beginner-friendly retail or superstore dataset from Kaggle. The same dataset is used everywhere, which makes the learning feel coherent instead of scattered.​

The Capstone Project: Retail Sales Performance

Throughout the roadmap, you work on one core problem: understanding and visualizing retail sales performance using a real-world style dataset. Think of questions like:​

• Which regions and product categories generate the most revenue?​
• How do sales and profit trend over time?​
• Which products or segments underperform and need attention?​

Your final project includes:​

• An Excel file with cleaned data, formulas, pivot tables, and charts.
• A SQL database with queries answering concrete business questions.
• A Python notebook that explores the data and creates bar and line charts.
• A Power BI dashboard with interactive visuals, KPI cards, and slicers.
• A GitHub repo with all files, a clear README, and screenshots.
• A blog post (500–800 words) walking through your process and insights.
• A LinkedIn post showcasing your dashboard and key findings.

This one project becomes the backbone of your portfolio and a strong story to tell in interviews or networking conversations.​

Pre-Week: Your Python Secret Weapon

Before the “official” four weeks start, you invest 5 hours in the free Kaggle Python course. It runs entirely in the browser, so you avoid painful installation issues and jump straight into writing code.​

Across three short sessions, you cover:

• Variables and basic data types (strings, integers, floats, booleans).​
• Functions, conditionals (if/elif/else), lists, and loops.​
• Dictionaries and working with external libraries – essential concepts for pandas later.​

By the end of this Pre-Week, Python is no longer a mystery. You know how to read error messages, write simple logic, and import libraries, which makes the later pandas and matplotlib work feel much more approachable.​

Week 1: Excel Foundations + GitHub Setup

Week 1 focuses on Excel as your first analytics tool and GitHub as your project home base. You start by setting up a GitHub account and repository, downloading your dataset, and getting comfortable committing your work regularly.​

Inside Excel, you learn to:

• Import CSV data, clean it, remove duplicates, and fix formatting issues.​
• Apply core formulas like IF, XLOOKUP/VLOOKUP, SUMIFS, and COUNTIFS.​
• Build pivot tables to summarize sales by region, product category, and month.​
• Create basic bar and line charts and use conditional formatting and slicers to make an interactive mini-dashboard.​

By the end of Week 1, you commit your Excel files and a short Week 1 summary with screenshots to GitHub. This simple habit of “build then publish” sets the tone for the rest of the roadmap.​

Week 2: SQL – Asking Better Questions

In Week 2, you move your dataset into a database and start querying it with SQL. Using a beginner-friendly tool like DB Browser for SQLite means you get a visual interface without touching the command line.​

You learn to:

• Create a database and import your data as a table.​
• Write SELECT, WHERE, ORDER BY, and LIMIT queries for filtering and sorting.​
• Use GROUP BY with SUM, AVG, COUNT, MAX, and MIN for aggregations.​
• Join multiple tables with INNER JOIN and LEFT JOIN.​
• Write subqueries and CTEs (WITH clauses) to break complex questions into smaller steps.​
• Experiment with window functions like RANK or ROW_NUMBER to find top products or regions.​

By the end of the week, you export interesting query results back to CSV, save your SQL scripts into a sql/ folder, and push everything to GitHub. This is where you start to think like an analyst, not just a tool user.​

Week 3: Python for Data Analytics (Novice Pace)

Week 3 is where your Pre-Week investment pays off. You install Anaconda, launch Jupyter, and create your first working notebook, taking the time to ensure everything is set up correctly before diving into pandas.​

Over the week, you:

• Load your dataset with pandas, explore it using head(), info(), describe(), and check for missing values.​
• Filter rows, select columns, sort data, and handle missing values with dropna and fillna.​
• Group data with groupby to replicate and extend the aggregations you did in SQL.​
• Use matplotlib to build clean bar and line charts that highlight trends and comparisons.​

One powerful habit here is adding markdown notes in your notebooks. Above each code block, you write one or two sentences explaining what the cell does and why it matters, turning your notebook into an understandable story instead of a wall of code. At the end of the week, you clean up your notebooks, screenshot key charts, and push everything to the python/ folder in GitHub.​

Week 4: Power BI and Publishing Your Work

The final week is all about polishing your insights and sharing them with the world. You bring your cleaned data into Power BI, design an interactive dashboard, and then package the entire journey into a portfolio-friendly format.​

In Power BI, you:

• Connect to your cleaned CSV and use Power Query for final transformations.​
• Build a simple data model with relationships and calculated columns.​
• Create core DAX measures like SUM, CALCULATE, and DIVIDE for KPIs.​
• Design two dashboard pages with bar and line charts, KPI cards, slicers, drill-throughs, and a consistent color theme.​

Then you:

• Export dashboard screenshots and (optionally) publish to the Power BI Service.​
• Polish your GitHub README with a project overview, key insights, and images.​
• Write and publish a blog post explaining the problem, tools, process, and findings in 500–800 words.​
• Post a concise LinkedIn update with your top 2–3 insights and links to your GitHub and blog.​

This week transforms your work from a private learning exercise into a public portfolio.​

Habits and Mindset: How to Succeed as a Novice

Tools matter, but your mindset and habits matter more. A few principles run through this roadmap:​

• Errors are normal: treat them as feedback, not failure, and read error messages slowly before searching for help.​
• Time buffers: always keep an extra 15 minutes per session for things that take longer than expected.​
• Daily reflection: end every session by writing one sentence starting with “Today I learned that…”.​
• Commit often: push to GitHub at the end of each session, even if things feel messy.​
• Share in public: post small updates (for example, your SQL progress at the end of Week 2) instead of waiting for perfection on Day 30.​

In about a month, this roadmap helps you go from “I don’t know where to start” to “Here is my complete project, live on GitHub, with a blog post and dashboard to prove it.” Start the Kaggle Python course, pick your retail dataset, and take the first small step today.