A data model is a semantic layer that makes Hunk a powerful analytical tool for business users. Pivot is a user-friendly interface where anyone can create complex multidimensional reports or interactive dashboards that can be distributed across colleagues.
Let's explore the Pivot UI. Click on Pivot, select the Unicorn Fashion Digital Analytics data model, and Pivot UI will come up:
Pivot UI consists of the following main elements:
|
Pivot element |
Definition |
|---|---|
|
Filters (1) |
This is used to cut down the result count for the object. There are restrictions in addition to those that might be applied via constraints or other means in the object's definition. All Pivots are filtered by time range. We can optionally add one or more filters by attribute. |
|
Split Rows (2) |
This splits out the Pivot results by row. For example, we could use this element to configure a page view object to display a row for each month of the past year, thus breaking out the page view count by month. |
|
Split Columns (3) |
This breaks out field values by column. For example, we could design a Pivot table for a page view event-based object that breaks out its returned events by the |
|
Column Values (4) |
This is usually numeric in nature and represents aggregates such as result counts, sums, and averages (in the case of non-numeric attributes you can do things such as listing distinct attribute values). When we first enter a Pivot table, we find a default column value element that uses the |
|
Data visualization tab (5) |
This tab has various chart data visualizations for exploring our data. They are: Table, Column chart, Bar chart, Scatter chart, Area chart, Line chart, Pie chart, Single value visualization, Radial gauge, Marker gauge, and Filler gauge. |
|
Result tab (6) |
This tab represents the final result of the Pivot editor that can be saved as a report or dashboard. |
In order to successfully finish this chapter in style, let's create a chart via Pivot and try to look at brands by categories:
- Choose Column Chart in the Data Visualization tab.
- In Filter choose status | 300 in order to choose only successful transactions.
- In the X-Axis choose the productBrand as Field and type
Brandin Label. Change Label Rotation to -45. - In the Y-Axis leave the default Count of Digital Data and type
Countin Label. - In Color choose productName as the Field and choose Stack Mode as stacked. Change Legend Positions to Top.
- Click on Save as Report and name the report:
Brands by Categories. - Go to the Reports tab and open the new report:
We have successfully created a report via Pivot and learned how to explore data with a user-friendly interface.