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.
Relational Database Support for Data Warehouses is course 3 of 5 in the Data Warehousing for Business Intelligence Specialisation.
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.
Week 1: DBMS Extensions and Example Data Warehouses
Week 2: SQL Subtotal Operators
Week 3: SQL Analytic Functions
Week 4: Materialized View Processing and Design
Week 5: Physical Design and Governance