数据仓库的概念、设计与数据整合

Data Warehouse Concepts, Design, and Data Integration

本课程是Data Warehousing for Business Intelligence专项课程的其中一门课程(共 5 门课程)

科罗拉多大学系统

分享

数据仓库的概念、设计与数据整合
  • 分类: 计算机
  • 平台: Coursera
  • 语言: 英语

About this Course

This is the second course in the Data Warehousing for Business Intelligence specialization. Ideally, the courses should be taken in sequence.

In this course, you will create a data warehouse design that satisfies business intelligence requirements using available data sources. You will work with sample data sources to gain experience implementing data integration workflows. These are fundamental skills for data warehouse developers and administrators. You will also gain a conceptual background about maturity models, architectures, multidimensional models, and management practices, providing an organizational perspective about data warehouse development. If you are currently a business or information technology professional and want to become a data warehouse designer or administrator, this course will give you the knowledge and skills to do that. By the end of the course, you will have the design experience and organizational context that prepares you to succeed with data warehouse development projects.

In this course, you will create data warehouse designs and data integration workflows that satisfy the business intelligence needs of organizations. When you’re done with this course, you’ll be able to:
* Evaluate an organization for data warehouse maturity and business architecture alignment;
* Create a data warehouse design and reflect on alternative design methodologies and design goals;
* Create data integration workflows using prominent open source software;
* Reflect on the role of change data, refresh constraints, refresh frequency trade-offs, and data quality goals in data integration process design; and
* Perform operations on pivot tables to satisfy typical business analysis requests using prominent open source software

数据仓库的概念、设计与数据整合 is course 2 of 5 in the Data Warehousing for Business Intelligence Specialization.

This Specialization covers data architecture skills that are increasingly critical across a broad range of technology fields. You’ll learn the basics of structured data modeling, gain practical SQL coding experience, and develop an in-depth understanding of data warehouse design and data manipulation. You’ll have the opportunity to work with large data sets in a data warehouse environment to create dashboards and Visual Analytics. You will use of MicroStrategy, a leading BI tool, OLAP (online analytical processing) and Visual Insights capabilities to create dashboards and Visual Analytics. In the final Capstone Project, you’ll apply your skills to build a small, basic data warehouse, populate it with data, and create dashboards and other visualizations to analyze and communicate the data to a broad audience.

授课教师

Michael Mannino
Associate Professor
Business School, University of Colorado Denver

声明:MOOC中国收录之课程均源自下列机构,版权均归他们所有。本站仅作报道并尊重其著作权益,感谢他们对MOOC事业做出的贡献!(排名不分先后)
  • Coursera
  • edX
  • OpenLearning
  • FutureLearn
  • iversity
  • Udacity
  • NovoEd
  • Canvas
  • Open2Study
  • Google
  • ewant
  • FUN
  • IOC-Athlete-MOOC
  • World-Science-U
  • Codecademy
  • CourseSites
  • opencourseworld
  • ShareCourse
  • gacco
  • MiriadaX
  • JANUX
  • openhpi
  • Stanford-Open-Edx
  • 网易云课堂
  • 中国大学MOOC
  • 学堂在线
  • 顶你学堂
  • 华文慕课
  • 好大学在线CnMooc

Copyright © 2008-2015 MOOC.CN 慕课改变你,你改变世界