Category Archives for "Blog"

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

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 […]

Vlookup vs Index Match

Vlookup is probably one of the top 5 functions that asked for Excel professionals to demonstrate for analysis or while interviewing. I can personally attest that early in my career I was asked whether I could do Vlookup hundreds of times. I often wonder why VLOOKUP became the go-to function for looking up data when […]

Python for Data Science –Free Learning Path

It took me a long time to learn Python. The reasons are aplenty on why it was such a long journey. However, hands down, I can tell you the main reasons are due to the vast amount of flexibility with Python. I tried to learn too much at one time instead of focusing on key […]

Google Store Most Installed Apps

The  Google Apps store has a plethora of different apps ranging across a ton of different categories. Here is a visualization created in Tableau that give you an idea of what are the most popular apps on the platform.       The dataset was sourced a Kaggle.com in the form a CSV. I did some light […]

70 Excel Keyboard Shortcuts to Save Time

One thing that I love to do more than anything is save time. So, here is a collection of some of the most useful Excel Keyboard shortcuts. These should help you become much more efficient and leave more time to analyze and visualize your data. These 70 tips range from general to data operation. If […]

NRA Political Donations from 1990 to 2018

NRA Donations by Party and Politician Where does the NRA concentrate their donations? You can view the data according to the New York Times, OpenSecrets.org and Fortune Magazine. The top politicians that receive money from the NRA are overwhelmingly Republican with Donald Trump who is the the top politician of the Republican party with over […]

Tableau vs Power BI – Which is the best tool for you?

Tableau vs Power BI The two top business intelligence and data visualization tools are Power BI and Tableau. The products are similar and the decision between the two is dependent on the specific needs of the company including budget, organization, and intended use. Tableau for Data Science A-Z for $10 Bundle. Become a Tableau Expert. […]