Programme Objective

This workshop is designed for finance and accounting professionals who work on strategizing and analyzing business problems. It is focused on learning about nuances of data analytics and advanced analytical techniques available in today’s world.
The participants of this workshop will learn working with large data sets and complex calculations whilst understanding data statistically. The trainer will focus on multiple available techniques in Data Mining, Predictive Analytics and Prescriptive Analytics to enhance the participants’ understanding of data from an analytical perspective and ability to make informed decisions.

This workshop will also help the participants to learn tips and tricks of developing complex analytical dashboards and use of Business Intelligence and its tools in the market.
Our expert trainer will work with the participants on huge data sets and practical examples to help them relate to real life analytical problems and optimum approach to the solutions. Hands on exercises will be given to help the participants to master these functionalities and apply them in a meaningful way.

Training Outcomes:

At the end of the workshop, the participants will be able to increase productivity and enhance efficiency in their day-to-day work with Excel files. Participants will be able to analyze their financial data in a meaningful way to draw further insights for decision making. The aim of the workshop is to allow the participants to be more self-confident with data mining and advanced analytical techniques for further analysis and interpretation for senior management and steer committees.
 

Programme Outline

• Understanding Data statistically for further analysis
  • What is Data Analytics and its types
  • Using Statistical Analysis
  • Descriptive Vs Predictive Analytics
  • Predictive Vs Prescriptive Analytics
  • Data Modelling Relationship
  • Correlation and regression analysis techniques
  • Correlation Vs Causation
  • Application to Business Management
  • Discussing examples
• Mastering Descriptive Analytics and application of these concepts in real work related projects
  • Understanding the concepts of statistical terms and techniques
  • Using Statistical Analysis to generate insights
  • Multiple hands-on exercises and examples to help participants to apply these techniques in their respective work areas
  • Quiz and practical exercises
• Understanding the techniques of Predictive Analytics and its application
  • Concept of Hypothesis Testing
  • Use of Critical Metrics and Level of Confidence
  • Data Modelling Relationship
  • Understanding Logistic Regression
  • Quiz and practical exercises
• Advanced Data Analytics
  • Understanding Prescriptive Analytics
  • Mastering Prescriptive Analytics techniques
  • Prescriptive Analytics using MS Excel
  • Use and application of Market Basket Analysis with examples
• Advanced Data Mining techniques to solve more complex analytical problems
  • Using Cluster Analysis
  • Application of Clustering in Excel
  • Defining and understanding Association rules
  • Application to Business Management
• Learning all about Sentiment Analysis
  • Concept of Sentiment Analysis
  • Calculating the textual sentiments
  • Deriving analysis
• Mastering the concept of Forecasting
  • Forecasting using historical data
  • Forecasting in Excel
  • Forecasting techniques
  • Application of Forecasting methods in Excel
• Quick Analytical Tips and Tricks to apply analysis on day-to-day work
  • Using Excel for Advanced Data Analysis
  • Managing multiple business scenarios and achieving targets
  • Working with large volume of data
• Analyzing and Evaluating Data Dashboards at your fingertips
• Mastering Performance Management and identifying key performance indicators
• Constructing and designing Financial and Strategic Dashboards for enhanced decision making
• Mastering techniques for Reporting and Presentation to senior management
• Business Intelligence concepts and its applications
  • Introduction to data warehousing
  • Understanding different Business Intelligence Tools and its uses
  • Connection with data visualization tools and technology
  • Comparing available tools in the market and choosing the best fit as per your needs

 

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

Live Webinar, with multiple hands on exercises and assignments

Closing Date for Registration

1 week before programme or until full enrolment.

Intended For

The training is ideal for those (such as Accountants, Controllers, Finance managers, Auditors and all accounting professionals) who deal with large volume of data and Excel applications in their day-to-day work for reporting, data mining and need Excel tools and technologies to further enhance their efficiency and productivity in data analysis and interpretation.

Programme Facilitator(s)