self service bi solution architecture for dynamic reporting l.
Download
Skip this Video
Download Presentation
Self-Service BI Solution Architecture for Dynamic Reporting

Loading in 2 Seconds...

play fullscreen
1 / 8

Self-Service BI Solution Architecture for Dynamic Reporting - PowerPoint PPT Presentation


  • 512 Views
  • Uploaded on

Self-Service BI Solution Architecture for Dynamic Reporting. Rakesh Parida, Ashwin Rao Karavadi rakpar@microsoft.com, ashwinrk@microsoft.com Microsoft IT India. Self-Service BI Solution Architecture Why?. End to end changeability of a BI solution by BI power user

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Self-Service BI Solution Architecture for Dynamic Reporting' - yoland


Download Now 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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
self service bi solution architecture for dynamic reporting

Self-Service BI Solution Architecture for Dynamic Reporting

Rakesh Parida, Ashwin Rao Karavadi

rakpar@microsoft.com, ashwinrk@microsoft.com

Microsoft IT India

self service bi solution architecture why
Self-Service BI Solution ArchitectureWhy?
  • End to end changeability of a BI solution by BI power user
  • Continual changes due nature of business being supported
  • Changes impacting complete solution due to snowballing effect of changes on any part of the architecture
  • Significant time required to implement solution change
typical bi solution architecture
Typical BI Solution Architecture

Data Sources

ETL / Data Flow

Warehouse

Data Marts/Cubes

Reporting

self service bi solution architecture how
Self-Service BI Solution ArchitectureHow?
  • Primary Components
    • Metadata Backbone
    • Dynamic ETL framework
    • Dynamic Reporting framework
    • Extensible relational database structures
self service bi solution architecture how5
Self-Service BI Solution ArchitectureHow?
  • Metadata base contains
    • Complete data flow information for a dynamic ETL based data flow system
    • Reporting information such as data column mapping, formatting, calculations for the dynamic reporting framework
  • Extensible relational database structures able to absorb addition of new database objects/schema
self service bi solution architecture benefits
Self-Service BI Solution ArchitectureBenefits
  • Easy and quick absorption of changes to solution
  • Automation of change management of the solution
  • Enabling business users to realize real-time reporting enhancements
slide8

© 2009 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.

The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

ad