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
Environment
Microsoft BI
Qlik data files
IBM ETL
Oracle DB
Microsoft DB
Get Social