Course Detail(BarPlusCode : Advanced Certificate in Business Analytics and Reporting (BAR))

UTAP Funding

BarPlusCode : Advanced Certificate in Business Analytics and Reporting (BAR)

15.00 CPE Hours (Others)
Classroom

Approved for UTAP support for intakes conducted between 1st April 2019 to 31st March 2020. NTUC members enjoy course fee support with up to $250 every year when you enroll for courses supported under UTAP (Union Training Assistance Programme). This excludes miscellaneous fees such as GST and registration fee etc. (Terms & Conditions apply)

For eligibility criteria or UTAP claims submission, please refer to the Funding tab.


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

The BAR+: Advanced Certificate in Business Analytics and Reporting (BAR) is designed to provide past BAR participants a platform to enhance your business reporting skills and refine your financial models in a 2-days intensive course.

It covers advanced Excel tools and techniques which is essential for financial reporting including data queries to import and link to data, using SQL to automate and enhance reporting, using advanced Excel functions and charting techniques, and reviewing security issues associated with creating and communicating Excel financial reports.

This course provides a comprehensive coverage, from time-saving to automation tips, bringing you to a higher level of financial analysis and reporting. 
 
Master the advanced BAR techniques in 2 days and learn how you can be an expert in building sustainable, interactive and impressive reporting models with Excel.

Programme Outline

Module 1: The Performance Dashboards & Analysis Perspectives(includes an e-learning module to be completed prior to course commencement)
 

  • Understanding the concepts of data warehouses, data mining, and business intelligence
  • Relational databases and data modelling
  • The business models and financial projections
  • Building a performance management framework

 
Module 2: Quick overview of the BAR conceptual framework for building interactive tables and charts

  • The components, relationship and data structure of interactive reports
  • The design and building of the interactive reports and charts
  • Formula auditing and debugging to bullet-proof the model
  • The relationship between the spreadsheet and the VBA engine

 
Module 3: Importing data & Working with Pivot Tables 
 

  • Importing data from text, web and databases using database import functions, Pivot Tables and SQL
  • Using PivotTables to quickly summarize data and build ad hoc reports
  • Understand features of Charts/PivotCharts that are useful for information analysis and reporting
  • Integrating Slicers to build dynamic tables and charts

 
Module 4: The Application of Excel to Building Key Models & Dashboards
 

  • Visual enhancements to reports incorporating conditional formatting, special chart types with advanced Excel functions and techniques to create more sophisticated and flexible charts and reports.
  • Working with Form Controls to build interactive tables and charts

 
 Module 5: Incorporating Advanced Macro Techniques Into Models & Dashboards 
 

  • Adding Form and ActiveX Controls with macros to create robust interactive charts and reports
  • Using macros to automate repetitive formatting tasks, consolidation of data and exporting data to other office documents such as PowerPoint for report presentations.
  • Techniques for protecting business reports and to share data without sharing formulas

 
This course includes an Assessment element. 
 
Participants will be awarded a certificate in Completion and an Advanced Certificate in Business Analytics and Reporting (BAR) once they have passed the assessments which will include a 10 minutes online MCQ test and a class assignment.
For the class assignment the candidate can use the BAR LuxKarz Case Study or individual’s project work.  The candidate can explore where are the areas of improvements that can be made to the current template using the underpinning knowledge and techniques taught in the class.

For more information, please click on “Download Brochure”.
For more details on BAR Certification Programmes, please click
here


2-Day Hands-on with Assessments
 
CPE Hour: 15 CPE hours
User-added image


 
Bundle Package
BAR3R* and BAR+
(With GST)
Savings
Member $  1,338.00  $  238.00
Non-Member $  1,608.00  $  283.20


*BAR3R: Refresh, Recap and Revise the Essential BAR Techniques is intended for participants who had attended Business Analytics and Reporting (BAR). Participants who have taken the 1-Day AER are advised to attend the 3-Day BAR programme. Please click here to download BAR brochure.

Training Methodology
 
Lecture style, with computer hands-on Exercises


Closing Date for Registration

1 Week before Programme or Until Full Enrolment.

Intended For

