All posts by Dustin Ryan

Dustin is a Data Platform Solutions Architect on the Education team at Microsoft. You can find Dustin blogging and speaking at events like SQL Saturday, Code Camp, and SQL Rally. Follow Dustin on Twitter @SQLDusty.

Setting Up a Drillthrough Action in your Power BI Report

At some point this weekend, the Microsoft Power BI folks turned on the drill-through feature in the Power BI service. Then the following week, the September release of Power BI Desktop included the new drill-through action feature. This is the same drill-through feature that demonstrated during day 1 of the Microsoft Data Insights Summit, which you can read about here. So I thought it’d be good to quickly walk through how you can set up the drill through action. Continue reading Setting Up a Drillthrough Action in your Power BI Report

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

Power BI FAQ Chat Bot 9000 lives!

So I’ve been working on a fun little project over the past couple weeks. A lot of my customers have questions related to Power BI and I spend a lot of my time answering those questions. So I said to myself, “Self, why don’t you build a chat bot that can help field some of those basic questions?” Thus was gloriously born the Power BI FAQ Chat Bot 9000!

The Power BI FAQ Chat Bot 9000 uses Azure Bot Service leveraging a knowledge base created using QnA Maker. Later I’m going to do a write-up on how exactly I created the Power BI FAQ Chat Bot 9000 (it only took me about 10 minutes), but for now I just want to share the bot with you. Start with “Hello” and then try asking a few questions like:

What is Power BI?
How is Power BI Pro different than Power BI Premium?
Does Power BI support mobile devices?

Try the bot here. Don’t make him angry!

Or if you’d like, chat with Power BI FAQ Chat Bot 9000 via Skype.

image

Now there’s a couple things to keep in mind. First, the Power BI FAQ Chat Bot is only as smart as his knowledge base, so if you get a funky response back from the bot, its probably because there’s something weird in the knowledge base that I need to sharpen up. The knowledge base is still under construction so let me know if you find oddities. Also, if performance of the bot seems to struggle, keep in mind that I’m using free or low cost service tiers for the technology in Azure running the bot. And whatever you do, do not ask him about the robot overlords.

But totally feel free to ask Power BI FAQ Chat Bot 9000 any questions related to Power BI! The knowledge base I’ve provided is based on the documentation and frequently asked questions sections of PowerBI.com.

If you have any questions or suggestions, feel free to leave a comment down below! I’d love to hear your thoughts about the Power BI FAQ Chat Bot 9000.

Building Your Brand and Becoming a Thought Leader Session Materials

Thank you to everyone that attending my session today at SQL Saturday #649 in Jacksonville, Florida! It was a packed room with over 70 people attending my session and the audience was lively! We had lots of great questions and tons of awesome interaction! If you want to download my slide deck from today’s presentation you can do that right below. Continue reading Building Your Brand and Becoming a Thought Leader Session Materials

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!

How to Automate Processing of Azure Analysis Services Models

I’ve been working on a proof of concept for a customer that involved using Azure Analysis Services as a cache for some data in an Azure Data Warehouse instance. One of the things I’ve been working on is scheduling the automatic processing of the Azure AS database. I did find the following documentation on the process, but the screenshots of the Azure portal are out of date and I did find some errors in the instructions. I also found this very extensive project for partition management in Azure AS, but this was a little overkill for my purposes and I was just interested in the very basics.

Read my recap for MS Data Summit here

These previously mentioned resources led me to write this blog post. In this post I’m going to leverage the previously mentioned article and walk through creating an Azure Function App to automatically refresh my Azure Analysis Services model, while correcting a few errors and updating the screenshots.

If you’re new to Azure Analysis Services, take a look at this documentation. For the purposes of this post, I’m going to assume you have a basic understanding of Analysis Services.

Continue reading How to Automate Processing of Azure Analysis Services Models