Conversational BI is here, and it is a competitive advantage your firm needs today. Conversational BI gives you the ability to ask plain language questions about your data via voice or search, and your BI solution returns answers in the form of data to explore, charts, graphs, etc. Gartner predicts that “by 2020, 50% of analytical queries will be generated via search, natural-language processing or voice, or will be automatically generated.” Gartner, Inc. (2018).
Firms that take advantage of this technology can simultaneously reduce costs and fast track BI development by reducing their dependence on:
- Technical experts for ad-hoc data requests and analysis
- BI developers to create new reports and visualizations
- QA Teams for testing
- IT infrastructure teams for deployments and operations
- On-premise hardware and associated CapEx/OpEx
In this blog, we will explore the integrated Q&A feature in Microsoft’s Power BI. Q&A allows your users to ask questions directly of your data such as “what were total sales last year.”
Power BI Q&A
Power BI Q&A quickly and easily enables natural language processing by leveraging the names/aliased names of columns within the dataset to build an automatic default linguistic schema.
To enable Q&A for a data connection
- In the upper-right corner of Power BI, select the cog icon and choose Settings.
- Select datasets and choose the dataset to enable for Q&A.
- Expand Q&A and Cortana, select the checkbox for Turn on Q&A for this dataset and choose to Apply.
- It is extremely important to name/alias the dataset’s column names with descriptive meanings that your users will understand and use when questioning data.
- You can also edit the default Power BI linguistic schema to tailor it to your users and business with custom phrases, synonyms, etc. You can export and import the linguistic schema YAML file for a model by opening it in Power BI Desktop, going to the Modeling tab in the ribbon, finding the Q&A group and clicking Linguistic Schema.
Where to Find Power BI Q&A
You’ll find Q&A on Power BI service dashboards (web and mobile), above visualizations in Power BI Embedded, and as a visualization type (Q&A Explorer) you can add to reports.
How to Use Power BI Q&A (Text)
- When selected Q&A shows you keywords and sample/suggested questions that can be selected and added to the question box.
- Q&A helps you ask questions is with prompts, auto-complete, and visual cues.
- Answers are nearly instantaneous since Power BI runs on Microsoft’s Azure cloud platform with in-memory storage.
Your initial question is just the start. You can explore your data and expand or refine your question, find new information, and traverse hierarchies and drill in on the details.
How to Use Power BI Q&A (Voice)
Search-based type questions are just the start though. Power BI also integrates with Cortana (Microsoft’s virtual assistant) making voice-driven Q&A available across many of your devices including PCs, Android, and iOS. Simply say “Hi Cortana” and ask your question.
“Hi Cortana. Can you show me the last 12 months revenues by store?”
Power BI Data Sources and Compatibility
Power BI supports a wide range of data sources that can be internal or external to your organization including flat files, databases, and cloud or web platforms such as Facebook, Google Analytics, and Salesforce objects.
The fastest way for your users to get an answer from your data is to ask a question using plain language. By democratizing access to data and significantly reducing dependence on IT expenses, the ROI on Power BI Q&A is extremely high because it starts at an affordable price of $9.99/user/month with a Pro license.
Keep your firm a leader in the legal services industry with answers to your questions at your fingertips. If you need a company with extensive experience in setting up, configuring, and customizing linguistics for Conversational BI, please contact JBS Solutions at (888) 421-1155 x682.