Tag Archives: data warehousing

Querying the GHDx Database: Demonstration and Review of Application

Many data scientists interested in health are looking to query the Global Burden of Disease database, also known as the GHDx

Querying the GHDx database is challenging because of its difficult user interface, but mastering it will allow you to access country-level health data for comparisons! See my demonstration!

Referring to Variables in Processing Data is Different in SAS Compared to R

When doing data processing, especially extract-transform-load (ETL) into a data warehouse, you might need to refer to the variables in your code, and it's done differently in SAS vs. R.

Referring to variables in processing is different conceptually when thinking about SAS compared to R. I explain the differences in my blog post.

Confused when Downloading BRFSS Data? Here is a Guide

Many images of colorful database shapes on a rainbow background

I use the datasets from the Behavioral Risk Factor Surveillance Survey (BRFSS) to demonstrate in a lot of my data science tutorials. The BRFSS are free and available to the public – but they are kind of buried on the web site. This blog post serves as a “map” to help you find them!

I Installed the Free “SAS University Edition” and Here’s What I Recommend: Part 3

Install Free SAS University Edition Set up your computer to use SAS for free

In this blog post, I walk you through SAS Download and Install steps 1 and 2. In those steps, you make a free account with SAS, and you download and install Oracle’s VirtualBox. The screen shots in this post will get you ready for what you will see when you do these steps.