Deep Dive Into Data Analytics - Part 2: Data Models | Seattle

About this workshop

This is PART TWO of a three-part Data Analytics workshop series. Part 1: Telling the Story With Data Part 2: Data Models Part 3: Tools and Techniques for Data Analysis

Build more powerful and more accurate forecasting models to better analyze financial data, predict revenue and costs, assess risk, and justify critical business decisions.

What we 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

• 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.)

Prereqs & Preparation

• A basic understanding of Excel’s capabilities and common Excel functions.
• Laptop with Excel (preferably 2013 or later), 10-key function if possible

Before Class:

• Have "Developer" Tab loaded onto Excel Ribbon (Instructions: http://www.techonthenet.com/excel/questions/developer_tab2013.php)
• Have "Solver" loaded in Excel; under Data Tab on Excel Ribbon (Instructions: https://support.office.com/en-us/article/Load-the-Solver-Add-in-ec994cd0-a396-4bf3-a5dd-feda369cef37)
• Have "Data Analysis" loaded in Excel; under Data Tab on Excel Ribbon (Instructions: https://support.office.com/en-us/article/Load-the-Analysis-ToolPak-305c260e-224f-4739-9777-2d86f1a5bd89)