The power of Power Pivot Cristian Nicola Dynamics
- Slides: 15
The power of Power Pivot Cristian Nicola Dynamics. BIGuide. com
Summary • • • Introduction Reading data with Power Pivot Building your first Power Pivot report Building a Power Pivot Data Model Power Pivot Advanced Design Examples Q&A #NAVUGforum
Introduction #NAVUGforum
Power Pivot: Built By Business Users …Managed By IT • Free Self-Service BI Add-on in Excel 2010, 2013 & Office 365 • Leverages familiar Excel features (Pivot Table, Pivot Charts) and Excel functions format • Available both as “Personal BI” (using Excel) or “Corporate BI” (along with Share. Point and SQL Server) #NAVUGforum
Power Pivot offers the Low Startup Cost and Agility of Spreadsheets Blended with the Robustness and Low Ongoing Cost of “Traditional BI” Credit: Power. Pivot. Pro. com #NAVUGforum
Power Pivot Benefits • Ability to handle up to hundreds of millions of rows in a single workbook, while maintaining manageable file sizes and fast performance • Pivot. Table and Pivot. Charts built over multiple tables of data without requiring those tables to be VLOOKUP’d together into a single table • The capability to quickly create mashups that cross reference and integrate data from multiple sources • New formula engine for Pivot. Tables that goes far beyond any formulas capabilities available in Excel to date #NAVUGforum
Reading Data with Power Pivot #NAVUGforum
Generic Data Sources • • • Any SQL database Any ODBC Connection Web Services and ODATA Web Services OLAP Cubes Excel Spreadsheets … and many more #NAVUGforum
Microsoft Dynamics Data Sources • Dynamics NAV: SQL Tables, Views and Queries (any version running on SQL database), ODATA Web Services (NAV 2013, NAV 2013 R 2 and up) • Dynamics CRM: SQL Tables, Views and Queries, ODATA Web Services #NAVUGforum
A spreadsheet is worth 1000 slides #NAVUGforum
Building your first Power Pivot report • Demo #NAVUGforum
Building a Power Pivot Data Model • Demo of Table Relationships #NAVUGforum
Power Pivot Advanced Design Examples • Demo #NAVUGforum
Is this it? … No there is more • • Power View Power Map Power Query Power BI for Office 365 #NAVUGforum
Questions Cristian Nicola cnicola@ncadynamics. com Dynamics. BIGuide. com