Category Archives for "Power BI"

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

Avoid Python Errors in Power BI

When integrating Python into Power Bi, you will often be faced with integration issues. However, luckily, there is a very easy way to avoid these problems. In this post, we are going to evaluate how to sidestep some of the major errors with Python in Power BI. Missing Dependencies The most common error is that […]

Get Google Trends Data into Power BI with Python

As of the time of writing this post, there is no native connector in Power BI for Google Trends API to pull data directly a report. However, we can easily do this with just a few lines of Python code. This will allow you to bring in multiple keywords to compare trends over time. We […]

Statistical Tables in Power BI with Python

One of the best things about Python is the sheer number of libraries that can easily be used. You can create correlation tables and statistic summary tables similar to what you find in the data analysis tool kit or in the Pandas library in Python with the native functions. How to create a correlation table:1. […]

Power BI Interview Questions

Here is a list of common Power BI interview questions that are open ended and use to demonstrate the overall knowledge of the applicant. These questions are real and allow you to find intermediate level Power BI practitioners. Answering 6 out of the 10 question would demonstrate a confident familiarity with Power BI.  1. Where […]

Calculate Totals Month to Date & More in Power BI

How to Calcuate MTD, QTD and YTD in Power BI Calculating the month to date, year to date, or quarter to date is not as daunting as you think in DAX. However, there are few stepst that are needed before you can get these function to provide the information that you are looking for.  These […]

Format all the Font in Power BI

You can quickly get uniform text accross your visuals by using the Power BI themes customization. In just a few steps you will be able to quickly alter the text family.  Step 1: Go to Theme Options The first step you will need to take is to navigate to the top ribbon in Power BI […]

Forecasting with Python and Power BI

We are using an airline passenger dataset that you can get from Kaggle, which shows us the data from 1949 to 1960 for airline passengers.  Please find the PBIX file on my Github   Load in my dependencies, which are pandas and numpy and Matplotlib. I’m just going to import those in. And then once […]

Rolling Averages In Power BI

Getting a rolling average should be an native function in Power BI. However maybe at the time you read this, there will already be a a feature added. However, in the meantime lets dive into dynamic rolling average using Power BI. Here are the list of functions will be using the to create our calculation: […]

Sales Prediction Model in Power PI

Leveraging the Python Scripting option in Power BI is a powerful way to build complex machine learning models with the interactive of a dashboard. For the Python model, the SciKit Learn library to create a Linear Regression model that will have a training and testing set for the model to learn on. Then we will […]

1 2 3 4