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.
Social
- Website: http://thingsilearned.com/
- LinkedIn: Dave Fowler
- Twitter: https://twitter.com/__dave
Author of 25 chapters
Acknowledgments & Contributions
From Cloud Data ManagementThis 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 ManagementChoosing 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 ManagementLearn how Data Governance practices change as the level of data sophistication changes.
What Stage are You at?
From Cloud Data ManagementFigure out what level of data sophistication your team is at.
Design a Dashboard Example
From How to Design a DashboardExample of how applying design thinking improves dashboard design
Basic SQL Practice Grounds
From Learn SQLAfter you've got the basic SQL fundamentals. Put that knowledge to the test in these interactive SQL practice exercises.
Quick Introductory SQL Concepts
From Learn SQLLearn 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 SQLLearn 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.
Browsing the SCHEMA
From Learn SQLSCHEMA is the collection of tables and relationships in your database. In this interactive SQL tutorial, learn how to browse a SCHEMA with PostgreSQL.
PostgreSQL Tutorial Completed
From Learn SQLCongratulations 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 SQLWhen 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 SQLLearn 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 SQLYou can generate random values and sequences in SQL. Learn how with this interactive PostgreSQL tutorial.
Aggregate Functions
From Learn SQLLearn 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 SQLDATE 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.
JOIN Relationships and JOINing Tables
From Learn SQLA 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 SQLAfter you've mastered mid-level SQL fundamentals, put that knowledge to the test in these interactive SQL practice exercises.
About this Book
From Cloud Data ManagementInformation about who this book is for, who it's not, how we wrote it, disclaimers, influences and how to contribute.
Reviewer of 27 chapters
Start Modeling Data
From SQL OptimizationQuick introduction on using to dbt and BigQuery to model data. Modeling data can have significance performance impacts on your database.
Data Mart Implementation
From Cloud Data ManagementLearn the best practices for building a Data Mart
Data Mart Maintenance
From Cloud Data ManagementLearn Best Practices for Maintaining a a Data Mart, such as handling errors and incorporating new data sources.
Data Warehouse Security
From Cloud Data ManagementLearn how to secure sensitive data on your database and BI platform.
Defining a Data Governor
From Cloud Data ManagementData Governors maintain the database so that is remains valuable to an organization. This involves security, education, and modeling.
ETL vs ELT
From Cloud Data ManagementLearn why you should use an ELT over a ETL process for your Data Lake
Extract and Load a Lake
From Cloud Data ManagementLearn how to extract and load data sources like SalesForce, Hubspot, Marketo, etc into a single source.
Source Data Connections
From Cloud Data ManagementLearn how to configure your database to analyze source data effectively.
Source Data Best Practices
From Cloud Data ManagementLearn how to manage queries, model in a BI tool, and use drag and drop query interfaces.
Starting with Source Data
From Cloud Data ManagementLearn how to analyze data from applications, production databases, and financial records.
Why Build a Data Lake
From Cloud Data ManagementLearn why you should build a data lake to improve analytics at your company.
Why Build Data Marts
From Cloud Data ManagementLearn 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 DashboardMaximize understanding of a dashboard by arranging data visualizations intelligently. Learn common design patterns to improve readability.
Build the Metrics
From How to Design a DashboardUse 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 DashboardDefine 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 DashboardDecide 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 DashboardLearn 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 DashboardLearn the key stakeholders for a dashboard design process. Learn how to work with Designers, Developers, and your audience.
Introduction
From How to Design a DashboardDashboards 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 DashboardUse 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 DashboardLearn 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 DashboardLearn 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 DashboardLearn the best practices behind dashboard design to support decision making. Accuracy, Clarity, Empowerment, and being Succinct.
How Subqueries Work
From How to Teach People SQLVisualize 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 SQLIntroduction 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 SQLVisualize how SQL is joining two tables using a Union All join. See animated visualizations of the data being Unioned in SQL. Learn more.
Data Lake Security
From Cloud Data ManagementLearn best practices for ensuring data security on a Data Lake database.
