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)