Category Archives for "Power BI"

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

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 OptionsThe first step you will need to take is to navigate to the top ribbon in Power BI and click […]

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

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:SUMCALCULATELASTDATEDATESINPERIODDISTINCTCOUNTThere are […]

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

Best Power BI Courses

​Power BI’s user-base is growing daily. In just a few years, the adoption of Power BI into data productivity suites has exponentially grown. The team at Microsoft provides monthly updates that increase Power BI’s functionality and customization. ​If you are familiar with the field of data visualization, you would have heard of Power BI as […]

Does Height Affect Becoming the President

Open the dashboard below and interact with the data. This dashboard shows all the presidential election by nominee and winner. The height of each candidate is listed. Unsurprisingly due to better nutrition and medicine, the presidents have grown in height. The largest disparity exist in the last presidential election when 6’3″ Donald Trump the current […]

Diabetes Across the United States Dashboard

Data is from the Center for Disease Control which has health and disease penetration by state, county and city.  This dashboard was created in Microsoft Power BI with two CSV export from the CDC that listed percentage of residents with diabetes by year and state.  No calculated measures were created due to the data having […]

1 2 3