What is Pranali BI Framework?
Pranali’s BI Framework is a set of ready data models for banks and other verticals. The framework is broken down by BI subject areas. Each subject area has its own set of data models which may be populated from the metadata layer drawn from organisation’s source system/s. Pranali’s BI Framework has staging data models, data model publishing processes with embedded best practices and proven methodologies, subject-wise published data models / marts and many suggested reports, dashboards and BI paradigms for proactive analysis of data within the data model.
Even as individual subject area may be taken up for design, development and implementation, the data models within the subject area may be implemented in modular fashion, Pranali’s Banking BI Framework follows Bus Architecture to ensure scalability and enterprise-wide deployment.
For long term data warehouse success we need to use an architected incremental approach to building the Enterprise Warehouse. We advocate Data Warehouse Bus architecture as the right approach. A Bus is a common structure to which everything connects and from which everything derives power. By defining standard bus interface for data warehouse environment separate data marts can be implemented by different groups at different times. The separate data marts can be plugged together and can usefully co-exist if they adhere to the standard. We design a master suite of standardized dimensions and facts that have uniform interpretation across the enterprise. This establishes the data architecture framework. We then tackle the implementation of separate data marts in which each iteration closely adheres to the architecture. As separate data marts come on line they fit together like pieces of a puzzle.
What are customizable components?
The data component (ETL Layer)
Different businesses use different core ERP and other transaction processing systems for managing their operations. Even where two businesses have implemented exactly same transaction processing systems the implementation varies from one business to another. Pranali’s BI Framework has to extract, transform and load data from a businesses’s core ERP and other transaction processing systems. Customized effort is required for mapping data from transaction processing systems to the staging data models as finalized with business users.
The presentation layer component
The presentation layer is built on the data models published by the Pranali BI Framework. The presentation layer may be in form of reports, dashboards, KPI scorecards etc. Although, in our Presentation Layer Framework, there are hundreds of pre-designed reports and dashboards for reference purposes, the businesses are likely to design their own formats and content for these outputs in the presentation layer. So also, businesses may use different BI tools and technologies for deploying BI content drawn from our published data models. Customization of the presentation layer component may therefore be necessary.
- The presentation layer is built on the data models published by the Pranali BI Frameworks.
- Pranali Presentation Layer Framework readily addresses multi-functional BI needs across business verticals.
- The Pranali Presentation layer is in the form of Reports, Dashboards, KPI scorecards which can quickly be fine tuned for any business thereby reducing TAT for deployment.
- The businesses are likely to design their own formats and content in the presentation layer – Self Service BI.
- Businesses may use different BI tools and technologies for deploying BI content drawn from our published data models.