Ravindra BagaleCourses & study guides

12. Data Hierarchies and Groups

By Last updated:

Ya module madhe aapan data la vyavasthit "shelves" var laavuya – hierarchies aani groups. State › City › Area › Store ashi drill path, aani Pune + Solapur = West ase regions. Maharashtra chya udaharanatun he ekdum sope vatel.

What you will learn in this module

  • Creating and editing hierarchies in the Data pane and Model view
  • The automatic date/time hierarchy vs a custom Date table hierarchy
  • Using hierarchies in visuals and slicers
  • Data groups (list groups) such as Maharashtra regions, and the "Other" group
  • Bin groups for delivery time and order value (size vs number of bins)
  • When to use groups vs calculated columns vs hierarchies

Concepts in this chapter

  1. 12.1What Is a Hierarchy?
  2. 12.2Creating a Hierarchy in the Data Pane
  3. 12.3Auto Date/Time Hierarchy vs a Custom Date Table
  4. 12.4Using Hierarchies in Visuals and Slicers
  5. 12.5Data Groups (List Groups)
  6. 12.6Bin Groups (Numeric and Date Bins)
  7. 12.7Groups vs Calculated Columns vs Hierarchies

The chapter recap is at the end of the last concept page.