Category Archives for "Power BI"

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

Learn Power BI Fast

AbsentData Blog Google Tag Manager Tableau Analytics Tutorials Adwords Excel Power BI PANDAS Get Sh*t Done in Power BI1.5 hour Short Course If you hate overviews and need to learn fast. This is the course for you .NON TRADITIONAL LEARNING.Step 1:  DO FIRST ASK QUESTIONS LATER!You can get a dashboard up and running quickly without even […]

10 DAX Most Useful Power BI Functions

The importance of data analytics and visualization has grown tremendously over the last 5 years. The terms Data transformations, Big Data, AI, and Blockchain are discussed in every sphere of business including operational staff and c-suite executives. It is of paramount importance that huge data sets are visualized efficiently to give managers better insights and […]

Starbucks Calorie Burn Calculator

  This data was sourced from Kaggle which had both McDonalds and Starbucks items datasets. The data was broken up by items and nutritional elements. I put this data into a Power BI dashboards. There were several functions to get this to work. The exercise data set was sourced from Nutri Strategy I based all […]

Sentiment Analysis in Power BI

How to use natural language sentiment analysis in your text data with Power BI. I am really starting to fall in love with Power BI now that I have the ability to use Python scripts to transform my data and bring my visuals to a whole new level. We will use the NLTK Sentiment Intensity […]

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