New user? Register as member

Data Analytics Training Advanced

This workshop is designed for finance and accounting professionals, who are aware of the excel interface and its regular features. This workshop is focused on learning about the nuances of data analytics in today’s world.

The participants of this workshop will learn about working on large data sets and complex calculations through understanding data statistically, creating dashboards, dynamic formulas, advanced pivot tables techniques, and many more to create meaningful and insightful information using excel. This workshop will also help the participants to learn concepts of Business Intelligence and its tools in today’s market.

Our expert trainer will work with all the participants on huge data sets and practical examples to help them relate to real-life analytical problems and optimum approaches to its solutions. Hands-on exercises will be given to help all the participants to master these functionalities and apply them in a meaningful way.

Objective

At the end of the workshop, the participants will be able to increase productivity and enhance efficiency in their day-to-day work by Analysing their excel files much better. Participants will be able to analyze their financial data in a meaningful way to draw further insights and decision-making. The aim of the workshop is to make them self-confident in data mining and slicing and dicing the data for further analysis and interpretation.

In addition, participants will be able to express the data graphically and in a dynamic way that helps them to represent complex data sets through the best visual representations for senior management and steer committees.

Outline

Understanding Data Statistically for further analysis

1. What is Data Analytics and its types
2. Using Statistical Analysis
3. Descriptive Vs Predictive Analytics
4. Concept of Hypothesis testing
5. Data Modelling Relationship
6. Correlation and regression analysis techniques
7. Correlation Vs Causation
8. Application to Business management
9. Discussing Examples

Advanced Data Analytics

1. Learing about advanced Predicative Anlytics
2. Predicictive vs Prescriptive Analytics
3. Mastering Prescriptive analytics techniques
4. Prescriptive analytics using MS excel
5. Use and application of Market basket analysis
6. Using Cluster Analysis
7. Application of Clustering in Excel
8. Association rules vs clustering
9. Application to Business Management

Mastering the concept of Forecasting

1. Forecasting using historical Data
2. Forecasting in Excel
3. Forecasting techniques
4. Application of Forecasting methods in Excel

Business Intelligence concepts and its applicability

1. Introduction to data warehousing
2. Data repository vs data segmentation
3. Understanding different Business Intelligence Tools and its uses
4. Introduction to data visualization tools and technology

Who should attend

The training is ideal for those (such as Accountants, Controllers, Finance managers, Auditors and all accounting professionals) who deal with a large volume of data & excel in their day-to-day work for creating reporting solutions, data mining and need excel tools and technologies for further enhancing their efficiency and productivity. This workshop is apt for those people who want to understand the analytical perspective of data and draw further insights.

Profile of Divya Arora Hans

Divya is an expert Speaker and Trainer with more than decade experience in field of Management Reporting, Data Analytics, Business Intelligence and Change Management. She has excellence in her oration and has been responsible for training Corporates, Self employed, Individuals and stakeholders in areas of Advanced MS Excel, Mastering Power Point, Data Analytics, Delivering Impactful Presentations, Data visualizations, Advanced business communications, Wow your audience and many Soft Skills Trainings

Her Span of Experience has been to varied CXO’s, Department Heads and leadership teams across Finance, Accounting, Insurance, Engineering, Healthcare and FMCG industries

Her experience has been with ACCA Singapore, NTU, Delphi Technologies and multiple Retail trainings in Singapore

Her core skills are trainings in areas of MS Office, Power BI, Project Management, Business Intelligence, Business Communication Skills, Stakeholder Management, Team management/leadership, Process Transitions, Process excellence, Continuous Improvement and Change Management. She has varied experience working with big giants like Glaxo Smith Kline, ABN AMRO Bank and Max Life Insurance joint venture with MITSUI SUMITOMO and various training institutes in India and Singapore.

She has been a key contributor to Quality and service excellence and is a certified Green Belt Six sigma professional.