Microsoft Power BI

Microsoft Power BI

Excel 中的自助式 Power BI 實作：Power Query 篇


Tutorial: Facebook analytics using Power BI Desktop

•英文網址

•Task 1: Connect to a Facebook page

•Task 2: Create visualizations using the Report view

•Task 3: Shape data in the table
•Task 4: Create additional visualizations using the Report view

Tutorial: Importing and analyzing data from a Web Page using Power BI Desktop

•英文網站

•Task 1: Connect to a web data source –

•Task 2: Shape data in the Query view –

–Step 1: Remove Other Columns to only display columns of interest –

–Step 2: Replace Values to clean up values in a selected column –

–Step 3: Filter values in a column –

–Step 4: Rename a column -

–Step 5: Filter null values in a column –

–Step 6: Rename a query - Query Steps created –

•Task 3: Create visualizations using the Report view

–Step 1: Load the query to your report

–Step 2: Create a Map visualization 



Power Pivot

•網站

•Chapter 1：資料載入

•Chapter 2：精簡您的資料

•Chapter 3：建立運算

•Chapter 4：建立關聯

•Chapter 5：建立階層

•With Power BI Desktop,

 https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-tutorial-analyzing-sales-data-from-excel-and-an-odata-feed/

•transformation and aggregation steps Tutorial: Analyzing sales data from Excel and an OData feed https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-tutorial-analyzing-sales-data-from-excel-and-an-odata-feed/