automation to reduce operating costs

1 April 8, 2023© Kalido I Kalido Confidential I April 8, 2023

Automation to Reduce Operating CostsDiana Collins


Agenda

True Cost of Ownership

Initial build versus maintenance

Architectural rigidity

How to build for change

Incremental Methodology

The Bottom Line


True Cost of Ownership

Decision support draws from many disciplines– Business Analysts– System Architecture– Data Modeling– ETL– Database design and

administration– Business Intelligence

Multiple interaction points– Errors– Delays


Build Cost and Maintenance Cost

Complexity and expertise requirements add up

A typical warehouse project will cost ~ $2 million

TDWI survey – Take 2 years to complete– Annual maintenance cost is 50% to 75% of build cost

5 year TCO = $6 million– Not including extension or expansion


Why is it so expensive?

Architectural Rigidity– Each layer is built upon the last– No dynamic interaction

Difficulty of revision leads to:– Long requirements gathering– Long design phase– “Answer everything”

Requirements gap– By the answer is available the question has changed


Imagine building an office building…

You lay the foundation…

Erect the framework…

Install the plumbing…

The wiring and elevators…

Lay out all the office space…

And then decide you need a hotel instead!


A better way

The “Lego Approach”

What makes them work?– A single consistent format– Many different shapes and

sizes– All able to connect to each

other

Kalido is like that


Kalido Business Information Model - Example


Kalido supports an incremental approach

Don’t “answer every question” – Just the most important ones– Iterate your way to a first release

Then incrementally expand

Never rebuild…just reconfigure

Automation is the key

FinanceSales

Marketing

Distribution

Supply Chain

eCommerce

PartnersHR

ManufacturingIncreasing Value

Value

Time


Automation Using Best Practices

Master Data Governance and Stewardship

Schema Management

Model and Metadata Management

Hierarchy Management Workflow and SecurityData Profiling and Validation Data Authoring

Controlled PublicationIdentity Management

Auto-generated Application

Browse and Search Full History and Audit TrailsAuto Match and Merge

OperationsData Integration

Data Validation

Suspense and Exception Handling

Data Sourcing and Field Mapping

Delta Detection

Surrogate Key Management

Code Management and Lookup

Currency and UoM

Graphical Modeling

Model FederationMulti-GranularitySub-typing and Inheritance

Composite EntitiesRagged Hierarchies Change ManagementKPI Management

Business Metadata Classification Hierarchies

Star and Snowflake Schema

Physical Schema Management

Slowly Changing Dimensions

Data Mart and Aggregates

Data Load and Index Management

Rollup Path Awareness

Incremental Summary Generation

Process Automation

Task Execution and Monitoring

Deployment and Migration

Archiving

Restore for Model and Data

Undo Loads

Audit and Logging

Presentation

Metadata Management for BOBJ

Native XLS Pivot Table Generation

Native QlikView Generation

Metadata Management for MSAS

Metadata Management for COGN

MDM Consumer Interface

Report-Time Formula Management

Automated


The bottom line

Kalido customers build their Data Warehouse for less– 50% less cost, and 75% less time– Smaller teams– Fewer tasks– No handoffs

Kalido Customers maintain their warehouses for less– Only 15% to 20% of the initial build cost– No rebuilding– Less testing– Faster turnaround


The payoff

The “average” data warehouse project…– Instead of 2 years, takes about 9 months (with interim results)– Instead of $2 million, costs $1million– Instead of a $6 million 5 year TCO, less than $2 million

Better aligned with business needs– Over a year sooner– Over $4,000,000 savings


Want To Learn More?

Continue the Summer Series of webinars at kalido.com/webinars

Request a demo at kalido.com/demo

Watch the replay, get the slides and more at get.kalido.com/automation-replay


Thank you

automation to reduce operating costs

Technology

kalido confidential

2013 automation

kalido

2013 kalido

july 23

question

2 million

2 years