Tessorio Library · Premium

Data Analytics with Excel and SQL: From Raw Data to Answers

data analyticsspreadsheetsSQLcareer skills20 lessons · Adult beginner — no prior data, coding or math beyond arithmetic
Unit 1

The Analyst's Job and the Six Steps

A Week in the Life of an Entry-Level Analyst (and the Three Portfolio Pieces That Get You Hired)
07:32You will describe what an entry-level data analyst actually does Monday to Friday, name the tools and work samples employers ask for, and write your own step-by-step route from today to a first job application.
Ask, Prepare, Process, Analyze, Share, Act: Sorting Coffee Shop Tasks Into the Six Steps
08:48Comes with a paid plan
Turning "Sales Feel Down Lately" Into One Answerable Question
10:46Comes with a paid plan
Unit 2

Getting the Coffee Shop Data Clean

Reading a Raw Sales Export: Grain and Red Flags
07:52Comes with a paid plan
Fixing Duplicates, Stray Text, Dates and Dollar Signs
10:46Comes with a paid plan
The Six Blank Quantities: Deciding and Logging Your Choices
07:49Comes with a paid plan
Unit 3

Spreadsheet Answers: Formulas, Lookups and Pivot Tables

Adding Up Only the Lattes: SUM, AVERAGE, COUNTIF and SUMIF
10:47Comes with a paid plan
IF Labels and the $ That Locks a Cell
07:35Comes with a paid plan
Pulling in Each Item's Category with VLOOKUP
10:41Comes with a paid plan
Building a Pivot Table That Answers "Which Hour Is Busiest?"
10:25Comes with a paid plan
Unit 4

Asking the Database: SELECT to JOIN

Tables, Rows and Columns: Your First SELECT and WHERE
10:39Comes with a paid plan
Biggest First, Top 20 Only: ORDER BY and LIMIT
08:36Comes with a paid plan
One Row Per Item: GROUP BY, COUNT, SUM, AVG and HAVING
11:07Comes with a paid plan
Matching Two Tables: INNER JOIN, LEFT JOIN and Counting the Rows
10:35Comes with a paid plan
Unit 5

Numbers That Tell the Truth

Five Numbers That Describe a Week of Coffee Sales
11:51Comes with a paid plan
Why That $9.80 Average Slide Isn't Safe
11:10Comes with a paid plan
Unit 6

Charts and a Dashboard That Answer the Question

Line, Bar, Stacked or Scatter: Matching the Chart to the Coffee Shop Question
11:25Comes with a paid plan
One Screen for 'Should I Add a Second Barista?'
07:38Comes with a paid plan
Unit 7

Case Study: One Question, Start to Finish

Chasing One Question: "Why Are Our Afternoons Quiet?"
11:14Comes with a paid plan
The 200-Word Finding: Evidence, Limits and a 30-Day Measure
08:17Comes with a paid plan