Data & Analytics

Data & Analytics

  • 20 Hours
  • Intermediate
  • 4 Lessons
  • 4 Quizzes

COURSE DESCRIPTION

The Data & Analytics track gives you practical skills to work confidently with data—even if you’re not a data analyst. You’ll learn how to clean, interpret, and visualize data using accessible tools like Google Sheets, SQL, and Looker Studio.

Whether you’re building reports for work, launching your own business, or improving decision-making, this track helps you turn messy data into clear insights.

WHAT WILL I LEARN FROM THIS COURSE?

  • How to use Google Sheets for cleaning, filtering, and analyzing data
  • How to visualize insights through charts, dashboards, and reports
  • How to build dashboards in Looker Studio (formerly Google Data Studio)
  • How to write basic SQL queries to extract and summarize data
  • How to apply data literacy to real-world business problems
Module 1: Intro to Data Literacy - 4 Hours
  • What Is Data Literacy? Key Concepts and Terms
  • Types of Data and How to Work with Them
  • Understanding Data Quality and Sources
  • Thinking Critically with Data
  • Quiz: Data Types & Critical Thinking
  • Formulas, Filters, and Conditional Formatting
  • Pivot Tables and Charts
  • Data Cleanup Techniques
  • Project: Lightweight Sales Dashboard
  • Quiz: Google Sheets Functions & Analysis
  • Connecting Data Sources
  • Creating Pages, Scorecards, and Charts
  • Customizing Layout and Themes
  • Project: Build a Marketing or Ops Dashboard
  • Quiz: Dashboard Building & Visualization
  • SELECT, WHERE, GROUP BY, and JOIN Explained
  • Filtering, Aggregating, and Ordering Data
  • Writing Reusable Queries
  • Project: Run Business Reports from a Sample Database
  • Quiz: SQL Query Writing & Logic
Do I need to be “good at math” to take this course?

Not at all. This track focuses on practical tools and concepts—no complex math or statistics required.

Yes. Each module includes real projects, and you’ll leave with a complete set of dashboards and templates.

We cover SQL from the ground up. No prior experience is needed, and you’ll start with easy queries and build confidence quickly.

Many lessons will work in Excel too, but we focus on Sheets for accessibility and integration with Looker Studio.

Definitely. Data literacy is valuable across industries—from marketing to operations to finance—and can be a major professional advantage.

Yes. All lessons include downloadable spreadsheets and datasets so you can follow along and build your own versions.

$89.00

Empowering learners with practical, career-focused online courses in AI, data, coding, and digital tools. Learn at your pace—no fluff, just skills that matter.

Courses
Get Help

 Copyright © 2025 Master Tech Skills. All rights reserved.