SharePoint business intelligent learning notes-dmeo (8)

1) Add the workbook toolbar in Excel

Step 1: Enable the workbook toolbar in Excel, create a blank Excel file, click File in the upper left corner, and then click Options

 

2) Add a data source using the workbook

Step 2: Use the workbook component to import data sources

 

 

 

3) create a data perspective

Step 3: Draw a picture and add a filter

 

 

 

4) CreatePowerviot Library

Step 4: Create a powerviot database in the background of the SharePoint website and upload the Excel file to the database.

 

 

The workbook Library provides preview thumbnails for excle. You can select whether to use execl to open locally or use Excel Web access to open online in the workbook. If you select to open online, the data request steps are as follows: