16. Drill Up and Drill Down
The manager asks, "What are the sales in Maharashtra? And in Pune? And in the Kothrud store?" – that is drill down. In this module we look at the drill buttons, drill vs expand, +/- in a matrix, and include/exclude, in simple words.
Manager विचारतात, "Maharashtra मध्ये sales किती? आणि Pune मध्ये? आणि Kothrud store मध्ये?" – हेच drill down. या module मध्ये drill buttons, drill vs expand, matrix मधले +/- आणि include/exclude हे सगळं सोप्या भाषेत बघू.
Manager पूछते हैं, "Maharashtra में sales कितनी? और Pune में? और Kothrud store में?" – यही drill down है. इस module में drill buttons, drill vs expand, matrix के +/- और include/exclude यह सब आसान भाषा में देखेंगे.
What you will learn in this module
- Preparing hierarchies for drilling (Date, Location, Product)
- The four drill buttons: Drill up, Drill down (drill mode), Go to the next level, Expand all down one level
- The difference between drilling down and expanding
- Expand/collapse in a matrix, and Include/Exclude
- Tips for drill-friendly reports
Live story: Year, then Quarter, then Month in one chart
Suppose the Swiggy Maharashtra finance lead looks at a yearly bar and asks, "Which quarter dropped?" Then, "Which month in that quarter?" We do not build three charts. We drill down in one. This chapter covers drill down, drill up and expand to next level.
All numbers in this story are fictional practice data.
Live story: एकाच chart मध्ये Year, then Quarter, then Month
समजा Swiggy Maharashtra चे finance lead वर्षाचा bar बघून विचारतात, "कोणत्या quarter मध्ये घसरण झाली?" मग, "त्या quarter मधला कोणता महिना?" आपण तीन charts बनवत नाही. एकाच chart मध्ये drill down करतो. हा chapter drill down, drill up आणि expand to next level शिकवतो.
या story मधले सगळे आकडे काल्पनिक practice data आहेत.
Live story: एक ही chart में Year, then Quarter, then Month
मान लीजिए Swiggy Maharashtra के finance lead साल का bar देखकर पूछते हैं, "किस quarter में गिरावट आई?" फिर, "उस quarter का कौन-सा महीना?" हम तीन charts नहीं बनाते. एक ही chart में drill down करते हैं. यह chapter drill down, drill up और expand to next level सिखाता है.
इस story के सारे आँकड़े काल्पनिक practice data हैं.
Concepts in this chapter
- 16.1Prepare the Hierarchies
- 16.2The Drill Buttons
- 16.3Drill Down vs Expand – the Difference
- 16.4Matrix: Expand, Collapse and +/- Icons
- 16.5Include and Exclude
- 16.6Tips for Drill-friendly Reports
The chapter recap is at the end of the last concept page.
Ravi Sir's Cards: 8 revision, interview and comparison cards for this chapter · मराठी cards