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 […]
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 […]
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 […]
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 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 […]
Using What If parameter in Power Bi can easily give you the ability to dynamically transform your data. For example, using this parameter will allow to demonstrates how your data change under various scenarios. For example how much revenue would you have if your products were at 10%, 20% or 30% of the retail price. […]
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 […]
NBA All Time Point Leaders This Plotly chart was created using a dataset of NBA players stats from basketball-reference.com. It contains player points, rebounds, assists, starts and etc. I create this visualization by building it in Plotly, based on an initial Python plot created using Matplotlib. I wanted to explore using Plotly cause I thought […]
You can easily create and style a histogram in Seaborn with just a few steps. Let’s get started. You will need a few dependencies to ensure that the plot is shown. The dependencies that you essentially need to load are Matplotlib and Seaborn. However, let’s load the standards such as Pandas and Numpy also in case […]
Definition: Waffle chart is a 10 X 10 cell grid in which each cell represents 1 percentage point summing up to total 100%. Waffle charts can be represented with conditional formatting where cells are highlighted with different colors based on the percentage value of that KPI. There are following used cases of Waffles chart: To […]