overview of the corporate information factory and...
TRANSCRIPT
Overview of the Corporate Information Factory and Dimensional Modeling
Copyright (c) 2010 BIS3 LLC. All rights reserved.
Rosendo AbelleraPresident, BIS3o Nearly 2 decades software
and system developmento 12 years in DW and BI spaceo 25+ years of data and
intelligence/analytics
AccentureToshibaNational Security Agency (NSA)US Air Force
Copyright (c) 2010 BIS3 LLC. All rights reserved. 2
Data Warehouse Architect:
Other Notable Data Projects:
A data warehouse is a repository of an organization's electronically stored data designed to facilitate reporting and analysis.
Subject-orientedNon-volatileIntegrated
Time-variant
Reference: Wikipedia
Copyright (c) 2010 BIS3 LLC. All rights reserved. 3
CorporateInformation Factory
Copyright (c) 2010 BIS3 LLC. All rights reserved. 5
Dimensional Modeling
3rd Normal FormBill InmonData MartEnterprise Data WarehouseHub and SpokeOperational Data StoreRalph KimballSlowly Changing DimensionsSnowflakeStar Schema
??
Corporate Information Factory
1.Top down2.Data normalized to
3rd Normal Form3.Enterprise data
warehouse spawns data marts
Copyright (c) 2010 BIS3 LLC. All rights reserved. 6
Dimensional Modeling
1.Bottom up2.Data denormalized to
form star schema3.Data marts conform to
develop the enterprise data warehouse
Focus◦ Single repository of enterprise data◦ Framework for Decision Support Systems (DSS)
Specifics◦ Create specific structures for distinct purpose◦ Model data in 3rd Normal Form◦ As a Hub and Spoke Approach, create data marts as
subsets of data warehouse as needed
Copyright (c) 2010 BIS3 LLC. All rights reserved. 7
Focus◦ Business Process Oriented◦ User Understandability◦ Performance
Specifics◦ Declare the level of granularity◦ Develop conformed dimensions◦ Identify metrics and measurements◦ Data Bus Matrix
Copyright (c) 2010 BIS3 LLC. All rights reserved. 9
Popularity of Dimensional Modeling ◦ Adopted by ETL companies (e.g., Informatica)◦ Evident in the strategies of mainstream BI tools
such as Cognos, Microsoft’s Analysis Services, OBIEE, etc.
Shift in focus to Enterprise Architecture◦ SOA and Master Data Management rethinking◦ Consideration for Other Structures◦ Combination of Inmon and Kimball Approaches
Copyright (c) 2010 BIS3 LLC. All rights reserved. 11
Holistic Approach to Enterprise DataData Integrity and CleansingDM in Semantic Layer of BI ToolsODS can be used as a great data source for the Data Warehouse
Copyright (c) 2010 BIS3 LLC. All rights reserved. 12
CorporateInformation Factory
Copyright (c) 2010 BIS3 LLC. All rights reserved. 14
Dimensional Modeling
3rd Normal FormBill InmonData MartEnterprise Data WarehouseHub and SpokeOperational Data StoreRalph KimballSlowly Changing DimensionsSnowflakeStar Schema
??
Corporate Info Factory
Copyright (c) 2010 BIS3 LLC. All rights reserved. 15
3rd Normal FormBill InmonHub and SpokeOperational Data StoreEnterprise Data Warehouse
Data MartRalph KimballSlowly Changing DimensionsSnowflakeStar SchemaEnterprise Data Warehouse
Dimensional Modeling