1 / 8

Microsoft PowerPivot

Microsoft PowerPivot. Office 2010. By Fahad Siddiqui. PowerPivot. PowerPivot uses Data Analysis Expressions (DAX) DAX formulas requires knowledge of OLAP Relation databases DAX Permits user to create custom calculations. Advantages. Uses similar features from Excel such as

hanh
Télécharger la présentation

Microsoft PowerPivot

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Microsoft PowerPivot Office 2010 By FahadSiddiqui

  2. PowerPivot • PowerPivot uses Data Analysis Expressions (DAX) • DAX formulas requires knowledge of • OLAP • Relation databases • DAX Permits user to create custom calculations

  3. Advantages • Uses similar features from Excel such as • Office Fluent user interface, PivotTable and PivotChart views, and slicers • Processes million rows of data quickly • Works with SharePoint 2010 only. • Combine data from more sources.

  4. Disadvantages • No BI built-in • KAPL wouldn’t use for SharePoint because it store password. • Users need to be familiar with DB terminologies and concepts • Learning curve • Not compatible with SharePoint 2003 & 2007

  5. Demo 1(from the project)

  6. Demo 2(in-class group activity)

  7. Summary • Office 2010, light weight provides good performance to PowerPivot • Gathers data from different source and can create relationships • Don’t need powerful PC to use PowerPivot • Data Model knowledge isn’t required to use the tool

  8. References • "Power Pivot for Excel 2010." SpyJournal (2009): n. pag. Web. 26 Feb 2011. <http://www.spyjournal.biz/node/1197>. • Webb, Chris . "PowerPivot/Excel/Sharepoint and SSRS - should they merge?." Chris Webb's BI Blog. WordPress, 03 Mar 2010. Web. 26 Feb 2011. <http://cwebbbi.wordpress.com/2010/03/03/powerpivotexcelsharepoint-and-ssrs-%e2%80%93-should-they-merge/>. • "PowerPivot: Data Analysis Expressions (DAX) Language." Microsoft TechNet. Microsoft, 17 Dec 2010. Web. 26 Feb 2011. <http://social.technet.microsoft.com/wiki/contents/articles/powerpivot-data-analysis-expressions-dax-language.aspx>. • Dickerman, Howie. "DAX (Data Analysis Expressions) Measures in PowerPivot." PowerPivot Team Blog. MSDN Blogs, 05 Apr 2010. Web. 26 Feb 2011. <http://blogs.msdn.com/b/powerpivot/archive/2010/04/05/dax-data-analysis-expressions-measures-in-powerpivot.aspx>. • PowerPivot. Web. 27 Feb 2011. <http://www.powerpivot.com/index.aspx>.

More Related