Data Engineering Specialization

The Data Analytics Journey uses the analytics life cycle to conceptualize the processes, tools, and techniques for implementing data analysis, data engineering, and decision process engineering. Students gain fluency in gathering requirements, asking business questions, establishing evaluation metrics, identifying communication models, and aligning the analytics project outcomes to business goals. This course presents an overview of the various tracks offered in the program and the career options in these specializations. There is no prerequisite for this course.

Data Management builds proficiency in using both relational and non-relational databases. Topics include selection of a data storage architecture, data types, data structures, normalization and denormalization, and querying databases. Structured Query Language (SQL) topics such as Data Definition Language (DDL) and Data Manipulation Language (DML) are covered, including joins, aggregations, and transactions. Non-relational approaches to organizing and querying data are contrasted with relational approaches to build competency in adapting data storage architectures to business needs.

Analytics Programming builds algorithmic thinking using both the Python and R programming languages. This course builds from the foundations of programming. Learners use libraries and packages to perform common analytics tasks, including acquiring, organizing, and manipulating data sets. The course also presents methods for applying statistical functions and graphical user interfaces to perform basic analysis and to present findings. There is no pre-requisite for this course.

Data Preparation and Exploration applies analytical programming skills to the early steps of the data analytics life cycle. This course covers cleaning data to ensure the structure, accuracy, and quality of the data; interpretation of descriptive and inferential statistics as well as visualizations of data; and wrangling data to prepare it for further analysis. The course introduces hypothesis testing, focusing on application for parametric tests, and addresses communication skills and tools to explain an analyst’s findings to others within an organization. The following courses are prerequisites: The Data Analytics Journey, Data Management, and Analytics Programming.

Statistical Data Mining focuses on concepts in data preparation and supervised and unsupervised machine learning techniques. The course helps students gain basic knowledge in statistics, data preparation, regression, and dimensional reduction. Learners implement supervised models—specifically classification and prediction data mining models—to identify relationships among variables that are not apparent with more surface-level techniques. The course also explains when, how, and why to use unsupervised models to best meet organizational needs. The following course is a prerequisite: Data Preparation and Exploration.

Data Storytelling for Diverse Audiences focuses on communicating observations and patterns to diverse stakeholders, a key aspect of the data analytics life cycle. This course helps learners gain communication and storytelling skills in order to motivate change and answer business problems. It also covers data visualizations, audio representations, interactive dashboards, interpersonal communication, and presentation skills.

Deployment is the practice of operationalizing data analysis within a business environment. Given an analysis, learners determine the business functional and non-functional requirements for wider use and implement pipelines and functions to deploy analyses at scale. Topics including security, scalability, usability, and availability are discussed. Prerequisites for this course are Analytical Programming, Data Management, Data Preparation, and Statistical Data Mining.

Cloud Databases covers the application of cloud architectures to large-scale data systems. The differences between cloud-native approaches to data architectures and smaller scale systems are discussed and learners apply cloud computing concepts to address specific business scenarios.

The Data Engineering Capstone has learners utilize the skills learned throughout the MDSA core courses and the data engineering courses to examine a problem where data engineering is a solution and to build a cloud-native infrastructure that allows for data processing. Learners are asked to implement their solutions and tell a story using the data. Course material introduces the project and reminds learners of relevant learning resources from previous courses that will prove helpful in completing the performance assessment.

Data Analytics at Scale builds on previous data engineering courses and discusses approaches for analyzing large data sets. The course discusses map/reduce approaches, Apache Spark, and cloud–native solutions for developing, automating, and scaling data analytics. Also discussed are methods for integrating data processing pipelines and data stores to create comprehensive data analytics architectures.

Data Processing is the practice of automating data flow into and out of components of an analytics system and comprises a major part of the analytics life cycle in modern organizations. Data Processing covers concepts in Extract, Transform, and Load (ETL) pipeline operations on data at scale and variations of ETL (Extract, Transform, and Load) as a function of data repositories including data warehouses and data lakes. Streaming and batch data operations and their differences are discussed, and learners implement pipeline solutions in cloud-native environments.