Power BI preview has had a few new features added over the past few days. The most exciting of these is the Power Q&A functionality.
I have only got to play with the sample workbooks so far (as i don’t think you can yet add data) however it is as impressive as the Amir Netz Demo promised!
If you have a Power BI site already you will need to add the samples to get the new content, this then appears as a popular questions area above your reports library.
Clicking through there give a selection of popular questions with some nice images (how are we going to be able to control them in ‘real life’ scenarios?)
Clicking through to ‘Sports with the most medals’ give us a nice visualisation of the data we have asked for as well as a number of suggestions of similar questions to ask.
As some of you may know I’m a keen cyclist, so what happens if i free type ‘count of cycling gold medals by country name’? Power Q&A shows me a map as shown below
This is really interesting in that it has correctly realised i would like a bubble map, however you can see from the detailed description that what is is actually displaying is the Olympic host country where the medals were won. This was not the data I was looking for so i will change my query to Nationality. This is a reminder of the complexities of Natural Language search but i am impressed with the Power BI display of what it thinks you mean allowing for quick corrections.
This is much more like it, the most successful Olympic cycling nations of all time, we can take this further and add more filters or visualisations:
So to wrap up, initially i am very impressed. I can’t wait to point it at some real business data and see what I can do with it in that environment. I’m really excited to see how you manage the metadata and how much control you have with synonyms. Get hold of the preview if you can and prepare to be impressed!
Feel free to get in touch @calvinferns
Update:
you can also ‘show field list’ and go back to working the traditional way or double check what it has chosen for you!
Part 1 – Introduction to Geospatial data
Geospatial data is a niche area that is increasingly becoming utilised in the data analytics
Jan
Logic Apps: Saving files sent via Emails into Blob Storage
Using Microsoft Logic Apps we save files to Azure Blob storage that are sent to
Jan
Create and setup B2B Integration Account in Azure
An integration account allows you to build Logic Apps with enterprise B2B capabilities by adding
Jan
Time to move to the cloud? What to expect when migrating to Azure
Moving to the cloud can be complex. Here’s a simple breakdown you need to know
Dec
Serverless Transformation Data Pipelines with Serverless SQL Pools
What are Serverless SQL Pools? Serverless SQL Pools or SQL on-demand is a serverless distributed
Dec
Basic structure of x12 Edi message
All EDI transactions get defined by EDI message standards. It is vital to have proper
Dec
MultiVendor Cloud Security with the Microsoft Stack
Over Last few years there has been a large rise in identity based attacks and
Nov
Azure Logic Apps B2B EDI integration capabilities
One of the standard and most commonly used suites of protocols for B2B data transfer
Nov