Data Warehousing Capstone Project from Coursera

What's inside

Syllabus

Data Platform Architecture and OLTP Database

In this module, you will design a data platform that uses MySQL as an OLTP database. You will be using MySQL to store the OLTP data.

Build a Data Warehouse

In this module you will design and implement a data warehouse and you will then generate reports from the data in the data warehouse.

Data Analytics

In this module, you will assume the role of a data engineer at an e-commerce company. Your company has finished setting up a data warehouse. Now you are assigned the responsibility to design a reporting dashboard that reflects the key metrics of the business.

ETL & Data Pipelines

In this module, you will set up an ETL process using a Shell script to extract new transactional data for each day from the MySQL database and load it into the staging data warehouse in PostgreSQL. Later you will perform the transformation on the table in the staging warehouse to load the data in a dimension table and a fact table. You will then export these tables as CSV files to the production warehouse. You will set up a Cron Job to schedule these tasks.

Final Submission and Peer Review

In this final module, you will complete your submission of screenshots from the hands-on labs for your peers to review. Once you have completed your submission you will then review the submission of one of your peers and grade their submission.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Examines data warehouse engineering skills and techniques as part of the IBM Data Warehouse Engineer Professional Certificate

Develops a solid understanding of data warehouse engineering principles and practices

Provides hands-on labs and interactive materials to reinforce learning

Assumes the role of a Junior Data Engineer, providing practical experience

Covers industry-relevant topics such as data platform architecture, ETL, and reporting

Instructed by recognized experts in the field of data warehouse engineering

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Data Warehousing Capstone Project with these activities:

Review Data Warehouse Concepts

Show steps

Review basic data warehouse concepts to strengthen your foundation for the course.

Browse courses on Data Modeling

Show steps

Explore resources on data warehouse concepts
Take notes on key concepts like data marts, data integration, and ETL processes

SQL Practice for Data Warehouse Queries

Show steps

Improve your SQL skills by practicing queries specific to data warehouse environments.

Browse courses on Data Querying

Show steps

Find online resources or tutorials that provide SQL practice problems
Solve the practice problems, focusing on writing efficient queries that leverage data warehouse features

Design a Data Warehouse Schema

Show steps

Apply your understanding of data warehouse concepts by designing a schema for a specific business use case.

Browse courses on Data Warehouse Design

Show steps

Identify the business requirements for the data warehouse
Create a conceptual data model using tools like ER diagrams
Translate the conceptual model into a physical schema using SQL or a data modeling tool

Two other activities

Expand to see all activities and additional details

Show all five activities

Discuss Data Warehouse Implementations

Show steps

Engage with peers to discuss various approaches to implementing data warehouses and share best practices.

Show steps

Join an online forum or discussion group dedicated to data warehouse implementation
Participate in discussions, ask questions, and share your experiences
Synthesize insights from peer interactions and apply them to your own learning

Build a Mini Data Warehouse

Show steps

Apply your knowledge and skills to build a small-scale data warehouse, providing hands-on experience in the entire process.

Browse courses on Data Engineering

Show steps

Define a specific use case and gather the necessary data
Design and implement a data warehouse schema using a tool like PostgreSQL or Redshift
Load data into the warehouse and perform data transformations
Build reports and dashboards to analyze the data and provide insights

Career center

Learners who complete Data Warehousing Capstone Project will develop knowledge and skills that may be useful to these careers:

Business Intelligence Analyst

A Business Intelligence Analyst uses data to help businesses improve their performance. This course will provide you with the skills and knowledge you need to become a Business Intelligence Analyst, including how to identify business problems, collect data, analyze data, and develop recommendations. You will also learn how to use business intelligence tools and technologies, such as SQL, Excel, and Power BI.

See salaries and explore the career path for Business Intelligence Analyst

Data Analyst

A Data Analyst uses data to help businesses make better decisions. This course will provide you with the skills and knowledge you need to become a Data Analyst, including how to collect data, clean data, analyze data, and visualize data. You will also learn how to use data analysis tools and technologies, such as SQL, Python, and R.

See salaries and explore the career path for Data Analyst

Data Warehouse Engineer

