0 / 0
Quick start: Tell a story with a dashboard
Last updated: Apr 05, 2024
Quick start: Tell a story with a dashboard

You can tell a story about your data without coding by creating and sharing an interactive dashboard. Read about the dashboard editor, then watch a video and take a tutorial that’s suitable for beginners and does not require coding.

Required services
Watson Studio
Cognos Dashboard Embedded

Your basic workflow includes these tasks:

  1. Create a project. Projects are where you can collaborate with others to work with data.
  2. Add your data to the project. You can add CSV files or data from a remote data source through a connection.
  3. Create a dashboard with the Dashboard editor. If you don't have the Cognos Dashboard Embedded service, you can create one for free.
  4. Add your data to the dashboard and create your graphs.
  5. Share your dashboard with others as a read-only web page.

Read about dashboards

With dashboards, you can build sophisticated visualizations of your analytics results, and communicate the insights that you’ve discovered in your data on a dashboard. The dashboard editor provides a graphical builder for a line-of-business user to begin investigating data for patterns and insights. You don’t need to understand coding or SQL to explore the data and gain insights. You can share the results with other users both within your organization and externally through a URL link. Alternatively, you can hand off the dashboard to a data scientist for deeper analysis and predictive modeling.

Read more about dashboards

Watch a video about creating a dashboard

Watch Video Watch this video to see how to create a dashboard, view, and use data in customized visualizations, and save and share the dashboard.

This video provides a visual method to learn the concepts and tasks in this documentation.


Try a tutorial to create a dashboard

In this tutorial, you will complete these tasks:

This tutorial will take approximately 30 minutes to complete.





Tips for completing this tutorial

Here are some tips for successfully completing this tutorial.

Use the video picture-in-picture

Tip: Start the video, then as you scroll through the tutorial, the video moves to picture-in-picture mode. Close the video table of contents for the best experience with picture-in-picture. You can use picture-in-picture mode so you can follow the video as you complete the tasks in this tutorial. Click the timestamps for each task to follow along.

The following animated image shows how to use the video picture-in-picture and table of contents features:

How to use picture-in-picture and chapters

Get help in the community

If you need help with this tutorial, you can ask a question or find an answer in the Cloud Pak for Data Community discussion forum.

Set up your browser windows

For the optimal experience completing this tutorial, open Cloud Pak for Data in one browser window, and keep this tutorial page open in another browser window to switch easily between the two applications. Consider arranging the two browser windows side-by-side to make it easier to follow along.

Side-by-side tutorial and UI

Tip: If you encounter a guided tour while completing this tutorial in the user interface, click Maybe later.



Task 1: Open a project

You need a project to store the dashboard. Follow these steps to open an existing project or create a new project and associate the Cognos Dashboard Embedded service with the project:

  1. From the Cloud Pak for Data navigation menu Navigation menu, choose Projects > View all projects

  2. If you have an existing project, open it.

  3. If you don't have an existing project, then click New project.

  4. Select Create an empty project.

  5. Enter a name and optional description for the project.

  6. Choose an existing object storage service instance or create a new one.

  7. Click Create.

  8. When the project opens, click the Manage tab, and select the Services and integrations page.

  9. On the IBM services tab, click Associate service.

  10. If you don't have a Cognos Dashboard Embedded service instance provisioned yet, click New service, select Cognos Dashboard Embedded, and click Create.

  11. Select your Cognos Dashboard Embedded instance, and click Associate service.

  12. Click Cancel to return to the Services & Integrations page.

For more information or to watch a video, see Creating a project.
For more information on associated services, see Adding associated services.

Checkpoint icon Check your progress

The following image shows a new, empty project.

The following image shows a new, empty project.




Task 2: Add the data set to your project

The data set you will use in this tutorial is available in the Resource hub. Follow these steps to add the data asset to your project:

  1. Access the Bakery and weather data in the Resource hub.

  2. Click New asset.

  3. Select your project from the list, and click Add.

  4. After the data set is added, click View Project. You will see the data set on the Assets tab.

For more information on adding a data asset from the Resource hub to a project, see Loading and accessing data in a notebook.

Checkpoint icon Check your progress

The following image shows the data asset in the project.

The following image shows the data asset in the project.




Task 3: Add data to a dashboard

preview tutorial video To preview this task, watch the video beginning at 01:22.

Follow these steps to create a dashboard and select the data source for the dashboard:

  1. From your project, click New asset > Dashboard editor.

  2. Specify a name for your new dashboard.

  3. Select a Cognos Dashboard Embedded service instance from the list.

  4. Click Create.

  5. In the Tabbed template section, choose the 2 over 1 layout icon that is divided in three sections, and click OK.

  6. In the Selected sources panel, click the Add a source + (plus) sign.

  7. Select Data asset, and choose Bakery and weather data.csv.

  8. Click Select.

Checkpoint icon Check your progress

The following image shows the empty dashboard.

The following image shows the empty dashboard.




Task 4: Visualize data on the first tab in the dashboard

preview tutorial video To preview this task, watch the video beginning at 02:07.

Follow these steps to add visualizations to the first tab in the dashboard:

  1. In the Selected sources panel, click the CSV file source Bakery and weather data.csv to expand it and view all of the columns from the data set.

  2. Chart 1: Drag the single column called No of Transactions into the middle of the top left section of the dashboard.

  3. Chart 2: You can also select multiple columns. Hold down the Ctrl on your keyboard, and click No of Transactions, Sales in USD, and Product Group to select all three columns of data, then drag the selected columns into the middle of the bottom section of the dashboard. The dashboard service determines the best way to display the selected data.

  4. Click Properties to customize visual properties of the chart like colors and labels.

  5. Chart 3: Drag the Season column to the middle of the last empty section on the dashboard. You can select different seasons from the list and the other sections of the dashboard will change.

  6. Double click Tab 1, and rename the tab to Main Dash.

