为商业智能搭建数据仓库

Data Warehousing for Business Intelligence

Build a fully-optimized business data warehouse in five courses.

科罗拉多大学系统

专项课程

分享

为商业智能搭建数据仓库

本专项课程介绍

Evaluate business needs; design a data warehouse; and integrate, and visualize data using dashboards and visual analytics.

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.

第 1 门课程

数据库管理精要

Current session: 5月 2 — 6月 27.
课程学习时间 7 weeks of study, 4-6 hours/week

课程概述
Database Management Essentials provides the foundation you need for a career in database development, data warehousing, or business intelligence, as well as for the entire Data Warehousing for Business Intelligence specialization. In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy. As you develop these skills, you will use either Oracle or MySQL to execute SQL statements and a database diagramming tool such as the ER Assistant to create ERDs. We’ve designed this course to ensure a common foundation for specialization learners. Everyone taking the course can jump right in with writing SQL statements in Oracle or MySQL.

第 2 门课程

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

Upcoming session: 5月 9 — 6月 20.

课程概述
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 learn exciting concepts and skills for designing data warehouses and creating data integration workflows.
These are fundamental skills for data warehouse developers and administrators. You will have hands-on experience for data warehouse design and use open source products for manipulating pivot tables and creating data integration workflows.You will also gain 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, software background, 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

第 3 门课程

关系数据库支持的数据仓库

Upcoming session: 5月 9 — 6月 20.

课程概述
Relational Database Support for Data Warehouses is the third course in the Data Warehousing for Business Intelligence specialization. In this course, you’ll use analytical elements of SQL for answering business intelligence questions. You’ll learn features of relational database management systems for managing summary data commonly used in business intelligence reporting. Because of the importance and difficulty of managing implementations of data warehouses, we’ll also delve into storage architectures, scalable parallel processing, data governance, and big data impacts.

第 4 门课程

商业智能的概念、工具与应用

Upcoming session: 5月 9 — 6月 20.
课程学习时间 课程时长为五周,每周3-5小时

课程概述
本课程是《数据仓库和商业智能系列课程》的第四门课,建议按照顺序学习这些课程。通过本课程,你将学习到作为一个BI工程师应该具备的知识和技能,例如使用数据仓库实现商业智能的目标,你将有机会在数据仓库环境下使用大规模数据,还会使用MicroStrategy的在线分析(OLAP)和数据可视化功能来创建可视化的仪表盘。
本课程概述了商业智能技术是如何支持在不同商业领域的决策制定,这些技术已经在合作策略、业绩表现和竞争意识等方面产生了巨大的影响,包括了广泛采用的决策支持系统、商业智能系统和可视化分析技术。课程按照商业智能概念、工具和应用的方式进行组织,包括使用数据仓库进行报表展示和在线分析,创建可视化的仪表盘,以及业绩表现管理和描述性分析。

毕业项目

设计和开发数据仓库来实现商业智能

Upcoming session: 7月 11 — 8月 29.
课程学习时间 6 weeks of study, 3-5 hours/week

毕业项目介绍
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. 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.

声明: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 慕课改变你,你改变世界