For participants who have completed a course in Business Analytics & Reporting who wish to incorporate advanced techniques to build interactive reports and dashboards.  Any advanced users of Excel who wish to master the advanced BAR techniques in 2 days and learn how you can be an expert in building sustainable, interactive and impressive reporting models with Excel.

Competency Mapping

Others = 15.00 Hours

Schedule & Fees

Date & Time

28 Nov 2019 (9:00 AM - 5:00 PM)
29 Nov 2019 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 1,188.00
For Non-Members: $ 1,425.60

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

26 May 2020 (9:00 AM - 5:00 PM)
27 May 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 1,188.00
For Non-Members: $ 1,425.60

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

18 Nov 2020 (9:00 AM - 5:00 PM)
19 Nov 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 1,188.00
For Non-Members: $ 1,425.60

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

15 Jul 2019 (9:00 AM - 5:00 PM)
16 Jul 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Dr Lim Thou Tin

Date & Time

22 Nov 2018 (9:00 AM - 5:00 PM)
23 Nov 2018 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Dr Lim Thou Tin

Date & Time

16 Aug 2018 (9:00 AM - 5:00 PM)
17 Aug 2018 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Dr Lim Thou Tin

Testimonial


It was a very comprehensive course that teaches you how to use, pivots, VBAs with your dashboard. It had definitely enhanced the application to make dashboard reports more interactive and visually appealing!

Vivienne


I enjoyed the training. The training is very meaningful. I get to learn a lot of excel shortcuts, tips and knowledge which will help me in my job. The trainer is very good and experience. He is also very patient to guide us when we encounter issue and provides clear instructions. He also shares additional excel knowledge (excel formula) with us. Overall the courses conducted in ISCA is interesting. Will like to attend other finance related course which will aid me in my job role.

Chew Xintian


Great course, enjoyed it a lot as the course taught me so many things about Excel that I previously do not know and very applicable to my work. Great course and lecturer!

Ong Tah Keong


Great trainer!!! Love this course, wish there were more courses as such.

Ashish Kapoor

Funding

1] 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 1st April 2019 to 31st 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.

 
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)


Dr Lim Thou Tin
DBA, MKM, MInfSys, DipSA, DipIntelligentSys
DipMgtConsultancy, DipT&D, BBA, MFP (FAAFM)

 
Dr Lim Thou Tin is a business graduate with the National University of Singapore. He holds double masters in information systems and knowledge management with further postgraduate qualifications in systems analysis, intelligent systems, marketing, management consulting and training. He has a doctor of business administration from Southern Cross University with current research interests in information systems and business modelling. He is a fellow of the American Academy of Financial Management.
 
His work experience includes working in large Singapore companies to MNCs in senior corporate, IT and project management positions. As a management consultant and practitioner, he has facilitated organizational initiatives/projects over a span of more than 15 years in the region, including Australia, Singapore, Malaysia, Mauritius, China, India, Indonesia and Thailand.

Approved for UTAP support for intakes conducted between 1st April 2019 to 31st March 2020. NTUC members enjoy course fee support with up to $250 every year when you enroll for courses supported under UTAP (Union Training Assistance Programme). This excludes miscellaneous fees such as GST and registration fee etc. (Terms & Conditions apply)

For eligibility criteria or UTAP claims submission, please refer to the Funding tab.


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

The BAR+: Advanced Certificate in Business Analytics and Reporting (BAR) is designed to provide past BAR participants a platform to enhance your business reporting skills and refine your financial models in a 2-days intensive course.

It covers advanced Excel tools and techniques which is essential for financial reporting including data queries to import and link to data, using SQL to automate and enhance reporting, using advanced Excel functions and charting techniques, and reviewing security issues associated with creating and communicating Excel financial reports.

This course provides a comprehensive coverage, from time-saving to automation tips, bringing you to a higher level of financial analysis and reporting. 
 
Master the advanced BAR techniques in 2 days and learn how you can be an expert in building sustainable, interactive and impressive reporting models with Excel.

Programme Outline

