Dynamics of Data Science

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

The participants of this workshop will learn about working on large data sets and complex calculation 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 approach to its solutions. Hands on exercises will be given helping all the participants to master these functionalities and apply them in a meaningful way

Course 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
Dashboard designing
1. What is Management Dashboard
2. Principles of dashboard design
3. Using Advanced formulas to create dynamic data
4. Linking humungous data with customized view and selections
5. Mastering Developer Tab
6. Learning Advanced Pivot table techniques
7. Using Power Pivots
8. Using charts and visual data techniques
9. Hands on exercises
Using Excel for Advanced Data Analysis
1. Managing large Data sets
2. What if Analysis
3. Goal Seek
4. Scenario manager
5. Learning advanced Financial functions to draw Analysis on given data sets
6. Learning advanced Nested functions
7. Application of forecasting techniques
8. Forecasting using Historical data
9. Hands on exercises

Learning Outcomes

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 on 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 dynamic way that helps them to represents complex data sets through best visual representations for senior management and steer committees

Pre-Requisites

All participants should have their laptop with preinstalled MS office.

Who Should Attend

The training is ideal for those (such as Accountants, Controllers, Finance managers, Auditors and all accounting professionals) who deal with 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 to data and draw further insights

Contact Us

Name *

Phone Number

Email *

Company Name

Message *