11. data warehousing
TRANSCRIPT
-
8/11/2019 11. Data Warehousing
1/25
Data Warehouse &
Business Intelligence
-
8/11/2019 11. Data Warehousing
2/25
Data Warehouse & BI 2
What Does A Company Want?
As a companyWe want to reactto changes
Economic and market conditions
Competitors pricing / features / products
We also want to causechangeChange customer uy haits /eha!iorDisrupt market with new pricing" features etc
#/$2/$%
-
8/11/2019 11. Data Warehousing
3/25
Data Warehouse & BI
What Does A Company Want?
'etting the right information into the rightpeople(s hands in a format that allows them tounderstand data )uickly
Its aout helping management understandwhereto make the right changes
Its aout helping management understandwhichchanges are ha!ing the est / most /least impact
#/$2/$%
-
8/11/2019 11. Data Warehousing
4/25
Data Warehouse & BI %
Data Warehouse
A data warehousestores central" current andhistorical data ofpotential interest that haseen e*tracted from the !arious operational"e*ternal" and other dataases of an
organi+ation,It is data that is cleaned" transformed and
catalogued
Consolidates and standardi+es information
Can e used for data mining" -.A and decisionsupport purposes
#/$2/$%
-
8/11/2019 11. Data Warehousing
5/25
Data Warehouse & BI 0
Data Marts
Data Mart is Decentrali+ed" smaller"summari+ed" highly focused data put in aseparate dataase" susets of data warehouse
1ypically focuses on single suect or line ofusinessConstructed rapidly
.ower cost
#/$2/$%
-
8/11/2019 11. Data Warehousing
6/25
DW & BI
#/$2/$% Data Warehouse & BI 3
-
8/11/2019 11. Data Warehousing
7/25
Characteristics Of A DataWarehouse
#/$2/$% Data Warehouse & BI 4
Data Warehouse
c
OrganizationalConsistent
Time Variant
Non volatile
RelationalClient/server
Web-based
Integration
-
8/11/2019 11. Data Warehousing
8/25
Trouble With TheTerrorist Watch ist
Database
-
8/11/2019 11. Data Warehousing
9/25
Terrorist Watch ist
#/$2/$% Data Warehouse & BI 5
16C(s1error Watch
.ist
NationalCounterterrorismCenter(NCTC)
FBI
FBI CI
National !e"urit#gen"#(N!)
Trans$ortation !e"urit#
dmin(T!)
%! &e$tt o' omeland
!e"urit#
!tate &e$tt
%! Customs Border *rote"tion
%! +ars,alls !ervi"eW,ite ouse
!e"ret !ervi"e
irlines
-
8/11/2019 11. Data Warehousing
10/25
Wea!nesses With Terrorist Watchist
Data integration not complete
Data 7uality
olicy adherence
E8cacy of policies for nomination andremo!al
ri!acy concerns
9acial pro:ling
#/$2/$% Data Warehouse & BI $;
-
8/11/2019 11. Data Warehousing
11/25
Business Intelligence
Business Intelligence < enales dataconsolidation" and analysis to identify newpatterns" relationships" insights
BI 1ools include
Data mining< Disco!ery dri!en
1e*t mining and we mining
Dataase )uery and reporting tools
#/$2/$% Data Warehouse & BI $$
-
8/11/2019 11. Data Warehousing
12/25
Business Intelligence
BI 1ools