XBUS-518 - Data Warehouses & ETLs

School of Continuing Studies

What are the topics?

School of Continuing Studies

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Read more about Business Analytics

Business Analytics courses will introduce you to a popular and diverse profession. A business analyst is a specialist in many IT fields as well as in ...

About the course

A sound data engineering approach is the baseline by which all other data initiatives depend. Moving data through ETLs/ELTs into data warehouses that represent data in a way that is serviceable to the data goals of the organization is a critical, ongoing process to any data-driven organization. However, ETLs are filled with risks to data integrity, quality, and provenance and must be approached with best practices in mind.

This course will provide an overview of data engineering approaches and their trade offs in building different types of data warehouses. Tools for batch or stream data processing will be introduced. Common issues related to reliability, robustness, data loss, and data provenance will be explored.

This course is part of the Data Engineering track of the Advanced Data Science Certificate.

Course Objectives

Upon successful completion of the course, students will be able to:

Understand the different approaches to data warehousing across varying sized organizations.

Structure and organize data engineering initiatives.

Compose data pipelines that integrate a wide range of data tools including Python scheduling libraries or services, distributed processing systems, and multiple data stores.

Articulate the issues related to data lineage and provenance and evaluate workflow options that preserve them.

Design unit and end-to-end automated tests for data pipelines

Understand anomaly detection and alerting techniques to reinforce robust data pipelines.

Experts

Laura Lorenz

Laura is a data and software engineer at Industry Dive, a B2B media company, where she implements and operates full-stack solutions with both the web and data teams using primarily Python tools and frameworks such as Django, Flask, pandas, and scikit-learn. She also contributes to open source pro...

XBUS-518 - Data Warehouses & ETLs at School of Continuing Studies

This course has no confirmed dates in the future. Subscribe to be notified when it is offered.


Something went wrong. We're trying to fix this error.

Thank you

Someone from the Coursalytics team will be in touch with you soon.

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Read more about Business Analytics

What will you learn from Business Analytics courses? First of all, you will learn about the profession of a business analyst, his duties, and what such a specialist does. You will get various soft skills, such as organizing teamwork, for example, acc...

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.