Power BI has been on a roll recently, releasing a bunch of features that have overall strengthened Microsoft’s self-service business intelligence offering. It’s spiritual predecessor PowerView had a nice integration with PowerPoint. Now Power BI PowerPoint integration has arrived.
In the September update, we received a big upgrade to Power BI’s mapping capabilities through the introduction of ArcGIS maps. There has also been continued development around R integration within Power BI to better support the needs of customers requiring advanced analytics. You can now even connect to your preferred R IDE when developing R-based custom visuals or run an R script over your dirty data to impute missing values.
Power BI PowerPoint integration
n the last couple of days, Power BI has quietly released a feature that I personally think will get everyone excited and appeal to the masses – the ability to publish Power BI reports to PowerPoint with the click of a button! So lets get started on how you can find and use this new feature.
Open up a report in Power BI Online and click “File”. You will then see the screen below. Click the “Export to PowerPoint (Preview)” button to generate a PowerPoint file. It will contain a slide for each Power BI report page as well as a title slide containing information on when the data was last refreshed and the file downloaded.
Unfortunately, as you can see in the screenshot below, the end result is not what I expected. I would have liked to have seen a fully interactive experience that included the ability to use cross-highlighting/cross-filtering. It appears, for now at least, that the feature has fallen short of my expectations.
That being said, there are a few caveats, the first and biggest one is that this feature is in preview. We know from past experiences that Microsoft has been happy to ship features to Power BI that aren’t fully ready in the hope that they can leverage feedback from the community sooner rather than later. A recent notification from the Power BI team confirmed that this will be the case.
The second caveat is that in this demonstration we have used some Agile BI magic behind the scenes which probably has caused some headaches for Power BI’s cookie cutter Power BI PowerPoint feature. I tested this hypothesis by exporting a more simplistic Power BI report and I’ll be honest, I was impressed with the results.
The moral of the story, keep it simple for now.
This feature will eventually end up becoming a main selling point of Power BI over its competitors, but it still has a long way to go.
I’ve found with some things in Power BI you just have to be patient. In 2-4 months time, this feature will be generally released and I’m going to assume that this feature will end up being a lot closer to our current expectations. To put things in perspective, it has been less than a year and a half since the launch of Power BI and it has already become one of the leaders in the self-service BI market according to Gartner. In my opinion, one of the reasons that people see strength in Power BI is that they know it will continue to grow and develop faster than any other self-service product. I hope it continues as it’ll mean we’ll be seeing more new and improved features like this one coming to Power BI soon.
The September Power BI update is here and Power BI Maps have got a serious set of improvements. Mapping beforehand was … ok. Points and circles, pretty much like PowerView in Excel – it served a purpose, albeit a basic one. Now in the preview features there’s a new Shape Map (which replaces the Synoptic Panel in some circumstances) and even more Geospatially exciting ArcGIS Maps.
I’m excited! Let’s dig in…
Power BI Maps – Shape Map
Shape Maps are a variation on a map that assigns an ID to a region on a map – a number of baked in maps are provided – standard geographical maps are included – and you can then assign a number to that ID. Like below, I’ve just assigned some numbers to the States on a map of our lovely country:
Now, where this gets interesting is you can create your own shape maps as long as they are in the TopoJSON format. So if you want to map out your own space, such as a store – like in our partner showcase – you can create your own shape file, add keys to it and visualise it in Power BI Maps. This is a great feature for simple heatmaps and being able to build truly personalised data visualisations.
Power BI Maps – ArcGIS Maps
This is the industrial version of the existing map capability. Using ESRI maps you can create heatmaps, point maps, clusters, all driven by geospatial coordinates. I’m not going to get too deep on the technical side, but suffice to say beautiful mapping is well and truly here:
There’s a good source of fun data here if you want to play – just remember in the data model to tag the columns Data Category as Lat / Long as appropriate otherwise the mapping won’t work.
This update brings also reference layers which add secondary data such as populations, map based selection of points to apply filters to the rest of the report and a heap of other features – Power BI Maps have taken a big leap this update!
AgileBI is a leading Data Analytics consulting firm based in Sydney. We are a Gold Microsoft partner with fully-certified experienced people that can implement, tailor, and support Microsoft Business Intelligence products and solutions.
Microsoft Gold Data Analytics Partner
Microsoft Silver Cloud Platform Partner
Get in touch
1300 441 618
(02) 8088 7440
Suite 2, Level 1, 18-20 York Street, Sydney, NSW 2000