Data Analytics with Cloud Provider

(Concur)James Riley

VF Corp

Agenda• SAAS Master Data• SAAS Data Strategy• Concur Overview• Getting Started In Cognos• Mini Audit - Demo

SAAS Implementation Master Data Sync.

Minimize up front

More control

Administrator maintained Sync to Corp. Master Data

Manual Automated

Advantages Dis-Advantages Advantages Dis-Advantages

De-centralized controls

Integrity

Operating cost

Consistency

Minimize operating costs

Expansive dimensions

Loss of control

Up front

Data StrategyExtract as much data as possible Analyze on local resources

Extract as little data as possible Analyze on remote resources

ETL Investment Invest in learning GUI

Advantages Dis-Advantages Advantages Dis-Advantages

MashupsAdvanced functionalityLeverage subs and functionsPreserve evidence

Design and execute ETL Complicated by OLAP

No ETLEvaluating functionalityHand over (Aid packages)Talent development Not incurring holding liability

Learning curveAdvanced Functionality

Source Input Process Output Customer

HR

FinanceTravel AgencyTreasuryTravelersApprovers

ParticipantsApproversCost CenterItineraryChargesRational ReceiptApproval

Master Data

Operations

Oversight

PaymentExpense JournalReporting

TreasuryFinanceTravelersCost CentersProcurement

Credit Card Charges Upload

Random Audit

Manager Approval Payment

Traveler Completes

Claim

Exception Audit Reporting

4 5 1 2 3

Dashboard

• Is a Visualization• Of a Report• Based on a

Query

StandardReports

• Out of the Box• Visually pleasing• Results of a

Query

Custom Reports

• Consultant created

• Visually pleasing• Results of a

Query

Query Writer

• Based on OLAP Data Warehouse

WorksheetDataMenu Toolbar

DataMenu

Master Data

Operations

Reporting

• Consistent• Accurate

• Compliant• Audits are Efficient

and Effective

• Timely and Accurate

• Adequate

Assurance Objectives

Master Data

• Consistent• Accurate

Worksheet

Menu

Understand exceptions

1

Drill >division >cc > claim

Figure out what is being accomplished2

Understand what the auditteam is doing

3

Figure out what is being accomplished4

Customer

TreasuryFinanceTravelersCost CentersProcurement

audit

Cost center allocationExpense type hierarchy

%

1) Set up grid2) Filter for exp

types3) Cross tab

(pivot)

To Excel (config. issues)

1) Calc and apply with and without air or car

2) may factor number of nights3) may factor destination10% or more on food is high risk