𝗙𝗥𝗘𝗘 𝗗𝗔𝗧𝗔 𝗔𝗡𝗔𝗟𝗬𝗧𝗜𝗖𝗦 𝗧𝗢𝗢𝗟𝗦 𝗚𝗨𝗜𝗗𝗘

From SQL and Python to Excel, free datasets, projects, and beyond , covering everything you need to learn and build real-world skills.

Abhisek Sahu

Jun 11, 2026

Hey, here is the complete free tools guide

This guide will help you understand:

• What each tool does
• When to use each tool
• What to learn first
• Free resources
• Beginner project ideas

If you are starting Data Analytics, do not try to learn every tool at once.

Start with this order:

Excel
SQL
Power BI or Tableau
Python
Pandas
Looker Studio
Jupyter Notebook
GitHub

Don’t Miss these Sections

→ WHICH TOOL SHOULD YOU USE?
→ BEGINNER TOOL LEARNING ORDER
→ SIMPLE 8-WEEK TOOLS ROADMAP
→ BEST BEGINNER PROJECTS
→ DATASETS FOR PRACTICE

𝗧𝗢𝗢𝗟 𝟭: 𝗘𝗫𝗖𝗘𝗟

Excel is the easiest tool to start with.

It helps you clean, organize, calculate, and summarize data without coding.

Use Excel for:

• Quick analysis
• Small datasets
• Basic reports
• Pivot tables
• Charts
• Simple dashboards
• Business summaries

Learn these topics:

• Formulas
• Sorting
• Filtering
• Conditional formatting
• Pivot tables
• VLOOKUP / XLOOKUP
• Charts
• Data cleaning
• Basic dashboards

Free resources:

Microsoft Excel Training
https://support.microsoft.com/en-us/excel

ExcelIsFun YouTube Channel
https://www.youtube.com/@excelisfun

Practice project:

Create a monthly sales report with total revenue, top products, best region, and monthly sales trend.

𝗧𝗢𝗢𝗟 𝟮: 𝗚𝗢𝗢𝗚𝗟𝗘 𝗦𝗛𝗘𝗘𝗧𝗦

Google Sheets is a cloud-based spreadsheet tool.

It is useful when you want to work with others, share reports, and update data online.

Use Google Sheets for:

• Team collaboration
• Simple tracking
• Shared reports
• Live dashboards
• Lightweight data analysis
• Client reporting

Learn these topics:

• Formulas
• Sorting
• Filtering
• Charts
• Data validation
• Pivot tables
• Sharing permissions
• Basic dashboards

Free resources:

Google Sheets Training
https://support.google.com/a/users/answer/9282959

Google Sheets Help
https://support.google.com/docs/topic/9054603

Practice project:

Create a shared expense tracker or weekly business performance tracker.

𝗧𝗢𝗢𝗟 𝟯: 𝗦𝗤𝗟

SQL is used to get data from databases.

Most company data is stored in tables, and SQL helps you filter, join, group, and calculate that data.

Use SQL for:

• Database work
• Large datasets
• Sales analysis
• Customer analysis
• Revenue reports
• User behavior analysis
• Dashboard data preparation

Learn these topics:

• SELECT
• WHERE
• ORDER BY
• GROUP BY
• COUNT
• SUM
• AVG
• JOINS
• Subqueries
• Window functions

Free resources:

SQLBolt
https://sqlbolt.com/

Mode SQL Tutorial
https://mode.com/sql-tutorial/

W3Schools SQL
https://www.w3schools.com/sql/

HackerRank SQL Practice
https://www.hackerrank.com/domains/sql

DataLemur SQL Questions
https://datalemur.com/questions

Thanks for reading! This post is public so feel free to share it.

Practice project:

Analyze customer orders and find total revenue, repeat customers, best products, and monthly growth.

𝗧𝗢𝗢𝗟 𝟰: 𝗣𝗢𝗪𝗘𝗥 𝗕𝗜

Power BI is used to build interactive business dashboards.

It is popular in companies because it connects well with Excel, Microsoft tools, databases, and cloud platforms.

Use Power BI for:

• Business dashboards
• KPI tracking
• Management reports
• Sales reports
• Finance dashboards
• Operations dashboards
• Regular business reporting

