• code

    Covid-19 Visualization

    Explore US COVID-19 infection rates and hospitalizations for each state. You can change the states and time frame. There are a total of four tabs, the first two are visualizations while the second two are data tables if you want more detail. See https://github.com/mattjcamp/covid_dashboard for the Python data pipeline used to gather the data for this visualization.

  • code

    Europe vs United States COVID Rates

    Check out this chart from the Statista blog on how the US and European Union compare on COVID-19 infection rates. You will find more infographics at Statista This is interesting, the US is still doing far worse than Europe but the gap appears to be closing. It will be interesting to see how this plays out in the Fall when people in the US will start spending more time indoors.

  • lifestyle


    Last week, I got a solid flight in. This took place in a school parking lot that has an area off to the side with stands of trees and even a sort of enclosed area that is not used by anyone. This place was great at this time of day, I really loved how the setting sun lit the tops of the trees. This is part of a series that I’m doing for my FPV drone channel. I’m working on getting final flights at each of my old spots. It’s basically a long goodbye tour of the hobby. So, take look and enjoy!

  • code

    Setup Your Local Data Warehouse Content

    In last week’s post, I showed you how to get a free SQL database by setting up a MySQL database server on your desktop. Now, it’s time to finish setting up your local data warehouse that you can use it to practice your SQL chops. We will use data that is posted on data.world to fill out our data warehouse. The first dataset is from the WICHE organization and shows you student enrollments and graduations in K-12 schools. This is a dataset that I uploaded to data.world years ago and I use it in demos like this. We will also download a file with information on US states so we…

  • code

    Get this Free SQL Database

    For a long time, I’ve wanted to published guides to the programming languages that I use. Last week, I started by writing up quick notes on SQL but it occurred to me that you will need a SQL database to follow along. So I found a free SQL database system that you can download right now. Download MAMP The program that you need is called MAMP and you can download that here. Take care to download the correct version for your operating system. MAMP makes it easy to install these three open-source products: Apache, MySQL, and PHP. MySQL is the free SQL database, but you need all three working set…

  • code

    How to Get a Data Analyst Job

    Data Analysts use data to answer questions about the state of an organization’s business. Since data is stored in computer systems, a Data Analyst needs to be comfortable with technology. Data Analysts investigate data problems and be able to communicate their findings. Sound like a good job? Read on to learn how to get a data analyst job. This is a good job for people who are Investigative on the Holland Scale. If you are a problem solver and like to think things through then this may be the job for you. My Holland Code is ISE (Investigative, Social, Enterprising) and I have found data analysis to be a good…

  • code

    Basic SQL Notes

    Here are my notes on SQL. This Notes series is meant to be light on narrative but heavy on code samples that you can copy and paste. At some point, if there is demand I will provide posts that explain what is actually happening. Datasets are located here https://data.world/mattjcamp/wiche-enrollment-projections and you can follow along right in the Data World web app. This project has two data tables: wiche_graduate_projections.csv and state_table.csv. Select All Columns From Table Essentially the simplest SQL query that you can write that returns records from a table. Join Two Tables Use JOIN or INNER JOIN to combine two tables when you only want records that appear in…

  • business

    Can This Code Determine Work Satisfaction?

    Back in the Summer of 2018, I was in the middle of a work crisis that was so bad that went to see a therapist because I was afraid my mental health was at risk. The therapist I met with concluded that I was in the wrong job and we decided to work together to find my professional sweet spot. The idea was that my job was affecting me negatively and it was time to make a change. This therapist introduced me to the Holland Codes, a system developed by Dr. Holland that identifies a person with three out of six personality types that can be matched to jobs. You…

  • code

    Local Covid-19 Dashboard

    When I need a Data Science tool beyond vanilla SQL I usually reach for RStudio. There is no denying that R is fast and painless for doing statistical analysis, but it’s quirky and falls far out of the norms of coding and that’s always bugged me. So I’ve been debating making a switch. Lately, I’ve been experimenting with Python programming. Python is a very popular general-purpose programming language that is used in Data Science, but it’s also used to make apps, websites, and services. I’m particularly interested in using this language along with AWS services to publish small web APIs and things like that. But, I need to learn the…

  • lifestyle

    Is Bob Lazar for Real?

    I first learned about Bob Lazar last year when Netflix released a documentary titled Bob Lazar: Area 51 & Flying Saucers. This documentary was kinda crazy, it was filmed with a dramatic voice-over reading from a bizarre script. But, the subject of the film, Bob Lazar, seemed somewhat credible. Lazar and his associates have also appeared on the Joe Rogan podcast. For those of you who don’t know, Bob Lazar is a guy who claimed to work on reverse engineering alien technology for the government in 1989. His story was part of the reason that Area 51 became such an infamous spot in popular culture. The thing about Bob’s story…