BI Dashboard using Microsoft Excel with PowerPivot and iVobis

Agenda

• What is PowerPivot • How to obtain and install PowerPivot • Additional Integration Features • Technical Components • We will also have a demo of iVobis from 9-9:45

PowerPivot Advantages

• Ability to work with data from multiple sources • Ability to work with millions of rows of data – all from your desktop (this can be a disadvantage as well in my opinion) • Share this data within the Excel environment

Terminology

• Data Source can be SQL Server, Access, Excel, SSRS, MDX, CSV, oData, other • DAX – Data Analysis Expressions is the PowerPivot language • SSAS – SQL Server Analysis Service (PowerPivot is a scaled down or light version of this in my opinion)

Technical Information

• Requires Office 2010 • Windows 7 64 bit is not required but recommended for files with millions of rows • SQL Server Analysis Services • SharePoint Services

PowerPivot Configuration

Demo

Demo of the product - Install PowerPivot - See it in use FOLLOW-UP ITEMS - Show how this is used with SharePoint 2010 - Show connectivity and security modeling - What about a DBF or DBC?

Additional PowerPivot Info

• Where is the data – Imported data stored in the AVF – PivotCache in Excel – When uploading to SharePoint you can set the Data Refresh • Integration with SharePoint and PowerPivot will require Enterprise Client License and SQL Server 2008 R2 Enterprise Edition or higher

References for more information

• • • • • • • http://www.powerpivot.com/download.aspx

http://www.powerpivot.com/videos.aspx

http://redmondmag.com/Articles/2010/09/01/Making Excel-Analytics-Work.aspx?sc_lang=en&Page=1 PowerPivot for Excel 2010 – Microsoft Press PowerPivot for Excel and SharePoint – Wrox Press http://www.microsoft.com/sqlserver/2008/en/us/powerpiv ot.aspx

http://blogs.msdn.com/b/excel/archive/2009/10/22/introd ucing-powerpivot.aspx

Another Product - iVobis

www.ivobis.com

Presentation by: John Rinn VP of Sales and Marketing

2011 Meetings

• Dates & Location • 3 rd Wednesday of each month • At the RKL Office at 1800 Fruitville Pike, Lancaster, PA on the 4 th floor • 8 am – 10 am

2011 Call for Topics

• Network monitoring - how to find out what's slowing the pipe down • Backup technologies (tape, disk, cloud, software, etc) • Virtualization – Server and Desktop • Mobile devices in the workplace • Cloud Computing • Disaster Recovery • General Open Discussion (bring your topics and questions) • How to keep good records on licensing and what to expect if audited • OTHER IDEAS? (please send by 1/10/2011

Wrap-Up

• Thank you for attending and participating in 2010 • We will send out a link to get the PowerPoint slide deck and the recorded session from today • NEXT MEETING - Jan 19 - Open Discussion [IT Group]

subject to change

• Have a safe and happy holidays!