Presented By O’Reilly and Cloudera
Make Data Work
September 11, 2018: Training & Tutorials
September 12–13, 2018: Keynotes & Sessions
New York, NY

Refactor your data warehouse with mobile analytics products (sponsored by Kyligence)

Zhi Zhu (China Construction Bank ), Luke Han (Kyligence)
1:15pm–1:55pm Wednesday, 09/12/2018
Location: 1E 17

What you'll learn

  • Explore Apache Kylin and learn how China Construction Bank used it to refactor a data warehouse for mobile analytics


China Construction Bank (CCB) is the second-largest bank in China and #28 on the Global Fortune 500. Recently, the bank decided to refactor and migrate its legacy data warehouse to a new data warehouse architecture to fulfill its fast-growing business. In early 2017, CCB kicked off one project to migrate 23,000+ reports to mobile. The MVP worked well but would soon have to face the performance and concurrency challenges of serving 400K+ users.

CCB had built its enterprise data warehouse with Teradata for years. It also considered the traditional data warehouse applications and big data platform used by other giant banks. Ultimately, it chose Apache Kylin as the high-performance and high-concurrency platform to refactor its data warehouse architecture.

Zhi Zhu and Luke Han detail the necessary architecture and best practices for refactoring a data warehouse for mobile analytics. Along the way, they offer an overview of Apache Kylin and explain how it lowered the cost but sped up migration process, empowered users to gain quick insights through mobile, and unleashed productivity through self-service and its unified KPI. They also outline CCB’s plans to build a fusion data lake with Apache Kylin to connect to the legacy data warehouse, big data platform, and others.

This session is sponsored by Kyligence.

Photo of Zhi Zhu

Zhi Zhu

China Construction Bank

Zhi Zhu is vice director of technology mangement at CCB, where he manages the bank’s big data platform planning and technology assets. Zhi has 15 years of experience in bank IT management, analytics platforms, data warehouses, governance, and architecture. Zhi has led many nationwide projects at CCB, including creating its data warehouse and next-generation analytics platform.

Photo of Luke Han

Luke Han


Luke (Qing) Han is a cofounder and CEO of Kyligence, cocreator and PMC chair of Apache Kylin, the leading open source OLAP for big data, and a Microsoft regional director and MVP. Luke has 10+ years’ experience in data warehouses, business intelligence, and big data. Previously, he was big data product lead at eBay and chief consultant of Actuate China.