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 25 chapters

About this Book

From Cloud Data Management

Information about who this book is for, who it's not, how we wrote it, disclaimers, influences and how to contribute.

Acknowledgments & Contributions

From Cloud Data Management

This is a community driven book - with contributions from many different people and organizations. Help keep it relevant and continually improving.

Democratized or Centralized - choosing your workflow

From Cloud Data Management

Choosing whether data should be completely run by a centralized team, or efforts should be made into enable others in the organization to work with data is a big choice for companies, with great consequences on both sides.

Introduction - The 4 Stages of Data Sophistication

From Cloud Data Management

Learn how Data Governance practices change as the level of data sophistication changes.

What Stage are You at?

From Cloud Data Management

Figure out what level of data sophistication your team is at.

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 27 chapters

Data Lake Security

From Cloud Data Management

Learn best practices for ensuring data security on a Data Lake database.

Data Mart Implementation

From Cloud Data Management

Learn the best practices for building a Data Mart

Data Mart Maintenance

From Cloud Data Management

Learn Best Practices for Maintaining a a Data Mart, such as handling errors and incorporating new data sources.

Data Warehouse Security

From Cloud Data Management

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

Defining a Data Governor

From Cloud Data Management

Data Governors maintain the database so that is remains valuable to an organization. This involves security, education, and modeling.

ETL vs ELT

From Cloud Data Management

Learn why you should use an ELT over a ETL process for your Data Lake

Extract and Load a Lake

From Cloud Data Management

Learn how to extract and load data sources like SalesForce, Hubspot, Marketo, etc into a single source.

Source Data Connections

From Cloud Data Management

Learn how to configure your database to analyze source data effectively.

Source Data Best Practices

From Cloud Data Management

Learn how to manage queries, model in a BI tool, and use drag and drop query interfaces.

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.

Why Build Data Marts

From Cloud Data Management

Learn the best reasons to build a data mart on top of your data warehouse

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.

How Subqueries Work

From How to Teach People SQL

Visualize how subqueries work in SQL by seeing the intermediate table that is created during the process. See animations showing each step of the SQL query.

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

Union - Animated

From How to Teach People SQL

Visualize how SQL is joining two tables using a Union All join. See animated visualizations of the data being Unioned in SQL. Learn more.

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.