Posts by Category

Books

Career

10 Tips for Data Analysts

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

Udemy Value

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

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.

Data and Visual Analytics

Excel

Excel Basics

Overview of basic functions for data analysis in Excel.

General Software

API Paradigms

An overview of APIs and discussion of API release policies, uses, paradigms, and a few simple examples of API calls.

Google Cloud

Inclusive ML

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

Interests

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...

JP

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...

Math

On Overfitting

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

Metrics

OMSCS

Process

Purpose

Healthy Skepticism

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

Python

The Python Scientific Stack

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

SQL

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.”

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.”

Sources

Stats

On Overfitting

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

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 ...

Tableau Course Overview

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

Tools

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 ...

Tableau Course Overview

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

API Paradigms

An overview of APIs and discussion of API release policies, uses, paradigms, and a few simple examples of API calls.

Inclusive ML

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

The Python Scientific Stack

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

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.”

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.”