Name: Designing Data Systems
Price: -1 USD

Designing Data Systems

Overview

Design scalable data systems from the ground up. Practice data staging, transformation, and warehouse construction while learning to create centralized architectures for enterprise-wide insights and decision-making.

Syllabus

Foundations of Designing Data Systems

In this lesson, we will take a 30000-foot view of Designing Data Systems. We will meet the instructor and hear about the components of the course, including the final project.

Data Architecture

In this lesson, we will look at the importance of, benefits of, and artifacts of Designing Data Systems using Data Architecture. We will also introduce Snowflake, the software we will be using.

Staging Data

In this lesson, we will take a look at the important step of Staging Data. We will look at the theory behind it, study the steps involved, and then actually do it in Snowflake.

Operational Data Store

In this lesson, we will look at what an ODS is and how it is an important step in building a data warehouse. We will also take a look at how to manage, cleanse, and transform the data.

Data Warehouse

In this lesson, we will take a look at the final step of building a data warehouse. We will also look at reporting, the primary reason for a data warehouse.

Project: Design a Data Warehouse for Reporting and OLAP

In a real data warehouse, students will use actual YELP and climate datasets in order to analyze the effects the weather has on customer reviews of restaurants.