Course Detail(IT027C : Interactive Dashboard: Designing Visually Appealing Reports)

SDF Funding, SkillsFuture Credit, UTAP Funding

IT027C : Interactive Dashboard: Designing Visually Appealing Reports

14.00 CPE Hours (Others)
Classroom


Notice
 
Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided.
 
You may opt to bring along your laptop if you wish to use Excel 2013.
 
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.
 
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.

Competency Mapping

Others = 14.00 Hours

Schedule & Fees

Date & Time

05 Mar 2020 (9:00 AM - 5:00 PM)
06 Mar 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 679.45
For Non-Members: $ 815.34

Programme Facilitator(s)

Wong Suet Yin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

23 Jul 2020 (9:00 AM - 5:00 PM)
24 Jul 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 679.45
For Non-Members: $ 815.34

Programme Facilitator(s)

Wong Suet Yin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

27 Oct 2020 (9:00 AM - 5:00 PM)
28 Oct 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 679.45
For Non-Members: $ 815.34

Programme Facilitator(s)

Wong Suet Yin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

19 Dec 2019 (9:00 AM - 5:00 PM)
20 Dec 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Wong Suet Yin

Date & Time

25 Jul 2019 (9:00 AM - 5:00 PM)
26 Jul 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Wong Suet Yin

Date & Time

25 Apr 2019 (9:00 AM - 5:00 PM)
26 Apr 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Wong Suet Yin

Testimonial

Funding

1] SkillsFuture Credit (SFC)
Funding Period: Until 26 Jan 2021
Course Ref No.: CRS-N-0030905

All Singaporeans aged 25 and above will receive an opening credit of S$500 from the government. The credits will not expire and periodic top-ups will be provided by the government. SFC may be accumulated to pay for skills related course fees. You may wish to use your SFC to pay for partial/full ISCA course fees.  (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: Register for the course online via ISCA Portal. 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. At the Cart page, please ensure that SFC funding is applied before clicking “Checkout”.
  • Step 2: After successful enrolment, 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 here: 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 $42.80 for any revision of invoice.


2] WDA Training Grant - SDF Funding
This course is approved for SDF funding ($2 per training hour) for Company-sponsored participants only (Eligibility criteria apply). 
 
Funding Period: Until 26 Jan 2021
Funded Hours: 14 hours
Course Ref No.: CRS-N-0030905

If you wish to enrol participants with SDF Funding, please proceed with the following steps (For Corporate enrolments only) :

  • Step 1: Register for the course online via ISCA Portal. Upon adding to cart, the system will prompt a question “Do you wish to apply for WDA Funding?”, click Yes and input all required information. At the Cart page, please ensure that SDF funding is applied before clicking “Checkout”.
     
  • Step 2: After successful enrolment, please proceed to submit the Training Grant application via SkillsConnect Portal here: https://www.skillsconnect.gov.sg/

 

Employers of company-sponsored participants must submit training grant via SkillsConnect system to obtain training grant for course fees. You may submit the Training Grant application within the period from 30 days before the course start date to 30 days after course start date. Please note that there will be an administrative fee of $42.80 for any revision of invoice.

 

Eligibility Criteria:

  • Company must be registered or incorporated in Singapore and;
  • Applicant is taking the course for the first time.
  • Applicant must be employed, and is either Singapore Citizen or Permanent Resident of Singapore and;
  • Applicant must achieve at least 75% attendance, and pass all examinations /assessments and;
  • Applicant must be fully sponsored by the Company for all costs associated with the training and;
  • Payment has to be made via corporate means (e.g. corporate cheque, corporate GIRO, corporate credit card).

3] NTUC Union Training Assistance Programme (UTAP)
UTAP (Union Training Assistance Programme) is an individual skills upgrading account for NTUC members. NTUC member gets to enjoy UTAP funding 50% of the unfunded course fee capped at $250 every year. This excludes miscellaneous fees such as GST and registration fee etc.
 
This course is approved for UTAP support for intakes conducted between 01 April 2019 – 31 March 2020.
 
As UTAP is given on calendar year basis, and calculated based on year of training taken, it cannot be accumulated.

  • Maintained paid-up NTUC membership before course, throughout course duration and at the point of claim and;
  • Course by training provider must be supported under UTAP and training must commence within the supported period and;
  • Unfunded course fee must not be fully sponsored by company or other types of funding
  • Unfunded course fee must be S$20.00 and above, and;
  • Member must achieve a minimum of 75% attendance for each application and sat for all prescribed examination(s), if any and;
  • UTAP application must be made within 6 months after course ends.

 
Please refer to the UTAP Application Guide here on how union members can apply for UTAP via the system.
 
To submit for UTAP claims, please visit http://skillsupgrade.ntuc.org.sg/. Terms and conditions apply.
 
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)


Wong Suet Yin
CA (Singapore) 

 
Suet Yin graduated from the National University of Singapore with an accounting degree and is a member of the Institute of Singapore Chartered Accountants (ISCA). 
 
She has more than 20 years of working experience in the area of accounting, tax, project management and training. She held several management positions with large MNCs. Suet Yin is very passionate in training and is always ready to share her knowledge with others. She adopts a pragmatic real world approach during training and believes in 'fun - have a good time'.


Notice
 
Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided.
 
You may opt to bring along your laptop if you wish to use Excel 2013.
 
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.
 
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.

Competency Mapping

Others = 14.00 Hours

Programme Facilitator(s)

Wong Suet Yin
CA (Singapore) 

 
Suet Yin graduated from the National University of Singapore with an accounting degree and is a member of the Institute of Singapore Chartered Accountants (ISCA). 
 
She has more than 20 years of working experience in the area of accounting, tax, project management and training. She held several management positions with large MNCs. Suet Yin is very passionate in training and is always ready to share her knowledge with others. She adopts a pragmatic real world approach during training and believes in 'fun - have a good time'.

Upcoming Schedule

Date & Time

05 Mar 2020 (9:00 AM - 5:00 PM)
06 Mar 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 679.45
For Non-Members: $ 815.34

Programme Facilitator(s)

Wong Suet Yin

Venue

60 Cecil Street
ISCA House
Singapore 049709