Microsoft Excel 2010 Quick Reference Guide: Business Intelligence & Data Analysis Using PowerPivot (402)

Description

8-page bifold. Microsoft SQL Server PowerPivot for Microsoft Excel, simply known as PowerPivot for Excel, is a data analysis tool that delivers unique and powerful computational abilities within Microsoft Excel. It far exceeds the limits set for worksheets (1,048,576 rows by 16,384 columns) by allowing you to connect to large scale database applications (Microsoft SQL Server, Oracle and others). The imported data is linked to the source and utilizes the familiar PivotTable feature for in-depth data analysis. PowerPivot is also referred to as “self-service business intelligence” where users can develop analytics, data metrics, data models and complex calculations, and share them with their peers by utilizing SharePoint Server. Topics include: Understanding The Data Model, Using PowerPivot To Build A Data Model , Working With The PowerPivot Data Model, Creating Relationships, Alternate Models To Building Data Models and Adding Calculations - DAX Basics.