Skip to content

Establishing Data Infrastructure

Course two of three

Learn how to make strategic decisions for your organization's data pipeline technology as you hone specialized skills in Data Product Management.

Learn More


Enrollments for individual courses are no longer available for this program. Visit our Data Product Manager page to learn more about enrolling in the complete Nanodegree program.

Enroll now and take all three courses!

What you will learn

  1. Establishing Data Infrastructure

    1 month to complete

    Data product managers need to ensure that their products have the appropriate data pipelines in place so that data collected from users can be extracted, transformed, and loaded into a data lake or warehouse for use in statistical analysis. Learn about data infrastructure components including data pipelines, data producers, data consumers, data storage, and data processing. Master the nuances of evaluating strategic decisions for data pipeline technology, including security and compliance, and create solutions for real-world data infrastructure problems.

    Prerequisite knowledge

    1. Introduction to Data Pipelines

      Begin by understanding the importance and need of data pipelines and the various components of data pipelines, and learn how to organize data pipeline components to automate end-to-end data flow. Then, create conceptual data pipelines and conceptualize classic data problems that can be addressed by data pipelines.

      • Data Consumers

        Learn about primary data consumers, their data needs, and how to identify data consumers in an organization and their relevant data use cases. Develop an understanding of the components of a relational data model and apply relational data models to business scenarios.

        • Data Producers

          Learn how to create event data models and implement them to get business insights, and use data collected from event models to calculate product KPIs. Identify primary data producers in an organization and distinguish between backend data producers (SaaS, ERPs, and data stores) while also differentiating between types of data (structured vs. semi-structured vs. unstructured).

          • Data Strategy

            Understand the difference between ETL and ELT processes, distinguish between batch processing and stream processing, and learn to select the appropriate data processing components for a product based on data needs. Differentiate between a data warehouse and data lake, and between SQL and NoSQL databases, and determine the appropriate data storage components for a particular data infrastructure of a product based on data needs. Assess capabilities of various data warehousing options (build vs buy, cloud vs on-prem, open source vs proprietary, and insource vs outsource) to make strategic decisions for data infrastructure, and evaluate data security and compliance product use cases (PII, PCI, HIPAA, GDPR, and CCPA).

            • Final Project: Build a Scalable Data Strategy for Flyber

              In this project, you will act as a data product manager for Flyber, a fictional flying-taxi service, and create a data strategy to not only handle the massive amount of incoming data, but also process it to gain business insights. First, you will define the data needs of primary business stakeholders within the organization and create a data model to ensure the data collected supports those needs. Then, you will perform the necessary extraction and transformation of the data to make the data relevant to answer business questions. Finally, you will interpret data visualizations to understand the scale of Flyber’s data growth and choose an appropriate data warehouse to enable that growth.

            Learn with the best.

            Learn with the best.

            • Vaishali Agarwal


              Vaishali has spent 12+ years in the tech eco-system with roles spanning product management and product development to content writing to coding. She is experienced in building platforms, high performance start-up divisions, streamlined operations, and managing customer expectations.

            All our programs include:

            • Real-world projects from industry experts

              With real-world projects and immersive content built in partnership with top-tier companies, you’ll master the tech skills companies want.

            • Technical mentor support

              Our knowledgeable mentors guide your learning and are focused on answering your questions, motivating you, and keeping you on track.

            • Career services

              You’ll have access to Github portfolio review and LinkedIn profile optimization to help you advance your career and land a high-paying role.

            • Flexible learning program

              Tailor a learning plan that fits your busy life. Learn at your own pace and reach your personal goals on the schedule that works best for you.

            Program offerings

            • Class content

              • Real-world projects
              • Project reviews
              • Project feedback from experienced reviewers
            • Student services

              • Technical mentor support
              • Student community
            • Career services

              • Github review
              • Linkedin profile optimization

            Succeed with personalized services.

            We provide services customized for your needs at every step of your learning journey to ensure your success.

            Get timely feedback on your projects.

            • Personalized feedback
            • Unlimited submissions and feedback loops
            • Practical tips and industry best practices
            • Additional suggested resources to improve
            • 1,400+

              project reviewers

            • 2.7M

              projects reviewed

            • 88/100

              reviewer rating

            • 1.1 hours

              avg project review turnaround time

            Mentors available to answer your questions.

            • Support for all your technical questions
            • Questions answered quickly by our team of technical mentors
            • 1,400+

              technical mentors

            • 0.85 hours

              median response time

            Program details

            Program overview: Why should I take this program?
            • Why should I enroll?
            • How do I know if this program is right for me?
            • What jobs will this program prepare me for?
            • What is the difference between the Product Manager, the Growth Product Manager, the Data Product Manager, and the AI Product Manager Nanodegree programs?
            Enrollment and admission
            • Do I need to apply? What are the admission criteria?
            • What are the prerequisites for enrollment?
            • If I do not meet the requirements to enroll, what should I do?
            Tuition and term of program
            • How is this Nanodegree program structured?
            • How long is this Nanodegree program?
            • Can I switch my start date? Can I get a refund?
            Software and hardware: What do I need for this program?
            • What software and versions will I need in this program?