Ravindra BagaleCourses & study guides मराठी Track your progress

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 + Mumbai = 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

Live story: From Maharashtra down to one store

Suppose the state head looks at Maharashtra sales and asks, "Which city? Which area? Which store?" She wants to click and go down, not open a new page. She also wants a Region view: West and Vidarbha. This chapter builds hierarchies (State › City › Area › Store) and groups.

All numbers in this story are fictional practice data.

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.

Ravi Sir's Cards: 11 revision, interview and comparison cards for this chapter · मराठी cards