• data science

    Killer Data Science Training Sale

    So real quick, anyone who knows me knows that I love love love Data Camp. This week, Data Camp is offering up to 62% off their year subscriptions. These are already a good deal but a total no-brainer at this price. I recommend this to anyone who works in a data profession or who wants to pivot into a data profession like Data Science or Machine Learning. I really love the format: very short but informative videos followed up by hands-on simulations. You really learn by doing AND you get the theoretical context so you understand how to do the analysis. They have skill tracks so you can just learn…

  • covid-19,  data science,  portfolio

    County Level Covid-19 Dashboard

    Explore US COVID-19 new cases and deaths by US county. You can change the states, counties and time frame. There are a total of three tabs, the first two are visualizations while the third is a data table 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.

  • covid-19,  data science,  portfolio

    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.

  • covid-19,  data science

    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.

  • drones


    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,  data science

    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,  data science

    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…

  • data science

    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…

  • lifestyle 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…