All Posts by Admin

Python Machine Learning in Power BI

We are going to do some machine learning in Python to transform our dataset into algorithm digestible data for churn analysis. using sci-kit learn It’s a ton easier than it sounds. We will be utilizing the Python scripting option withing in the query editor in Power BI. There typical stages of machine learning. These steps […]

Continue reading

Import PDF Tables in Power BI & Python

One of the best things that have happened to Power BI is the addition of Python scripting options. There are a host of things that can be accomplished such as data imports, custom Python visuals, and advanced data cleansing. For this tutorial, I am going to show you how to import PDF tables into Power […]

Continue reading

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

Continue reading
  • May 27, 2019
  • Blog

How to Create an Excel Step Chart

A step chart is a great way to show how there has been a significant increase at a period of time.  When simply using a line chart in Excel the data is naturally going to trend from one point to the next.  This action creates a slope. As opposed to, a stepchart that will show […]

Continue reading
  • May 23, 2019
  • Excel

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. To create a scatterplot you will need […]

Continue reading

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

Continue reading

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

Continue reading

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

Continue reading

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

Continue reading

What If Parameter in Power BI

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

Continue reading
1 2 3 6