Shaping Data Shaping data refers to manipulating how data is represented in columns and rows Each table has a shape. The result set of each query has a shape. An important concept in shaping data is figuring out the granularity of data you need. Flattening data is also another important concept. This refers to reducing the number of rows that represent an entity. Joining multiple tables together is one way to flatten data.
Share this post
Doing Data Analysis with SQL (Part Two)
Share this post
Shaping Data Shaping data refers to manipulating how data is represented in columns and rows Each table has a shape. The result set of each query has a shape. An important concept in shaping data is figuring out the granularity of data you need. Flattening data is also another important concept. This refers to reducing the number of rows that represent an entity. Joining multiple tables together is one way to flatten data.