Datawarehouse overall

---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




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.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