1 / 12

PowerPivot using Stats SA data

PowerPivot using Stats SA data. Mark Stacey. #88 Cape town. Mark Stacey. Founded Pragmatic Works South Africa Started BIDN Johannesburg chapter Frequent presenter at MS User Groups Author of “ Sharepoint 2010 BI” Running SQL 11 Launch events for EMEA http://www.expeditionDenali.com.

dash
Download Presentation

PowerPivot using Stats SA data

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. PowerPivot using Stats SA data Mark Stacey #88 Cape town

  2. Mark Stacey • Founded Pragmatic Works South Africa • Started BIDN Johannesburg chapter • Frequent presenter at MS User Groups • Author of “Sharepoint 2010 BI” • Running SQL 11 Launch events for EMEA http://www.expeditionDenali.com

  3. Pragmatic Works Training

  4. Introduction & Agenda Technology Stack Excel as a Front-End @MarkGStacey Power Pivot Excel Services & Power Pivot Services #SQLSAT88 @MarkGStacey

  5. 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 #SQLSAT88 @MarkGStacey

  6. 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 #SQLSAT88 @MarkGStacey

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

  8. Excel as a front-end #SQLSAT88 @MarkGStacey

  9. PowerPivot #SQLSAT88 @MarkGStacey

  10. Excel & PowerPivot Services #SQLSAT88 @MarkGStacey

  11. Demo Statistics SA data #SQLSAT88 @MarkGStacey

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

More Related