{"id":8195,"date":"2022-04-28T21:10:06","date_gmt":"2022-04-28T21:10:06","guid":{"rendered":"https:\/\/www.tun.com\/courses\/2019\/12\/23\/design-and-build-a-data-warehouse-for-business-intelligence-implementation\/"},"modified":"2022-04-28T21:10:06","modified_gmt":"2022-04-28T21:10:06","slug":"design-and-build-a-data-warehouse-for-business-intelligence-implementation","status":"publish","type":"post","link":"https:\/\/www.tun.com\/courses\/design-and-build-a-data-warehouse-for-business-intelligence-implementation\/university-of-colorado-system\/","title":{"rendered":"Design and Build a Data Warehouse for Business Intelligence Implementation"},"content":{"rendered":"
\n
\n
\n

Description<\/h2>\n

The capstone course, Design and Build a Data Warehouse for Business Intelligence Implementation, features a real-world case study that integrates your learning across all courses in the specialization. In response to business requirements presented in a case study, you\u2019ll design and build a small data warehouse, create data integration workflows to refresh the warehouse, write SQL statements to support analytical and summary query requirements, and use the MicroStrategy business intelligence platform to create dashboards and visualizations.<\/p>\n

In the first part of the capstone course, you\u2019ll be introduced to a medium-sized firm, learning about their data warehouse and business intelligence requirements and existing data sources. You\u2019ll first architect a warehouse schema and dimensional model for a small data warehouse. You\u2019ll then create data integration workflows using Pentaho Data Integration to refresh your data warehouse. Next, you\u2019ll write SQL statements for analytical query requirements and create materialized views to support summary data management. Finally, you will use MicroStrategy OLAP capabilities to gain insights into your data warehouse. In the completed project, you\u2019ll have built a small data warehouse containing a schema design, data integration workflows, analytical queries, materialized views, dashboards and visualizations that you\u2019ll be proud to show to your current and prospective employers.<\/p>\n

<\/div>\n

Price: Enroll For Free!<\/h2>\n
<\/div>\n
View Class<\/a><\/div>\n
<\/div>\n
\n
\n

Language:<\/strong> <\/em>English<\/p>\n<\/div>\n

\n

Subtitles<\/strong>: <\/em>English<\/p>\n<\/div>\n<\/div>\n

Design and Build a Data Warehouse for Business Intelligence Implementation – University of Colorado System<\/strong><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Description The capstone course, Design and Build a Data Warehouse for Business Intelligence Implementation, features a real-world case study that integrates your learning across all courses in the specialization. In response to business requirements presented in a case study, you\u2019ll design and build a small data warehouse, create data integration workflows to refresh the warehouse, […]<\/p>\n","protected":false},"author":1,"featured_media":19364,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_uag_custom_page_level_css":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[250],"tags":[],"class_list":["post-8195","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-university-of-colorado-system"],"aioseo_notices":[],"uagb_featured_image_src":{"full":["https:\/\/www.tun.com\/courses\/wp-content\/uploads\/2019\/12\/University-of-Colorado-Systemonline-education.png",375,224,false],"thumbnail":["https:\/\/www.tun.com\/courses\/wp-content\/uploads\/2019\/12\/University-of-Colorado-Systemonline-education-150x150.png",150,150,true],"medium":["https:\/\/www.tun.com\/courses\/wp-content\/uploads\/2019\/12\/University-of-Colorado-Systemonline-education-300x179.png",300,179,true],"medium_large":["https:\/\/www.tun.com\/courses\/wp-content\/uploads\/2019\/12\/University-of-Colorado-Systemonline-education.png",375,224,false],"large":["https:\/\/www.tun.com\/courses\/wp-content\/uploads\/2019\/12\/University-of-Colorado-Systemonline-education.png",375,224,false],"1536x1536":["https:\/\/www.tun.com\/courses\/wp-content\/uploads\/2019\/12\/University-of-Colorado-Systemonline-education.png",375,224,false],"2048x2048":["https:\/\/www.tun.com\/courses\/wp-content\/uploads\/2019\/12\/University-of-Colorado-Systemonline-education.png",375,224,false]},"uagb_author_info":{"display_name":"Axiom Pegasus","author_link":"https:\/\/www.tun.com\/courses\/author\/magic\/"},"uagb_comment_info":0,"uagb_excerpt":"Description The capstone course, Design and Build a Data Warehouse for Business Intelligence Implementation, features a real-world case study that integrates your learning across all courses in the specialization. In response to business requirements presented in a case study, you\u2019ll design and build a small data warehouse, create data integration workflows to refresh the warehouse,…","featured_media_src_url":"https:\/\/www.tun.com\/courses\/wp-content\/uploads\/2019\/12\/University-of-Colorado-Systemonline-education.png","_links":{"self":[{"href":"https:\/\/www.tun.com\/courses\/wp-json\/wp\/v2\/posts\/8195","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tun.com\/courses\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tun.com\/courses\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tun.com\/courses\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tun.com\/courses\/wp-json\/wp\/v2\/comments?post=8195"}],"version-history":[{"count":0,"href":"https:\/\/www.tun.com\/courses\/wp-json\/wp\/v2\/posts\/8195\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.tun.com\/courses\/wp-json\/wp\/v2\/media\/19364"}],"wp:attachment":[{"href":"https:\/\/www.tun.com\/courses\/wp-json\/wp\/v2\/media?parent=8195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tun.com\/courses\/wp-json\/wp\/v2\/categories?post=8195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tun.com\/courses\/wp-json\/wp\/v2\/tags?post=8195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}