tailieunhanh - Business Intelligence in Microsoft SharePoint 2010 phần 5

Về cơ bản, SSS lưu trữ thông tin một cách an toàn mà làm cho họ có sẵn cho các ứng dụng dịch vụ như dịch vụ Excel để sử dụng cho những thứ như dữ liệu làm mới. Một quản trị viên phải cấu hình | 142 Chapter 5 PowerPivot for Excel and SharePoint 7. Close the Preview page shown in the preceding figure if you opened it and then in the Select Tables And Views dialog box click Finish. At this point PowerPivot for Excel sends a command to the VertiPaq engine to create the PowerPivot data store which is an Analysis Services in-memory database retrieving the data you specified from the relational SQL Server data source you selected. After the import operation starts you can see the quantity of rows imported as the VertiPaq engine processes the tables. PowerPivot for Excel also tries to import any existing relationships between the tables being imported. 8. When the operation completes on the Import Summary dialog box click Close. Notice that the PowerPivot window fills with the data you imported as shown in the following illustration. The tables are organized as separate tabs each accessible from the bottom of the window just like a typical Excel worksheet. Choose one of the sheets that is one of the tables to see all its columns and rows. At the bottom of the PowerPivot for Excel window is a Records field which shows you how many rows that particular table has loaded. The FactSales table for example has more than three million rows and all that data is available. You can scroll through it seamlessly thanks to the Getting Started 143 VertiPaq engine which uses a columnar technology to achieve high compression rates and processing power. When you scroll apply filters or perform calculations PowerPivot for Excel sends queries in the background known as tabular queries to the VertiPaq engine which retrieves the results amazingly fast. Importing from Windows Azure Marketplace DataMarket Released in October 2010 Windows Azure Marketplace DataMarket referenced hereafter as Azure DataMarket for simplicity is a service with which developers and information workers can easily discover purchase and manage premium data subscriptions some of these data subscriptions are free