Improving the Operational Art of Curbside Pickup and Other People-Based Processes
Five Key Points to Consider When Executing A Tagging Implementation
Five Key Aspects Organizations Should Consider While Deploying An Analytics Stack
Blockchain as a Platform for Data Governance 2.0
Driving Actionable Insights Through Data Engagement
Keeping your Data Stack Agile as a Startup
Taking a DA Hub Approach to Solving Analytics Challenges
About this Book
Acknowledgments & Contributions
Data Lake Maintenance
Data Lake Security
Data Mart Implementation
Data Mart Maintenance
Data Warehouse Implementation
Data Warehouse Maintenance
Data Warehouse Security
Defining a Data Governor
Democratized or Centralized - choosing your workflow
Doing more with your Data Mart
ETL vs ELT
Evaluating Data Stack Technologies
Extract and Load a Lake
Introduction - The 4 Stages of Data Sophistication
Data Warehouse Architecture
Source Data Connections
Source Data Best Practices
Starting with Source Data
What Stage are You at?
What Engine to Use For a Data Lake
Why Build a Data Lake
Why Build a Data Warehouse
Why Build Data Marts
Creating an EC2 Server
Row vs Column Oriented Databases
Running Jupyter Notebook on an EC2 Server
Using Jupyter Notebooks
SQL (Structured Query Language)
Choosing Metrics for Product Launch
Correlation and P value
How to Explore Data
Types of Data Analysis
What is an Outlier?
What is Data and Why Should I Care
What is the Interquartile Range?
Arranging Your Charts as a Dashboard
Build the Metrics
Conclusion
Dashboard Design Process
Dashboard Prototyping and Feedback
Design a Dashboard Example
Determine the Metrics to Monitor
Find the Best Visualizations for Your Metrics
Finding the Data That Builds Metrics
Identifying Key Roles
Introduction
Making Sure Your Dashboard Always Gets Better
Scaling Dashboards
Sharing the Dashboard – Distribution Strategies
What is a Dashboard?
What Makes a Great Dashboard (ACES)
Accessing Data
Difference between WHERE and ON in SQL
How Regex in SQL Works
How to Find Outliers with SQL
Syntax Conventions
Third Normal Form
Cross Join - Animated
0 Rows Returned
Syntax Errors
Full Outer Join - Animated
How CASE WHEN Works
How Aggregations Work
How Subqueries Work
How Window Functions Work
Inner Join - Animated
Introduction
Left & Right Join - Animated
SQL Join Types Explained Visually
Union - Animated
Why Databases?
Basic SQL Practice Grounds
FROM
Quick Introductory SQL Concepts
LIMIT and OFFSET
ORDER BY
Browsing the SCHEMA
SELECT
PostgreSQL Tutorial Completed
Help with Common PostgreSQL Errors
5 Redshift SQL shortcuts
Additional Practice
AND OR Boolean Logic
Conditional Logic
Copying Data Between Tables
Drop all tables Postgres
Exclude a Column
Export to CSV with \copy
Find Duplicates
PostgreSQL Generate_Series
Hierarchical data in SQL
How to Create a Copy of a Database in PostgreSQL
How to Export PostgreSQL Data to a CSV or Excel File
How to Replace Nulls with 0s in SQL
How to Start a PostgreSQL Server on Mac OS X
Importing Data from CSV in PostgreSQL
Insert multiple rows
List the tables in SQLite opened with ATTACH
Meta commands in PSQL
Outputting Query Results to Files with \o
How To Generate Random Data in PostgreSQL
Show Tables in Postgres
SQL Cheat Sheet
UPDATE with JOIN in SQL
Using ALTER in PostgreSQL
What is the difference between UNION and UNION ALL
Aggregate Functions
DATE and TIME Functions
GROUP BY
JOIN Relationships and JOINing Tables
Mid Level SQL Practice Grounds
Operators
WHERE
Comparing to Historical Averages
Confirmation Bias
Define Experiment Parameters
Increase Ecommerce Sales with Metrics
Metric vs Metrics
Overall vs Groups
Predicting Outcomes
Relative vs Absolute Change
Review Outcomes
Selection Bias
Statistic vs Distribution
Survivorship Bias
Trends
BigQuery Optimization
Indexing
Multicolumn Indexes
Optimization with EXPLAIN ANALYZE
Optimize your SQL Query
Redshift Optimization
Order of a SQL Query
Partial Indexes
Scheduling Modeling
Snowflake Optimization
Start Modeling Data
Views
What is a Query Plan