Contributors

Tim Miller

Sr Data Advisor at Chartio,
Contributor at Data School

Tim is a Senior Data Advisor at Chartio and brings 10+ years of Data Analysis background as well as years of experience in instruction methods and hands-on instruction to Chartio’s Data School.

Tim Miller's Picture

Social

Author of 11 chapters

SQL Join Types Explained Visually

From How to Teach People SQL

Data within a database exists across multiple tables, JOINs allow you to combine datasets into new tables for analysis. Learn more.

Data Warehouse Implementation

From Cloud Data Management

Learn how to setup a Data Warehouse. Model and transform data to make it easy to analyze.

Data Warehouse Architecture

From Cloud Data Management

Learn why you should build a Single Source of Truth in your Data Warehouse. Overcome common obstacles and empower your colleagues

Starting with Source Data

From Cloud Data Management

Learn how to analyze data from applications, production databases, and financial records.

Why Build a Data Lake

From Cloud Data Management

Learn why you should build a data lake to improve analytics at your company.

Arranging Your Charts as a Dashboard

From How to Design a Dashboard

Maximize understanding of a dashboard by arranging data visualizations intelligently. Learn common design patterns to improve readability.

Find the Best Visualizations for Your Metrics

From How to Design a Dashboard

Decide what chart works best for your visualization based on if you want to show composition, relationship, distribution or comparison.

Making Sure Your Dashboard Always Gets Better

From How to Design a Dashboard

Use feedback loops from your audience to keep iterating on dashboards you create. Learn to improve it's usability and performance.

Sharing the Dashboard – Distribution Strategies

From How to Design a Dashboard

Learn the best practices and common pitfalls of sharing out dashboards. Distributing your dashboard is critical to it being useful.

What Makes a Great Dashboard (ACES)

From How to Design a Dashboard

Learn the best practices behind dashboard design to support decision making. Accuracy, Clarity, Empowerment, and being Succinct.

Data Lake Maintenance

From Cloud Data Management

Learn best practices for data lake maintenance. Handle Data Source updates and improve performance.

Reviewer of 6 chapters

Build the Metrics

From How to Design a Dashboard

Use SQL to query the database to get the data behind the metrics people want to see. Use our template to quickly build accurate queries. Learn more.

Finding the Data That Builds Metrics

From How to Design a Dashboard

Learn to collaborate with your data team to discover what data can be used within a dashboard. Use SQL to find and assess columns to use.

What is a Dashboard?

From How to Design a Dashboard

Learn what dashboards are and why they are important to making decisions. Dashboards have a long history for supporting decision making.

Full Outer Join - Animated

From How to Teach People SQL

Visualize how SQL is joining two tables using a Full Outer JOIN. See animated visualizations of the data being FULL OUTER joined in SQL. Learn more.

Inner Join - Animated

From How to Teach People SQL

Visualize how SQL is joining two tables using an Inner JOIN. See animated visualizations of the data being INNER joined in SQL. Learn more.

Left & Right Join - Animated

From How to Teach People SQL

Visualize how SQL is joining two tables using a Left JOIN and a Right JOIN. See animated visualizations of the data being LEFT and RIGHT joined in SQL. Learn more.