Data Modeling Essentials

Following best practices to format data tables allows us to manage and analyze data efficiently.
Image credit: Art by Allison Horst

Description

Preparing your data for analysis can be time-consuming and tedious. But, it is a necessary step before analyzing your data. This lesson dives deep into what is tidy and normalized data and how to make sure your data structure follows a “tidy structure.” It also introduces relational data models and provides an overview of merging data using joins. This lesson explores fundamental concepts for working with data and includes a hands-on exercise to apply these concepts to an actual data set.

Prerequisites

None

Learning Goal

• Applying tidy and normalized data principles
• Following best practices to format data tables’ content
• Relating tables following relational data models principles
• Understanding how to perform table joins.

Duration

2 hours