Client background: Public research university in Sheffield

Data-reporting-and-visualization-for-a-leading-university

Business Challenge

  • 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

Business Solution

  • 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

Business Benefits

  • Acquired a well established Information Management platform successfully ingesting data from multiple sources and producing high quality outputs

  • Maximized value from the user friendly platform

Environment

  • ETL Tool and ESB

  • Microsoft SQL Server

  • Oracle repository