Blake Barnhill
Marketing Intern at Chartio,
Contributor at Data School
Blake is an undergraduate in Computer Science at Virginia Tech with a passion for teaching others the intricacies of computer coding and analytical thinking. As a lover of all things math, he is very interested in the data analytics world. Blake is working on the Data School @ Chartio initiative.
Author of 11 chapters
Scheduling Modeling
From SQL OptimizationSchedule data modeling tasks to make data easy to query. Learn to use dbt Cloud to model data to optimize your data warehouse. Learn more.
Row vs Column Oriented Databases
FromColumn oriented databases have become dominant over row oriented databases in data warehousing.
Running Jupyter Notebook on an EC2 Server
FromLearn how to run a Jupyter Notebook on an AWS EC2 Server and the advantages of this.
Using Jupyter Notebooks
FromThis article walks through the basics of using a Jupyter notebook. It covers how to load data, create a notebook, and begin using that notebook.
How Regex in SQL Works
From How to Teach People SQLLearn how Regex works in SQL and how to use it in your queries. See the Regex process visualized in gifs. Learn more.
How CASE WHEN Works
From How to Teach People SQLCASE WHEN is a SQL function that works a lot like IF THEN in other programming languages. Learn to use CASE WHEN in SQL.
How Window Functions Work
From How to Teach People SQLLearn how window functions work by looking at gifs that show the process in slow motion. See every step in SQL animated in slow motion. Learn more.
BigQuery Optimization
From SQL OptimizationLearn how BigQuery optimizes your database through specific hardware optimization strategies.
Indexing
From SQL OptimizationIndexing is a critical part of database optimization. Indexing can dramatically increase query speed. See how indexes work and learn to build indexes with SQL.
Redshift Optimization
From SQL OptimizationLearn how Redshift manages optimization for your cloud data warehouse. Learn when to manually tune the database further for more performance for SQL queries.
Creating an EC2 Server
FromLearn how to quickly set up an EC2 server on AWS. Follow along with screenshots and instructions.
Reviewer of 17 chapters
What is a Query Plan
From SQL OptimizationQuery Plan's are the code that SQL runs on your database. Learn how the query plan works and how to optimize your SQL queries. Learn more
Export to CSV with \copy
From Learn SQLThis article discusses how to export data from psql to a csv file using the copy commands
How to Start a PostgreSQL Server on Mac OS X
From Learn SQLThis article shows how to start a PostgreSQL server using both Homebrew and the potgres app on a Mac.
Using ALTER in PostgreSQL
From Learn SQLLearn the different potential uses of the ALTER command in PSQL. Add and drop columns from tables. Rename and change schemas and more.
Confirmation Bias
From Avoid Misrepresenting DataConfirmation bias negatively affects the accuracy of your analysis. Learn how to detect Confirmation Bias and how to avoid this cognitive bias.
Define Experiment Parameters
From Avoid Misrepresenting DataDefining Experiment Parameters improves analysis and increases trust in results that are shared in an organization.
Relative vs Absolute Change
From Avoid Misrepresenting DataRelative and Absolute changes can bias your interpretation of data you are analyzing. Learn to interpret them correctly.
Review Outcomes
From Avoid Misrepresenting DataReview Outcomes of Feature Releases to evaluate their impact and to create institutional knowledge. Learn how to interpret results accurately.
Selection Bias
From Avoid Misrepresenting DataSelection bias negatively affects your analysis. Learn how to detect Selection Bias and how to avoid this cognitive bias.
Statistic vs Distribution
From Avoid Misrepresenting DataDistributions provide much more nuance to the data than a statistic does. Learn how to query to get distributions and then interpret them.
Survivorship Bias
From Avoid Misrepresenting DataSurvivorship bias negatively affects your analysis. Learn how to detect Survivorship Bias and how to avoid this cognitive bias.
Trends
From Avoid Misrepresenting DataTrend in data can be misleading depending on what time frame you are looking at it. Learn how to accurately interpret trends.
Multicolumn Indexes
From SQL OptimizationThis article walks through what multicolumn indexes are, how to make them, and when to use them.
Optimization with EXPLAIN ANALYZE
From SQL OptimizationThe EXPLAIN shows the query plan for SQL queries in Postgres. Learn how to interpret the results from EXPLAIN and use it to optimize your SQL queries.
Partial Indexes
From SQL OptimizationPartial indexes are an advanced database optimization technique. Learn how to create Partial Indexes and measure their performance.
Views
From SQL OptimizationSQL VIEWs allow you to create temporary or permanent references to data. This is a common database optimization technique. Learn more.
Copying Data Between Tables
From Learn SQLLearn to copy data from a table or query into another table using the INSERT command in psql.
