• consulting
  • ampersand
  • ampersand_2

CLP Power Hong Kong established in 1901, and is the principal subsidiary of the CLP Group. CLP Power is the largest vertically-integrated electricity generation, transmission and distribution company in Hong Kong serving 80 percent of the territory’s population.


This project was a BI Architecture review, recommendation, and best practice solution for CLP Power Hong Kong. CLP Power has large data sets with more than 200 Million records of data in single data set. This project designed in a way that CLP Power’s internal BI team be advised about best pracitces for performance tuning, technologies to be used, infrastructure configuration and specifications, and the security solution.

This BI Architecture project was include heavy documentation and advisory component which includes headings such as;

  • ETL Architecture
  • Database Architecture
  • BI Tool Selection
  • Alert and Email Notification Architecture
  • Security Architecture
  • Self-Service Architecture
  • SharePoint Site Architecture
  • Monitoring Architecture
  • Multi-Tenancy Delivery
  • Naming Standards
  • Version Management
  • Migration Architecture