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!
Meet the Team – Jason Bonello, Senior Consultant
Meet Jason Bonello! Jason has been with us for just over two years and works
Apr
Meet the Team – Matt How, Principal Consultant
Next up in our series of meet the team blogs is Matt How. Matt has
Apr
MLFlow: Introduction to MLFlow Tracking
MLFlow is an open-source MLOps platform designed by Databricks to enable organisations to easily manage
Apr
Adatis are pleased to announce expansion plans into India
Adatis has offices in London, Surrey and Bulgaria – and has some big expansion plans
Mar
Querying and Importing Data from Excel to SSMS
Introduction There are couple of ways to import data from Excel to SSMS – via
Mar
Data Engineering for Graduates and New Starters
This blog aims to give potential graduates and other new starters in the industry some
Mar
Passing DP-900 Azure Data Fundamentals
Back in December, I took the DP-900 Azure Data Fundamentals exam which is one of
Feb
Real-time Dashboards Provide Transparency to Everyone
Real-time dashboards enable data analytics firm Adatis to be agile and transparent with its team
Feb