Learn these topics:

• Importing data
• Cleaning data in Power Query
• Data modeling
• Relationships
• DAX basics
• Charts
• Filters
• Slicers
• Dashboard publishing

Free resources:

Microsoft Learn Power BI
https://learn.microsoft.com/en-us/training/powerplatform/power-bi

Power BI Desktop
https://www.microsoft.com/en-us/download/details.aspx?id=58494

Power BI Learning
https://www.microsoft.com/en-us/power-platform/products/power-bi/learning

Practice project:

Build a sales dashboard with revenue, profit, top products, monthly trend, and region-wise performance.

𝗧𝗢𝗢𝗟 𝟱: 𝗧𝗔𝗕𝗟𝗘𝗔𝗨

Tableau is used to create clean, visual, and presentation-ready dashboards.

It is great for storytelling and portfolio projects.

Use Tableau for:

• Visual dashboards
• Data storytelling
• Business presentations
• Portfolio projects
• Public dashboards
• Exploring patterns visually

Learn these topics:

• Connecting data
• Dimensions and measures
• Charts
• Filters
• Calculated fields
• Dashboards
• Storytelling
• Publishing to Tableau Public

Free resources:

Tableau Public
https://public.tableau.com/

Tableau Free Training
https://www.tableau.com/learn/training

Tableau Learning
https://www.tableau.com/learn

Tableau Public How-To Videos
https://public.tableau.com/app/learn/how-to-videos

Practice project:

Create a public dashboard on sales, Netflix movies, sports data, or customer analysis.

𝗧𝗢𝗢𝗟 𝟲: 𝗟𝗢𝗢𝗞𝗘𝗥 𝗦𝗧𝗨𝗗𝗜𝗢

Looker Studio is a free dashboard and reporting tool from Google.

It is useful for marketing, website, SEO, and client reports.

Use Looker Studio for:

• Marketing dashboards
• Website reports
• Google Analytics reports
• Search Console reports
• Client dashboards
• Shareable online reports
• Simple BI dashboards

Learn these topics:

• Connecting data sources
• Charts
• Scorecards
• Filters
• Date controls
• Blended data
• Report sharing
• Dashboard design

Free resources:

Looker Studio
https://lookerstudio.google.com/

Looker Studio Help
https://cloud.google.com/looker-studio

Looker Studio Support
https://developers.google.com/data-studio/support

Practice project:

Create a website performance dashboard using Google Analytics, Search Console, or Google Sheets data.

𝗧𝗢𝗢𝗟 𝟳: 𝗣𝗬𝗧𝗛𝗢𝗡

Python is used for data cleaning, automation, analysis, visualization, and machine learning.

It gives you more flexibility than spreadsheets.

Use Python for:

• Messy data cleaning
• Repeated analysis
• Automation
• Large files
• Custom calculations
• Data visualization
• Machine learning later

Learn these topics:

• Variables
• Lists
• Dictionaries
• Loops
• Functions
• If-else logic
• File handling
• Basic libraries
• Working with CSV files

Free resources:

Kaggle Python
https://www.kaggle.com/learn/python

freeCodeCamp Python Course
https://www.youtube.com/watch?v=rfscVS0vtbw

Python Official Tutorial
https://docs.python.org/3/tutorial/

Google Colab
https://colab.research.google.com/

Practice project:

Write a Python script that reads a sales file and calculates total sales, average order value, and top products.

𝗧𝗢𝗢𝗟 𝟴: 𝗣𝗔𝗡𝗗𝗔𝗦

Pandas is a Python library for working with table-like data.

It helps you clean, filter, merge, transform, and analyze datasets.

Use Pandas for:

• CSV analysis
• Excel file analysis
• Data cleaning
• Exploratory data analysis
• Grouping data
• Merging datasets
• Creating new columns
• Preparing data for dashboards or ML

Learn these topics:

• Read CSV files
• Read Excel files
• Select rows and columns
• Filter data
• Handle missing values
• Remove duplicates
• Group data
• Merge datasets
• Create new columns

Free resources:

Kaggle Pandas
https://www.kaggle.com/learn/pandas

