Power BI 範例,即教學課程The Power BI samples, a tutorial

建議您從 Power BI 的範例資料集一文開始。We recommend starting with the article Sample datasets for Power BI. 在該文章中,您會了解範例的所有資訊;範例要如何取得、儲存、使用,及各範例可提供的一些案例。In that article you'll learn all about the samples; how to get them, where to save them, how to use them, and some of the stories each sample can tell. 之後,當您掌握到一些基礎時,請返回本教學課程。Then, when you have a grasp of the basics, come back to this Tutorial.

先決條件Prerequisites

這些範例適用於 Power BI 服務和 Power BI Desktop。The samples are available for Power BI service and Power BI Desktop. 如果要跟著做,我們將會使用「零售分析」範例。To follow along, we'll be using the Retail analysis sample.

本教學課程使用的「零售分析」內容套件範例,包含儀表板、報表和資料集。The Retail Analysis sample content pack used in this tutorial consists of a dashboard, report, and dataset. 為了熟悉此特定內容套件和其案例,您可以:瀏覽零售分析範例To familiarize yourself with this particular content pack and its scenario, you may want to take a tour of the Retail Analysis sample before you begin.

關於本教學課程About this tutorial

本教學課程將教導您如何This tutorial teaches you how to

  • 匯入範例內容套件,將它新增至 Power BI 服務,然後開啟該內容。import a sample content pack, add it to Power BI service, and open the contents. 「內容套件」是一種範例類型,其中資料集會隨附在儀表板及報表中。A content pack is a type of sample where the dataset is bundled with a dashboard and report.
  • 在 Power BI Desktop 中開啟範例.pbix 檔案。open a sample .pbix file in Power BI Desktop.

範例和 Power BI 服務Samples and Power BI service

  1. 開啟並登入 Power BI 服務 (app.powerbi.com)。Open and sign in to Power BI Service (app.powerbi.com).
  2. 選取左側瀏覽窗格底部的 [取得資料] 。Select Get Data at the bottom of the left navigation pane. 如果您沒有看到 [取得資料],請選取 展開瀏覽窗格。If you don't see Get Data, expand the nav pane by selecting .

  3. 選取 [範例]。Select Samples.

  4. 選取 [零售分析範例],然後選擇 [連線]。Select the Retail Analysis Sample, and choose Connect.

確切來說,會匯入什麼項目?What exactly was imported?

透過簡單的內容套件,當您選取 [連線] 時,Power BI 實際帶入的是該內容套件的複本,並將其儲存在雲端。With the sample content packs, when you select Connect, Power BI is actually bringing in a copy of that content pack and storing it for you in the cloud. 因為內容套件的建立者納入了資料集、報表及儀表板,所以當您按一下 [連線] 時,這就是您會得到的項目。Because the person who created the content pack included a dataset, a report, and a dashboard -- that's what you get when you click Connect.

  1. Power BI 會建立新的儀表板,並將其列在您的 [儀表板] 索引標籤中。會有黃色星號讓您知道這是新的。Power BI creates the new dashboard and lists it on your Dashboards tab. The yellow asterisk lets you know it's new.

  2. 開啟 [報表] 索引標籤。您會在這裡看到名為「零售分析範例」的報表。Open the Reports tab. Here you'll see a new report named Retail Analysis Sample.

    接著查看 [資料集] 索引標籤。其中也會有新的資料集。And check out the Datasets tab. There's a new dataset as well.

探索您的新內容Explore your new content

現在請自行探索儀表板、資料集和報表。Now explore the dashboard, dataset, and report on your own. 有很多不同方法可以瀏覽到您的儀表板、報表和資料集,而下方僅說明這許多方法的其中一種。There are many different ways to navigate to your dashboards, reports, and datasets, and just one of those many ways is described below.

提示

想要先進行一點教學嗎?Want a little hand-holding first? 試試瀏覽零售分析範例,以取得本範例的逐步解說。Try the Tour of the Retail Analysis sample for a step-by-step walkthrough of this sample.

  1. 瀏覽回您的 [儀表板] 索引標籤,然後選取 [零售分析範例] 儀表板加以開啟。Navigate back to your Dashboards tab and select the Retail Analysis Sample dashboard to open it.

  2. 儀表板隨即開啟。The dashboard opens. 其中有多種視覺效果磚。It has a variety of visualization tiles.

  3. 選取其中一個磚以開啟基礎報表。Select one of the tiles to open the underlying report. 在本例中,我們會選取區域圖 (上一張圖片中有粉紅色外框的部分)。In this example, we'll select the area chart (outlined in pink in the previous image). 報表會開啟為包含該區域圖的頁面。The report opens to the page that contains that area chart.

    注意

    如果磚是使用 Power BI 問與答所建立,會改為開啟問與答頁面。If the tile had been created using Power BI Q&A, the Q&A page would've opened instead. 如果該磚是釘選自 Excel,則 Excel Online 將會在 Power BI 中開啟。If the tile was pinned from Excel, Excel Online would've opened inside of Power BI.

  4. 返回您的 [資料集] 索引標籤,您有多種選項可以探索資料集。Back on your Datasets tab, you have several options for exploring your dataset. 您無法加以開啟及查看所有資料行和資料列 (如同您在 Power BI Desktop 或 Excel 中)。You won't be able to open it and see all the rows and columns (as you can in Power BI Desktop or Excel). 當有人與同事共用內容套件時,他們通常會想共用深入資訊,而不會把資料的直接存取權提供給同事。When someone shares a content pack with colleagues, they typically want to share the insights, not give their colleagues direct access to the data. 但這不表示您無法探索資料集。But that doesn't mean you can't explore the dataset.

    • 其中一個探索資料集的方式,是從頭建立您自己的視覺效果及報表。One way of exploring the dataset is by creating your own visualizations and reports from scratch. 選取圖表圖示 ,在報表編輯模式中開啟資料集。Select the chart icon to open the dataset in report editing mode.

    • 另一個探索資料集的方法是執行深入資訊摘要Another way of exploring the dataset is to run Quick Insights. 選取省略符號 (...) 並選擇 [取得深入資訊]。Select the ellipses (...) and choose Get insights. 當深入資訊就緒時,請選取 [檢視深入資訊]。When the insights are ready, select View insights.

