
Domain:
Digitalisation; Infocomm Technology & Smart Systems; Service Delivery; Our Core Competencies
Content Type:
Classroom
Course Code:
CRAAD10
Who Should Attend:
You are a Singapore Public Officer interested in learning how to use business intelligence tools to analyse trends, spot key issues and deliver data-driven insights. This programme will be relevant for public officers who regularly analyse data to generate insights and reports. As this programme involves working with formulae, you must be comfortable working with Power BI or similar business analysis tools.
Programme Overview
To support data-informed decision making, you need to be able to analyse data, generate insights and present them convincingly to your stakeholders. Elevate your data analysis, visualisation and communication today by using Business Intelligence (BI), the tool-driven process of analysing data, generating insights and presenting them.
You will learn to use Microsoft’s Power BI tool to integrate, analyse data and create interactive dashboards through hands-on tasks. You will also learn how to communicate data-driven insights to stakeholders through a coherent and convincing story that has the power to influence decision-making.
Learning Outcomes
- Appreciate what business intelligence is and its role in analytics
- Describe how business intelligence and descriptive analysis can be applied to data
- Identify the importance of analysing data visually and selecting the right method of data analysis
- Analyse trends, spot outliers in data and find correlations
- Use visual perception principles to design insightful and effective dashboards
- Develop an interactive dashboard using Power BI to communicate insights coherently and convincingly
Last updated:
- Overview of Business Intelligence (BI)
- What is BI?
- The BI Process
- OLAP - OnLine Analytical Processing
- What is BI?
- Descriptive analysis of data
- Types of variables
- Summarising data
- Measuring data
- Types of variables
- Introduction to Power BI
- Starting with Power BI
- Data analysis with Power BI
- Starting with Power BI
- Importance of analysing data visually
- Comparisons of numerical data
- Choosing appropriate visualisations
- Alternative charts for effective visualisations
- Comparisons of numerical data
- Mulit-dimensional analysis with BI
- Creating different charts and formatting effectively
- Connecting multiple data sources, grouping data, filtering data
- Introduction to DAX and calculated measures
- Creating dashboards
- Creating different charts and formatting effectively
- Principles of dashboarding
- What is a dashboard?
- Types of dashboards
- Designing dashboards
- Common mistakes in dashboard design
- What is a dashboard?
- Principles of visual perception
- Pre-attentive attributes
- Gestalt principles of perception
- Pre-attentive attributes

Need help? We are glad to help you
Find out how to contact us here.