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.
Doing Data Analysis with SQL (Part Two)
Doing Data Analysis with SQL (Part Two)
Doing Data Analysis with SQL (Part Two)
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.