Apache Kylin Training: Big Data Analytics & OLAP Cube Mastery

Master enterprise-scale Online Analytical Processing (OLAP) with Apache Kylin under expert guidance. Enroll in our comprehensive training program tailored specifically for big data analytics professionals seeking advanced cube-based analytical processing skills.

Face-to-Face Nov 12-13, 2026 9:00 AM - 5:00 PM Uzair Aslam
updated
intermediate
Apache Kylin
We price match

Public Pricing

MYR 3500

Corporate Pricing

Pax:

Training Fees: MYR 6500/day
Total Fees: MYR 13000 ++

Training Provider Pricing

Pax:

Training Fees: MYR 2800/day
Material Fees: MYR 600
Total Fees: MYR 6200 ++

Features

2 days
16 modules
6 intakes
Full life-time access
English
Technical: 25 pax

Target Audience

students
engineers

Methodologies

lecture
slides
labs
case studies
q&A

Subsidies

HRDC Claimable logo

What you'll learn

  • Connect Business Intelligence tools like Tableau and Power BI to Kylin for interactive dashboards
  • Design and implement efficient data models using star and snowflake schemas for OLAP cubes
  • Execute complex SQL queries and perform multidimensional analysis with drill-down capabilities
  • Understand OLAP fundamentals and Apache Kylin architecture within the Hadoop ecosystem
  • Build, manage, and optimize cubes using both batch and incremental processing strategies
  • Integrate real-time streaming data sources with Kafka for low-latency analytics
  • Implement performance optimization techniques and operational best practices for enterprise deployments
  • Install, configure, and deploy Kylin in both development and production environments

Why should you attend?

This comprehensive training program provides in-depth knowledge of Apache Kylin, a powerful Online Analytical Processing (OLAP) engine designed for big data analytics. Students will explore the fundamental concepts of OLAP and understand how Kylin revolutionizes traditional analytical processing through its innovative architecture and cube-based approach. The course covers the complete Kylin ecosystem, including its integration with Hadoop components such as Hadoop Distributed File System (HDFS), Hive, HBase, and Spark. Participants will learn hands-on installation and configuration techniques, from Docker-based quick deployments to production-ready setups with proper metastore configuration and system integration. Students will master data modeling principles for OLAP cubes, including star and snowflake schema design, dimension and measure definitions, and relationship management between fact and lookup tables. The program extensively covers cube building and management processes, including incremental builds, auto-merge strategies, and performance optimization techniques. Advanced topics include real-time streaming analytics with Kafka integration, lambda architecture implementation, and Business Intelligence tool connectivity. The course concludes with operational excellence practices, security considerations, and production deployment strategies, ensuring participants are well-equipped to implement and maintain Kylin solutions in enterprise environments.

Course Syllabus

Day 1 - Kylin Fundamentals Setup
Module 1
Module 2
Short Break
15 mins
Module 3
Module 4
Recap and Q&A
15 mins
Lunch
1 hour
Module 5
Module 6
Short Break
15 mins
Module 7
Module 8
Recap and Q&A
15 mins
End of Day 1
Day 2 - Advanced Operations Integration
Module 9
Module 10
Short Break
15 mins
Module 11
Module 12
Recap and Q&A
15 mins
Lunch
1 hour
Module 13
Module 14
Short Break
15 mins
Module 15
Module 16
Recap and Q&A
15 mins
End of Day 2

Instructor

