Turn data into insights that drive decisions.
Power BI Desktop Fundamentals is a practical course designed to help participants quickly glean insights from data using Power BI tools — Desktop, Service and Mobile. It covers importing and shaping data, creating interactive visualisations, building dashboards, and applying basic DAX for calculated measures.
By the end, learners can clean and model data, create KPIs, and share reports securely. No programming experience is required; basic Excel knowledge is recommended. Ideal for managers, analysts and professionals seeking to enhance data-driven decision-making.
Import data from various sources and perform basic cleaning and transformation using Power Query.
Design interactive reports and dashboards using Power BI Desktop’s visualisation tools.
Apply simple DAX formulas to create calculated columns and measures for enhanced analysis.
Overview of the Power BI ecosystem, installing and navigating Power BI Desktop, and the workflow: Get Data → Transform → Model → Visualise → Share.
Importing from multiple sources; combining, appending and cleaning data; removing duplicates and blanks; conditional and custom columns; best practices for query organisation.
What DAX is and why it matters; calculated columns and measures; SUM, AVERAGE, COUNTROWS, IF, SWITCH, CALCULATE; filter and row context.
Creating bar, column, pie and line charts; slicers and filters; formatting for clarity; dashboards with multiple visuals; report themes and layout tips.
Guided exercises for each module and a mini project: combine Excel sheets, clean data, create DAX measures and build a dashboard.
A hands-on, practical approach with guided exercises, real-world scenarios and mini projects. Participants learn by doing — importing, transforming and visualising data — supported by step-by-step instructions and immediate feedback.
CK Ong is a Microsoft Certified Trainer based in Bayan Lepas, Penang. With extensive experience in corporate training, CK specialises in practical, hands-on courses in data analytics, Power BI and decision-making for SMEs, combining real-world scenarios and interactive exercises to build confidence and actionable skills.
Customised, outcome-driven and HRDC-claimable. Let’s design the right journey for your team.