Category Archives for "Power BI"

Learn how to leverage Microsoft’s Power BI to make amazing visuals and data models.

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. Visualize Data with Python. Interpret Large Datasets. A/B […]

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

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

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

How to Use CALCULATE in Power BI

Great Uses for CALCULATE in Power BI Calculate is one of the most versatile functions in Power BI. When you begin using anything from simple filters, time intelligence functions or even advanced formulas, often the CALCULATE formulas are leveraged to produce the desired outcome. Let ’s use CALCULATE to filer a column in a table. CALCULATE […]

Calculate the Time between Two Dates in Power BI

Calculating the time between two dates is a rather simple task. You will just need a starting point and an ending point that has been formatted as a date or time. We can leverage Power BI native functions to get us the data we are looking for.  We will create columns that result in the […]

Using Python Visuals in Power BI

The addition of Python integration in Power BI is one of the greatest things that Microsoft could have done. This gives the user the ability to utilize amazing visual libraries such as Seaborn. Beyond visualization, you can also utilize some of the machine learning packages. If you want to improve your data visualization skill, check out Use Power […]

Add Custom KPI Icons in Power BI

If you are a user of Power BI, you have probably come across the KPI visual. I am often frustrated due to the visual’s lack of flexibility. Also, I would like the old school KPI from Excel to be incorporated into tables and other structures. However, at the moment, these are not native to Power […]

Power BI Dashboard in 10 minutes

Create a Power BI Interactive Dashboard in Minutes Microsoft Power BI is not a difficult business intelligence tool to adopt. So, I have decided to challenge users to create a Power BI dashboard in ten minutes. In this lighting fast tutorial, you will load, clean and visualize data in ten minutes which will culminate into […]

Microsoft Power BI Pros and Cons

Data visualization and data science are hot topics in businesses across America. Every company wants to turn data into a meaningful tableau of information. Power BI from Microsoft is a free or low-cost tool that many companies and individuals are turning to. You can also check out  Pros and Cons of Tableau What are the […]