Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Master Data Analytics in SQL & Excel

Microsoft via Great Learning

Overview

The Data Analysis using SQL and Excel course provides the practical skills needed for data analytics, focusing on SQL and Excel for data manipulation, filtering, and aggregation. You’ll master advanced SQL techniques, including joins, subqueries, and window functions, enabling you to handle complex datasets. The course also teaches data visualization in Excel, allowing you to create actionable insights through charts and dashboards. Additionally, you’ll learn Exploratory Data Analysis (EDA) to summarize and visualize data, ensuring you can make informed, data-driven decisions.By the end of this course, you'll be able to analyze and visualize data using SQL and Excel to drive business insights. Hands-on projects will equip you with the skills to clean data, identify trends, and generate reports. You’ll apply these techniques to real-world scenarios like optimizing airline operations, improving retail performance, and analyzing global demographics. These skills will help you make impactful decisions, optimize processes, and solve complex problems in any data-driven role.

Syllabus

  • Introduction to Data Analytics
    • Basics of data analytics and it's phases
  • SQL Basics
    • Cleaning and validating data with Excel and SQL
  • Advanced SQL Techniques
    • Querying, filtering, aggregations, and joins in SQL.
  • Case Study : Playstore Ad Revenue
    • End-to-end Business Analytics Case Study on Playstore Ad Revenue
  • Guided SQL Project 1: DVD Rental Store
    • DVD Rental Store Project : Functional requirements and step-by-step guide
  • Guided SQL Project 2 : World Demographics and Economics
    • World Demographics and Economics Project : Functional requirements and step-by-step guide
  • Fundamentals of Excel in Data Analytics
    • Subqueries, window functions, and advanced aggregations
  • Data Handling and Analysis in Excel
    • Excel functions, conditional operations, and data manipulation
  • Data Cleaning, Analysis, and Visualization in Excel
    • Data Cleaning, Analysis, and Visualization in Excel
  • Exploratory Data Analysis (EDA)
    • Conducting univariate, bivariate, and multivariate analysis using Excel.
  • Guided Excel Project 1 : E-Commerce
    • E-Commerce Project : Functional requirements and step-by-step guide
  • Guided Excel Project 2 : Aviation Sector Analysis using Excel
    • Aviation Sector Analysis Project : Functional requirements and step-by-step guide
  • SQL Developer and Excel Specialist - Mock Interview
    • 2 Personalised Mock Interviews to help you land a SQL Developer or an Excel Specialist role

Taught by

Dr. Bradford Tuckfield, Denver Dias, and Gaelim Holland

Reviews

4.6 rating at Great Learning based on 57 ratings

Start your review of Master Data Analytics in SQL & Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.