Posts by Tag

Business Metrics for Data-Driven Companies

Command Line

Coursera

Basic Tableau

Analysis of a Visa status application dataset to explore various occupations compensation data. Explores Tableau’s basic functionality and comments on a few ...

10 Tips for Data Analysts

Ten practical tips for data analysts Professor Jana Schaich Borg shares as part of her Tableau course.

Tableau Course Overview

An overview of the content objectives of the Data Visualization and Communication with Tableau Coursera course by Duke University.

Inclusive ML

Discussion of how ML models can amplify unconscious human biases, and presents a few techniques for mitigating the problem.

On Overfitting

Discussion of the mathematics of model overfitting, how it happens, the problem it creates, and a mitigation strategy.

Excel Basics

Overview of basic functions for data analysis in Excel.

Complex Teradata Queries

The final Teradata exercises and quiz for the Coursera course, “Managing Big Data with MySQL.”

Queries that Test Relationships

Testing Relationships between Business Indicators and Database Variables, from the Coursera course “Managing Big Data with MySQL.”

Logical Functions

Notes about SQL Logical Functions from the Coursera course “Managing Big Data with MySQL.”

Teradata Basics

Notes on the Teradata UI and differences from MySQL from the Coursera course “Managing Big Data with MySQL.”

Data Science for Business

Data Visualization and Communication with Tableau

Basic Tableau

Analysis of a Visa status application dataset to explore various occupations compensation data. Explores Tableau’s basic functionality and comments on a few ...

10 Tips for Data Analysts

Ten practical tips for data analysts Professor Jana Schaich Borg shares as part of her Tableau course.

Tableau Course Overview

An overview of the content objectives of the Data Visualization and Communication with Tableau Coursera course by Duke University.

Georgia Tech

How Google does Machine Learning

Inclusive ML

Discussion of how ML models can amplify unconscious human biases, and presents a few techniques for mitigating the problem.

Jordan Peterson

Serotonin and the Dominance Hierarchy

Transcription of part of a Q&A session during Jordan Peterson’s 2017 Maps of Meaning Lecture. Subject is the symptomatology of depression versus low stat...

Learning

How I’m Learning Data Science

Discussion of the current state of data science education, the inspiration for hosting my notes on ryanwingate.com, and my own learning journey.

Lecture Notes

Managing Big Data with MySQL

Complex Teradata Queries

The final Teradata exercises and quiz for the Coursera course, “Managing Big Data with MySQL.”

Queries that Test Relationships

Testing Relationships between Business Indicators and Database Variables, from the Coursera course “Managing Big Data with MySQL.”

Logical Functions

Notes about SQL Logical Functions from the Coursera course “Managing Big Data with MySQL.”

Teradata Basics

Notes on the Teradata UI and differences from MySQL from the Coursera course “Managing Big Data with MySQL.”

Mastering Data Analysis in Excel

On Overfitting

Discussion of the mathematics of model overfitting, how it happens, the problem it creates, and a mitigation strategy.

Excel Basics

Overview of basic functions for data analysis in Excel.

Mindset

Healthy Skepticism

Discussion of the appropriate mindset to bring to bear on data analysis projects.

Philosophy

Process

Python

Quora

The Python Scientific Stack

An overview of the Python Scientific Stack, courtesy of a Quora post written by Yassine Alouini and Jake VanderPlas.

Random

The Complete SQL Bootcamp

PostgreSQL with Python

Notes on Using PostgreSQL with Python from the Udemy Course “The Complete SQL Bootcamp.”

Views

Notes on SQL Views from the Udemy Course “The Complete SQL Bootcamp.”

JOINs

Notes on SQL JOINs from Udemy Course “The Complete SQL Bootcamp.”

Udacity

Udemy

Udemy Value

Review and time commitment breakdown for the Udemy course “The Complete SQL Bootcamp.”

PostgreSQL with Python

Notes on Using PostgreSQL with Python from the Udemy Course “The Complete SQL Bootcamp.”

Views

Notes on SQL Views from the Udemy Course “The Complete SQL Bootcamp.”

JOINs

Notes on SQL JOINs from Udemy Course “The Complete SQL Bootcamp.”