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.
Column oriented databases have become dominant over row oriented databases in data warehousing
This is a quick introduction to using DBT and Bigquery to model data
Miscellaneous chapters related to teaching people SQL
Understand how filtering and joining can be done in both the ON and WHERE clauses in SQL
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
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
Use SQL to query the database to get the data behind the metrics people want to see.
Learn to collaborate with your data team to discover what data can be used within a dashboard.
Define what metrics actually matter to business professionals.
Learn the key stakeholders for a dashboard design process.
Learn what dashboards are and why they are important to making decisions.