Understand what data analysis is
Learn what analysts do and how data helps people make decisions.
Learn Data with Debby
A simple learning path for complete beginners.
This space helps beginners understand data analysis in a simple, practical, and structured way through guides, tutorials, and datasets.
Beginner roadmap
Start here if you are new to data analysis.
These lessons teach the basic skills you need before moving into full tutorials and dashboard projects.
Learn Excel for data analysis
Clean, organize, calculate, summarize, and visualize data.
Learn SQL and Power BI
Query data, create visuals, and build reports that communicate clearly.
Practice with real datasets
Build confidence by applying what you learn independently.
Guided tutorials
Step-by-step tutorials to help you apply what you learn.
Excel Basics for Data Analysis
Start with the basic Excel skills every beginner analyst needs.
Read lessonBeginner Tutorial: Sales Data Analysis
Use a sales dataset to practice cleaning, analysis, and insight generation.
Read tutorialBeginner Tutorial: Excel Dashboard Creation
Learn how to turn spreadsheet analysis into a clear dashboard.
Read tutorialPower BI Basics for Beginners
Understand visuals, reports, and the basics of dashboard building.
Read tutorialBeginner Tutorial: Power BI Dashboard
Build a practical dashboard and learn how to present insights.
Read tutorialSQL for Beginners (MySQL)
Learn how to query databases and answer business questions with SQL.
Read tutorialExcel basics
Excel Basics for Data Analysis
This section is designed for complete beginners who have never used Excel before. Before moving to data analysis, you need to understand the basic tools in Excel.
Understanding Excel
Excel is made up of rows, columns, and cells.
- Rows are horizontal.
- Columns are vertical.
- Cells are where data is stored.
- Each cell has an address, such as A1 or B2.
Entering Data
You can enter text, numbers, or dates into Excel.
- Click on any cell.
- Type your value.
- Press Enter.
Basic Formulas
A formula is used to perform calculations. The equal sign is very important in Excel because formulas must begin with =.
- Click on an empty cell.
- Type
=SUM(. - Select the numbers you want to add.
- Close the bracket with
). - Press Enter.
Sorting Data
Sorting helps you organize your data in a clear order.
- Select your dataset.
- Go to the Data tab.
- Click Sort.
Filtering Data
Filtering helps you view only the specific data you need.
- Select your dataset.
- Click Filter.
- Choose what you want to display.
Excel tutorial
Beginner Tutorial: Sales Data Analysis
Learn how to analyze a Superstore Sales dataset step by step using Microsoft Excel. This tutorial covers cleaning, analysis, simple visualizations, and insight generation.
Watch the Loom tutorialOpen and understand the dataset
Observe important columns such as Order ID, Product Name, Sales, Profit, Discount, Category, Quantity, and Segment.
Clean the data
Check for empty cells, correct data types, duplicate records, and clear column headers before analyzing the data.
Calculate totals
Use formulas like =SUM( to calculate total sales,
total quantity, and other key values.
Use PivotTables
Create PivotTables to find top products and analyze category performance.
Generate insights
Identify top products, analyze category performance, create a simple chart, and summarize your findings.
Excel dashboard
Excel Dashboard Tutorial for Beginners | Pivot Tables, Charts & Data Analysis
Learn how to create a beginner-friendly Excel dashboard using pivot tables, charts, slicers, and clear dashboard layout.
Watch on YouTubePrepare your data
Ensure every column has a clear header and remove empty rows.
Create a PivotTable
Use Category in Rows and Revenue in Values to summarize performance.
Create charts
Use column charts to compare categories and see performance clearly.
Design your dashboard
Arrange charts on one sheet and add titles, labels, and clear spacing.
Power BI basics
Power BI Basics for Beginners
Power BI helps you analyze data and create dashboards that turn raw information into meaningful visuals and insights.
Understand the interface
Learn the ribbon, report view, data view, model view, fields panel, and visualizations panel.
Import and transform data
Use Get Data, then clean your dataset in Power Query before analysis.
Create measures
Create calculations such as Total Sales, Total Profit, and Total Quantity.
Build visuals
After cleaning and measures, you are ready to create reports and dashboards.
Power BI dashboard
Beginner Tutorial: Power BI Dashboard
Build a dashboard with key metric cards, category charts, sales trends, region profit visuals, and slicers for interaction.
Key metrics
Create cards for Total Sales, Total Profit, Total Quantity, and Total Discount.
Charts and trends
Create category charts, sub-category charts, and a line chart for sales trends.
Add slicers
Use slicers for Region, Category, and Order Date so users can explore the data.
Tell a story
Use your dashboard to answer questions about sales, profit, discounts, and trends.
SQL tutorial
SQL for Beginners (MySQL)
SQL helps data analysts retrieve, filter, sort, and summarize data from databases.
Basic SQL flow
- SELECT chooses columns.
- FROM chooses the table.
- WHERE filters rows.
- GROUP BY groups data.
- HAVING filters grouped data.
- ORDER BY sorts results.
SELECT Category, SUM(Sales)
FROM superstore
GROUP BY Category
HAVING SUM(Sales) > 1000
ORDER BY SUM(Sales) DESC;Practice datasets