Course Description
This program is designed to help participants understand the key principles and concepts of Data Analytics and Visualization. The detailed content covering analytical and visualization tools and techniques to interpret data is designed based on industry related data they would analyze and interpret on MS Excel.
Applying these principles on a case study with the guidance of an experienced facilitator will help ensure the best possible outcome for participants.
Learning Outcome
- Acquire an understanding of Data Analytics and its importance in the context of the organization’s industry.
- Understand the application of Excel in Data Analytics and Visualization.
- Acquire proficiency in crafting impactful dashboards for effective data representation.
- Explore and grasp the array of Data Analysis tools within the Excel platform.
- Develop the skills to navigate common pitfalls encountered in the process of conducting Data Analysis.
- Investigate how various banks leverage Data Analysis through the analysis of real-world use case.
01. Overview of Data Analytics
- Why are we talking about data now? Industry 4.0
- Value of data analytics to a business
- The role of data in decision making – what can and can’t we do with data?
- The Five Data Types
- The case we are going to tackle during the course
02. Principles of Data Analysis on Excel
- How does Excel see the world?
- Navigating Excel’s tools
- How to clean data so you and Excel can both understand it
- Mastering Excel formulae
03. Principles of Data Visualization and Dashboard Strategy
- Why we create dashboards
- Storytelling in data
- Major steps in formulating a dashboard strategy
- The major types of visuals and the number of parameters they require
- How to design a dashboard so it is understandable
04. Review of the Case Study
- What is the business problem?
- What are the questions we want to answer?
- What sort of dashboard can answer these questions?
- What data do we need to create these visuals?
- What challenges do we face on the data?
05. Analyzing the Data
- Data preparation
- Data analysis using the various tools in Excel:
- Toolpak
- Sort
- Filter
- Lookup
- Conditional formatting
06. Avoiding Pitfalls and Mitigating Unforced Errors
- Data validation
- Theory overload
- Common pitfalls in Data Analytics
- Understanding your data
- Looking beyond the data
07. Graphs, Visualization and Assembling the Dashboard
08. Final Takeaways
- What further business areas can we use these principles on?
- Formulate an action plan on 3 areas where the data analytics can help your role
- Overview
-
Course Description
This program is designed to help participants understand the key principles and concepts of Data Analytics and Visualization. The detailed content covering analytical and visualization tools and techniques to interpret data is designed based on industry related data they would analyze and interpret on MS Excel.
Applying these principles on a case study with the guidance of an experienced facilitator will help ensure the best possible outcome for participants.
Learning Outcome
- Acquire an understanding of Data Analytics and its importance in the context of the organization’s industry.
- Understand the application of Excel in Data Analytics and Visualization.
- Acquire proficiency in crafting impactful dashboards for effective data representation.
- Explore and grasp the array of Data Analysis tools within the Excel platform.
- Develop the skills to navigate common pitfalls encountered in the process of conducting Data Analysis.
- Investigate how various banks leverage Data Analysis through the analysis of real-world use case.
- Course Outline
-
01. Overview of Data Analytics
- Why are we talking about data now? Industry 4.0
- Value of data analytics to a business
- The role of data in decision making – what can and can’t we do with data?
- The Five Data Types
- The case we are going to tackle during the course
02. Principles of Data Analysis on Excel
- How does Excel see the world?
- Navigating Excel’s tools
- How to clean data so you and Excel can both understand it
- Mastering Excel formulae
03. Principles of Data Visualization and Dashboard Strategy
- Why we create dashboards
- Storytelling in data
- Major steps in formulating a dashboard strategy
- The major types of visuals and the number of parameters they require
- How to design a dashboard so it is understandable
04. Review of the Case Study
- What is the business problem?
- What are the questions we want to answer?
- What sort of dashboard can answer these questions?
- What data do we need to create these visuals?
- What challenges do we face on the data?
05. Analyzing the Data
- Data preparation
- Data analysis using the various tools in Excel:
- Toolpak
- Sort
- Filter
- Lookup
- Conditional formatting
06. Avoiding Pitfalls and Mitigating Unforced Errors
- Data validation
- Theory overload
- Common pitfalls in Data Analytics
- Understanding your data
- Looking beyond the data
07. Graphs, Visualization and Assembling the Dashboard
08. Final Takeaways
- What further business areas can we use these principles on?
- Formulate an action plan on 3 areas where the data analytics can help your role