Pandas Documentation
https://pandas.pydata.org/docs/

Pandas User Guide
https://pandas.pydata.org/docs/user_guide/index.html

Practice project:

Clean a messy customer dataset and create a summary of customer segments, revenue, and missing values.

𝗧𝗢𝗢𝗟 𝟵: 𝗝𝗨𝗣𝗬𝗧𝗘𝗥 𝗡𝗢𝗧𝗘𝗕𝗢𝗢𝗞 / 𝗚𝗢𝗢𝗚𝗟𝗘 𝗖𝗢𝗟𝗔𝗕

Jupyter Notebook lets you write Python code, charts, and notes in one place.

Google Colab is a free browser-based notebook tool.

Use notebooks for:

• Python practice
• Data analysis projects
• Step-by-step explanations
• EDA projects
• Machine learning practice
• Portfolio notebooks
• Sharing analysis process

Learn these topics:

• Code cells
• Markdown notes
• Importing files
• Running Python code
• Creating charts
• Explaining insights
• Saving notebooks

Free resources:

Google Colab
https://colab.research.google.com/

Jupyter Notebook
https://jupyter.org/

Kaggle Notebooks
https://www.kaggle.com/code

Practice project:

Create a notebook that explains a sales analysis from data loading to final insights.

𝗧𝗢𝗢𝗟 𝟭𝟬: 𝗚𝗜𝗧𝗛𝗨𝗕

GitHub helps you store, organize, and share your data projects.

It is important for building a professional portfolio.

Use GitHub for:

• Portfolio projects
• Sharing code
• Storing notebooks
• Writing project documentation
• Tracking changes
• Showing your work to recruiters
• Building credibility

Learn these topics:

• Repositories
• README files
• Uploading files
• Commit basics
• Project folders
• GitHub profile
• Sharing project links

Free resources:

GitHub Skills
https://skills.github.com/

GitHub Learn
https://learn.github.com/

GitHub Docs
https://docs.github.com/

Practice project:

Upload one complete data analysis project with a clean README, dataset link, notebook, screenshots, and final insights.

𝗪𝗛𝗜𝗖𝗛 𝗧𝗢𝗢𝗟 𝗦𝗛𝗢𝗨𝗟𝗗 𝗬𝗢𝗨 𝗨𝗦𝗘?

Use Excel when:

• You need quick analysis
• Dataset is small
• You need simple reports
• You are just starting

Use SQL when:

• Data is stored in databases
• Dataset is large
• You need business metrics
• You need to join tables

Use Power BI when:

• You need business dashboards
• Managers need regular reports
• Company uses Microsoft tools
• You want interactive visuals

Use Tableau when:

• You want polished dashboards
• You want strong visual storytelling
• You want portfolio-ready work
• You want to publish dashboards online

Use Python when:

• Data is messy
• Work needs automation
• Analysis is repetitive
• You want advanced analysis later

Use Pandas when:

• You work with CSV or Excel files in Python
• You need data cleaning
• You need custom analysis
• Excel feels limited

Use Looker Studio when:

• You need free online dashboards
• You work with Google tools
• You create client reports
• You want easy sharing

Use Jupyter / Colab when:

• You are learning Python
• You want step-by-step analysis
• You are building portfolio notebooks
• You want to explain your process

Use GitHub when:

• You want to showcase projects
• You need a portfolio
• You want to share code
• You want recruiters to see your work

𝗕𝗘𝗚𝗜𝗡𝗡𝗘𝗥 𝗧𝗢𝗢𝗟 𝗟𝗘𝗔𝗥𝗡𝗜𝗡𝗚 𝗢𝗥𝗗𝗘𝗥

Follow this order:

Excel
SQL
Power BI or Tableau
Python basics
Pandas
Jupyter / Google Colab
GitHub
Looker Studio

Do not learn all tools at once.

Learn one tool, build one small project, then move to the next.

𝗦𝗜𝗠𝗣𝗟𝗘 𝟴-𝗪𝗘𝗘𝗞 𝗧𝗢𝗢𝗟𝗦 𝗥𝗢𝗔𝗗𝗠𝗔𝗣

