Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Data Analysis for Beginners: Excel, SQL & Real Insights
Rating: 3.7 out of 5(3 ratings)
914 students

Data Analysis for Beginners: Excel, SQL & Real Insights

Learn Excel, SQL, data cleaning, visualization & build a real project to become a job-ready data analyst
Created byData Science Academy, School of AI
Last updated 5/2026
English
English [Auto],

What you'll learn

  • Perform end-to-end data analysis using a real-world dataset
  • Clean and prepare messy data (handle missing values, duplicates, and formatting issues)
  • Use Excel for data analysis (functions, sorting, filtering, basic calculations)
  • Write SQL queries using SELECT, WHERE, ORDER BY, COUNT, SUM, and GROUP BY
  • Identify trends, patterns, and key insights from data
  • Create clear and effective visualizations using bar, line, and pie charts
  • Apply data storytelling techniques to communicate insights simply and clearly
  • Complete a portfolio-ready data analysis project to showcase skills

Course content

5 sections • 17 lectures • 3h 42m total length

  • 1.1 What is Data Analysis?9:14
  • 1.2 Types of Data9:58

    Learn to distinguish structured and unstructured data, and identify numerical versus categorical data, enabling you to choose the right methods in Excel, SQL, and beyond.

  • 1.3 Data Analyst Role & Workflow16:17

    Explore the data analyst role and the collect-clean-analyze-visualize workflow that turns raw data into actionable insights, using Excel, SQL, and Power BI.

Requirements

  • No prior experience in data analysis, Excel, or SQL is required
  • Basic computer skills (opening files, typing, using a browser)
  • A computer or laptop with internet access

Description

“This course contains the use of artificial intelligence”

In today’s data-driven world, data analysis is one of the most in-demand skills—and this course is your complete beginner-friendly path to mastering it.

This course is designed to take you from zero to confident data analyst using the most essential tools: Excel, SQL, and data visualization techniques. You won’t just learn theory—you’ll work on a real-world dataset and follow the exact workflow used by professional analysts.

We start with the foundations of data analysis, helping you understand how businesses use data to make decisions. Then, you’ll dive into Excel for data analysis, where you’ll learn how to explore datasets, use functions like SUM, AVERAGE, IF, and perform real data cleaning tasks.

Next, you’ll learn data cleaning and preparation, one of the most critical skills in analytics. You’ll handle missing data, duplicates, inconsistencies, and formatting issues—just like in real-world scenarios.

After that, we introduce SQL for beginners, where you’ll learn how to query data using SELECT, WHERE, ORDER BY, COUNT, SUM, and GROUP BY. This is a must-have skill for working with real company data.

Finally, you’ll move into data analysis, visualization, and storytelling, where you’ll learn how to identify trends, compare data, create charts, and present insights clearly.

To bring everything together, you’ll complete a final end-to-end project, where you will clean, analyze, visualize, and present your findings—creating a portfolio-ready project you can showcase.

By the end of this course, you won’t just understand data—you’ll know how to turn data into insights and decisions.

Who this course is for:

  • Beginners who want to learn data analysis from scratch with no prior experience
  • Students and graduates preparing for data analyst or business analyst roles
  • Professionals looking to switch into a data-driven career
  • Anyone who wants to learn Excel and SQL for real-world data analysis
  • Business users, managers, or entrepreneurs who want to make better data-driven decisions
  • Learners who prefer hands-on, practical learning with a real project

Report abuse