Loading...
Mohammad Mehdi Lotfinejad Chief Data Officer & Data Science Trainer
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Mohammad Mehdi Lotfinejad is a distinguished Chief Data Officer and certified HRDF trainer with over 15 years of experience in computer science instruction and professional data science training. Currently serving as Chief Data and Knowledge Officer at Magna.ai, a Florida-based lawtech company, he leads the development of sophisticated graph databases, data warehouses, and API solutions that power AI-driven legal case analysis systems. His expertise spans the entire data ecosystem, from architecture design to workflow automation and team leadership. With a robust background encompassing more than a decade of hands-on experience in data engineering and data science, Mohammad has successfully implemented enterprise-scale data processing pipelines across multiple industries and geographies. His professional journey includes senior roles at Axiata Digital Advertising (ADA) in Malaysia, where he designed and deployed data pipelines using AWS Redshift, Snowflake, Apache Spark, and Apache Airflow, and at The Center of Applied Data Science, where he led teams delivering training solutions to major corporations including CIMB, PETRONAS, SHELL, and TNB. Mohammad's technical proficiency is comprehensive and current, encompassing cloud platforms (AWS, Google Cloud), data warehousing solutions (Redshift, Snowflake), big data technologies (Apache Spark, Hadoop, Hive), workflow orchestration (Apache Airflow), and multiple database systems (MySQL, PostgreSQL, MongoDB). He holds a Harvard Business School certification in Business Analytics and multiple AWS certifications, including specialized credentials in Big Data, Data Warehousing, and Practical Data Science with Amazon SageMaker. As an educator, Mohammad brings exceptional depth to his training delivery. His academic career includes faculty positions at Payame Noor University and Islamic Azad University, where he served in leadership roles including Chancellor and Department Head. He has authored three technical books and published numerous peer-reviewed papers in international journals. His teaching repertoire covers data engineering, data science, machine learning, software development, and computer architecture, delivered through engaging, hands-on methodologies that bridge theoretical concepts with practical industry applications. Mohammad's unique combination of executive leadership, technical expertise, and proven training capabilities makes him an invaluable resource for organizations seeking to develop their data science and engineering capabilities. His ability to translate complex technical concepts into actionable learning outcomes, coupled with his extensive real-world implementation experience, ensures that training participants gain immediately applicable skills that drive business value.
8 Students
108 Courses
18 Years

Instructor

Loading...
Uzair Aslam Senior Data Scientist & ML Expert
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
TTT Accreditation
TTT Accreditation
Uzair Aslam is an accomplished Data Scientist with extensive expertise in machine learning, artificial intelligence, and advanced analytics. With a proven track record of delivering transformative data-driven solutions across the financial services and telecommunications sectors, he brings a unique combination of technical excellence and business acumen to every project. Currently serving as AVP - Senior Data Scientist at Maybank, Uzair has spearheaded the development of cutting-edge fraud detection models that have revolutionized risk management processes. His innovative machine learning solution reduced false positive review time by 75%, saving approximately 2,940 man hours and significantly improving operational efficiency. He has successfully engineered sophisticated fraud detection systems combining Computer Vision and Natural Language Processing, utilizing OCR technology for document analysis and anomaly detection. His leadership extends to managing cross-functional teams and developing automated business intelligence solutions, including news web-scraping applications for risk event monitoring across the Asia Pacific region. Uzair's professional journey includes valuable experience as a Specialist Data Scientist at The CADS, where he provided strategic advisory services to major international clients including Petronas, Shell, and CIMB. His consulting expertise focuses on translating complex business requirements into actionable data science use cases. He has also demonstrated exceptional training capabilities, delivering corporate training programs on Machine Learning, Deep Learning, and Natural Language Processing to diverse professional audiences. With a Master's degree in Data Science & Business Analytics from Asia Pacific University (achieved with Distinction) and a Bachelor's in Electronics Engineering, Uzair possesses a solid academic foundation complemented by numerous industry certifications. His technical proficiency spans Python, R, SQL, Spark, SAS, and HiveQL, along with expertise in modern data science platforms including Tableau, Power BI, DataRobot, H2O.ai, and Dataiku. His project portfolio demonstrates versatility across fraud detection, credit scoring, opinion spam detection, electricity load forecasting, and neural network applications, showcasing his ability to apply advanced statistical and machine learning concepts to solve real-world business challenges.
58 Courses
English
10 Years

Instructor Reviews

ML

Mohammad Mehdi Lotfinejad

Chief Data Officer & Data Science Trainer

"Mehdi and I worked on several projects with company such as Petronas , Shell and CIMB Regional ETC. I must say Mehdi's training was highly appreciated by our clients as he was able to exhibit in full display his vast knowledge as a Data professional. I would highly recommend him to anyone looking for a top tier training expert."

"Not only knowledgeable but also having hands dirty on what he knows Friendly and building networks quickly."

