1 / 10

An Introduction to Excel Services and PowerPivot Presented by : Mark Stacey 26 February 2011

An Introduction to Excel Services and PowerPivot Presented by : Mark Stacey 26 February 2011. Introduction & Agenda. Who am I? Started BIDN Johannesburg chapter Author of “ Sharepoint 2010 BI”. Technology Stack. @MarkGStacey. Excel as a Front-End. Power Pivot.

kanoa
Download Presentation

An Introduction to Excel Services and PowerPivot Presented by : Mark Stacey 26 February 2011

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. An Introduction to Excel Services and PowerPivot Presented by : Mark Stacey 26 February 2011

  2. Introduction & Agenda • Who am I? • Started BIDN Johannesburg chapter • Author of “Sharepoint 2010 BI” Technology Stack @MarkGStacey Excel as a Front-End Power Pivot Excel Services & Power Pivot Services #SPSJHB @MarkGStacey

  3. Levels of BI Strategic Tactical Operational Scorecards, Workflow, Annotations, Communication Reports, Cubes, Annotations, Workflow, Communication Reports, Embedded Functions, Mobile BI Business Process Automation Strategic Value Reporting Services Workflow Reporting Services Excel Workflow Subscriptions Analysis Services Performance Point , SharePoint Number of Decisions #SPSJHB @MarkGStacey

  4. Excel Services Architecture • Client • Local File • Processing on machine • Sharepoint • Shared, Version controlled worksheet in DB • Processing on scalable servers #SPSJHB @MarkGStacey

  5. Excel as a front-end #SPSJHB @MarkGStacey

  6. PowerPivot #SPSJHB @MarkGStacey

  7. Excel & PowerPivot Services #SPSJHB @MarkGStacey

  8. Demo Statistics SA data #SPSJHB @MarkGStacey

  9. Questions? User Group http://www.bidn.com/ Blog http://www.bidn.com/people/MarkGStacey Twitter @MarkGStacey

  10. Thank you for your time Jhb! Please don’t forget to fill in your evaluation forms! #SPSJHB

More Related