• business,  code

    Should You Write a Tech Book?

    Are you considering publishing a book with a company like Apress, No-Starch, or O’Reilly? Maybe you have been contacted by someone who noticed a blog post that you wrote or a YouTube video? I’ve been down this road a few times now and there are some things that you need to know. Jump Right To… What You Need to Know About the 10 Phases of Publishing Publishing Myths Busted Should You Write a Book? How I Became an Author Years ago I ran a blog where I talked about my iPhone app business. My audience grew fairly quickly to a peak of 5,000 visits per day because at the time…

  • code

    Can You Embed a Visualization On Your Website?

    I’ve been in a strange place. I mean professionally, of course. Most of the time and in most of the jobs I’ve held I’ve been a data analyst. Or something like that. Research Statistician, Statistical Programmer, Data Scientist, and yes Data Analyst. That is what I do right now. My jobs have all had different titles, but at the end of the day I’ve always worked with messy data. Databases. Data Sources. ERP Systems. APIs. Data Lakes. Data Oceans? Data Warehouses. You get my drift right? What I do is part engineering and part scientist. Sometime hacker. I have to find out where data exists, use programming to pull it…

  • code

    Pro Data Visualization with R and JavaScript

    This page is where readers of my upcoming book will be able to find resources discussed in the book along with added content that will be added post-publication. Jump Right To… Chapter Code and Resources Downloads Web Visualizer Training Blueprint Web Visualization Training Blueprint Soon after I started working on Pro Data Visualization with R and JavaScript I realized that the material would be a stretch for almost any reader. The simple fact is that the skills that you need to be a successful data analyst or data scientist and a successful full stack web developer are very different. They seem to be the same on the surface. After all,…

  • code

    Bar Plot w/ ggplot2

    Quick reference for using ggplot2 with R. This package uses data from my covid data pipeline. Please see that post for more details on the data content. Simple Barplot This will result in a very basic plot that looks like this. Better Barplot We need this to look a little better, so here is how you add labels and adjust the scales so the numbers come out in a readable format. Now we get a nicer looking plot that is ready to publish. Horizontal Barplot Now here is a spruced up Horizontal Boxplot. And you will get something like this. Where to Learn More You can make most graphs with…

  • code

    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…

  • code

    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.

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

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