Client background: Singapore’s first & one of the oldest Polytechnic in the country
Industry: Public Sector
Products/Services: MSBI

Power BI solution for a Polytechnic in Singapore

Business Challenge

  • Current BI system is accessing multiple sources including Excel, CSV, Oracle, Qlik data files

  • Lack of resource availability to manually upload data which are again prone to human errors

  • Existing BI Technologies are from different Products, IBM Data Stage (ETL), Oracle (DB) and Qlik (Reporting)

  • Data loading process into the BI system is around 3 to 4 hours of time

  • Org (Departmental) changes have to be done manually for each report

Business Solution

  • Integrated all the sources to Microsoft database, hence Microsoft DB is centralized repository

  • Automated all the Data Load jobs without any human intrusion, as and when there is an issue in the data load process an email will be triggered to the relevant business users

  • Integrated IBM ETL and Oracle DB to Microsoft Repository

  • Developed OLTP system, which eliminates the Data redundancy and Data Inconsistency.

  • Automated Org changes with a click away using DWH concept call SCD (Slowly Changing Dimension)

Business Benefits

  • Real-time data for decision making

  • Better data visualization

  • Minimum human interference

  • Maintenance free system

Environment

  • Microsoft BI

  • Qlik data files

  • IBM ETL

  • Oracle DB

  • Microsoft DB