Matt David

Matt David

Hi! I'm Matt David. I have over 7 years industry experience using data and currently the Editor of the Data School @ Chartio. Previously I 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 I am passionate about making data concepts more easily understood to increase data literacy for everybody.

Chapters written by
Matt David
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

Optimize your SQL Query
3
min read

Learn quick tips for how to optimize your SQL queries

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

What is a Dashboard?
3
min read

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