1 / 16

Enabling Self-Service Reporting in Microsoft SQL Server 2008

Enabling Self-Service Reporting in Microsoft SQL Server 2008. C. Ryan Clay, Thiago Silva & Bryan C. Smith. Today’s Objectives. Explore the topic of self-service in business intelligence Review Microsoft’s approach to self-service Demonstrate Microsoft self-service reporting technologies.

joben
Download Presentation

Enabling Self-Service Reporting in Microsoft SQL Server 2008

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. Enabling Self-Service Reporting in Microsoft SQL Server 2008 C. Ryan Clay, Thiago Silva & Bryan C. Smith

  2. Today’s Objectives • Explore the topic of self-service in business intelligence • Review Microsoft’s approach to self-service • Demonstrate Microsoft self-service reporting technologies

  3. Supporting Materials

  4. Business Intelligence def. - the processes, tools, and technologies for turning data into information, and information into knowledge, and plans that lead to positive actions for the organization • Reporting • Exploratory Analysis • Performance Management • Predictive & Statistical Analysis

  5. Business Intelligence Demands Predictive & Statistical Analysis Performance Management Exploratory Analysis Reporting

  6. The Opportunity for Self-Service Business demand outpaces IT capacity High demand for less technically complex activities

  7. Realizing the Opportunity for Self-Service Complete IT Dependence Full Business Self-Service People Complete IT Dependence Full Business Self-Service Process Technology

  8. The People Component • Adoption should be actively encouraged • Users should be supported

  9. The Process Component • Transitions should be carefully planned • Expectations should be actively managed

  10. The Technical Component • Technologies need to be highly approachable • Tools should support varying degrees of sophistication • Tools should support publication and re-use

  11. Microsoft’s Self-Service BI Strategy

  12. Business Intelligence Demands Predictive & Statistical Analysis Office Data Mining Add-Ins Office Performance Point Server Performance Management Office Excel Exploratory Analysis SQL ServerReport Builder 2.0 Reporting Analysis Services

  13. Report Builder 2.0 • Office-like interface for high accessibility • Support for both casual and deeply technical users • Improvements to Reporting Servicestranslate into improved userexperience

  14. Analysis Services 2008 • Internal metadata ensures accurate front-end data assembly • Fine-grained security model built into the database • High performance data retrieval better ensures end-user satisfaction

  15. Demonstrations

  16. For More Information rclay@hitachiconsulting.com tsilva@hitachiconsulting.com bcsmith@hitachiconsulting.com

More Related