The Money Fight: Mayweather vs McGregor

Click for interactive version

Like most Americans, I bought into the hype of the Mayweather vs McGregor fight.  This fight paired a legendary boxer against a champion MMA fighter, so I was very curious to see the outcome.  Going into the fight, I had no idea if McGregor would be knocked out in the first few rounds or somehow land a knockout on Mayweather.  This was definitely the most unpredictable fight I have seen.

McGregor had a strong start as Mayweather played it cautious taking and landing far less punches.  McGregor ultimately threw 110 more punches than Mayweather, which most likely contributed to his fatigue we saw in later rounds.  By Round 6, Mayweather had closed the gap in punches landed, and as McGregor continued to fatigue, we saw Mayweather unleash in Round 9.

In Round 9, Mayweather landed 42 punches, the most of any round, against only 10 for McGregor.  This was the pivotal round where Mayweather began to dominate the fight.  In the 10th Round, Mayweather landed 20 punches to McGregor's 4 before ultimately scoring the TKO.

Real-Time 2017 Eclipse Path

This viz will update every minute with the eclipse's umbral path.

How To: Create Eclipse Path Map in Tableau

I recently saw a visualization on Reddit that showed Google search result interest for the word "eclipse" plotted with the path of the 2017 eclipse.  Since I will be right in the heart of the eclipse's path, this event has been very fascinating to me, and I wanted to see if I could build the same visualization in Tableau.

Building the visualization in Tableau is very simple with most of the work occurring in QGIS.  Here's everything you will need to get started:

1. Download and install the appropriate version of QGIS
2. Download and install the MMQGIS plugin
3. Download the shapefile for the United States.  I used the file from
4. Download the eclipse shapefile from the Cannon of Solar Eclipses Database

Now that you have QGIS setup and the necessary files, we can start to create the shapefile for Tableau.  I'm not an expert in QGIS, so there could be easier ways to do this, but I wanted to give a big thanks to Adam Crahen for helping me through a few issues.

1. Click Layer, Add Layer, Add Vector Layer in QGIS

2. Choose the Eclipse shape file

3. Do the same again, but this time choose the state shape file

4. Now you will see both shape files overlaid.

5. Click the MMQGIS plugin and choose Merge Layers.  This will create a merged shapefile.

6.  Choose the layers to merge and select an output file

7. Open Tableau, connect to a new data source, and choose Spatial file

8. Tableau makes this really easy.  Simple double click the Geometry measure.

9. Tableau will generate the latitude and longitude and render your states with eclipse path

Now you can join or blend additional data sets to the state field.  In this case, I used the Google Trends results for the word "eclipse" and blended the data.

Feel free to download the workbook if there are any issues and comment with any questions.

Makeover Monday: Results Voided

For this week's Makeover Monday, I wanted to do something a bit more analytical.  I wanted to see if you could statistically detect when a cyclist may be using performance enhancing drugs.  Using Z score calculations in Tableau, I was able to see which years out of the last 20 were potential outliers. A good test for an outlier is +-2 Standard Deviations.  Once I built the Z score calculations and applied it, you can see that in 2005 there was a fairly strong outlier.  This is the only occurrence in 20 years where the average speed was 2 standard deviations faster than the mean and also the fastest speed in Le Tour de France history.  This record was set by Lance Armstrong, who later confessed to using performance-enhancing drugs in 2013.