Reveal Dashboards

Kinetica’s powerful visualization tool, Reveal, provides a clear and vibrant look into your data using user-friendly slices and dashboards that can update with your data.

This tutorial will walk you through dashboard and slice creation. After you’re finished, you’ll have a fully-fledged dashboard replete with various types of information displayed using slices (typically known as widgets), ultimately providing you with actionable insight into your business. In this guide, we’re going to create a dashboard to host NYC Taxi transaction statistics and information.

Creating a Dashboard

To house all the slices we’ll create later in the tutorial, we need to first create the dashboard.

  1. Navigate to Reveal (http://<kinetica-host>:8088).
  2. Click Dashboards.
  3. Click the + icon.
  4. Input NYC Taxi (Quick Start) for the Title and click Save. You’ll be taken to the new dashboard.
  5. Under the Global Filtering section of the welcome box, select taxi_data from the Table drop-down menu.

The dashboard is now available and (mostly) a blank canvas. It has a Filter slice with it by default to allow you to globally filter the dashboard.


 

Let’s make a minor edit to the Filter slice so the entire dashboard will automatically refresh every 30 seconds.

  1. On the new NYC Taxi (Quick Start) dashboard, point to the taxi_data Filter on the right side of the dashboard. Click the Slice Designer icon () in the top-right corner.
  2. Under Options, set the Auto-Refresh Interval to 30 seconds.
  3. Click Update, and then click Save.
  4. Leave the default settings for Save Slice. Under Dashboard, select Add to existing then select the NYC Taxi (Quick Start) dashboard from the drop-down menu.
  5. Click Save & Go To Dashboard.

Creating a Table Slice

The first slice we’ll create is a Table slice. This slice will show the sum of the dollars collected across all taxi transactions, grouped by payment type.

  1. Navigate to Reveal (http://<kinetica-host>:8088).
  2. Click Dashboards.
  3. Click NYC Taxi Data.
  4. Click + Add Slices in the top-right corner of the dashboard.
  5. Click + Create New Slice in the bottom-left corner of the Add Slices window.
  6. Leave the default Database and table selections and click + Create Slice With Table.
  7. Leave the default Table & Chart settings (the default new slice type is Table).
  8. Under Groups, input payment_type for the Group by.
  9. Search for and select SUM(total_amount) for the Metrics.
  10. Click Update. The slice preview will be updated.
  11. Click Save.
  12. Under Save Slice, input Taxi Payment Type Totals for the slice name, and then click Save & Go To Dashboard.

Creating a Pie Chart Slice

The second slice we’ll create is the Pie Chart slice. This slice will show a pie chart representing the relative number of trips for each vendor in the table.

  1. Navigate to Reveal (http://<kinetica-host>:8088).
  2. Click Dashboards.
  3. Click NYC Taxi Data.
  4. Click + Add Slices in the top-right corner of the dashboard.
  5. Click + Create New Slice in the bottom-left corner of the Add Slices window.
  6. Leave the default Database and table selections and click + Create Slice With Table.
  7. Click Table (the default new slice type is Table), then search for and select the Pie Chart slice.
  8. Under Slices, search for and select vendor_id for the Series.
  9. Select the Donut checkbox and clear the Legend checkbox under Options.
  10. Leave the other settings as the default and click Update. The slice preview will be updated.
  11. Click Save.
  12. Under Save Slice, input Taxi Vendor Counts for the slice name, and then click Save & Go To Dashboard.

Creating a Bar Chart Slice

The third slice we’ll create is the Bar Chart slice. This slice will show a bar chart of the total number of rides taken, binned by passenger count (1, 2, 3, 4, 5, or 6 passengers).

  1. Navigate to Reveal (http://<kinetica-host>:8088).
  2. Click Dashboards.
  3. Click NYC Taxi Data.
  4. Click + Add Slices in the top-right corner of the dashboard.
  5. Click + Create New Slice in the bottom-left corner of the Add Slices window.
  6. Leave the default Database and table selections and click + Create Slice With Table.
  7. Click Table (the default new slice type is Table), then search for and select the Bar Chart slice.
  8. Under Bars, search for and select passenger_count for the Series.
  9. Under Options, clear the Legend checkbox and select the Bar Values checkbox.
  10. Input Passengers for the X Axis Label and input Rides for the Y Axis Label.
  11. Click Update. The slice preview will be updated.
  12. Click Save.
  13. Under Save Slice, input Taxi Passenger Counts Per Ride for the slice name, and then click Save & Go To Dashboard.

Creating a Map Slice

Next, we’re going to create a Map slice to plot our historical and streaming taxi transaction data.

  1. Navigate to Reveal (http://<kinetica-host>:8088).
  2. Click Dashboards.
  3. Click NYC Taxi Data.
  4. Click + Add Slices in the top-right corner of the dashboard.
  5. Click + Create New Slice in the bottom-left corner of the Add Slices window.
  6. Leave the default Database and table selections and click + Create Slice With Table.
  7. Click Table (the default new slice type is Table), then search for and select the Map slice.
  8. Adjust the map area and zoom as necessary, leave the rest of the settings as default, and then click Update.
  9. Click Save.
  10. Input Taxi Dropoff Map for the slice name, and click Save & Go To Dashboard.

Creating a Realtime Slice

To validate the streaming data coming in, we’re going to create a Realtime slice that will update every few seconds to reflect the count of trips taken per vendor, with each line representing a different vendor’s trip count over time.

  1. Navigate to Reveal (http://<kinetica-host>:8088).
  2. Click Dashboards.
  3. Click NYC Taxi Data.
  4. Click + Add Slices in the top-right corner of the dashboard.
  5. Click + Create New Slice in the bottom-left corner of the Add Slices window.
  6. Leave the default Database and table selections and click + Create Slice With Table.
  7. Under Table & Chart, click Table (the default new slice type is Table), then search for and select the Realtime slice.
  8. Under Time, change the Since field to 1 hour ago.
  9. Under Groups, add vendor_id to the Group by field.
  10. Under Options, change the Interval and Delay fields to 3 seconds. Clear the Update on Filter checkbox.
  11. Click Update. Data will begin to plot on the slice preview to the right.
  12. Click Save.
  13. Input Vendor Counts Realtime for the slice name, and click Save & Go To Dashboard.

Creating a Scatter Plot Slice

Lastly, we’ll create a Scatter Plot slice to show the positive correlation between trip distance and total cost.

  1. Navigate to Reveal (http://<kinetica-host>:8088).
  2. Click Dashboards.
  3. Click NYC Taxi Data.
  4. Click + Add Slices in the top-right corner of the dashboard.
  5. Click + Create New Slice in the bottom-left corner of the Add Slices window.
  6. Leave the default Database and table selections and click + Create Slice With Table.
  7. Click Table (the default new slice type is Table), then search for and select the Scatter Plot slice.
  8. Under Axes, search for and select trip_distance for X and search for and select total_amount for Y. Input Trip Distance for the X Axis Label and Total Amount for the Y Axis Label.
  9. Under Ranges, input 15 for the Max X and input 80 for the Max Y. Change the Point Size to 1.
  10. Click Update. The slice preview will be updated.
  11. Click Save.
  12. Input Taxi Trip Scatter Plot for the slice name, and click Save & Go To Dashboard.

Organizing Your Dashboard

After adding all the slices, the dashboard is functionally complete. Use the Move Slice icon () in the top-right corner of a slice or use the arrow () in the bottom-right corner of a slice to rearrange the dashboard or resize slices, respectively. Click Save in the top-right corner of the dashboard to save the dashboard’s current layout. In the end, your dashboard should look similar to the picture below (with some modifications based on your preferences).

Kinetica Trial Feedback