{"id":1351,"date":"2022-09-18T21:19:44","date_gmt":"2022-09-18T14:19:44","guid":{"rendered":"http:\/\/moenawar.web.id\/?p=1351"},"modified":"2022-09-18T21:57:12","modified_gmt":"2022-09-18T14:57:12","slug":"data-warehouse-its-best-practices","status":"publish","type":"post","link":"http:\/\/moenawar.web.id\/?p=1351","title":{"rendered":"Data Warehouse & Its Best Practices"},"content":{"rendered":"

A data warehouse is a central repository of information that can be analyzed to make more informed decisions. Data flows into a data warehouse from transactional systems, relational databases, and other sources, typically on a regular cadence. <\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
No<\/th>\nTitle<\/th>\nLink<\/th>\n<\/tr>\n<\/thead>\n
0<\/td>\nSyllabus<\/td>\nRPS<\/a>
\nCourse Rules<\/a><\/td>\n<\/tr>\n
1<\/td>\nIntroduction to DW<\/td>\nIntro to DW<\/a><\/td>\n<\/tr>\n
2<\/td>\nDW Architecture<\/td>\nDW Architecture<\/a><\/td>\n<\/tr>\n
3<\/td>\nDW Development Phase<\/td>\nDW Deveopment Phase<\/a><\/td>\n<\/tr>\n
4<\/td>\nData Quality in DW Development Phase<\/td>\nDQ in DW Deveopment<\/a><\/td>\n<\/tr>\n
5<\/td>\nDW Framework with DQ Consideration<\/td>\nDW Framework with DQ<\/a><\/td>\n<\/tr>\n
6<\/td>\nDW Requirements Analysis<\/td>\nRequirements Analysis<\/a><\/td>\n<\/tr>\n
7<\/td>\nDW Conceptual Design<\/td>\nConceptual Design<\/a><\/td>\n<\/tr>\n
8<\/td>\nDW Logical Design<\/td>\nLogical Design<\/a><\/td>\n<\/tr>\n
9<\/td>\nETL<\/td>\nETL<\/a><\/td>\n<\/tr>\n
10<\/td>\nPhysical Design<\/td>\nPhysical Design<\/a><\/td>\n<\/tr>\n
11<\/td>\nDW Benefits<\/td>\nDW Benefits<\/a><\/td>\n<\/tr>\n
12<\/td>\nOLAP Operations & Query<\/td>\nOLAP Operations and Query<\/a><\/td>\n<\/tr>\n
13<\/td>\nDW Optimization<\/td>\nDW Optimizations<\/a><\/td>\n<\/tr>\n
14<\/td>\nBuilding the DW & Case Study<\/td>\nSample OLAP Pivot Table<\/a><\/p>\n

Intro to Pivot Table<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

A data warehouse is a central repository of information that can be analyzed to make more informed decisions. Data flows into a data warehouse from transactional systems, relational databases, and…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0},"categories":[17],"tags":[62],"views":1891,"_links":{"self":[{"href":"http:\/\/moenawar.web.id\/index.php?rest_route=\/wp\/v2\/posts\/1351"}],"collection":[{"href":"http:\/\/moenawar.web.id\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/moenawar.web.id\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/moenawar.web.id\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/moenawar.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1351"}],"version-history":[{"count":4,"href":"http:\/\/moenawar.web.id\/index.php?rest_route=\/wp\/v2\/posts\/1351\/revisions"}],"predecessor-version":[{"id":1359,"href":"http:\/\/moenawar.web.id\/index.php?rest_route=\/wp\/v2\/posts\/1351\/revisions\/1359"}],"wp:attachment":[{"href":"http:\/\/moenawar.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/moenawar.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1351"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/moenawar.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}