Dimension Overall - onenote lbm

---Date Modeling Techniques

https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/

---Datawarehouse Lifecycle Planning toolkit

https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/books/data-warehouse-dw-lifecycle-toolkit/

---- Naming Convention - list of abbreviations(From Kimball reference)

http://www.indiana.edu/~edss/Services/Naming/nameDisplay.pl?table=ab

---- Kimball Reference for documents related to building a Datawarehouse

https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/books/microsoft-data-warehouse-dw-toolkit/

Data Warehouse3 toolkit by Ralph Kimball

https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/books/data-warehouse-dw-toolkit/

Data warehousing Methodologies

https://blog.westmonroepartners.com/data-warehouse-architecture-inmon-cif-kimball-dimensional-or-linstedt-data-vault/

https://www.researchgate.net/publication/317229839_Herding_the_elephants_Workload-level_optimization_strategies_for_Hadoop

Types of Dimensions

https://www.vertabelo.com/blog/technical-articles/dimensions-of-dimensions-a-look-at-data-warehousings-most-common-dimensional-table-types

Rapidly Changing Dimensions

https://www.itprotoday.com/sql-server/data-warehousing-rapidly-changing-monster-dimensions

https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.whse.doc/ids_ddi_360.htm

https://www.ibmbigdatahub.com/blog/building-fast-data-warehouse-schemas-part-2

Datawarehouse 2.0 by Bill Inmon

https://gerardnico.com/data/warehouse/start

Various Data models CSU

http://www.databaseanswers.org/data_models/index.htm

https://www.semanticscholar.org/paper/Evolution-of-a-Dynamic-Multidimensional-Meta-Model-Hansen-Cruz/dd8935733b7fb57f6de643308a769c07ac77963c

https://www.semanticscholar.org/topic/Star-schema/417461

DW fundamentals with good examples of ODS

http://lia.univ-avignon.fr/fileadmin/documents/Users/Intranet/chercheurs/torres/cours/ed/Architecture02.pdf

https://docs.oracle.com/cd/B19306_01/bi.102/e10084/logical.htm#BABBHEEA

---HR Model Very good example

http://www.databaseanswers.org/data_models/hr_platform/index.htm

https://www.databasejournal.com/features/oracle/article.php/3529531/Database-Modeling-Using-Visio.htm

https://www.opm.gov/services-for-agencies/hr-line-of-business/enterprise-architecture/hrlob_dm.pdf  ** Very good example of Project Planning

https://subscription.packtpub.com/book/big_data_and_business_intelligence/9781782173250/7/ch07lvl1sec37/human-resources-data-model

http://tdan.com/a-universal-person-and-organization-data-model/5014

https://www.oracle.com/technetwork/developer-tools/datamodeler/sample-models-scripts-224531.html

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/bp-modeling-nosql-B.html

http://web.mit.edu/warehouse/metadata/stars/business_area/human_resources.html

Financial DataModels / Universal Datamodels

http://www.univdata.com/Portals/9/Publication_Articles_7_02_Financial_Serv.pdf

https://www.dwhpro.com/teradata-fsldm/

https://www.dwhpro.com/teradata-denormalization-quick-guide/

Product Hierarchy

https://www.enterworks.com/product/product-information-management-software/

https://www2.microstrategy.com/producthelp/10.4/ProjectDesignGuide/WebHelp/Lang_1033/Content/ProjectDesign/Sample_data_model.htm

Geogrpahy Hierarchy

https://stackoverflow.com/questions/4262520/data-modeling-hierarchy-of-geographic-locations

http://www.softwaregems.com.au/Documents/Student%20Resolutions/SONewbie%20DM.pdf

---- Invoice Header

https://www.kimballgroup.com/2007/10/design-tip-95-patterns-to-avoid-when-modeling-headerline-item-transactions/

https://www.slideshare.net/nongoffna/data-warehouse-order-management?from_action=save

http://www.b-eye-network.com/view/9910

https://www.nuwavesolutions.com/degenerate-junk-dimensions/

