Data Analysis from Excel to SQL
Transform messy raw spreadsheets into automated models, interactive dashboards, and robust database queries. Learn to clean data in Power Query, calculate metrics in DAX, and extract answers with SQL.
Like Duolingo, but for Data Analysis from Excel to SQL. Tomo turns the whole topic into a game you play five minutes a day, until it actually sticks.
25 levels across 3 sections, about 50 minutes end to end, roughly 10 days at five minutes a day. It moves through Automating Spreadsheets and Cleaning Messy Data, Modeling and Visualizing in Power BI, and Querying Relational Databases with SQL. It starts from scratch.
Free forever · No credit card · iPhone & Android
Key ideas in Data Analysis from Excel to SQL
- XLOOKUP can look to the left of the lookup column without restructuring data
- XLOOKUP has a built-in argument to return a fallback value when no match exists instead of an error code
- Dynamic formulas automatically spill their output into neighboring rows and columns
- Dragging formulas down manually can cause calculation overlaps or block spill behavior
- Structured table formulas use column names instead of fixed cell coordinates like A2:A100
- Appending new rows to an official Excel table automatically expands the table boundaries and recalculates formulas
- Checking for blank or invalid values first lets you flag or exclude them before running math operations
- Unscreened text or zero-division errors in raw rows propagate upward and break downstream totals like SUM or AVERAGE
- Keeping raw records untouched ensures an audit trail and prevents accidental edits while typing formulas
- Separating calculations from source data keeps summary reports clean and reliable as new source files arrive
- Power Query reads raw data and records transformation steps without overwriting source files
- Raw spreadsheets stay completely intact even if you remove or edit columns in the editor
- Analysis tools like pivot tables require one column for category names and one for values rather than separate columns per month
- Unpivoting transforms wide cross-tab reports into tall rows with dedicated attribute and value columns
- Merging connects two tables side-by-side based on a shared matching column like an ID
- Merge queries replaces brittle, formula-based lookups across separate sheets
You've tried the other tabs
Thirty open tabs. Four facts you actually kept.
You watched. You nodded. By Sunday it was gone.
One answer, then back to scrolling.
Eight weeks. You meant to finish. You didn't.
Tomo gives Data Analysis from Excel to SQL the Duolingo treatment: levels, streaks, and quick quizzes that test what you just learned. That game loop is what the tabs above never had, so it's the one you actually finish.
Here's what playing it feels like
A real question from this course. Take your best guess.
What happens in XLOOKUP if a customer ID isn't found and you want to show 'Unknown' instead of an ugly error?
Get it right to open this lesson and 24 more in the app.
Where Data Analysis from Excel to SQL takes you
- 1
Automating Spreadsheets and Cleaning Messy Data
- Modern Lookup and Dynamic Logic in Excel
- Automating Data Cleanup with Power Query
- 2
Modeling and Visualizing in Power BI
- Structuring the Star Schema Data Model
- Calculating Business Metrics with DAX
- Designing Interactive Decision Dashboards
- 3
Querying Relational Databases with SQL
- Extracting and Filtering Records with SQL
- Aggregating and Grouping Data for Insights
- Joining Relational Tables
3 sections · 8 units · 25 levels. Built to play, not to enroll.
You pick the voice
Data Analysis from Excel to SQL is taught in the The Bestie style: your friend who just gets it. Want a different feel? In the app you can spin up the same topic in any of Tomo's teaching styles. Same facts, totally different vibe.
More Technology on Tomo
Spreadsheets in Practice: Real-World Data
Bridge the gap between basic cell entry and functional data management. Learn to clean messy inputs, reconcile records, and build reliable models for school administration and financial tracking.
Resilient Excel Spreadsheets
Upgrade from fragile, manual spreadsheets to modern, dynamic workbooks. Learn to replace nested IFs, retire brittle lookups with XLOOKUP, and build self-updating models using dynamic arrays and structured tables.
Everyday Excel
Stop wrestling with unruly spreadsheets. Learn how to write reliable formulas, fix common calculation blunders, and turn raw lists into clean, actionable summaries.
Everyday Excel
Stop doing repetitive manual data entry and let the spreadsheet work for you. Learn the essential formulas, cleanup tricks, and summary tools to turn messy numbers into clear answers fast.
Mastering Maps with QGIS
Stop just looking at maps and start building them. Learn to track weather patterns, analyze local changes, and solve real-world problems using the world's most powerful free mapping tool.
Business Automation with n8n
Move beyond simple triggers to build complex, AI-powered business systems. Learn to orchestrate data, integrate LLMs like Claude, and solve real-world consulting challenges with node-based logic.
Start Data Analysis from Excel to SQL today.
Download Tomo, search Data Analysis from Excel to SQL, and play your first lesson in under a minute.