"I had the pleasure of working with Mehdi together on some high-level initiatives such as the Petronas data scientist program and Shell's project to become a data-driven organization. During these projects, Mehdi received numerous accolades for his ability to share his knowledge and mentor up-and-coming data scientists. Based on our shared experiences, I have no hesitation in recommending Mehdi for any project or position he may be considered for."

FAQ

Frequently Asked Questions About This Course

Why should you attend?

This comprehensive training program provides in-depth knowledge of Apache Kylin, a powerful Online Analytical Processing (OLAP) engine designed for big data analytics. Students will explore the fundamental concepts of OLAP and understand how Kylin revolutionizes traditional analytical processing through its innovative architecture and cube-based approach. The course covers the complete Kylin ecosystem, including its integration with Hadoop components such as Hadoop Distributed File System (HDFS), Hive, HBase, and Spark. Participants will learn hands-on installation and configuration techniques, from Docker-based quick deployments to production-ready setups with proper metastore configuration and system integration. Students will master data modeling principles for OLAP cubes, including star and snowflake schema design, dimension and measure definitions, and relationship management between fact and lookup tables. The program extensively covers cube building and management processes, including incremental builds, auto-merge strategies, and performance optimization techniques. Advanced topics include real-time streaming analytics with Kafka integration, lambda architecture implementation, and Business Intelligence tool connectivity. The course concludes with operational excellence practices, security considerations, and production deployment strategies, ensuring participants are well-equipped to implement and maintain Kylin solutions in enterprise environments.


What you'll learn

  • Connect Business Intelligence tools like Tableau and Power BI to Kylin for interactive dashboards
  • Design and implement efficient data models using star and snowflake schemas for OLAP cubes
  • Execute complex SQL queries and perform multidimensional analysis with drill-down capabilities
  • Understand OLAP fundamentals and Apache Kylin architecture within the Hadoop ecosystem
  • Build, manage, and optimize cubes using both batch and incremental processing strategies
  • Integrate real-time streaming data sources with Kafka for low-latency analytics
  • Implement performance optimization techniques and operational best practices for enterprise deployments
  • Install, configure, and deploy Kylin in both development and production environments

Course Syllabus

Day 1 - Kylin Fundamentals Setup
Module 1
Module 2
Short Break
15 mins
Module 3
Module 4
Recap and Q&A
15 mins
Lunch
1 hour
Module 5
Module 6
Short Break
15 mins
Module 7
Module 8
Recap and Q&A
15 mins
End of Day 1
Day 2 - Advanced Operations Integration
Module 9
Module 10
Short Break
15 mins
Module 11
Module 12
Recap and Q&A
15 mins
Lunch
1 hour
Module 13
Module 14
Short Break
15 mins
Module 15
Module 16
Recap and Q&A
15 mins
End of Day 2

Instructor Reviews

ML

Mohammad Mehdi Lotfinejad

Chief Data Officer & Data Science Trainer

"Mehdi and I worked on several projects with company such as Petronas , Shell and CIMB Regional ETC. I must say Mehdi's training was highly appreciated by our clients as he was able to exhibit in full display his vast knowledge as a Data professional. I would highly recommend him to anyone looking for a top tier training expert."

"Not only knowledgeable but also having hands dirty on what he knows Friendly and building networks quickly."

"I had the pleasure of working with Mehdi together on some high-level initiatives such as the Petronas data scientist program and Shell's project to become a data-driven organization. During these projects, Mehdi received numerous accolades for his ability to share his knowledge and mentor up-and-coming data scientists. Based on our shared experiences, I have no hesitation in recommending Mehdi for any project or position he may be considered for."

We price match

Public Pricing

MYR 3500

Corporate Pricing

Pax:

Training Fees: MYR 6500/day
Total Fees: MYR 13000 ++

Training Provider Pricing

Pax:

Training Fees: MYR 2800/day
Material Fees: MYR 600
Total Fees: MYR 6200 ++

Features

2 days
16 modules
6 intakes
Full life-time access
English
Technical: 25 pax

Target Audience

students
engineers

Methodologies

lecture
slides
labs
case studies
q&A

Subsidies

HRDC Claimable logo

Instructors

