Advanced Analytics“Knowledge is Power” – Francis Bacon

Presented by:JAMES KOENIGAnalytics Developer

November 9, 2015

Summary:Advanced Analytics modules leverage the power of your data in an easy to use Excel interface so you can make better business decisions and improve profitability

Who Should Attend:

Decision makers and improvement drivers in Finance, Production, Purchasing and Sales

SUMMARY

#Orchestrate2015

My Background

• 25 years in Operations Management

• Last 9 years in Process Production (like beer)

• Key expertise: Inventory management and

process improvement

Presenter

#Orchestrate2015

NEW Advanced Analytics Modules

• All NEW for 2015

• What are they?

• How do they work?

• What information will I see?

• How can I modify or customize them?

AGENDA

#Orchestrate2015

Advanced Analytics

What are the Advanced Analytics Modules?• Excel workbooks

• Linked to your LIVE data

• Common data analysis is already built

• 4 modules included

#Orchestrate2015

SALES PRODUCTION PURCHASING FINANCE

Advanced Analytics

How do they work?

• Key data is read from the db and stored in an Excel data model where it can be used in a workbook

#Orchestrate2015

Data Model(selected data)

Workbook(display data)

All Data

Advanced Analytics

Fun Facts about Excel Data Models

• They efficiently hold 2 billion records

• Compare to 1 million rows in an Excel worksheet

• Load / refresh direct from your LIVE data

• All the data YOU NEED is in the data model

• Only the data YOU WANT TO SEE is in the workbook

• Aka “POWERPIVOT” or “Data Cube”

#Orchestrate2015

Advanced Analytics

Explore the Advanced Analytics “Cubes”

#Orchestrate2015

Advanced Analytics

In a Nutshell…

#Orchestrate2015

SALES PRODUCTION PURCHASING FINANCE

http://

forums.orchestratedbeer.com

Thank You!

Excel Data Model Formulas

• Formula syntax is unique

– (DAX) Data Analysis eXpressions

• You must use DAX to make your own

calculated fields

• Best reference: www.Powerpivotpro.com

AGENDA

#Orchestrate2015