Category Archives: power bi desktop

Preparing for Microsoft Certification Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI

Late last month Microsoft released the certification exam for Power BI, 70-778: Analyzing and Visualizing Data with Microsoft Power BI. The exam is currently in beta and will likely remain that way for the next eight to twelve weeks. If you were lucky enough to snag one of the 300 uses of the voucher code, you’re already registered for the exam. If not, you’ll be waiting until the certification exam’s beta period is wrapped. And then everyone will be able to complete the exam. Thankfully I was able to take the exam a couple of weeks ago but am still waiting on the results for the next few weeks.

If you’re fairly new to Power BI or don’t have much experience with the Power BI ecosystem, I’d recommend starting with these helpful self paced learning options. Continue reading Preparing for Microsoft Certification Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI

What-If Analysis in Power BI Desktop

One of the most talked about features previewed during the Microsoft Data Insights Summit in the previous June was the What-If Analysis capabilities. Today, this capability was finally released as part of the August update to Power BI Desktop.

New to Power BI? Start here!

The What If Parameter feature allows you to dynamically perform what-if type analysis by using a slider bar to visualize changes to a calculation. This becomes a very flexible way to perform all kinds of different “what if” type scenarios.

how to set up what if analysis power bi

In this blog post, I’m going to walk through setting up a simple What-If type scenario to dynamically change a Revenue Target calculation. Continue reading What-If Analysis in Power BI Desktop

Power BI NFL Football Stats Comparisons and Analysis Report is now available!

For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power BI reports featuring player statistics. This year is no different. This year I’m finally able to release my NFL Football Stats, Comparisons, and Analysis reports featuring the stats for players at the quarterback, runningback, wide receiver, tightend, and kicker positions. Unlike previous years, this years reports are based on data from NFL.com. My goal for producing this report is, as nerdy as this is, to give me a leg up on my fantasy football drafts. If you’ve ever played fantasy football, you know the key to winning is having the deepest roster and I hope that these reports will allow me to identify middle and late round talent using the collected data in a readable and navigable format.

I think this is probably my best version of the NFL stats report that I’ve released yet, and there’s a few reasons why I think so. First, I included Continue reading Power BI NFL Football Stats Comparisons and Analysis Report is now available!

Power BI Architecture Diagram v3 is Now Available!

Over the past couple weeks there has been a ton of news and announcements around the direction Microsoft is taking Power BI. Between Power BI Premium and Power BI Report Server, my head has been spinning trying to stay educated on all the new changes and enhancements. With all these announcements, it was definitely time to update my Power BI architecture diagram to reflect the addition of Power BI Premium and Power BI Report Server.

Here’s how to install and set up Power BI Report Server (Preview)

I’ve made a few changes in v3 of the Power BI architecture diagram. Continue reading Power BI Architecture Diagram v3 is Now Available!

Microsoft Business Intelligence Materials from Discussion at Jacksonville University

Today I had the wonderful pleasure for leading a discussion regarding the products, services, and tools Microsoft provides in the business intelligence stack. I met with Jacksonville University students and faculty and also had the pleasure of speaking with members of local businesses that are interested in leveraging Microsoft technologies. It was a wonderful experience and I had a great time!

If you’d like to download my slide deck from the discussion and presentation today, you can find that here.

Continue reading Microsoft Business Intelligence Materials from Discussion at Jacksonville University

Introduction to Power BI Desktop – Session Materials Available

imageFor my second time, I was afforded the great opportunity to present virtually to the great people of the Madison Power BI User Group. I’m always really excited when someone invites me back a second time to speak because that means that the first time wasn’t completely awful! We had a great time last evening discussing Continue reading Introduction to Power BI Desktop – Session Materials Available