Data Analytics is one of the hottest, most in-demand fields in technology. It’s a high-paying career that is open to people from all backgrounds because it relies on logic and critical thinking, not just a specific degree. But many people are stopped by the perceived cost. They see expensive bootcamps and online courses and believe they can’t afford to get started.
This is a myth. You don’t need an expensive program to become a data analyst. All you truly need is a laptop, an internet connection, and a disciplined plan. The tools are free. The datasets are free. The knowledge is free.
What you’re missing is a roadmap. This article will provide that. This is a 90-day, project-based plan to learn the fundamentals of Data Analytics for free. If you can commit to this plan and, most importantly, do the projects, you will have a job-ready portfolio in three months.
The Philosophy: Projects Over Certificates
Before we start, you must adopt this mindset. This plan is not about watching videos. It’s about building things. A recruiter will never hire you because you have a certificate; they will hire you because you have a portfolio that proves you can do the work. Each 30-day block in this plan is designed to produce one high-quality project for your portfolio.
Month 1 (Days 1-30): Master the Spreadsheet (Excel / Google Sheets)
The Goal: To learn the fundamental tool and, more importantly, to learn how to “think” like an analyst. Spreadsheets are the foundation of all data analysis. Do not skip this step, even if you think you “know” Excel. The Curriculum:
- Data Cleaning: Learn functions like
TRIM,PROPER,LEFT/RIGHT, and “Text to Columns.” - Data Lookups: Master
VLOOKUPand, more importantly, the more powerfulINDEX(MATCH). - Data Aggregation: This is the most critical part. Master Pivot Tables. Learn how to group, filter, and summarize data to answer questions.
- Data Visualization: Learn how to create clean, clear, and effective charts (bar charts, line charts, pie charts).
The Free Resources:
- YouTube Channels: “ExcelIsFun” is a legendary resource with thousands of videos. “Chandoo” is another excellent one.
- Google’s Official Documentation: Google’s help center for Sheets is surprisingly comprehensive.
The Portfolio Project:
- Find a Dataset: Go to a site like Kaggle or Makeover Monday. Find a “dirty” dataset (e.g., world population data, e-commerce sales, or movie box office numbers).
- Define Your Questions: Before you start, write down 5 business questions you want to answer (e.g., “Which movie genre was most profitable in the last 10 years?”).
- Execute:
- Clean the messy dataset in one tab.
- Analyze the data using Pivot Tables in a second tab.
- Build a simple, one-page dashboard with 3-5 charts that clearly answer your 5 questions.
- Save this file. It is Project #1.
Month 2 (Days 31-60): Learn a BI Visualization Tool (Google Looker Studio)
The Goal: To learn how to tell a powerful, interactive story with data. While Tableau and Power BI are industry standards, Google’s Looker Studio (formerly Data Studio) is completely free, web-based, and incredibly powerful. The Curriculum:
- Connecting Data: Learn how to connect your Google Sheet from Month 1 into Looker Studio.
- Building Charts: Explore the different chart types (bar, line, scatter, maps, scorecards).
- Creating Interactivity: This is the magic. Learn to add “Controls” like date filters and drop-down menus that allow the user to explore the data themselves.
- Dashboard Design: Learn the basics of good design: alignment, use of color, and clear labeling.
The Free Resources:
- Google’s Analytics Academy: Google provides free courses on how to use its tools, including Looker Studio.
- YouTube: Search for “Looker Studio beginner tutorial” for hundreds of high-quality guides.
The Portfolio Project:
- Use Your Dataset: Take the same dataset you cleaned in Month 1.
- Execute: Rebuild your Excel dashboard in Looker Studio, but make it better.
- Add at least two interactive filters (e.g., let the user filter by “Year” or “Country”).
- Include a “Scorecard” showing a key metric (e.g., “Total Revenue”).
- Design it to be a clean, professional, one-page report.
- Save the public link. This is Project #2.
Month 3 (Days 61-90): Learn the Language of Data (SQL)
The Goal: To learn how to retrieve data from databases. This is a non-negotiable skill for any serious data analyst. It’s what separates the beginners from the professionals. The Curriculum:
- The Basics:
SELECT,FROM,WHERE,ORDER BY. - Aggregation:
GROUP BY,COUNT,SUM,AVG. - The Big One:
JOINs. Learn how to combine data from multiple tables (INNER JOIN,LEFT JOIN). - Filtering:
HAVINGvs.WHERE.
The Free Resources:
- W3Schools: Provides interactive tutorials where you can write and run SQL queries directly in your browser.
- SQLZoo: Another fantastic, free, interactive learning platform.
- Mode’s SQL Tutorial: A very well-regarded, free tutorial that is beginner-friendly.
The Portfolio Project:
- Use a Free Database: Use one of the sample databases on W3Schools or SQLZoo.
- Define Your Questions: Write down 10 business questions that would require you to query the database (e.g., “Which 5 customers had the highest total sales in 2024?”).
- Execute:
- Write the 10 SQL queries that answer these questions.
- Create a simple document or PDF. For each question, include the question itself, the SQL query you wrote, and the result/answer.
- This document proves you can understand a business question and translate it into a technical query.
- Save this document. This is Project #3.
You Are Now a Data Analyst
By Day 90, you are no longer an “aspiring” analyst. You are a Data Analyst with a 3-project portfolio. You have proven you can clean data in Excel, visualize it in a BI tool, and query it from a database. This portfolio is now your CV. You are ready to start applying for jobs. No excuses.
Did you gain value from this? love this post, comment, follow DEXA and share to read more like this from me to help your tech journey.
Want to learn a tech skill? Go to DEXA and enroll now: www.learnwithdexa.com