deltek insight 2012: embrace the cube!

Embrace the Cube!

Nick Vlattas AIA, Chief Operations OfficerHanbury Evans Wright Vlattas + CompanyPS-153

©2012 Deltek, Inc. All Rights Reserved2

creating, preserving and transforming enduring spaces

global resource for higher education

3 ©2012 Deltek, Inc. All Rights Reserved

EMBRACE THE CUBE!

In the recent economic downturn, design professionals faced the challenge of tightening all aspects of our business lines. From an operations perspective, we found that contract negotiation, project accounting and firm forecasting all need to be retooled in order to find success in the “new normal.” The use of data cubes, which does not require Vision Performance Management, has significantly reduced the amount of time preparing data for analysis and has allowed for a much deeper dive into what exactly our Vision data can tell us. New levels of truth about our firm’s performance are now available in a fraction of the time we used to spend on firm forecasting. Learn how capture deep value from your Deltek databases to position your firm on it’s path to success through the economic recovery and beyond. (Intermediate Level)

Session Description


Introduction

Discovering the cube

Connecting the cube

Building the cube• Firm performance• Project earnings• Employee time• Budgeting and forecasting

Questions and answers

Agenda


Discovering the Cube

Harper & Shuman CFMS - 1983

Deltek Advantage – 1996

Deltek Vision - 2006

Deltek Insight - 2010

• Cube

• CRM

• Open Asset

• Knowledge Architecture


Connecting the Cube

Connect to the General Ledger and Project OLAP Cubes in the Vision database using the Excel Connections command on the Data tab


Building the Cube

Balance Sheet

Income Statement

Key Performance Indicators

General Ledger OLAP Cube Project OLAP Cube

Revenue and expense trending

and forecasting

Annual budgeting

Project hours revenue, expense and profit

Project manager performance

Employee utilization

Employee labor detail


Firm Performance – Balance Sheet

Summary data mined from pivot table using Excel formulas

Update periods in pivot table monthly

=SUMIFS(C$43:C$207,$A$43:$A$207,">100",$A$43:$A$207,"<110")

=VALUE(LEFT(B47,6))

Summary data

Pivot Table and Field List


Firm Performance – Income Statement

Select data from pivot table

Create comparative reporting and monitoring for YTD and previous years or quarters

Snapshot report


Firm Performance – Key Metrics

Create formulas and graphs for monitoring key performance indicators


Project Earnings - Summary Reports

Select pivot table data to display

Create summary report

Update monthly by changing period


Project Earnings - Summary Reports

Select pivot data to analyze such as phase, project type or PM performance and save reports on different tabs in MS Excel file


Project Earnings – Detailed Reports

Drill down for more detail on projects to include hours, revenue, expenses, overhead, multipliers and profit per phase


Employee Time – Utilization

1. Create summary report on total firm hours and labor costs for input into KPI calculations

2. Utilization reports for employees comparing direct and indirect time 2

1


Employee Time – Labor Detail

Analyze time spent by employees by period on overhead, promotional and regular projects


Employee Time – Project Detail

Review time spent by employees for each period on projects and phases


Budgeting & Forecasting – Revenue Forecast

1. Net revenue forecast for next 12 months in phases compared to target

2. YTD Revenue + Forecast revenue compared to budget

3. Tracking and trending of forecast data

1

2

3


Budgeting & Forecasting – Marketing Outlook

CRM data not available to the Cube, but Cube did inspire better methods for tracking marketing data


Budgeting & Forecasting – Budget Development

1. Based on prior performance and target objectives, develop detail for budget

2. Plan utilization rates for employees to create direct and indirect labor budget

3. Summarize budget detail and reference to Cube reports for analysis of YTD performance


Questions and Answers


Call to Action

Collaborate on Linkedin, share Cube discoveries:

NickVlattas or [email protected]

See related presentations at

Insight 2012:

PS-149: Build a Campfire Around Your Vision Data presented by Amy Aponte

Wednesday, 11 AM – 12 PM

PS-111: How do We get People to Share? Presented by Christopher Parsons

Wednesday, 3:15 PM – 4:15 PM

mailto:[email protected]

Thank You!

deltek insight 2012: embrace the cube!

Technology

deltek vision

deltek insight

answers42012 deltek

data tab62012 deltek

vision data

spendon firm

timepreparing data

use of data cubes