MICROSOFT EXCEL DATA ANALYTICS: Power Query, Power Pivot & Interactive Dashboard Development, 23rd - 24th November 2026_Kota Kinabalu, Sabah
- IT
- 23rd - 24th November 2026
- Le Meridien Kota Kinabalu
INTRODUCTION
Modern businesses generate data from multiple sources such as Excel workbooks, CSV files, databases, and online systems. This practical two-day workshop equips participants with the knowledge and hands-on skills to automate data preparation using Power Query, build powerful data models using Power Pivot, and create interactive dashboards for management reporting.
Participants complete an end-to end case study from raw data to a refreshable dashboard.
This Course Include
- Access to our course materials
- Full lifetime access
- Certificate of Attendance
CONTACT INFORMATION
- For more information, please contact the following Program Consultant:
-
Ms. Annette / email: annette@cfrontier.com /
Tel: (+6) 011 6076 4504
LEARNING OUTCOME
- Understand the modern Excel data analytics workflow.
- Import data from Excel workbooks, CSV files and folders.
- Clean, reshape and transform datasets using Power Query.
- Perform business calculations using Custom Columns and Conditional Columns.
- Understand the fundamentals of M Language generated by Power Query.
- Combine datasets using Merge and Append queries.
- Automate monthly reporting using Folder Import and Refresh.
- Build a relational Data Model using Power Pivot.
- Create DAX Measures for business analysis.
- Design interactive dashboards using PivotTables, PivotCharts, Slicers and Timelines.
- Produce refreshable reports for management decision- making.
WHY THIS PROGRAM MATTER NOW?
- Supports Malaysia’s digital transformation.
- Automates Excel reporting and saves time.
- Reduces errors and improves data accuracy.
- Enables faster, data-driven decisions.
- Builds practical, in-demand analytics skills.
- Maximizes Microsoft 365 capabilities.
- Prepares organizations for AI and data analytics.