|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/data-warehouse-bi-building
课程评论：没有评论
课程名称：设计与构建数据仓库以实施商业智能 概述：此课程为最终专题课程，结合了一项真实案例研究，整合了您在整个专业化课程中的学习成果。根据案例研究中提出的商业需求，您将设计并构建一个小型数据仓库，创建数据集成工作流程以刷新仓库，编写 SQL 语句以支持分析和汇总查询要求，并使用 MicroStrategy 商业智能平台创建仪表板和可视化效果。 在课程的第一部分，您将了解一家中型企业的背景，学习其数据仓库和商业智能需求以及现有数据源。您将首先构建一个小型数据仓库的仓库架构和维度模型。随后，您将使用 Pentaho 数据集成创建数据集成工作流程以刷新数据仓库。接下来，您将编写 SQL 语句以满足分析查询需求，并创建物化视图来支持汇总数据管理。对于数据集成工作流程和分析查询，您可以选择使用 Oracle 或 PostgreSQL。最后，您将利用 MicroStrategy 的 OLAP 能力深入分析您的数据仓库。在完成的项目中，您将构建一个包含架构设计、数据集成工作流程、分析查询、物化视图、仪表板和可视化效果的小型数据仓库，这将成为您向现任和未来雇主展示的一项骄傲成就。 课程大纲： 1. 课程概述：介绍课程的目标和主题，并提供案例及软件需求的背景。课程围绕2015年 CPI Card Group 所面临的商业情况构建现实案例研究。 2. 数据仓库设计：展示案例研究第一部分的数据仓库设计要求。可以收听关于 CPI Card Group 高管的访谈，以提供案例研究的背景。 3. 数据集成：展示案例研究第二部分的数据集成要求。可以收听有关 CPI Card Group、First Bank 和 Pinnacol Assurance 高管的采访，以提供背景。 4. 分析查询与汇总数据管理：展示案例研究第三部分的分析查询与汇总数据管理要求。 5. 数据可视化与仪表板设计要求：展示案例研究第四部分的数据可视化与仪表板设计要求。 6. 项目总结与提交：这是模块 5 的延伸部分，将模块 5 的同行评审移动到模块 6，以便您有更多时间完成先前模块中的作业，并在本模块中进行同行评审。
Part: 1
Title:Course Overview
Description:Module 1 introduces the objectives and topics in the course and provides background on the case and software requirements. The capstone course is organized around a realistic case study based on the business situation faced by CPI Card Group in 2015.
Part: 2
Title:Data Warehouse Design
Description:Module 2 presents the requirements of the first part of the case study involving data warehouse design. To provide a context for the case study, you can listen to an executive interview with a CPI Card Group executive.
Part: 3
Title:Data Integration
Description:Module 3 presents requirements for the second part of the case study involving data integration. To provide a context for the case study, you can listen to executive interviews with executives from CPI Card Group, First Bank, and Pinnacol Assurance.
Part: 4
Title:Analytical Queries and Summary Data Management
Description:Module 4 presents requirements for the third part of the case study involving analytical queries and summary data management.
Part: 5
Title: Data Visualization and Dashboard Design Requirements
Description:Module 5 presents the data visualization and dashboard design requirements for the fourth part of the case study.
Part: 6
Title:Wrap Up and Project Submission
Description:This is an extension of Module 5. The peer assessment from module 5 is moved to module 6 to give you more time completing the assignments in prior modules as well as for you to do your peer assessment in this module.
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’ll 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. In the first part of the capstone course, you’ll be introduced to a medium-sized firm, learning about their data warehouse and business intelligence requirements and existing data sources. You’ll first architect a warehouse schema and dimensional model for a small data warehouse. You’ll then create data integration workflows using Pentaho Data Integration to refresh your data warehouse. Next, you’ll write SQL statements for analytical query requirements and create materialized views to support summary data management. For data integration workflows and analytical queries, you can use either Oracle or PostgreSQL. Finally, you will use MicroStrategy OLAP capabilities to gain insights into your data warehouse. In the completed project, you’ll have built a small data warehouse containing a schema design, data integration workflows, analytical queries, materialized views, dashboards and visualizations that you’ll be proud to show to your current and prospective employers.
