Information and Communication Technology

Power BI Desktop Essential Skills

Microsoft Power BI is a suite of business analytics tools for presenting data from a variety of sources. It is available offline as Windows software (Power BI Desktop), as a mobile app, and online via a web interface (Power BI Online). With Power BI you can create rich reports that display metrics in a way that is easy for users to understand and interact with. Prerequisites: Participants must already have experience working with Excel charts.

Power BI Data Modelling

Data modelling is one of the pillars of Power BI report development. It allows you to connect different data tables in your Power BI report by creating relationships between them. It is important to understand the basics of data modelling as it makes sure you’re getting the right results in your reports. It will save you the frustration of trying to find the root cause of errors that might result from the wrong relationships. So, developing your data modelling skills will greatly improve your reports and outputs.

PowerPivot - Powerful Data Analysis and Data Modelling in Microsoft Excel

This course is relevant to data analysts, business analysts, financial analysts and anyone who wants to better manage their data. Knowledge and experience in using Excel PivotTable is assumed. Participants are required to have the Microsoft Excel version 2010 and above.

Introduction to Power Query and Power BI

Participants will experience the Power BI platform and learn to extract, load and transform (ELT) data using Power Query before creating visualizations using Power BI’s drag-and-drop functionality.

Advanced Power Query Functions in Data Transformation

This course enables participants to further harness the usage and functionality within the Power Query user interface. It explores the techniques in merging and when the `grouping’ feature is best applied. Participants will learn to the features of parameters which serves as a way to easily store and manage a value that can be reused. is used. Users will also learn to create the Dynamic Calendar Table in ths Power Query. Participants need to have the basic knowledge of Power Query.

Data Analysing with Microsoft Excel Functions

Users of Microsoft Excel are familiar with its common functions and formulas but many have yet to discover the far potential and application of these tools. In learning and maximizing its specific & relevant functions, the common and tedious tasks can be simplified and made easy. Participants will discover how to avoid common pitfalls in using them, from learning the basic facts in using formulas to mastering the usage of more complex functions. This course is recommended to users who use MS Excel extensively at work or users who wanted to know more about functions that are available in Excel. Familiarity with the basics of Microsoft Excel is assumed.

Manipulating Data Effectively with Microsoft Excel

These days, any managerial or analyst role requires that you work with data. Excel remains one of the most powerful and easy to use tools when it comes to crunching data. Learning Excel in a proper, structured way not only can help you save time, but also can help you become better at your job and give you time to focus on things and people that matter. This is an ideal course for users who desires to manage data, sort and filter, analyze data, and learn to automate some common Excel tasks. Prerequisites: experience in creating, editing, formatting, saving, and printing basic spreadsheets in Microsoft Excel is necessary.

Microsoft Excel Lookup Functions – Vlookup, Hlookup, Match, Index

Participants will be exposed to the ultimate lookup functions in Excel. Prerequisites: Participants should have experience working with Microsoft Excel.