範例和 Power BI DesktopSamples and Power BI Desktop

當您第一次開啟範例 PBIX 檔案時,它會在 [報表檢視] 中顯示,以供您搭配視覺效果探索、建立及修改任何數量的報表頁面。When you first open the sample PBIX file, is displays in Report view where you can explore, create, and modify any number of report pages with visualizations. [報表檢視] 所提供的設計體驗,大致上與 Power BI 服務中報表的 [編輯檢視] 類似。Report view provides pretty much the same design experience as a report’s Editing view in the Power BI service. 您可以在回處移動、複製及貼上、合併其中的視覺效果等等。You can move visualizations around, copy and paste, merge, etc.

之間唯一的差別是使用 Power BI Desktop 時,您可以處理您的查詢及建立資料模型,讓資料在報表中能夠提供最透徹的深入剖析資訊。The difference between them is when using Power BI Desktop, you can work with your queries and model your data to make sure your data supports the best insights in your reports. 您可以將 Power BI Desktop 檔案儲存在任何位置,無論是本機磁碟機或雲端。You can then save your Power BI Desktop file wherever you like, whether it's your local drive or to the cloud.

  1. 在 Power BI Desktop 中開啟零售分析範例 .pbix 檔案Open the Retail Analysis sample .pbix file in Power BI Desktop.

  2. 檔案會在 [報表檢視] 中開啟。The file opens in Report view. 是否有注意到位於報表編輯器底部的 4 個索引標籤?Notice the 4 tabs at the bottom of the report editor? 這表示此報表中有 4 個頁面,且目前選取的是 [New Stores] (新門市) 頁面。That means that there are 4 pages in this report, and the "New Stores" page is currently selected.

    ..

  3. 若要深入了解報表編輯器,請參閱報表編輯器導覽For a deep dive into the report editor, see Take a tour of the report editor

確切來說,會匯入什麼項目?What exactly was imported?

當您在 Desktop 中開啟範例 PBIX 檔案時,Power BI 實際上是帶入該資料的複本,並為您將它儲存在雲端。When you open the sample PBIX file in Desktop, Power BI is actually bringing in a copy of that data and storing it for you in the cloud. 您可以從 Desktop 存取該報表和其基礎資料集From Desktop you have access to the report and the underlying dataset. 當資料載入之後,Power BI Desktop 會嘗試為您尋找及建立關聯性。When the data is loaded, Power BI Desktop will attempt to find and create relationships for you.

  1. 選取資料表圖示 以切換至資料檢視Switch to Data view by selecting the table icon .

    [資料檢視] 可協助您檢查、瀏覽及了解 Power BI Desktop 模型中的資料。Data View helps you inspect, explore, and understand data in your Power BI Desktop model. 它與您在 [查詢編輯器] 中檢視資料表、資料行和資料的方式不同。It's different from how you view tables, columns, and data in Query Editor. 透過 [資料檢視],您看到的是載入模型之後的資料。With Data View, you’re looking at your data after it has been loaded into the model.

    當您建立資料模型時,有時會想要在報表畫布上沒有建立視覺效果的情況下,查看資料表或資料行中的實際內容,通常會查看到資料列層級。When you’re modeling your data, sometimes you want to see what’s actually in a table or column without creating a visual on the report canvas, often right down to the row level. 特別是當您要建立量值和導出資料行,或需要識別資料類型或資料類別時。This is especially true when you’re creating measures and calculated columns, or you need to identify a data type or data category.

  2. 選取 圖示以切換到關聯性檢視Switch to Relationships view by selecting the icon .

    [關聯性檢視] 會顯示模型中的所有資料表、資料行及關聯性。Relationship view shows all of the tables, columns, and relationships in your model. 您可以從這裡檢視、變更及建立關聯性。From here you can view, change, and create relationships.

探索您的新內容Explore your new content

現在請自行探索資料集、關聯性和報表。Now explore the dataset, relationships, and report on your own. 如需開始使用的說明,請瀏覽 Desktop 使用者入門指南For help getting started, visit the Desktop Getting Started Guide.

後續步驟Next steps

Power BI 基本概念Power BI basic concepts

Power BI 服務範例Samples for Power BI service

Power BI 的資料來源Data sources for Power BI

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