Skip to main content

Guided Learning

This chapter explores Insights Boards in DataChat using a Titanic dataset. For this example, we'll create tables and charts about ticket fares to add to an Insights Board.

Load Data​

To start, Load the "Titanic Dataset" into your session. We're given a sample of our data that looks like this:

titanic data

Create Objects​

We need to create a couple of objects from this dataset that we can add to an Insights Board.

Pivot Tables​

Let's create a pivot table using the Data Assistant to view the average fare costs for survivors and non-survivors across passenger classes. Enter "Pivot on average Fare creating rows from Survived and columns from Pclass". Optionally, you can also create this pivot table using the Show me something interesting feature. Note that this recommendation may not always be generated. To refresh the insight recommendations, click the Refresh button.

The chart appears in the Data Assistant output. Click Add to Chart tab.

add to chart tab

From here we can see that across all passenger classes, average Fare is higher for those who survived than those who didn't.

Charts​

Let's create some visualizations to add as well. Let's say we'd like to visualize the relationship between fare and age for each passenger class. Navigate back to the Data tab, then:

  1. Click Plot Chart in the skill menu to open the Chart Builder.
  2. Select Bar Chart for type.
  3. Under Required Fields, select "Age" for the X-Axis and "Fare" for the Y-Axis.
  4. Under Optional Fields, select "Pclass" for Slider.
  5. Click Submit.

create chart 1

The chart appears in the Chart tab.

Let's now create a second chart to examine fare and survived. Hover over the Chart tab and click New Chart, then:

  1. Select Violin Chart for type.
  2. Under Required Fields, select "Survived" for the X-Axis and "Fare" for the Y-Axis.
  3. Under Optional Fields, select "Pclass" for Subplot.
  4. Click Submit.

create chart 2

Add Objects to an Insights Board​

Now that we have objects created, we can create an Insights Board to add them to.

Create an Insights Board​

  1. Click more option from the violin chart's header.
  2. Click Publish.
  3. Click Create Insights Board and Publish.
  4. Enter "Titanic_Board" for the name, then click Submit.

create an ib

Add Other Objects​

  1. In the Chart tab, scroll to the bar chart.
  2. Click more options from the chart header.
  3. Click Publish
  4. Select "Titanic Board".

add an ib

Repeat steps 2-4 for the "averageFarePivot" pivot table.

Edit and Use an Insights Board​

Open an Insights Board​

To view our Insights Board, "Titanic_Board":

  1. Return to the homepage.
  2. Double-click "Titanic_Board" from either the My Work or Insights Boards section.

The Insights Board automatically opens with our published charts and pivot table:

open ib

Move and Resize Object Panels​

Let's say that we'd like to organize our Insights Board so that the charts are a bit larger and sit beneath the "averageFarePivot" pivot table.

  1. Move the panels by clicking the top of the panel and dragging to the desired position.

    move panels

  2. Resize the panels by clicking and dragging the edge of the object panel.

    resize panels

Create an Annotation​

Let's say we'd also like to make an annotation about the "Average Fare vs. Age" bar chart to call out that "Average Fare" decreases as "Pclass" increases.

  1. Click Annotate in the sidebar.
  2. Enter "Average Fare decreases as Pclass increases".
  3. Click Submit.

annotation

The annotation appears on the Insights Board. You can move and resize it, like other panels, to your desired position.

Edit Charts​

From an Insights Board, we can also edit our charts. Let's say we'd like to change the "Average Fare vs. Age" chart to the color to purple:

  1. Click Edit mode.
  2. Click Customize to open the customizable option.
  3. Click the Color button, and select the purple option.
  4. Click Submit.

chart colors

Remove Objects​

Let's say that we no longer need our "averageFarePivot" pivot table. We can remove the panel by clicking the Remove publication button.

remove panels

Add Cross Filters​

Let's say that we'd like to add a cross filter to our board so that we can easily look at only data on passengers in third class.

  1. Click Cross Filters in the sidebar.
  2. Click Add Cross Filter.
  3. Enter the "Pclass" for the column, "is equal to" for the expression, and "3" for the value.
  4. Click Apply.

cross filters

The objects on our board now display only data on passengers in third class.

cross filters

Refresh an Insights Board​

Let's say we expect changes have been made to the underlying data associated with "Titanic_Board". We can refresh our Insights Board to rerun the underlying workflow and apply changes by clicking Refresh in the sidebar. You can also hover an object to display the most recent refresh.

refreshed IB

Share an Insights Board​

Now that we have our Insights Board finalized with refreshed objects, we can share it with others using a link. To share "Titanic_Board":

  1. Click Share in the sidebar.
  2. Enter the name of a user to share with. You can remove users by clicking the X next to their role.
  3. Optionally, you can make the Insights Board public by clicking the Make Public button. This creates a link to "Titanic Board" that you can copy and share with anyone outside of your organization.

share IB form