Loading...
Mohammad Mehdi Lotfinejad Chief Data Officer & Data Science Trainer
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Mohammad Mehdi Lotfinejad is a distinguished Chief Data Officer and certified HRDF trainer with over 15 years of experience in computer science instruction and professional data science training. Currently serving as Chief Data and Knowledge Officer at Magna.ai, a Florida-based lawtech company, he leads the development of sophisticated graph databases, data warehouses, and API solutions that power AI-driven legal case analysis systems. His expertise spans the entire data ecosystem, from architecture design to workflow automation and team leadership. With a robust background encompassing more than a decade of hands-on experience in data engineering and data science, Mohammad has successfully implemented enterprise-scale data processing pipelines across multiple industries and geographies. His professional journey includes senior roles at Axiata Digital Advertising (ADA) in Malaysia, where he designed and deployed data pipelines using AWS Redshift, Snowflake, Apache Spark, and Apache Airflow, and at The Center of Applied Data Science, where he led teams delivering training solutions to major corporations including CIMB, PETRONAS, SHELL, and TNB. Mohammad's technical proficiency is comprehensive and current, encompassing cloud platforms (AWS, Google Cloud), data warehousing solutions (Redshift, Snowflake), big data technologies (Apache Spark, Hadoop, Hive), workflow orchestration (Apache Airflow), and multiple database systems (MySQL, PostgreSQL, MongoDB). He holds a Harvard Business School certification in Business Analytics and multiple AWS certifications, including specialized credentials in Big Data, Data Warehousing, and Practical Data Science with Amazon SageMaker. As an educator, Mohammad brings exceptional depth to his training delivery. His academic career includes faculty positions at Payame Noor University and Islamic Azad University, where he served in leadership roles including Chancellor and Department Head. He has authored three technical books and published numerous peer-reviewed papers in international journals. His teaching repertoire covers data engineering, data science, machine learning, software development, and computer architecture, delivered through engaging, hands-on methodologies that bridge theoretical concepts with practical industry applications. Mohammad's unique combination of executive leadership, technical expertise, and proven training capabilities makes him an invaluable resource for organizations seeking to develop their data science and engineering capabilities. His ability to translate complex technical concepts into actionable learning outcomes, coupled with his extensive real-world implementation experience, ensures that training participants gain immediately applicable skills that drive business value.
8 Students
108 Courses
18 Years
Loading...
Uzair Aslam Senior Data Scientist & ML Expert
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
TTT Accreditation
TTT Accreditation
Uzair Aslam is an accomplished Data Scientist with extensive expertise in machine learning, artificial intelligence, and advanced analytics. With a proven track record of delivering transformative data-driven solutions across the financial services and telecommunications sectors, he brings a unique combination of technical excellence and business acumen to every project. Currently serving as AVP - Senior Data Scientist at Maybank, Uzair has spearheaded the development of cutting-edge fraud detection models that have revolutionized risk management processes. His innovative machine learning solution reduced false positive review time by 75%, saving approximately 2,940 man hours and significantly improving operational efficiency. He has successfully engineered sophisticated fraud detection systems combining Computer Vision and Natural Language Processing, utilizing OCR technology for document analysis and anomaly detection. His leadership extends to managing cross-functional teams and developing automated business intelligence solutions, including news web-scraping applications for risk event monitoring across the Asia Pacific region. Uzair's professional journey includes valuable experience as a Specialist Data Scientist at The CADS, where he provided strategic advisory services to major international clients including Petronas, Shell, and CIMB. His consulting expertise focuses on translating complex business requirements into actionable data science use cases. He has also demonstrated exceptional training capabilities, delivering corporate training programs on Machine Learning, Deep Learning, and Natural Language Processing to diverse professional audiences. With a Master's degree in Data Science & Business Analytics from Asia Pacific University (achieved with Distinction) and a Bachelor's in Electronics Engineering, Uzair possesses a solid academic foundation complemented by numerous industry certifications. His technical proficiency spans Python, R, SQL, Spark, SAS, and HiveQL, along with expertise in modern data science platforms including Tableau, Power BI, DataRobot, H2O.ai, and Dataiku. His project portfolio demonstrates versatility across fraud detection, credit scoring, opinion spam detection, electricity load forecasting, and neural network applications, showcasing his ability to apply advanced statistical and machine learning concepts to solve real-world business challenges.
58 Courses
English
10 Years

FAQ

Frequently Asked Questions About This Course

Close menu