1 / 8

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?. End to end changeability of a BI solution by BI power user

yoland
Télécharger la présentation

Self-Service BI Solution Architecture for Dynamic Reporting

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. Self-Service BI Solution Architecture for Dynamic Reporting Rakesh Parida, Ashwin Rao Karavadi rakpar@microsoft.com, ashwinrk@microsoft.com Microsoft IT India

  2. 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

  3. Typical BI Solution Architecture Data Sources ETL / Data Flow Warehouse Data Marts/Cubes Reporting

  4. Self-Service BI Solution ArchitectureHow? • Primary Components • Metadata Backbone • Dynamic ETL framework • Dynamic Reporting framework • Extensible relational database structures

  5. 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

  6. 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

  7. Self-Service BI Solution ArchitectureTypical SDLC with Self Service BI

  8. © 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.

More Related