Module 1: The Performance Dashboards & Analysis Perspectives(includes an e-learning module to be completed prior to course commencement)
 

  • Understanding the concepts of data warehouses, data mining, and business intelligence
  • Relational databases and data modelling
  • The business models and financial projections
  • Building a performance management framework

 
Module 2: Quick overview of the BAR conceptual framework for building interactive tables and charts

  • The components, relationship and data structure of interactive reports
  • The design and building of the interactive reports and charts
  • Formula auditing and debugging to bullet-proof the model
  • The relationship between the spreadsheet and the VBA engine

 
Module 3: Importing data & Working with Pivot Tables 
 

  • Importing data from text, web and databases using database import functions, Pivot Tables and SQL
  • Using PivotTables to quickly summarize data and build ad hoc reports
  • Understand features of Charts/PivotCharts that are useful for information analysis and reporting
  • Integrating Slicers to build dynamic tables and charts

 
Module 4: The Application of Excel to Building Key Models & Dashboards
 

  • Visual enhancements to reports incorporating conditional formatting, special chart types with advanced Excel functions and techniques to create more sophisticated and flexible charts and reports.
  • Working with Form Controls to build interactive tables and charts

 
 Module 5: Incorporating Advanced Macro Techniques Into Models & Dashboards 
 

  • Adding Form and ActiveX Controls with macros to create robust interactive charts and reports
  • Using macros to automate repetitive formatting tasks, consolidation of data and exporting data to other office documents such as PowerPoint for report presentations.
  • Techniques for protecting business reports and to share data without sharing formulas

 
This course includes an Assessment element. 
 
Participants will be awarded a certificate in Completion and an Advanced Certificate in Business Analytics and Reporting (BAR) once they have passed the assessments which will include a 10 minutes online MCQ test and a class assignment.
For the class assignment the candidate can use the BAR LuxKarz Case Study or individual’s project work.  The candidate can explore where are the areas of improvements that can be made to the current template using the underpinning knowledge and techniques taught in the class.

For more information, please click on “Download Brochure”.
For more details on BAR Certification Programmes, please click
here


2-Day Hands-on with Assessments
 
CPE Hour: 15 CPE hours
User-added image


 
Bundle Package
BAR3R* and BAR+
(With GST)
Savings
Member $  1,338.00  $  238.00
Non-Member $  1,608.00  $  283.20


*BAR3R: Refresh, Recap and Revise the Essential BAR Techniques is intended for participants who had attended Business Analytics and Reporting (BAR). Participants who have taken the 1-Day AER are advised to attend the 3-Day BAR programme. Please click here to download BAR brochure.

Training Methodology
 
Lecture style, with computer hands-on Exercises


Closing Date for Registration

1 Week before Programme or Until Full Enrolment.

Intended For

For participants who have completed a course in Business Analytics & Reporting who wish to incorporate advanced techniques to build interactive reports and dashboards.  Any advanced users of Excel who wish to master the advanced BAR techniques in 2 days and learn how you can be an expert in building sustainable, interactive and impressive reporting models with Excel.

Competency Mapping

Others = 15.00 Hours

Programme Facilitator(s)

Dr Lim Thou Tin
DBA, MKM, MInfSys, DipSA, DipIntelligentSys
DipMgtConsultancy, DipT&D, BBA, MFP (FAAFM)

 
Dr Lim Thou Tin is a business graduate with the National University of Singapore. He holds double masters in information systems and knowledge management with further postgraduate qualifications in systems analysis, intelligent systems, marketing, management consulting and training. He has a doctor of business administration from Southern Cross University with current research interests in information systems and business modelling. He is a fellow of the American Academy of Financial Management.
 
His work experience includes working in large Singapore companies to MNCs in senior corporate, IT and project management positions. As a management consultant and practitioner, he has facilitated organizational initiatives/projects over a span of more than 15 years in the region, including Australia, Singapore, Malaysia, Mauritius, China, India, Indonesia and Thailand.

Upcoming Schedule

Date & Time

28 Nov 2019 (9:00 AM - 5:00 PM)
29 Nov 2019 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 1,188.00
For Non-Members: $ 1,425.60

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

60 Cecil Street
ISCA House
Singapore 049709