Course Detail(IT088v : Work with Data & Generate Data Driven Insights using Advanced Data Analytics (Live Webinar))

IT088v : Work with Data & Generate Data Driven Insights using Advanced Data Analytics (Live Webinar) NEW

14.00 CPE Hours (Others)
Live Webinar

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.

Competency Mapping

Others = 14.00 Hours

Schedule & Fees

Date & Time

28 Oct 2021 (9:00 AM - 5:00 PM)
29 Oct 2021 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 749.00   $ 599.20
For Non-Members: $ 898.80   $ 719.04
Discount till 31 Dec 2021

Programme Facilitator(s)

Divya Arora

Venue

Online Classroom in or outside of
Singapore

Date & Time

28 Jul 2021 (9:00 AM - 5:00 PM)
29 Jul 2021 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Divya Arora

Testimonial

Funding

No funding Available!

Programme Facilitator(s)


Divya Arora
 
Divya is a thorough professional and has 15 years of work experience and have core skills in field of Data Science, Data Visualization and Analytics, Business Intelligence, Management reporting and analytics. She is excellent in her oration and has been responsible for training her teams and stakeholders in areas of Advanced Data Analytics, Big data techniques, Data Visualizations tools, Advanced Excel techniques, mastering the art of giving presentations, Dash boarding and visual presentations in alignment with organisation goals.
She has varied experience working with big giants like Ministry of Foriegn Affairs, Ministry of National Development, National University of Singapore, Murdoch University, Glaxo Smith Kline, ABN AMRO and Max Life Insurance and various training institutes in India and Singapore.
 
Divya has worked across different industries like healthcare, consumer and insurance. She has been a key player in working across transition projects, transformation journey’s, new process set ups, data warehousing and Enterprise wide deployment of new Analytical and Business Intelligence tools
 
Divya has been a key contributor to Quality and service excellence and is certified Green Belt Six Sigma professional.

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.

Competency Mapping

Others = 14.00 Hours

Programme Facilitator(s)

Divya Arora
 
Divya is a thorough professional and has 15 years of work experience and have core skills in field of Data Science, Data Visualization and Analytics, Business Intelligence, Management reporting and analytics. She is excellent in her oration and has been responsible for training her teams and stakeholders in areas of Advanced Data Analytics, Big data techniques, Data Visualizations tools, Advanced Excel techniques, mastering the art of giving presentations, Dash boarding and visual presentations in alignment with organisation goals.
She has varied experience working with big giants like Ministry of Foriegn Affairs, Ministry of National Development, National University of Singapore, Murdoch University, Glaxo Smith Kline, ABN AMRO and Max Life Insurance and various training institutes in India and Singapore.
 
Divya has worked across different industries like healthcare, consumer and insurance. She has been a key player in working across transition projects, transformation journey’s, new process set ups, data warehousing and Enterprise wide deployment of new Analytical and Business Intelligence tools
 
Divya has been a key contributor to Quality and service excellence and is certified Green Belt Six Sigma professional.

Upcoming Schedule

Date & Time

28 Oct 2021 (9:00 AM - 5:00 PM)
29 Oct 2021 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 749.00   $ 599.20
For Non-Members: $ 898.80   $ 719.04
Discount till 31 Dec 2021

Programme Facilitator(s)

Divya Arora

Venue

Online Classroom in or outside of
Singapore