top of page

Optimize Your Business through Data Analytics

"Trends and Metrics through Data Analytics Techniques"

16-18 June 2020 | Kuala Lumpur, Malaysia and 5-7 August 2020 | Manila, Philippines



Data analytics is the science of analysing raw data in order to draw conclusions. Many of the techniques and processes of data analytics have been automated into mechanical processes and algorithms that work over raw data for human consumption. Data analytics techniques can reveal trends and metrics that would otherwise be lost in the mass of information. This information can then be used to optimize processes to increase the overall efficiency of a business or system.


The process involved in data analysis involves several different steps:


  • The first step is to determine the data requirements or how the data is grouped. Data may be separated by age, demographics, income and gender. Data values may be numerical or be divided by category.

  • The second step in data analytics is the process of collecting it. This can be done through a variety of sources such as paper based sources, computers, online sources, cameras, environmental sources.

  • Once the data is collected, it must be organized so it can be analysed. Organisation may take place on a spreadsheet or other form of software that can take statistical data.

  • The data is then cleaned up before analysis. This means it is scrubbed and checked to ensure there is no duplication or error and that it is not incomplete. This step helps correct any errors before the data go to the analyst


Key Learning Points


  • Data analytics is the science of analysing raw data in order to make conclusions about that information.

  • The techniques and processes of data analytics have been automated into mechanical processes and algorithms that work over raw data for human consumption.

  • Data analytics helps a business to optimise its performance.

Course Contents


We cannot look at and solve all data analysis problems and cases but here is a glimpse into the areas where data analysis is being applied very successfully:


  • Retail

  • Health

  • Sports

  • Weather

  • Financial modeling

  • Energy

  • Social Media Analysis

  • Internet of Things


Throughout this course, we will be assessing examples from these areas as an aid to our greater understanding of the usefulness and application of data analysis.


Who Should Attend?


This workshop will be valuable to everyone who is faced with quantitative decision making, financial and non financial reporting, statistical and data analysis and more.


  • CEO/CFO/COO/Finance Directors/Financial Controllers /Heads of Finance

  • Financial Analysts

  • Directors/Heads/Managers of Strategic Planning

  • Directors/Heads/Managers of Business Development

  • Financial/Equity/Treasury Analysts

  • Project Managers

  • Project Financiers and Lenders

  • Accountants and Auditors

  • Financial controllers

  • Risk managers

  • Credit managers

  • Financial and management accountants

  • Financial project administrators

  • Project finance professionals

  • Financial planners


This course will focus on the tools and techniques available in preparing, analysing and drawing conclusion through data which will enable you to develop your own solutions to your own problems.

For more information, investment fees and registration, email us at


What do they say about our recent runs? 

"Learning the advanced features of Excel and how to apply it in my line of work." - John Elson Baguipo,  Financial Modeller, Boracay Island Water Company\

"Course was very comprehensive but the material very much relevant and applicable to corporate career. - Francis Buenaventura, Treasury Specialist, Ayala Corporation

"Very well organised, highly informative, and a chance to get to know more people outside our department." - Rico Escaler, Corporate Strategy & Development Associate, Ayala Corporation

"The instructor had a very good idea of what we would need Excel to do in our work and was able to point out some really helpful and useful techniques for us to apply at work." - Monica Fajardo, Finance Analyst, Ayala Corporation

"There were applications that we've been using for years and only to find out there were simpler commands we can use. The training will be very useful and applicable being a finance person. " - Rizalyn Guico, Finace Manager, Ayala Automotive

"Learned a lot of new concepts and enhanced my efficiency in excel." - John Albert Ong, Business Development Analyst, Ayala Corporation Infrastructure

"Great course, with all the new learnings in Excel, Power Q, Power BI, should improve production time  significantly." - John Armand Ong, Finance Manager, Ayala Corporation

"Very helpful and expert instructor!" - Jun Villaluz, Corporate Finance Associate Director, Ayala Corporation

"CTS provides an easy step by step guidance on modeling concepts and the insturctor really knows what he's talking about." - Anonymous, Ayala Infrastructure


"Mr. Duncan is very helpful & approachable " - Kate Petilla, Auditor, Ayala Corporation 

" Very Good" - Anonymous, Ayala Group Club, Inc.

"Very informative." - Alvin Evangelista, Finance Manager, Manila Water Asia Pacific (VIetnam)

"Learned a lot in this course. Thank you!" - Mayee Pena, Cost Controller,  Manila Water

"I learned a lot! MS Excel Level Up" - Jasmine Orpilla, Corporate Finance and Admin Manager,  Manila Water

"I am happy I was able to participate and learn in this seminar, looking forward to future trainings. " - Timothy Salak, Business Development Manager Ayala Corporation Infrastructure  

"Mr. Williamson is very approachable, tries to understand and provide practical solutions to questions of the attendees." - Mae Christine Go, Internal Audit Manager, Ayala Corporation 

bottom of page