1 / 11

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.

afric
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. Tools • Performance Point • Scorecards: High Level Overview, drill down • Analytics : Interactive • Cons: Not totally customisable • SSRS • High Fidelity • Advanced Visualisations • Drilldown/drill through – can be dynamic, requires more work • Excel / Excel Services (PowerPivot) • Fully customisable • High Fidelity • Loses fidelity in Excel Services • Not as interactive with other Sharepoint components

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

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

  7. PowerPivot #SPSJHB @MarkGStacey

  8. Excel & PowerPivot Services #SPSJHB @MarkGStacey

  9. Demo Statistics SA data #SPSJHB @MarkGStacey

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

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

More Related