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

Expert Speaker, Business Consultant with almost 20yrs experience in field of Artificial Intelligence, Data Science, Gen AI, Machine Learning, Digitalization, Data & Predictive Analytics, Creating Interactive Dashboards, Data Storytelling, Data Visualizations, Creating automated reports for real time reporting, Data & Visual Analytics using Excel and business intelligence tools like Power BI and Tableau.

In addition Divya also specializes in Academic and Corporate and Government Trainings and consulting engagements, Insights generation, decision making, driving efficiency in processes, Process Automations and creating roadmap for use of Artificial Intelligence and automation for organizations to enhance data driven decision making.

She has excellence in her oration and has been responsible for conducting CEO round tables and training Faculty members, Students and staff of prestigious Academic institutions and Leadership teams across public sector , corporates,
Government and SME’s both in Singapore and Globally

Key Experience
• National University of Singapore (NUS)
• Nanyang Technological University (NTU) – Training Adult Learners
• Singapore Management University (SMU)
• Singapore University of Social Sciences (SUSS)
• Ministry of Foreign Affairs Singapore– Trained across 25 countries
• Ministry of Defence (MINDEF)
• Institute of Singapore Charted Accountants (ISCA)
• 1FSS
• Agency for Integrated Care- Ministry of Health
• UWCSEA – United world college South east Asia
• Murdoch University – Australian university
• Association of Chartered Certified Accountants (ACCA)

Sector Experience
• Academia
• Universities
• Education Sector
• Finance and Accounting
• Government Sector – Multiple Ministries across Singapore
• Public sector
• FMCG
• Healthcare

Key Trainings conducted across above sectors
• Artificial Intelligence & Generative AI
• Data Visuaization
• Power BI and Tableau Trainings
• Data Analytics & Machine Learning
• Data Visualization and Big Data
• Creating Data Dashboards & Excel Expertise

Professional and Technical qualifications
• Masters in Business Economics
• Masters in Business Administration
• a certified Green Belt Six sigma professional.
• Economics (Hons)