Data Warehousing

A sneak peak​
Submitted by : Annie Bindhu Sajan
Student ID: 56299​
Submitted to: Dr Krzysztof Kandefer​
1
What is Data '50

Warehousing?
• A data warehouse is a centralized repository of integrated, organized, and

optimized data that is specifically designed to support business

intelligence (BI) and reporting activities.

• It is a large, subject-oriented, and time-variant database that provides a

platform for efficient querying, analysis, and reporting.

Data Warehouse Purpose
Identify problems in time to avoid them
•

Locate opportunities you might otherwise miss

•
Warehousing Problems
Business Issues
•

Data Quantity
•

Data Accuracy
•

Maintenance
•

Ownership
•

Cost
•
 '50

EUC Data Architecture

End-user computing (EUC) is a combination of technologies, policies, and processes that gives your workforce secure, remote access to
applications, desktops, and data they need to get their work done.

Modern enterprises use EUC so that their employees can work from wherever they are, across multiple devices, in a safe and scalable
way.

A well-designed EUC program gives users immediate access to the digital technologies they need for productivity, both on-premises and
remotely in the cloud.
Data Warehouse vs Operational Databases
'50

1.
Highly tuned 1. Flexible access
2.
Real time Data 2. Consistent timing
3.
Detailed records 3. Summarized as appropriate
4.
Current values 4. Historical
5.
Accesses small amounts of data 5. Access large amounts of data in
6.
in a predictable manner unexpected ways
Data Warehouse Architectures

•
Independent Data Mart
•
Dependent Data Mart and Operational Data Store
•
Logical Data Mart and Real-Time Data Warehouse
•
Three-Layer architecture

All involve some form of extract, transform and load (ETL)

Independent data mart data warehousing architecture

Data marts:
Mini-warehouses, l
imited in scope
Dependent data mart with
operational data store:
a three-level architecture
Process of knowledge from data
Organisational Impact in nutshell
 Empirical Example: Retail Data Warehouse
Business Context:
Imagine a large retail corporation with a presence in both physical stores and online platforms. The company deals with a vast amount of
data daily, including sales transactions, inventory levels, customer interactions, and marketing campaigns.
Business analysts,
ETL processes The data managers, and With the insights
warehouse is Historical

:egarotS ataD lacirotsiH

: s i sy l a n A d n a y r e u Q
are implemented executives can now gained from the data
The company designed using a sales data is
to Extract, use powerful warehouse, the
integrates data star schema, stored,
Transform, and reporting and company can make
allowing for
: s e s s e c or P L T E

:troppuS noisiceD
from various where the central

:gniledoM ataD
Load data into analytics tools to informed decisions.
sources, fact table contains trend
the data query the data For example, they
:noitatnemelpmI esuoheraW ataD

including point- sales analysis,

warehouse. This warehouse. They may optimize
of-sale systems transactions, and seasonality
involves cleaning can analyze sales inventory levels
in physical dimension tables understanding
and transforming performance by based on historical
stores, online include customer , and
raw data into a product category, sales patterns, tailor
sales platforms, details, product comparison
standardized track customer marketing strategies
customer information, time of sales
format suitable purchasing to specific customer
relationship dimensions, and performance
for analysis. behavior, and segments, and
management more. over time.
evaluate the identify
(CRM) systems, effectiveness of opportunities for
and marketing marketing revenue growth.
databases. campaigns.
Benefits:
• Improved Decision-Making: The company can make data-driven decisions, leading to more
effective strategies and operations.
• Enhanced Customer Experience: Understanding customer behavior allows for personalized
marketing and improved customer service.
• Optimized Inventory Management: Historical sales data helps in predicting demand and
optimizing inventory levels.
• Increased Operational Efficiency: Streamlined reporting and analytics processes save time and
resources.

Challenges Addressed:
• Data Silos: Integration of data from various sources reduces data silos and ensures a
comprehensive view.
• Historical Analysis: The data warehouse facilitates historical analysis, providing a better
understanding of long-term trends.

This example illustrates how a retail company can leverage a data warehouse to gain valuable
insights, enhance decision-making processes, and optimize various aspects of its business
operations.
 References/Bibliography

V. Poe, Data Warehouse: Architecture is not Infrastructure, Database Programming and Design, July 1995

J. Bischoff, Achieving Warehouse Success, Database Programming and Design, July, 1994.

W. Inmon, For Managers Only - A Tale of Two Cycles: Iterative development in the information warehouse environment, Database
Programming and Design, Dec 1991.

Summary
 '50

QA
&