Today I sat through the Keynote session at the Microsoft Data Insights Summit. As expected, James Phillips confirmed that MS has been holding back a few killer features to announce at the Summit. Here is the list of new things that are coming that I wanted to share with you – I am truly excited.
All of these features should be released sometime between now and the next 3 months.
New Pricing Tier
There was an announcement of 2 new Power BI capacity based tiers (EM1, EM2) design specifically for Power BI Embedded. The price starts at $625 per month. These new tiers are designed for Power BI embedded, but can I understand they can also be used for general premium distribution. I saw a demo of this being deployed inside SharePoint and also Microsoft Teams. This was very cool and maybe (just maybe) it will address the SME pricing gap I have been complaining about a lot lately – let’s wait and see.
I want to call this one out – this is massive for companies that want to improve their processes in the business (I personally have worked on process improvement for many years and I know the benefits of measurement and management). You can now paste a Visio Diagram into a Power BI Report, and the data is mapped to the process diagram (using process IDs in your data set and Visio). It means that you can load your process map, add a colour saturation to highlight blockages in the individual process steps based on the data, and then drill down to see the detail. There are many people that won’t be excited by this, but believe me, this has the potential to be huge.
Write Back to DB
We saw a demo of Power Apps embedded directly into Power BI. The App accepted input from the user and then the changes were written back to the database. I am not sure exactly how that works, but I am sure we will hear more about that in the coming months.
Drill Through Pages
This is another killer feature that many have been asking for (or something similar). The new feature allows you to build one or more “Drill Through” pages in your report. Once you have your drill through pages, you can click a button on a main page and then drill through to the underlying page – WITH FILTER CONTEXT!. Wait did you get that – WITH CONTEXT! This means you can explore something at a high level on one page, when you find something interesting you can swap to a detail page and pass all the filters from the first page to the new page. And there is a back button when you want to go back.
There is a new Bookmarks pane coming. You can save the status of a page with the current filter context, and come back to it later by clicking on the bookmark. Once you have a few bookmarks in your report, you can string the bookmarks together into a “play feature” so you can tell a story live in the system – fully interactive. As a bonus, there is a new show and hide feature that allows you to turn on/off visuals on a page. And what is great is you can turn on/off individual visuals on the same page and use them in the bookmarks to tell a story. Bookmarks can also be used as links on buttons from within pages so you will be able to jump between pages and also to change the visible visuals on the same page, all using the bookmarks and buttons.
There is a new What If Parameters feature coming to Power BI. If you have a measure that is hard coded at say 0.75 for the AUD/USD exchange rate, you will be able to easily set up a new parameter that can adjust the value of the exchange rate straight out of the UI – very cool.
More from Quick Insights
There were a few excellent improvements coming to Quick Insights. One I really love is “Explain the Increase/decrease”. This is a context sensitive Quick Insights. Find a line that is growing over time, right click on one of the data points and then select “Explain the Increase”. Quick Insights will use the machine learning capability to analyse the data variation and suggest to you what is driving the change. When you find something interesting, you can add the visual to your report.
And there are more Natural Language improvements where you can have a conversation with the application. You don’t have to write each query from scratch, you can write a query “Total Revenue of Movies WorldWide” and get a Quick Insights report, but then go on to say “What about China?” and the user interface understands that you want to drill further into the previous query.
That’s all for today. Make sure you watch the keynote session from day 1 when it is released in the coming days.