Data reporting and visualization for a leading university

Unmanaged repository of corporate data that has evolved over the years

Considerable duplication of data without attempts to conform data to specific standards

BI content unreliable and inconsistent compounded by usage of different tools SQL scripts, Cognos, Excel

Manual efforts to collate and publish BI content hampering evidence based decision making

Dire need to implement a technical solution and a data governance model

Implemented Microsoft and Talend based Information Management platform including a Corporate Data Warehouse (CDW) to support MI reporting and analytics

Assessment of existing infrastructure and software, data ingestion framework & initiatives including the Student Lifecycle project

Defined and refined foundation data model using a series of modelling workshops with the newly formed Business Intelligence Analysts (BIA) Team, business and technical SMEs, business owners and end users

Conducted Data workshops to arrive at and implement overall data ingestion framework (standard approaches to data processing operations, naming conventions, parameterization etc.) and addressed data challenges including organizational structure, bad data, volatile data feeds, multiple sources of reference data & key entity data, data extraction issues and data type conformance

Leveraged Enterprise Service Bus (ESB) to support master data messaging Addressed issues of data integration between operational systems through an ESB which allowed system to system data messaging

Defined and implemented an information governance framework