Category Archives for "Blog"

We hope to bring you the best in thought, news and reviews in regards data insight and digital data analysis

Power BI, Tableau and Google Data Studio Comparison

As the volume of data triples each year, businesses are challenged to make sense of it. Many will turn to use data visualization software to gain a deeper understanding of their key performance indicators and derive insights. Using business intelligence software allows one to interact with, interpret, and display the data, among many other great […]

How to Make a Tree Map in Python

Often we we want to show the size differences for groups, we can use things like a tree map. A tree map plot doesn’t come out out the box with the traditional plots such as Matplotlib and Seaborn. The tree map provides a visual representation of the various proportions of categories, much as a pie […]

Cohort Analysis with Python

Using Python to understand user retention is much easier than you might have imagined. All of this can be done with a few libraries. For this tutorial, we will be using Pandas, Matplotlib and Seaborn and Datetime. You can follow the along in the video to save time if you are in a rush. You […]

Data Analyst Toolkit

As a data analyst there is a wild range of tools you need for exploration, analysis, visualization and prediction. I thought this was good opportunity to explore the most popular and go to tools for data analyst.Stage 0: Identify Business Questions.These tools are critical for collection thoughts and ideas from stakeholders. This is the most […]

Top E Sports Earners

E-sports has been become a multi-million dollar industry with over 160 million dollars in prize money in 2019 alone.  I wanted to explore the earnings of the top tournaments, players and games below. There is an awesome sight with all this data compiled and tracked. You can go to esportsearnings.com . If want you learn […]

Which Superhero Has the Most Powers? | Data Viz

The datasets This data set was sourced from Kaggle. There are two data sets that had to be preprocessed and merged. The first data set contained each out the hero’s dimensions such as race, eye color, and other physical dimensions. The second dataset contains all the powers that are valued in boolean format.  The booleans […]

Create a Seaborn Scatterplot

A scatterplot is one of the best ways to visually view the correlation between two numerical variables. Seaborn has a number of different scatterplot options that help to provide immediate insights.  This tutorial will show you how to quickly create scatterplots and style them to fit your needs. Learn Seaborn Data Visualization at Code Academy […]

How to Remove Leading Zeros Power in BI

Getting rid of leading zeros can be kind of difficult in Power BI if there is no consistency in the number of zeros. However, I am going to demonstrate a few easy ways to eliminate leading zeros in Microsoft Power BI. Change the Data Types One of the little known tricks in Power BI to […]

Add Data Entry Form in Excel 2016

You can quickly add a data entry form in Excel 2016 in just a few clicks. The steps to add a data entry include adding the form to your quick access menu and creating a table with headings for the data to be entered and finally initiating the table. Yes, that is all that is […]

Find and Highlight Duplicates in Excel

You can quickly find duplicates in Excel by employing a few different strategies. Often users want to see if there is a duplicate email in a list. Also, retailers may want to see if there have been duplicate transactions over a given period of time. There are tons of scenarios where you may want to […]

1 2 3 4