1 / 13

BI Dashboard using Microsoft Excel with PowerPivot and iVobis

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.

myrrh
Download Presentation

BI Dashboard using Microsoft Excel with PowerPivot and iVobis

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. BI Dashboard usingMicrosoft Excel with PowerPivotand iVobis

  2. 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

  3. 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

  4. 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)

  5. 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

  6. PowerPivot Configuration

  7. 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?

  8. 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

  9. 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/powerpivot.aspx http://blogs.msdn.com/b/excel/archive/2009/10/22/introducing-powerpivot.aspx

  10. Another Product - iVobis www.ivobis.com Presentation by: John Rinn VP of Sales and Marketing

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

  12. 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

  13. 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!

More Related