Course Detail()

This session is delivered via live webinar (zoom platform).

Programme Objective

A picture speaks a thousand words. Dashboards are data synthesized into meaningful visualizations, appealing to the end users. Dashboard containing reports with summarised information rather than raw data with numbers in neat formatting, totals and sub-totals.
With the use of advanced business techniques, dashboard can enhance decision making process through building of powerful charts.

Understanding why data visualization is becoming more important within business intelligence (BI) and analytics.

Building your data model
Conceptualising your designs
Automating the reports
Create dashboards which are visually appealing to the visual learners, interactive and user-friendly.

Programme Outline

Moving from Spreadsheets to Dashboards
Define the difference between reports and dashboards
How to categorise dashboards
Establish visualization
Design Principles How to Develop a Data Model
What are the best practices in Data Modelling
Using advanced excel functions to bring together data from different sources and enable users to query and present the data in a variety of formats
Establish visualization
How to effectively leverage Excel charts to synthesize your data into meaningful visualizations
Selecting the best display medium
Understanding of how to choose and design the best display medium to enable clear and effective communication
How to use advanced business techniques to enhance decision making process through building of powerful charts
Techniques to automate your presentation processes
Clear understanding of how macros can aid in dashboard presentations
Introduction of interactive controls that can allow direct user interface and allow them to easily navigate through and interact with your dashboard
How to communicate with the Outside world?
Case studies
Participants to apply principles learned to Design and Present a dashboard

To view our full list of Infocomm courses, please click here.

Pre-requisites

Please take note of the following admission requirements:

Trainings will be conducted on Zoom platform, thus video camera and microphone are compulsory
Mandatory for video camera to be turned on throughout the course
Display your official name (as per NRIC) in Zoom, to facilitate attendance taking

Training Methodology

Lecture style, with computer hands-on Exercises

Closing Date for Registration

1 Week before Programme or Until Full Enrolment

Intended For

A programme for accountants, finance personnel, Accounts Managers, Managers and Executives who have to prepare and present monthly / weekly dashboards and KPI reports with data exported from systems.

Schedule & Fees

Testimonial

Past Participant

Funding

1] SkillsFuture Credit (SFC)
Funding Period: Until 26 Jan 2025
Course Reference Number: TGS-2020500501

All Singaporeans aged 25 and above will receive an opening credit of S$500 from the government. You may wish to use your SFC to pay for partial/full ISCA course fees.

On 1 Oct 2020, the Government provided a one-off SkillsFuture Credit Top-up of $500 for all eligible Singaporeans aged 25 or above by 31 Dec 2020. Singaporeans aged 40 to 60 by 31 Dec 2020 will also receive an Additional SkillsFuture Credit (Mid-Career Support) of $500 which can be used for courses under: (i) SGUnited Skills Programme, (ii) SGUnited Mid-Career Pathways Programme – Company Training, and (iii) Career Transition Programmes. This additional SFC (Mid-Career Support) is NOT applicable for use on ISCA courses. (For more information on the SFC scheme, please visit http://www.skillsfuture.sg/credit)

If you wish to enrol for the course with SFC Funding, please proceed with the following steps:

Step 1: You will need to ensure that you have sufficient SkillsFuture Credits in your SkillsFuture Credit account in order to make a successful claim. Please check your SFC account balance here.
Step 2: Register for the course online via ISCA Portal.
Step 3: Upon adding to cart, the system will prompt a question “Do you wish to apply for SkillsFuture Credit?”, click “Yes” and input all required information.
Step 4: At the Cart page, please ensure that SFC funding is applied before clicking “Checkout”.
Step 5:Upon receiving an email that the programme status is confirmed, please proceed to submit SFC claim on SkillsFuture Portal within 60 days before the course start date and obtain the necessary approval. Please submit SFC claim via SFC portal (http://www.skillsfuture.sg/credit).

Failure to submit claim application and obtain necessary approval before the course start date will result in topping up of the SFC indicated for use. Please note that there will be an administrative fee of $43.20 for any revision of invoice.

2] NTUC Union Training Assistance Programme (UTAP)
UTAP (Union Training Assistance Programme) is an individual skills upgrading account for NTUC members.

To find out more on the UTAP funding and support validity period please click here.

Should you have queries on the funding scheme, you can email to UTAP@e2i.com.sg or call NTUC Membership Hotline at 6213-8008

Programme Facilitator(s)