https://www.kimballgroup.com/2007/12/design-tip-97-modeling-data-as-both-a-fact-and-dimension-attribute/

https://www.researchgate.net/publication/237622501_Chapter_I_Conceptual_Modeling_Solutions_for_the_Data_Warehouse

http://info.kickfurther.com/7-major-things-you-need-to-know-about-an-invoice

Address in Datawarehouse

http://kimballgroup.forumotion.net/t1918-customer-with-multiple-address-types

https://www.tek-tips.com/viewthread.cfm?qid=732020

https://www2.microstrategy.com/producthelp/10.4/ProjectDesignGuide/WebHelp/Lang_1033/Content/ProjectDesign/Geography_hierarchy.htm

https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.whse.doc/ids_ddi_355.htm

https://www.rittmanmead.com/blog/2011/05/geography-hierarchies/

http://kimballgroup.forumotion.net/t1183-how-to-model-customer-in-data-warehouse

Many to Many Facts examples

https://hub.packtpub.com/solving-many-many-relationship-dimensional-modeling/

https://www.codemag.com/article/1304071/The-Baker%E2%80%99s-Dozen-13-Tips-for-Basics-of-Data-Warehousing-and-Dimensional-Modeling

https://www.nuwavesolutions.com/bridge-tables/

https://www.vertabelo.com/blog/technical-articles/five-common-dimensional-modeling-mistakes-and-how-to-solve-them - using a additional fact table

https://www.vertabelo.com/blog/technical-articles/data-warehouse-modeling-the-snowflake-schema

How to load Fact Tables

https://www.tek-tips.com/viewthread.cfm?qid=1643616

https://social.technet.microsoft.com/Forums/en-US/7cba63e1-6742-4db5-8011-44a8fea8c041/slowly-changing-facts-creation-with-scd-type-2-dims-tables?forum=sqldatawarehousing

https://martinschoombee.com/2011/11/16/temporal-fact-tables/

Temporal Modeling

https://www.linkedin.com/feed/update/urn:li:ugcPost:6497167178356318208

https://sqldusty.com/2015/10/19/data-warehouse-design-challenge-relating-a-temporal-fact-table-to-a-date-dimension/

https://sqlbits.com/Sessions/Event10/Temporal_Snapshot_Fact_Table

https://www.researchgate.net/publication/330798405_Temporal_Dimensional_Modeling

Google Search : what is a key of a fact table in a data warehouse

https://stackoverflow.com/questions/21606750/is-there-a-concept-of-slowly-changing-fact-in-data-warehouse

https://www.researchgate.net/publication/330798405_Temporal_Dimensional_Modeling

----Multiple Models

http://www.databaseanswers.org/downloads/Dimensional_Modelling_by_Example.pdf

---Kimball Books on Datawarehouse Designs

https://books.google.com/books?id=XoS2oy1IcB4C&pg=PA422&lpg=PA422&dq=customer+address+dimension&source=bl&ots=1CJ9lElOjF&sig=ACfU3U2sWQOgAAOeBF0CjnoT1vbLwbRSXw&hl=en&sa=X&ved=2ahUKEwi_styn4b7gAhUDL30KHZHjDyI4ChDoATAHegQIBxAB#v=onepage&q&f=false

https://books.google.com/books?id=XoS2oy1IcB4C&dq=customer+address+dimension&source=gbs_navlinks_s

https://books.google.com/books?id=C3G-CgAAQBAJ&pg=PA416&lpg=PA416&dq=customer+address+dimension&source=bl&ots=s5smQqrXHy&sig=ACfU3U2KmmAvpvKkpMgJUXGBcC9etOLOiw&hl=en&sa=X&ved=2ahUKEwi_styn4b7gAhUDL30KHZHjDyI4ChDoATAJegQIBBAB#v=onepage&q=customer%20address%20dimension&f=false

Surrogate Key reference

https://www.kimballgroup.com/1998/05/surrogate-keys/

Surrogate Key as Primary Key

https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/dimension-surrogate-key/

https://www.kimballgroup.com/2006/07/design-tip-81-fact-table-surrogate-key/