Overview

Gain practical, real-world experience in data architecture through this hands-on capstone project course, developing skills highly valued by employers. During this course, you’ll apply all that you’ve learned throughout the Data Architecture Professional Certificate. As you work through the course, you’ll evaluate, design, migrate, and integrate enterprise data systems through a case study. In the capstone project, you will assess the current data architectures of two organizations, highlighting their strengths and identifying areas for improvement. Based on this analysis, you will design and implement a unified and efficient architecture for the newly merged entity, aligning with business goals. The project includes working with both RDBMS and NoSQL databases and developing ETL pipelines to ensure smooth data integration and flow. Additionally, you will create a data governance plan that addresses regulatory compliance and outlines strategies for data protection. Overall, this real-world inspired scenario will give you plenty to talk about implementing an architecture and managing a system transition in interviews. If you’re keen to add practical experience to your portfolio that employers look for, enroll today!

Syllabus

Introduction and Evaluating Enterprise Data Architecture

This module lays the groundwork for the course by introducing the case study that you will work on and outlining the applicable prerequisites. In this module, you will evaluate the enterprise data architecture of two apparel retail companies that are about to get merged through a hands-on lab, focusing on assessing the organization's data systems. The evaluation includes identifying the strengths, weaknesses, and areas for improvement in data architecture, in alignment with the business goals and data strategies.

Designing the Data Architecture for an Enterprise

This module focuses on designing scalable and efficient data architecture. Through a hands-on lab, you will develop the data architecture for FutureMart, a newly formed entity resulting from the merger of FashionMart and TrendyThreads. This module emphasizes data modeling, selecting appropriate data storage solutions, and creating high-level architecture designs that align with business objectives.

Data Migration in an Enterprise

In this module, you will explore the strategies for data migration between different database systems. Through hands-on labs, you will perform data migration from a relational database (RDBMS) to a NoSQL database and vice versa, focusing on maintaining data integrity and understanding the requirements of data migration.

Data Integration and Related Techniques

This module focuses on advanced data integration techniques, including building ETL pipelines and ensuring data quality. You will work in the hands-on labs to design an ETL pipeline for machine learning (ML) anomaly detection, perform data quality checks, and design a data warehouse schema for efficient data storage and retrieval.

Data Governance for an Enterprise

This module focuses on the critical aspects of data governance and security. Through a case study, you will identify the cost of a data breach. By working on a hands-on lab, you will draft a comprehensive data governance plan for a company, addressing regulatory compliance, data protection, and policy implementation.

Final Project and Submission

The final module brings together all your learning in a graded project. You will redesign the data architecture to manage a company acquisition, applying evaluation, design, migration, and governance principles. After completing the project, you will submit the artifacts developed in the project for grading. The module concludes with the reflections and the next steps in your learning journey.