30 Oct’17

BINatural Language Q&A in Power BI

Introduction:

Power BI comes with a powerful language recognition engine that lets you ask questions of your data using conversational phrases and questions. Based on these questions, Power BI dynamically creates charts and graphs. For example, if the data is defined as a date type, it is more likely to be displayed as a line chart. Data that is categorized as a city is more likely to be displayed as a map.

Questions can be asked on a dashboard. The feature is called as Q&A or Questions & Answers. Natural Language Q&A is really an underused tool in Power BI despite of being really powerful.

Following is my dashboard on a Credit Card transaction dataset. I will be performing simple Q&A questions on this dashboard.


Pre-Requisites:

Power BI Subscription

Features of Q&A:

  1. Auto Prompts:
    This prompts are created on the basis of:
    a. the questions used to create tiles that are already pinned to the dashboard, and
    b. the name of tables in the underlying dataset(s).

    Can build a question using the prompts (Eg. What is the total amount in April)

  2. Dropdown pops up while typing a question. Helps with auto-replacement terms as well.
  3. Can use Aliasing table to make querying more powerful.
  4. Featured Q&A Questions
    1. Click on your Dashboards Ellipses and then select Settings.
    2. Click on the Datasets tab and select Featured Q&A questions.
    3. Select Add a question and type a question and then click on Apply.
    4. Now whenever a user starts typing on Q&A they will be prompted with this question first.
  5. Dims words it does not understand.
  6. Can combine results from more than one data set. When you type a query, Power BI looks for an answer in any dataset that has a tile on that dashboard.  If all the tiles are from datasetA, then your answer will come from datasetA.  If there are tiles from datasetAand datasetB, then Q&A will search for the best answer from those 2 datasets.
  7. Dynamically generates a visual depending on the question.
  8. Can change the visual type using the ‘as’ keyword.
  9. Can pin this new visualization back to your dashboard.
  10. The visual answers can also be edited. Just by using the Visualizations and the Filter panes on the right side of the screen we can alter the layout, adjust filters and change fields.

Conclusion:

We have discussed the various features that can be used with Q&A which can improve our ability in analyzing data.
 

Written by

Shannon Pereira

Software Engineer

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Reading more then 10K records in D3FOE OData API

    11 July’ 2018

    Introduction: We all know Dynamics 365 Finance and Operations has limitation of 10K records to be fetched at a time usi...

    Read more
  • Paging in D365 Customer Engagement v9.0

    10 July’ 2018

    Introduction: The Xrm.retrieveMultipleRecords method is used to retrieve a collection of records in Dynamics 365 Custom...

    Read more
  • Set up Dynamics 365 connection in Microsoft Social Engagement

    10 July’ 2018

    Introduction: This blog explains how to Set up Dynamics 365 connection in Microsoft Social Engagement. Steps to be follo...

    Read more
  • Voice of the Customer failed to install

    10 July’ 2018

    Introduction: Many people face issues in installing Voice of Customer solution on v9 environment and trying repeatedly ...

    Read more
  • Scribe Insight AX as a Web Service Find Block issue

    10 July’ 2018

    Introduction: If we need to look up for any value from AX then we do it by using a Find Block in Scribe Insight Eg: Basi...

    Read more