Microsoft SQL Server PowerPivot for Microsoft Excel (PowerPivot for Excel) is a data analysis tool that delivers unmatched computational power directly within the application that you already know and love—Microsoft Excel. PowerPivot for Excel Help will get you up to speed and enable you to be productive right away.
Power View, a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, is an interactive data exploration, visualization, and presentation experience. It provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers. They can easily create and interact with views of data from data models based on PowerPivot workbooks published in a PowerPivot Gallery, or tabular models deployed to SQL Server 2012 Analysis Services (SSAS) instances. Power View is a browser-based Silverlight application launched from SharePoint Server 2010 that enables users to present and share insights with others in their organization through interactive presentations.
Come learn the benefits (and challenges) of these tools in the Microsoft Business Intelligence (MS BI) feature set. We’ll walk through some of the key components necessary to implement these tools and share some best practices
Dan Evans is the Director and Market Lead for the Americas Business Intelligence Service Line at Avanade, Inc. He benefits from 20 years in information technology management in data analysis, design, development, testing, deployment, strategy, and consulting. Daniel’s key interests are in business intelligence, data warehousing, executive information strategy, and IT governance/compliance. His work crosses several industries such as retail, insurance, health services, manufacturing, marketing, logistics, telecommunications, and professional services. Daniel promotes technology for business use through various channels by sponsoring user groups like The Data Warehousing Institute (TDWI) Mid-South Chapter, the Mid-South Data Management Association (DAMA) chapter and is founder and acting president of the Memphis Professional Association of SQL Server (PASS) chapter. Dan holds several MCPs in SQL Server and SharePoint and is Certified Business Intelligence Certification (CBIP) with Mastery in Leadership and Management, Business Analytics, Data Analysis and Design and Data Integration. Daniel is a nationally recognized speaker at TDWI, TechEd and PASS on topics related to SQL Server and SharePoint.
Here’s the presentation and the scripts from Dan’s presentation:
Here are a few important links that Dan wanted to add as well:
http://www.microsoft.com/en-us/bi/default.aspx – PowerPivot tab for the download for Office 2010
http://technet.microsoft.com/en-us/library/gg399157.aspx – Introduction to PowerPivot for Excel
http://technet.microsoft.com/en-us/library/hh213579.aspx – Introduction to Power View
http://www.microsoft.com/en-us/download/details.aspx?id=26718 – Samples of PowerPivot Excel spreadsheet and Power View report. The tutorial documents (in zip file) can be found on this page as well.