Learn more about the features and functionality of Pivot 2.0.
Step 1: Set up the data cube
Setting up a data cube requires admin-level privileges. If you are not an administrator, ask your Pivot administrator to complete this step.
As a Pivot administrator, follow these steps to create the data cube used in this tutorial:
- In the Settings menu, click Feature flags.
- Enable Pivot 2.0, and click Save.
- Click the Plus icon on the Pivot landing page.
- Click Load Data.
- On the Druid page that opens, click Example data.
- Click KoalasToTheMax (9 days).
- Click through the data loading flow until you click Submit.
- In Pivot, click Create new data cube. Choose KoalasToTheMax (9 days) as your data source. This data is about user interactions with a website.
- Save your data cube with the name "KoalasToTheMax".
- Add users who can view this data cube in the Settings menu. For more information, see User management.
Step 2: Navigate Pivot 2.0
Once an admin has completed the prerequisites to set up your data cube, log onto the Pivot 2.0 platform. Then, go to the KoalasToTheMax data cube to start exploring your data.
At the top of your page, there is a filter bar. You can filter by any dimension or measure that you want. Click on the filter icon to choose one of four ways to filter:
Add dimensions, measures and comparisons that you want to see to the show bar under the filter.
The left sidebar contains all the data cube's dimensions and measures. You can add any of them to a visualization by dragging them to the show bar. Alternatively, you can click on anything in the left sidebar and select an option:
Under the dimensions and measures, the left sidebar also has a Comparisons section that you can use to compare data from different time periods.
On the right side of the page, there are three main features. First, the visualization menu lets you pick the type of visualization you want to use: .
There is also a pinboard on which you can pin one or more dimensions and their respective values that you always want to see:
Finally, there is a paintbrush by which you can format certain aspects of your visualization. The paintbrush formatting options change depending on your visualization type in the table view, for example, you can add bars or a heat map to help show how much your table's rows differ.
Step 3: Explore features and functionality
You can use Pivot 2.0 to draw insights from your data. For example, suppose that you want to know which browser was most popular in the past week. Change your filter to "latest week," and drag the "Browser" dimension into the show bar. You can now see that Chrome was the most frequently used browser:
You can add more to your visualization without slowing performance. For example, you can drill down to see the number of events per browser version for each browser:
Next, suppose you want to break down this data by country. You can create new columns for each country by dragging the "Country" dimension into the Columns field in the show bar. To add a column, click the show bar's drop-down menu icon so that the Columns row of the show bar appears.
To see whether these results are typical or how they change over time, you can use the comparisons feature to compare your results to a previous period. To compare this week to the previous one, drag "Previous period" in the Comparisons section of the left sidebar to the show bar:
Step 4: Visualize your data
Pivot 2.0 has several visualization types to help you understand your data. For example, you can also see how a dimension changes over time using a line chart. For example, to see how session lengths change over time:
- Switch to a line chart in the visualization menu.
- Add "Session length" in the "Measures" section of the show bar. Delete "Number of events" from the show bar.
- Add the "time" dimension to the "Line" section of the show bar.
- To compare across various countries, put "Country" in the "Multiples" section.
- You can add another dimension to each panel. For example, you can add "Browser" to the "Layer" section: