The objective of the banking project is to collect financial data from all branches and centralize it in a data warehouse for enhanced data analysis and reporting. The goal is to ensure efficient extraction, transformation, and loading (ETL) of transactional, customer, and operational data from multiple sources across the organization. This consolidated data serves as a foundation for building advanced analytical models and generating Power BI reports. By implementing a robust data infrastructure, the project aims to enable real-time insights, support business decision-making, and improve operational efficiency, all while ensuring data accuracy, consistency, and security.

Consumer Health Data Platform is a data repository on the Azure platform that receives, stores, and transforms data for reporting and analytical use. Data is extracted from different source systems and from external data files (flat files), transformed and stored in Azure platform, which will be consumed by a reporting system. One of the mail goals of the Consumer Health Data Platform is to build an agnostic Consumer Health Data Warehouse consisting of the most commonly used data elements that can be leveraged to enable data-driven decisions.

HPI would like to build a modern cloud compliant solution for all finance data delivery to offload historical data from ODW. As part of this process, existing Webi Reports have to be migrated to ThoughtSpot.

The project objective is to create a single point of extract process to get data from CDF (Case Definition Facility) and Soldcase for various analytical model, dashboard, and API needs.