Using Data Analytics to tell ‘THE STORY’ | Online

About this workshop

Regardless of your job function and industry everyone is being exposed to more and more data. If you are not able to summarize and explain the data in a clear and meaningful way, it provides little value to you or your organization. This course will teach you how to effectively summarize and communicate the results your data to team members and senior management. Use Key Performance Indicators (KPI) drivers to show others the results under various ‘What-if’ scenarios. The term ‘Model’ will show up far and wide as you dive into Data Analytics. It is important to remember a ‘Model’ is simply using a tool to build a representation of a real world situation

How you will benefit: - Effectively communicate the results of models to team members and senior management - Evaluate patterns in your historical data - Identify and utilize key business drivers and integrate them into your forecast - Make business decisions based on your analysis

What You Will Cover: - Working with advanced Excel modeling techniques such as ‘Goal Seek’ Optimization - Analyzing and applying diagnostics to validate your forecast - The Art of Telling the story

Takeaways

• Identify the Key Points Necessary to Build a Model
• Describe the Art in Creating an Effective Model
• Use KPI Drivers to create ‘What-if’ Scenarios

Prereqs & Preparation

Basic understanding of Excel and charting functions Laptop with Excel (preferably 2013 or later), 10-key function if possible