Kepuncak Academy

Home
About Us
Courses
Programmes
Let's Talk
Home
About Us
Courses
Programmes
Contact Us

Our Courses

Upgrade your skills with our professional training programs.

Transforming Data Analysis – Dashboard with Excel & AI

This hands-on course is designed to help participants transform raw data into interactive and insightful dashboards using Microsoft Excel, Power Query and AI enhanced methos. Participants will progress from basic data handling to building interactive dashboards that support faster, smarter decisions at work. The class focuses on real-life applications using real datasets, making it suitable for professionals, educators, and students across all industries.

Course Objectives:

By the end of this course, participants will be able to:

  1. Master data cleaning and preparation techniques using Excel and Power Query.
  2. Use formulae, functions, and lookups to analyse data and identify trends.
  3. Create dashboards that effectively communicate insights using charts and pivot tables.
  4. Apply AI features to enhance analysis, generate formulae, and summarise findings.
  5. Automate repetitive tasks using Excel and data validation techniques.

Learning Outcomes:

Participants will:

  1. Apply essential Excel and AI tools to prepare, clean, and analyse data effectively.
  2. Create interactive dashboards to support data-driven decision-making.
  3. Improve reporting accuracy and present findings with effective data storytelling techniques.
  4. Demonstrate workflow efficiency and time savings using Excel automation.
  5. Use AI features ethically to enhance productivity.
  6.  

Module:

  1. Introduction to Data Analysis in Excel
  2. Excel Essentials Refreshers & Data Literacy
  3. Formulae and Functions for Analysis
  4. Data Cleaning Techniques
  5. Data Models and Pivot Analysis
  6. Data Visualisation & Chart Design
  7. Dashboard Development
  8. Introduction to Power Query & Work Automation
  9. Applying AI Ethically in Data Work

This hands-on course equips participants with the complete workflow of data analysis and dashboard design using Microsoft Power BI enhanced with AI-driven features. Participants will learn to clean, analyze, visualize, and communicate data insights for business and workforce decision-making. It is designed for all levels, from beginners to those seeking to improve their reporting and analytics skills.

Course Objectives:

By the end of this course, participants will be able to:

  1. Connect and import data from Excel and other sources into Power BI.
  2. Clean and transform data using Power Query.
  3. Create calculated columns and measures using DAX formulas.
  4. Design interactive dashboards and reports with charts, slicers, and filters.
  5. Apply AI features to gain deeper insights and automate parts of data analysis.

Learning Outcomes:

Participants will:

  1. Understand the complete Power BI workflow – from raw data to presentation.
  2. Produce professional dashboards for reporting and decision-making.
  3. Use data storytelling techniques to communicate insights effectively.
  4. Save time by automating report refresh and updates.
  5. Apply analytical thinking for better decision support.

Module:

  1. Introduction to Power BI
  2. Connecting Data Sources
  3. Cleaning and Transforming Data
  4. Data Modelling and DAX Basics
  5. Building Dashboards
  6. Data Storytelling
Transforming Data Analysis – Excel & Power BI Integration Workshop

This practical workshop helps participants master the complete data analysis workflow from Excel to Power BI. Participants will learn how to clean, manage, and analyze data in Excel, then connect and visualize data in Power BI for professional dashboards and automated reports. This program is for anyone who works with data regularly and wants to upgrade report skills using real-world business cases.

Course Objectives:

By the end of this course, participants will be able to:

  1. Manage and clean data efficiently in Excel (and Power Query) for Power BI integration.
  2. Create formulas, lookups, and pivot tables for quick insights.
  3. Import, transform, and model data in Power BI using Power Query.
  4. Build dynamic dashboards and visuals stories using Excel and Power BI.
  5. Automate recurring reports and share dashboards effectively.

Learning Outcomes:

Participants will:

  1. Use Excel and Power BI together for end-to-end data analysis.
  2. Reduce manual reporting time through automation.
  3. Build dashboards that communicate insights clearly and visually.
  4. Apply analytical thinking and data storytelling skills.
  5. Return to work with practical templates ready to use.

Module:

  1. Excel Data Management Refresher
  2. Pivot Tables and Charts
  3. Power Query Transformation
  4. Preparing Data for Excel Dashboard
  5. Getting Started with Power BI
  6. DAX Basics for Analysis
  7. Building Interactive Dashboard using Power BI

This practical course introduces participants to data visualization and building interactive dashboard using Tableau. Participants will learn how to turn complex data into clear, interactive visuals that communicate insights effectively. This course emphasizes storytelling through data, helping participants design dashboards that inform, engage, and inspire decision-making even with no technical background.

Course Objectives:

By the end of this course, participants will be able to:

  1. Connect and import data from Excel and other sources into Tableau.
  2. Clean, organize, and prepare data for analysis.
  3. Create professional dashboards and interactive visuals.
  4. Apply storytelling techniques to communicate insights clearly.
  5. Share and publish dashboards for business, education, or reporting use.

Learning Outcomes:

Participants will:

  1. Understand key principles of data visualization and design.
  2. Build interactive dashboards using real datasets.
  3. Use filters, parameters, and charts to make data more meaningful.
  4. Present their dashboard effectively through storytelling techniques.
  5. Gain confidence in applying visual analytics in daily work or research.

Module:

  1. Introduction to Data Visualization
  2. Getting Started with Tableau
  3. Data Cleaning & Preparation
  4. Building Visuals in Tableau
  5. Designing Dashboards

This course provides a complete, structured learning pathway in SQL using MYSQL, starting from foundational concepts and progressing to advanced analytical capabilities. Participants learn through real datasets, business case studies, and industry scenarios, ensuring the knowledge gain is immediately relevant to modern job requirement. The course emphasizes understanding how data works inside companies, for instance, how it is stored, queried, analyzed, and transformed into insights. Through hands-on practice, participants develop expertise in CRUD operations, data filtering, aggregations, joins, subqueries, window functions, stored procedures, views, and advanced analytics queries.

This is fully practical, beginner-friendly, step-by-step training designed for immediate workplace application. By the end of the program, participants will be able to confidently use MySQL to clean data, perform analysis, generate insights, support decision-making, and prepare data for BI tools such as Power BI, Tableau, and Python analytics.

Course Objectives:

By the end of this course, participants will be able to:

  1. Understand the foundations of relational databases and SQL concepts.
  2. Perform CRUD operations to manage and manipulate data effectively.
  3. Use filtering, sorting, grouping, and aggregation for business insights.
  4. Join multiples tables to build complete analytical datasets.
  5. Write subqueries and derived tables for advanced data retrieval.
  6. Apply window functions for ranking, trends, running totals, and comparisons.
  7. Create views, stored procedures, and reusable scripts.
  8. Use SQL for practical analytics and decision-making.

Learning Outcomes:

Participants will:

  1. Write SQL queries from beginner to advanced level confidently.
  2. Build and manage relational databases.
  3. Clean, transform, and prepare data for analytics.
  4. Combine datasets using joins and subqueries.
  5. Generate analytical insights using aggregate and window functions.
  6. Create reusable SQL assets

Module:

  1. Introduction to Databases and MySQL
  2. Essential SQL Foundations
  3. Data Definition (The Blueprint)
  4. Data Querying and Manipulation
  5. Advanced Querying and Relationship (The Insights)
  6. Database Administration and Optimization
  7. Scalability and Advanced Data Types