A Data Warehouse Engineer designs and builds data warehouses, which are used to store and manage large amounts of data. This course will provide you with the skills and knowledge you need to design and build a data warehouse, including how to choose the right data warehouse platform, how to design the data warehouse schema, and how to load data into the data warehouse. You will also learn how to use data warehousing tools and technologies, such as SQL and ETL tools.

See salaries and explore the career path for Data Warehouse Engineer

Data Scientist

A Data Scientist uses data to solve complex problems. This course will provide you with the skills and knowledge you need to become a Data Scientist, including how to collect data, clean data, analyze data, and build models. You will also learn how to use data science tools and technologies, such as SQL, Python, and R.

See salaries and explore the career path for Data Scientist

Data Engineer

A Data Engineer builds and maintains data pipelines. This course will provide you with the skills and knowledge you need to become a Data Engineer, including how to design data pipelines, build data pipelines, and monitor data pipelines. You will also learn how to use data engineering tools and technologies, such as SQL, Python, and Airflow.

See salaries and explore the career path for Data Engineer

Database Administrator

A Database Administrator manages databases. This course will provide you with the skills and knowledge you need to become a Database Administrator, including how to install databases, configure databases, and maintain databases. You will also learn how to use database administration tools and technologies, such as SQL, MySQL, and PostgreSQL.

See salaries and explore the career path for Database Administrator

ETL Developer

An ETL Developer builds and maintains ETL pipelines. This course will provide you with the skills and knowledge you need to become an ETL Developer, including how to design ETL pipelines, build ETL pipelines, and monitor ETL pipelines. You will also learn how to use ETL tools and technologies, such as SQL, Python, and Airflow.

See salaries and explore the career path for ETL Developer

Software Engineer

A Software Engineer designs, develops, and maintains software. This course may be useful for Software Engineers who want to learn how to develop data warehouse solutions. You will learn how to design data warehouse architectures, how to build data warehouse ETL pipelines, and how to use data warehouse tools and technologies.

See salaries and explore the career path for Software Engineer

Business Analyst

A Business Analyst analyzes business problems and develops solutions. This course may be useful for Business Analysts who want to learn how to use data to solve business problems. You will learn how to collect data, clean data, analyze data, and develop recommendations.

See salaries and explore the career path for Business Analyst

Data Architect

A Data Architect designs and builds data architectures. This course may be useful for Data Architects who want to learn how to design data warehouse architectures. You will learn how to design data warehouse architectures, how to build data warehouse ETL pipelines, and how to use data warehouse tools and technologies.

See salaries and explore the career path for Data Architect

Data Visualization Engineer

A Data Visualization Engineer designs and builds data visualizations. This course may be useful for Data Visualization Engineers who want to learn how to build data warehouse data visualizations. You will learn how to design data warehouse data visualizations, how to build data warehouse data visualizations, and how to use data warehouse data visualization tools and technologies.

See salaries and explore the career path for Data Visualization Engineer

Data Quality Analyst

A Data Quality Analyst ensures that data is accurate, consistent, and complete. This course may be useful for Data Quality Analysts who want to learn how to assess data warehouse data quality. You will learn how to assess data warehouse data quality, how to improve data warehouse data quality, and how to monitor data warehouse data quality.

See salaries and explore the career path for Data Quality Analyst

Data Governance Analyst

A Data Governance Analyst develops and manages data governance policies. This course may be useful for Data Governance Analysts who want to learn how to develop data warehouse governance policies. You will learn how to design data warehouse governance policies, how to implement data warehouse governance policies, and how to monitor data warehouse governance policies.

See salaries and explore the career path for Data Governance Analyst

Database Designer

A Database Designer designs and builds databases. This course may be useful for Database Designers who want to learn how to design data warehouse databases. You will learn how to design data warehouse databases, how to build data warehouse databases, and how to use data warehouse database tools and technologies.

See salaries and explore the career path for Database Designer

Project Manager

A Project Manager plans, executes, and closes projects. This course may be useful for Project Managers who want to learn how to manage data warehouse projects. You will learn how to plan data warehouse projects, how to execute data warehouse projects, and how to close data warehouse projects.

See salaries and explore the career path for Project Manager