Planning for business intelligence adoption - Business Intelligence in Microsoft SharePoint 2013 - page 46

You can use this tool to do the following:

Retrieve data from a source without having query language skills

■

■ Analyze data (that is, group, filter, deep analysis) containing fewer than one million records

Create pivot tables and charts with limited formatting options

■

Apply complex calculations to data

■

Create an internal data model as a source for a Power View in Excel visualization by using small
or large amounts of data (in excess of one million records) and data from disparate sources

■

Publish workbooks to Excel Services to share insights

■

■ Store data for use in SharePoint:
• Visio web diagram
• PerformancePoint Services KPI or filter
• Component in a SharePoint or PerformancePoint Services dashboard
Power View in Excel provides casual and power users with a tool to explore data by using interac-
tive visualizations. You can use it to do the following:

Explore data in an Excel internal data model or PowerPivot in Excel tabular model

■

Visualize data as a table, matrix, chart, map, tile, or card

■

Create an animated scatter chart

■

Filter and highlight data

■

PowerPivot in Excel provides power users with a tool that uses familiar Excel features while sup-
porting more advanced analysis. You can use it to do the following:

Analyze small or large amounts of data (millions of records)

■

Integrate multiple data sources when no data mart exists or when analysis needs to incorpo-
rate data not found in the data warehouse

■

Create pivot tables and charts with limited formatting options

■

Apply complex calculations to data

■

Reproduce the analytical capabilities that Analysis Services supports without waiting for IT to
build a cube

■

Prepare a data model for import into an Analysis Services tabular model

■

Publish workbooks to PowerPivot for SharePoint to share insights

■