Building Data Models & Data Analytics

Online Campus

Online
Anywhere
Online

Past Locations for this Workshop

Building Data Models & Data Analytics | Online

Online Campus

Online
Anywhere
Online

Past Locations for this Workshop

About this workshop

Build more powerful and more accurate forecasting models to better analyze financial data, predict revenues and costs, assess risks—and justify critical business decisions. In this course, you will build robust financial forecasts and models, learn tips and tools, analyze the results, and learn how to communicate key data to decision makers in your organization. Build the model. . .generate the forecast. . .drive the business. Create more powerful and accurate forecasting models that steer you to fast-track, business-improving decision making.

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:

  • Create effective custom models that meet your specific business needs
  • Make better, more profitable business decision using advanced financial modeling methods
  • Apply external data to your forecast (GDP, Industry indices, etc.)

What You Will Cover:

  • The Process of Model Creation
  • Creating your own model from real-world examples
  • Working with advanced Excel modeling techniques such as ‘Goal Seek’ Optimization
  • Creating ‘slick’ interactive tools to add to your model(s)
  • Regression analysis using internal & external data

Takeaways

Takeaways:

  • Identify the Key Points Necessary to Build a Model
  • Customized model you can start using the very next day!
  • Other Model Templates

Prereqs & Preparation

Laptop with Excel (preferably 2013 or later), 10-key function if possible

Coming up near you

Let’s Keep You Updated

Enter your email to start following

I have read and acknowledge General Assembly's Privacy Policy and Terms of Service. SMS message and data rates may apply.