How to Build Google Analytics User Personas & Profiles

Building a Google Analytics Personas or  Customer Profile is an essential practice that all marketers should use. This profile can be quickly created using Google Analytics and Excel. However, it must be said that there are issues with data collected from Google Analytics such as this data is just a sample. However, the sample size […]

Continue reading

Install Hotjar with Google Tag Manager

Installing Hotjar has just gotten better and easier with a native template. Previously, you had to install this script with a custom HTML tag in Google Tag Manager. The this can done in 4 easy steps  in three phases. Take a look at the diagram below in order to see how to set this up.   […]

Continue reading

Chicago Crimes 2015 vs 2016 Data Visualization

Crime in Chicago has soared while other metropolitan cities have seen a major decline. To be exact, most crime in Chicago has not seen any major increases except for homicide. Homicides in Chicago in the first 8 months of the year have already soared beyond the sum of homicides in 2016. This begs the question […]

Continue reading

Interactive Google Analytics Dashboards with Tableau 10

Visualizing your data is one of the quickest ways to discover insights and communicate complexities. Google Analytics Dashboards provide you with everything you need to highlight performance trends. However, the user experience and visuals aren’t that great. Using Tableau allows you to connect to the Google Analytics Database and overcome these shortcomings. The data can […]

Continue reading

Is Google Page Speed Insights Accurate?

What does Google Page Speed Score Measure? Google Page Speed Insight Score is often used to grade the speed of a website. However, the same question always arises; is this an accurate measurement. The answer may lie in Google’s own definition of their test. Google defines the Page Speed Insights as a correlation of network-independent […]

Continue reading
  • October 3, 2016
  • Blog

F.B.I. Hate Crime Statistics — Visualization

    How I made this Viz: This was a very easy viz to make because there were no parameters or calculations. It was made purely with two essential sheets. One for the Map and the other for the bar chart. I made this by searching the net for hate crime statistics. I ended up […]

Continue reading
  • September 3, 2016
  • Blog

Time Spent in Daily Activities by Race, Weight, and Gender.

    How this was built: This dashboard allows you to explore primary daily activities on race, gender and body weight. It is broken into hours as the primary measure. Explore the viz below. Feel free to interact with the data. The source of this data was taken from two United States governmental database. One […]

Continue reading
  • August 30, 2016
  • Blog

How Social Media Managers Can Show ROI

With social media, there is always a question how to attribute its value to the bottom line. revenue So, I wanted to explore data driven ways that a social media marketer could demonstrate his or her value to their boss.  Here is a simple calculation below: Social Media ROI = Revenue(Assisted and Direct) – Cost/ […]

Continue reading
  • August 25, 2016
  • Blog

Fatal Attacks by Dog Breed

How I made this Viz The data was taken from Wikipedia using the Power Query in excel. Once the data was imported, it was manipulated in excel. The viz contains two major sheets created in Tableau. The age group worksheet was made by using the SUM of number of records and the age of victims. […]

Continue reading
  • August 11, 2016
  • Blog