Checkpoint icon Check your progress

The following image shows the completed Main Dash tab.

The following image shows the completed Main Dash tab.




Task 5: Visualize data on the second tab in the dashboard

preview tutorial video To preview this task, watch the video beginning at 03:45.

Follow these steps to add visualizations to the second tab in the dashboard:

  1. Click the Add new tab icon to create a second tab.

  2. In the pane that opens, select the 2 by 2 template icon that is divided in 4 sections, and click OK.

  3. Chart 1: Create a bar chart that shows the number of transactions for each promotion by season.

    1. Click the Visualizations icon to show the visualizations panel.

    2. Drag the Bar icon to the middle of an empty section of the dashboard to create an empty bar chart. The Fields panel displays on the right.

    3. Drag the following columns of data in Bakery and weather data.csv to their respective fields in the Fields panel:

      1. Drag the Season column onto the Bars field.

      2. Drag the No of Transactions column to the Length field.

      3. Drag the Promotion column to the Color field.

  4. Chart 2: Create a scatter chart that shows the number of transactions versus the dollar value in a given month.

    1. Click the Visualizations icon to show the visualizations panel.

    2. Drag the Scatter icon to the middle of an empty section of the dashboard to create an empty scatter chart. The Fields panel displays on the right.

    3. Drag the following columns of data in Bakery and weather data.csv to their respective fields:

      1. Drag the No of Transactions column to the x-axis field.

      2. Drag the Sales in USD column to the y-axis field.

      3. Drag the Month column to the Points field.

  5. Chart 3: Create a stacked column chart to gain insight on how season affects the sale of product groups.

    1. Click the Visualizations icon to show the visualizations panel.

    2. Drag the Stacked column icon to the middle of an empty section of the dashboard to create an empty stacked column chart. The Fields panel displays on the right.

    3. Drag the following columns of data in Bakery and weather data.csv to their respective fields:

      1. Drag the Product group column to the Bars field.

      2. Drag the Sales in USD column to the Length field.

      3. Drag the Season column to the Color field.

    4. Modify the stacked column chart to show the average number of sales for each season.

      1. In the Fields panel, click the 3 dots next to Sales in USD.

      2. In the context menu that opens, click Summarize > Average. You can also create your own calculation by clicking Calculation in the context menu instead.

  6. Chart 4: Create a map that visualizes the number of transactions spatially by state.

    1. Hold down Ctrl on your keyboard, and click No of Transactions and State to select them.

    2. Drag the selected columns of data over into the middle of the last empty section on the dashboard. The dashboard service determines the best way to display the selected data. The Fields panel displays on the right.

    3. Click Properties, and on the Visualization tab, customize the map appearance by removing the legend and disabling the automatic zoom.

      1. In the Legend section, select the Show legend toggle to turn it off.

      2. In the Chart section, select the Automatic zoom toggle to turn it off.

    4. Click the General tab in the Visualization properties panel to add a title.

      1. In the Appearance section, select the Show title toggle to turn it on.

      2. Type the title you want to give your map.

  7. You can modify the theme for the entire dashboard like the theme and background color.

    1. Click a blank space anywhere in the dashboard pane to deselect the chart.

    2. In the Dashboard properties panel, expand the Color and theme section, and select Dark in the Visual theme drop-down box.

Checkpoint icon Check your progress

The following image shows the completed tab.

The following image shows the completed tab.




Task 6: Interact with visualizations in a dashboard

preview tutorial video To preview this task, watch the video beginning at 05:49.

Follow these steps to interact with all of the visualizations in each tab. All of the visualizations in a single tab are linked by default.

  1. Click one of the data points on the scatter chart. The rest of the charts should change based on the point you selected.

  2. Click the filter icon in the top right corner of any of the charts to see any filters that have been applied.

  3. Click the remove icon for each filter you want to remove and clear all of the filters.

  4. Create filters for users to interact with by dragging columns of data to the All tabs filter pane or the This tab filter pane.

    • Filters in the All tabs filter pane are available across all tabs.

    • Filters in the This tab filter pane are only available in current tab that you have selected.

      1. Drag the Weather data to the All tabs filter pane.

      2. Confirm the tab named Tab 1 is selected and drag the Season data to the This tab filter pane.

  5. Double click Tab 1, and rename it to Custom charts.

Checkpoint icon Check your progress

The following image shows the finished dashboard.

The following image shows the finished dashboard.




Task 7: Share a dashboard

preview tutorial video To preview this task, watch the video beginning at 06:45.

Follow these steps to enable dashboard sharing to provide others with a link to the dashboard.

  1. Click the Save icon to save the dashboard.

  2. Click the Share icon.

  3. In the window that opens, select the Share with anyone who has the link toggle to turn it on. This makes the dashboard publicly viewable to anyone who has the link.

  4. Copy the link, and click Close.

  5. Paste the URL into the search bar of your browser to view and interact with the dashboard at that URL.

Checkpoint icon Check your progress

The following image shows the shared dashboard.

The following image shows the shared dashboard.



Next steps

Now you can use this data set for further analysis. For example, you or other users can do any of these tasks:

Additional resources

Parent topic: Quick start tutorials

Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more