Power BI Q&A is a natural language query tool available in dashboards. To start Q&A, click the Ask a question link. Create a query by typing and using the field name buttons. Resolved field names are underlined in a contrasting color. You can specify a sort order, filter, and visualization type. Pin a Q&A visualization to add it to a dashboard.
- [Instructor] Power BI dashboards have a built-in link to ask questions about our data. This is the doorway to Power BI Q&A, a very powerful tool and a final way that we can create a tile in one of our dashboards. Notice that we're in a dashboard when we're doing this. It's the only time that "Ask a question about your data" is displayed. If I click, it takes me into ask a question about your data. It says the customer catalog request table has these field names that I might want to know about.
So I'm going to ask a question, what state. As soon as I say what state, it's going to go to work. Here are my states, and it says, do I want to know about a person? These are values that it's providing. What state is Yoko in? Nope. What state has the most requests? It says I don't understand requests, but I think maybe you mean cat requests, and immediately gives us a chart. That's the count of catalog requests by state. I can save as a table or as a map, as a matrix, as a line chart, as a clustered column chart.
Look at all of my choices. I'm going to say, what state has the most requests as a map, for example. I can see that I have a lot of requests from California, for example, but this is really crowded. So let's back up, and rather than as a map, I'm going to to say, show me a tree map. I like this very much. This is kind of cool, and if I want to hang onto this and pin it on a dashboard, I can do that. Look at this. Pin visual.
Put it on my existing catalog request. Well, let's put it on Catalog Request Insights. That'll work great here. Pin it. It's been pinned to my dashboard, and I can go to my dashboard, but let's do it again, before we leave. I want to make another request for an analysis. I want to say cat requests by month. Wow, as a line chart.
Look at that. It looks like we go on vacation in March and don't come back until November. Hm, maybe we're not asking for catalog requests. I don't want to put this information in a pie. The pie is not going to help me because it takes me a minute, and I go, oh, okay, a lot in December, January, and February, but it doesn't show me this overwhelming issue that we have here. Now, I can just click on anything that's underlined. So if I wanted to see it by state or by zip code or something else, I could.
I think let's look at that as a line chart. That was powerful. Good information. Let's pin this visual to our catalog request insights. For you to be efficient with the Power BI Q&A tool, you will want to know the names of your columns. We'll talk more in the next movie about how to make that easier for you and your colleagues. You want to have a sense of curiosity. You also want to be familiar with the types of visualizations you can use and to know why it's better to show this count of catalog requests as a line chart rather than a pie, because it creates the right conversation about how catalog requests do or do not occur at different times of the year in our organization.
Remember, any time you like the visual that is created as result of your Power BI Q&A session, simply pin it to the dashboard where you would like to see it appear in the future.
Looking for study partners?Join the Data Analytics study group
Discover how to quickly glean insights from your data using Power BI. This formidable set of business analytics tools—which includes the Power BI service, Power BI Desktop, and Power BI Mobile—can help you more effectively create and share impactful visualizations with others in your organization. In this course, Gini von Courter helps you get started with this powerful toolset. Gini begins by covering the web-based Power BI service, explaining how to import data, create visualizations, and arrange those visualizations into reports. She discusses how to pin visualizations to dashboards for sharing, as well as how to ask questions about your data with Power BI Q&A. She also provides coverage of Power BI Mobile—explaining how to use it to view and share your data—and shows how to use the data modeling capabilities in Power BI Desktop.
- Working with cloud-based and on-premises data sources
- Creating reports with data visualizations
- Modifying existing reports
- Creating and managing data dashboards
- Asking questions with Power BI Q&A
- Enabling Microsoft Cortana for Power BI
- Sharing Power BI datasets, dashboards, reports, and workbooks
- Using Power BI Mobile and Power BI Desktop