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.
Quick visual review of designing a dashboard
Successful dashboards get used a lot so they need to be built to scale
Learn techniques to prototype your dashboard and iterate on it
Overview of all the steps in a dashboard design process
Dashboards are the way data people help the rest of an organization make data driven decisions.
Introduction about why teaching SQL requires understanding of the audience who is less adept at dealing with abstract ideas
Learn quick tips for how to optimize your SQL queries
Visualize how subqueries work in SQL by seeing the intermediate table that is created during the process.
Visualize how SQL aggregates data by viewing examples of COUNT, AVG, and SUM
Learn the most common reasons you will get a SQL error due to syntax.
Learn the most common reasons you will get 0 rows returned from your SQL query.
Visualize how SQL is joining two tables using a Cross Join
Visualize how SQL is joining two tables using a Union All
Visualize how SQL is joining two tables using a Full Outer JOIN
Visualize how SQL is joining two tables using a Left JOIN and a Right JOIN
Visualize how SQL is joining two tables using an Inner JOIN
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.
Databases are better for managing data than spreadsheets when you consider size, accuracy, and security
Learn what dashboards are and why they are important to making decisions.