Matt David

Matt David

Matt has over 7 years industry experience using data and currently the Editor of the Data School @ Chartio. Previously he worked at Udacity as Product Lead for the School of Data Science. Data has become a prerequisite skill set for more and more non-data jobs and he is passionate about making data concepts more easily understood to increase data literacy for everybody.

Chapters written by
Matt David
Row vs Column Oriented Databases
5
min read

Column oriented databases have become dominant over row oriented databases in data warehousing

Start Modeling Data
7
min read

This is a quick introduction to using DBT and Bigquery to model data

Appendix
1
min read

Miscellaneous chapters related to teaching people SQL

Difference between WHERE and ON in SQL
4
min read

Understand how filtering and joining can be done in both the ON and WHERE clauses in SQL

Conclusion
1
min read

Quick visual review of designing a dashboard

Scaling Dashboards
3
min read

Successful dashboards get used a lot so they need to be built to scale

Dashboard Prototyping and Feedback
3
min read

Learn techniques to prototype your dashboard and iterate on it

Dashboard Design Process
3
min read

Overview of all the steps in a dashboard design process

Introduction
2
min read

Dashboards are the way data people help the rest of an organization make data driven decisions.

Introduction
1
min read

Introduction about why teaching SQL requires understanding of the audience who is less adept at dealing with abstract ideas

How SQL Subqueries Work
5
min read

Visualize how subqueries work in SQL by seeing the intermediate table that is created during the process.

How SQL Aggregations Work
6
min read

Visualize how SQL aggregates data by viewing examples of COUNT, AVG, and SUM

Debugging SQL: Syntax Errors
5
min read

Learn the most common reasons you will get a SQL error due to syntax.

Debugging SQL: 0 Rows Returned
4
min read

Learn the most common reasons you will get 0 rows returned from your SQL query.

Cross Join - Animated
2
min read

Visualize how SQL is joining two tables using a Cross Join

Union - Animated
3
min read

Visualize how SQL is joining two tables using a Union All

Full Outer Join - Animated
2
min read

Visualize how SQL is joining two tables using a Full Outer JOIN

Left & Right Join - Animated
5
min read

Visualize how SQL is joining two tables using a Left JOIN and a Right JOIN

Inner Join - Animated
3
min read

Visualize how SQL is joining two tables using an Inner JOIN

Accessing Data
3
min read

Accessing data within a company requires being given permission to the data, learning how to ask questions in SQL, and how to explore a schema.

Why Databases
4
min read

Databases are better for managing data than spreadsheets when you consider size, accuracy, and security

Build the Metrics
2
min read

Use SQL to query the database to get the data behind the metrics people want to see.

Finding the Data That Builds Metrics
2
min read

Learn to collaborate with your data team to discover what data can be used within a dashboard.

Determine the Metrics to Monitor
3
min read

Define what metrics actually matter to business professionals.

Identifying Key Roles
3
min read

Learn the key stakeholders for a dashboard design process.

What is a Dashboard?
3
min read

Learn what dashboards are and why they are important to making decisions.