Contributors

Dave Fowler

CEO at Chartio,
Contributor at Data School

Dave is the founder of Chartio and DataSchool. He’s been working in BI for 10 years, obsessed with the mission to JOIN people ON data - or enable anyone in (not just data analysts) to explore and understand their data.

Dave Fowler's Picture

Social

Author of 20 chapters

SQL (Structured Query Language)

From

SQL is short for Structured Query Language

Design a Dashboard Example

From How to Design a Dashboard

Example of how applying design thinking improves dashboard design

Basic SQL Practice Grounds

From Learn SQL

After you've got the basic SQL fundamentals. Put that knowledge to the test in these interactive SQL practice exercises.

FROM

From Learn SQL

This interactive SQL tutorial will explain the FROM command with syntax and use cases on how to interact with your data in the PostgreSQL database. Learn how to use the SQL FROM command by following the steps in this interactive tutorial.

Quick Introductory SQL Concepts

From Learn SQL

Learn how to use SQL with your PostgreSQL database. In this interactive SQL data tutorial, get an introduction that is designed to get you querying your PostgreSQL database as quickly as possible. Learn SQL basics, tables and SQLbox.

LIMIT and OFFSET

From Learn SQL

Learn how to LIMIT the number of results that are returned you can simply use the LIMIT SQL command at the end of the query to specify. You can use the LIMIT command on your PostgreSQL database. Read the tutorial to learn more.

ORDER BY

From Learn SQL

Learn how to use the SQL ORDER BY command in PostgreSQL. The ORDER BY command is used to sort your result data in ascending or descending order. Follow the interactive SQL tutorial to use cases and best practices for the ORDER BY command.

Browsing the SCHEMA

From Learn SQL

SCHEMA is the collection of tables and relationships in your database. In this interactive SQL tutorial, learn how to browse a SCHEMA with PostgreSQL.

SELECT

From Learn SQL

Learn the SELECT SQL statement with your PostgreSQL database in this interactive SQL data tutorial. The SELECT statement is a basic SQL command to access data.

PostgreSQL Tutorial Completed

From Learn SQL

Congratulations on completing your learning in SQL for PostgreSQL. Continue your SQL education in testing out the SQL editor in Chartio that enables you to analyze your data from disparate data sources in one dashboard. Start a trial.

Help with Common PostgreSQL Errors

From Learn SQL

When working with SQL you’re going to run into a lot of errors. This is a guide to help you with common PostgreSQL database errors.

How to Export PostgreSQL Data to a CSV or Excel File

From Learn SQL

Learn how to export PostgreSQL data to a CSV or Excel file. Follow these instructions to copy tables, copy a query results, and open CSV files.

How To Generate Random Data in PostgreSQL

From Learn SQL

You can generate random values and sequences in SQL. Learn how with this interactive PostgreSQL tutorial.

Aggregate Functions

From Learn SQL

Learn about the COUNT function in SQL. The COUNT command is used to returns the count of how many rows there are. This interactive SQL tutorial will teach you how to COUNT.

DATE and TIME Functions

From Learn SQL

DATE and TIME values in PostgreSQL have a whole special set of functions and operators for their proper use. Learn how to use dates in PostgreSQL in this interactive SQL tutorial, so you can get the DATE and TIME of your data analysis.

GROUP BY

From Learn SQL

The GROUP BY SQL statement is used to aggregate functions like COUNT, MAX, MIN, SUM and AVG. In this interactive SQL tutorial, learn to use the GROUP BY .

JOIN Relationships and JOINing Tables

From Learn SQL

A JOIN SQL statement combines two data from two tables together. In this interactive SQL tutorial, learn the most common JOIN statements.

Mid Level SQL Practice Grounds

From Learn SQL

After you've mastered mid-level SQL fundamentals, put that knowledge to the test in these interactive SQL practice exercises.

Operators

From Learn SQL

Learn about Operators in SQL and how to use them in Postgres. Operators are used to specify conditions in a SQL statement.

WHERE

From Learn SQL

Learn how to use the WHERE command in PostgreSQL. In this interactive SQL tutorial, learn the best practices of the WHERE command for analysis and exploration.

Reviewer of 14 chapters

Data Warehouse Security

From Data Governance

Learn how to secure sensitive data on your database and BI platform.

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.

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.

Determine the Metrics to Monitor

From How to Design a Dashboard

Define what metrics actually matter to business professionals. Use customer development techniques to determine the best metrics.

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.

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.

Identifying Key Roles

From How to Design a Dashboard

Learn the key stakeholders for a dashboard design process. Learn how to work with Designers, Developers, and your audience.

Introduction

From How to Design a Dashboard

Dashboards help organizations make data driven decisions. Learn how to apply design thinking to creating useful dashboards.

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 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.

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.

Introduction

From How to Teach People SQL

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

Start Modeling Data

From SQL Optimization

Quick introduction on using to dbt and BigQuery to model data. Modeling data can have significance performance impacts on your database.