Power BI solution for a Polytechnic in Singapore

Case Studies

Client background: Singapore’s first & one of the oldest Polytechnic in the country

Industry: Public Sector

Products/Services: MSBI

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


  • Microsoft BI

  • Qlik data files


  • Oracle DB

  • Microsoft DB


Contact Info

Saksoft Limited, SP Infocity, Block A, 2nd Floor, #40 Dr. MGR Salai, Kandanchavadi, Perungudi, Chennai - 600096, India

Phone: +91 44 2454 3500

Fax: +91 44 2454 3510

Web: www.saksoft.com

Go to Top