Apache Kylin Training in Kuala Lumpur, Malaysia

This course provides a deep dive into Apache Kylin, a powerful distributed analytics engine designed to provide OLAP (Online Analytical Processing) capabilities on big data. Participants will learn how to install, configure, and administer Kylin, build and optimize data models, and perform interactive analytics on large datasets using SQL on Hadoop. The course also covers integration with BI tools and performance tuning.

Introduction and Setup

• Introduction to Apache Kylin

• OLAP vs OLTP, and how Kylin fits in

• Kylin architecture and components

• Installation and setup in Hadoop/YARN environment

• Connecting with Hive and HDFS

• Overview of Kylin Web UI

Data Modeling and Cube Design

• Data model design principles

• Star schema and snowflake schema

• Creating dimensions and measures

• Cube building and management

• Running and optimizing queries

Advanced Features and Integration

• Query routing and pushdown

• Integration with BI tools (Tableau, Excel, Superset)

• Kylin REST APIs and automation

• Security and user access control

• Performance tuning and troubleshooting

• Case studies and real-world use cases

Hands-on Exercises

Summary and Conclusion