A while back you may have caught my blog post introducing the Power BI Chat Bot 9000. Since posting that blog, I’ve received a lot of requests on the steps required to build the bot. The good new is that its super easy and really only take a few minutes to get it set up. In this blog post, I’m going to walk you through how to set up your own chat bot by creating a chat bot based on the SQL Database FAQ, which can be found here. Continue reading Creating a Knowledge Base Chat Bot w/ Azure Bot Service
The Data Migration Assistant is a great tool developed to assess your SQL Server environment for a migration to a modern SQL Server platform such as SQL Server 2017 or Azure SQL Database. If you’re assessing a single SQL Server with only a few databases, reading the exported results (which can be in .JSON or .CSV format) may not be that difficult. But if you’re assessing dozens of environments including hundreds of databases, we need a better way to understand the results. Continue reading Making Sense of Data Migration Assistant Assessments with Power BI
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
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
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.
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.
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
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.
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.
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