About TechLabs'

CIDDS

Corporate Integrated and Distributed

Data Warehouse System

 
 
Carpe diem (Seize the Day). - Horace, c. 29 BC

TechLabs plans, designs, builds and implements Corporate Integrated and Distributed Data Warehouses, world-wide, acting as Consultants, Managers or Prime Contractor. ...Tightly integrated with the business strategy, goals, metrics, critical success factors and business model. ...Providing integrated strategic and tactical decision support, not just data, to those that need it: integrated world-wide from among those sites that generate the data. Data warehousing is a process. The data warehouse is the box in which the process takes place. The process consists of collecting, cleansing, normalizing, relating and making available, in usable form, data integrated from all parts of the enterprise to form information useful for mathematical modeling--making strategic and tactical management decisions that have a measurable beneficial effect upon the goals of the enterprise and its components. Data Warehousing often has a secondary operational role of serving as a common interface among disparate operational software systems, to allow them to exchange data of known quality and consistency--even when that data may have arrived from multiple sources themselves.

---

Why CIDDS?

Answer: To earn money,

CIDDS Is the Best Practice for a Global Manufacturer. It is common for a Data Warehouse to repay its costs in 1.5 Years.A Conservative Example (From a TechLabs Client):

Average Gross Margin = 28.8% on Sales
Average EBIT = 9% on Sales
If the Data Warehouse can help increase sales 10% annually, adjusting for cost of sales...
Then EBIT Increases from 9% to 10.5%, for an increase of 16% in EBIT.
--Basis: TechLabs Microeconomic Model on Corporate 10Ks.
 
 

Popular belief to the Contrary Notwithstanding.... 
 
A Data Warehouse is a Decision Support System.
 
A Data Warehouse is primarily NOT an operational support system.

Operational Systems are Designed to Run the Business day to day: 
e.g. SAP, Edwards, Maximo, BPCS, LIMS, PIMS, Sales, Inventory, MRP, 
Cost Accounting, General Accounting.
 
...Nor can an operational system serve as a Data Warehouse.

A Data Warehouse uses data from operational systems to generate information that supports management decisions--both strategic and tactical.

Some Examples

 Walmart Corporation
100,000 Items in Inventory
Hundreds of Stores
Data Warehouse of 15 Terabytes (15,000 Gigabytes)
Every Night, Walmart Looks at Patterns, Inventory, Sales
Weather, Special Events, and...
Decides:

What to buy, and when, and
What to load on every truck for every store, every morning.

 Coca-Cola UK distributing with Schweppes 
Decides Every night what to ship to every pub each morning.

 Federal Express
Tactically: Track every package for on-line customer query
Strategically: Optimize Air Operations --Most Expensive Cost
Routes, Schedules, Airplane Sizes, Crews, Maintenance
Goal: Wheels-Up 75% of every 24 Hours!

Goals of a CIDDS

 No more Data Outhouses
 Right People, Information, Format and Time
 Data clearly defined to Corporate Enforced Standards
 Leverage Strategic Use of Data
New Strategic Analysis Requirements Can Use Data Previously Captured
 Get and Keep Business Users Involved
 Deal Effectively with Matrix of Business Units vs. Sites vs.
Points of Sale.

Empowering Management

Competitive Advantage no longer comes from fine-tuning manufacturing processes.
It Comes from Skillful, Rapid Management Decisions Implementation, Fast Feedback.
 

Leverage: Strategic Process Re-engineering based on Facts.

Management needs information, not data, Now... 
in Consistent, Integrated form, from Disparate Sources.
Now, not whenever.
 
Concept of the Information-Agile Enterprise. The Frontier: 
How quickly can we to acquire, analyze,act on info? 
 
 

Why an Enterprise-Wide Distributed Data Warehouse?

1. Answering complex management questions without the day-to-day involvement of IT specialists
2. Bringing the Data from the Owner to the User, integrated and in useful form
3. Reliability and Disaster-Proofing

Every Business Area Manager and Every Salesperson Needs Integrated and Detailed Data from Every Source.
 
 

Benefits of CIDDS

* One Consistent Source, World-Wide, for Data on All Aspects of Company Operations

* One Consistent Data Translation For Data from Many Apps and Platforms.

* (N) Instead of N(N-1) Interfaces.

* Integration of Data from Sites Matrixed to Business Unit Managers, Corporate People

* Integrated Data and Summaries for Controllers, Procurement, Manufacturing, Logistics, Marketing, wherever located

* Data capture, standardization, access for future requirements and analyses, including retrospective analyses

* Provision for Secure EDI

* Archival Data

* Transactional Data

* Data Interfaces, Cross-Platform (Hardware, Software)

* Integrated Reporting: Icon-Triggered, Active

Executives get the Information, not the Data:

*When they want it

* At their desired levels of detail

* Integrated Across Sites, Business Units, and/or Operational Systems.

The Data Warehouse is the Best Practice for Integrating and Exchanging Data among Operational Systems: BPCS, SAP, Purchasing, Inventory, PIMS, S2K, Others

Business and Technical Processes

Strategic Analysis and Planning

Enterprise Planning

Financial Planning

M&A and Corp. Re-engineering Analysis

Financial Operations

Corp Financial Strategy

Budgets and Fulfillment

Data for Accounting

Forecasting

Data for Cash Flows

Accurate Procurement and Sales Data

Human Resources

Forms Management, Distribution, Automated Input

Safety and Health: MSDS

MRP-II Data Integration

Process Planning and Optimization

CIDDS Architecture

---

Click here for a White Paper on Data Mining