讓資料適用於 Power BI 的問與答Make your data work well with Q&A in Power BI

如果您是建立資料模型的人員,或要建立搭配 Power BI 使用的 Excel 活頁簿,請繼續閱讀...If you are a person who creates data models or builds Excel workbooks that will be used with Power BI, read on...

在 Power BI 中,問與答可搜尋結構化的資料,並為您的問題選擇適當的視覺效果,就是這一點讓它成為大家愛用的工具。In Power BI, Q&A can search structured data and choose the right visualization for your question -- that's what makes it a compelling tool to use.

問與答可以處理任何已上傳的 Excel 檔案 (有資料表、範圍或包含 PowerPivot 模型),但是最佳化和資料清除執行愈多次,問與答的效能就愈穩固。Q&A can work on any uploaded Excel file that has tables, ranges, or contains a PowerPivot model, but the more optimizations and data cleaning you do, the more robust Q&A performance is.

問與答的運作方式How Q&A works

問與答有一組可在您的資料中運作的功能,可了解核心自然語言。Q&A has a set of core natural language understanding abilities that work across your data. 它會搜尋 Excel 資料表、資料行和導出欄位名稱之內容相關的關鍵字。It has context-dependent keyword search for your Excel table, column, and calculated field names. 其次,它有內建如何篩選、排序、彙總、群組和顯示資料的相關知識。Second, it has built-in knowledge for how to filter, sort, aggregate, group, and display data.

例如,在一個名為「銷售」的 Excel 資料表,其資料行為「產品」、「月」、「單位銷售」、「銷售毛額」和「利潤」,您可以詢問有關任何這些實體的問題。For example, in an Excel table named “Sales”, with columns “Product”, “Month”, “Units Sold”, “Gross Sales”, and “Profit”, you could ask questions about any of those entities. 您可以要求顯示銷售額、各月份的總計收益、依單位銷售排序產品等等。You could ask to show sales, total profit by month, sort products by units sold, and many others. 深入了解可提問的問題種類使用問題範本詢問問與答查詢中可以指定的視覺效果類型.Read more about the kinds of questions you can ask, and asking questions using a question template and visualization types you can specify in a Q&A query.

準備適用於問與答的活頁簿Prepare a workbook for Q&A

問與答依賴資料表、資料行和導出欄位的名稱,藉此回應特定資料的問題,這表示您如何在活頁簿中命名實體會相當重要!Q&A relies on the names of tables, columns, and calculated fields to answer data-specific questions, meaning what you call entities in your workbook is important!

以下是在您的活頁簿中善加利用問與答的一些秘訣。Here are some tips for making the most of Q&A in your workbook.

  • 請確定您的資料位於 Excel 資料表中。Make sure your data is in an Excel table. 以下是如何建立 Excel 資料表的說明.Here's how to create an Excel table.
  • 請確定您的資料表、資料行和導出欄位的英文名稱合理。Make sure the names of your tables, columns, and calculated field make sense in English.

    例如,如果您有包含銷售資料的資料表時,請將資料表命名為「銷售額」。For example, if you have a table with sales data, call the table “Sales”. 「年」、「產品」、「銷售代表」和「金額」等資料行名稱可適用於問與答。Column names like “Year”, “Product”, “Sales Rep”, and “Amount” will work well with Q&A.

注意

如果您的活頁簿有 PowerPivot 資料模型,您就可以更進一步地最佳化。If your workbook has a Power Pivot data model, you can do even more optimizations. 深入了解我們內部團隊之自然語言專家的 Demystifying Power BI Q&A part 2 (揭密 Power BI 問與答第 2 部分)。Read more about Demystifying Power BI Q&A part 2 from our in-house team of natural language experts.

後續步驟Next steps

Power BI 中的問與答Q&A in Power BI
教學課程:Power BI 問與答簡介Tutorial: Introduction to Power BI Q&A
取得 Power BI 的資料Get data (for Power BI)
Power BI - 基本概念Power BI - Basic Concepts

有其他問題嗎?More questions? 試試 Power BI 社群Try the Power BI Community