The user drags and drops column headers to X and Y positions with the data displayed in the resulting grid. This blog will focus on these areas of pivot data value:Ī Pivot Grid in Toad Data Point (known within Excel as a Pivot Table) allows for a data set to be easily summarized and manipulated to see data in different ways and uncover insights. The output can be managed on your workstation or published to Quest Toad Intelligence Central for shared use. The Pivot Grid can be saved as an Excel Pivot Table, and this feature can be automated to refresh this data as needed or on a regularly scheduled basis. The Pivot Grid is the specific feature within Toad Data Point that offers this functionality and allows analysts to drill down and see details for line items. Quest ® Toad ® Data Point can help analysts to arrange and pivot data, and it also works well with Microsoft Excel. While Microsoft Excel is the workhorse of many business analysts, some of the data manipulation, reporting and pivot data that analysts need can also be produced within database tools.
0 Comments
Leave a Reply. |