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: […]
Course Materials for Power BI for Marketers
Please find the course materials for the Power BI for Marketers. The below includes the course data source: The link below will give you access to the CSV with the Facebook Sales Data. fb_campaign
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 […]