𝗪𝗲𝗲𝗸 𝟭: 𝗘𝘅𝗰𝗲𝗹 𝗕𝗮𝘀𝗶𝗰𝘀

Learn formulas, sorting, filtering, charts, and pivot tables.

Resource:

Microsoft Excel Training
https://support.microsoft.com/en-us/excel

Project:

Create a simple sales summary report.

𝗪𝗲𝗲𝗸 𝟮: 𝗦𝗤𝗟 𝗕𝗮𝘀𝗶𝗰𝘀

Learn SELECT, WHERE, GROUP BY, ORDER BY, and basic aggregations.

Resource:

SQLBolt
https://sqlbolt.com/

Project:

Analyze customer orders using SQL.

𝗪𝗲𝗲𝗸 𝟯: 𝗦𝗤𝗟 𝗝𝗢𝗜𝗡𝗦 + 𝗣𝗿𝗮𝗰𝘁𝗶𝗰𝗲

Learn INNER JOIN, LEFT JOIN, subqueries, and window functions.

Resources:

Mode SQL Tutorial
https://mode.com/sql-tutorial/

DataLemur SQL Questions
https://datalemur.com/questions

Project:

Join customer, order, and product tables to create business insights.

𝗪𝗲𝗲𝗸 𝟰: 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗼𝗿 𝗧𝗮𝗯𝗹𝗲𝗮𝘂

Choose one dashboard tool first.

Resources:

Power BI Learning
https://learn.microsoft.com/en-us/training/powerplatform/power-bi

Tableau Training
https://www.tableau.com/learn/training

Project:

Create a dashboard with KPIs, charts, filters, and insights.

𝗪𝗲𝗲𝗸 𝟱: 𝗣𝘆𝘁𝗵𝗼𝗻 𝗕𝗮𝘀𝗶𝗰𝘀

Learn variables, lists, dictionaries, loops, functions, and file handling.

Resource:

Kaggle Python
https://www.kaggle.com/learn/python

Project:

Create a simple Python script to calculate sales metrics.

𝗪𝗲𝗲𝗸 𝟲: 𝗣𝗮𝗻𝗱𝗮𝘀

Learn CSV files, filtering, grouping, missing values, and data cleaning.

Resource:

Kaggle Pandas
https://www.kaggle.com/learn/pandas

Project:

Clean and analyze a messy dataset.

𝗪𝗲𝗲𝗸 𝟳: 𝗝𝘂𝗽𝘆𝘁𝗲𝗿 / 𝗚𝗼𝗼𝗴𝗹𝗲 𝗖𝗼𝗹𝗮𝗯

Learn how to write code, notes, charts, and explanations together.

Resource:

Google Colab
https://colab.research.google.com/

Project:

Create a complete analysis notebook with explanation and charts.

𝗪𝗲𝗲𝗸 𝟴: 𝗚𝗶𝘁𝗛𝘂𝗯 𝗣𝗼𝗿𝘁𝗳𝗼𝗹𝗶𝗼

Learn how to upload and document your projects.

Resource:

GitHub Skills
https://skills.github.com/

Project:

Upload 2-3 projects with README files and screenshots.

𝗕𝗘𝗦𝗧 𝗕𝗘𝗚𝗜𝗡𝗡𝗘𝗥 𝗣𝗥𝗢𝗝𝗘𝗖𝗧𝗦

Excel Sales Report
Tools: Excel
Goal: Analyze monthly sales, revenue, product performance, and region performance.
SQL Customer Analysis
Tools: SQL
Goal: Find top customers, repeat buyers, revenue trends, and product demand.
Power BI Sales Dashboard
Tools: Power BI
Goal: Build an interactive dashboard for business tracking.
Tableau Portfolio Dashboard
Tools: Tableau Public
Goal: Create a clean public dashboard for your portfolio.
Python Data Cleaning Project
Tools: Python + Pandas
Goal: Clean missing values, remove duplicates, and summarize data.
Looker Studio Marketing Report
Tools: Looker Studio
Goal: Create a simple client-style marketing dashboard.
GitHub Portfolio Project
Tools: GitHub
Goal: Upload your project with README, dataset link, screenshots, and insights
Thanks for reading! Subscribe for free to receive new posts and support my work.
.