Microsoft Excel Data Analytics: Power Query, Power Pivot & Interactive Dashboard Development, 8th - 9th December 2026_Kuching, Sarawak
- Digital
- 8th - 9th December 2026
- The Waterfront Hotel, Kuching
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. Joan / email: joan@cfrontier.com /
Tel: (+6) 012 898 7991
COURSE OBJECTIVES
- 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.