Visualize data

You can use Tableau visualizations to display insights that have been discovered in the data.

When you connect to a 1010data table or a custom SQL query in Tableau, a series of dimensions (usually categories of data) and measures (usually quantitative data) are dynamically discovered from its metadata. You can then create data visualizations from this data. When you choose a particular visualization type in Tableau, Tableau tells you how many dimensions and measures are required for the visualization. For example, a pie chart visualization requires 1 or more dimensions and 1 or 2 measures. You can also drag and drop the data you are interested in, and Tableau will present the data using the most appropriate visualization.

The following example shows how to create a simple bar graph showing total sales by day for a single store for the year 2019.

To create a simple data visualization:

  1. Connect to 1010data from Tableau.
    If you have already connected to 1010data, select it from the To a Server list.

    If your connection is successful, you will see your connection in the Data Source tab of the Tableau screen.
  2. From the Database drop-down list, select tenten.
  3. From the Schema drop-down list, select retaildemo.
  4. Drag sales_detail to Drag tables here.
  5. Click the Sheet 1 tab at the bottom left of the window to begin your visualization.
  6. Find the Marks card (between the Data pane and the sheet display area). Select Bar from the drop-down list.
  7. Select Date from the Dimensions section in the Data pane. Drag Date to the Filters shelf.
    A Filter Field [Date] dialog appears.

  8. Select the Years filter.
  9. Click Next.
    The Filter [Year of Date] dialog appears.

  10. Select 2019.
  11. Click OK.
  12. Select Store from the Measures section of the Data pane. Drag Store to the Filters shelf.
  13. With Store, repeat the filtering steps you performed for Date, choosing Store 10.
  14. Click OK.
  15. Drag the Date column to the Columns area.
  16. Click the down arrow to the right of the date. Select Day from the drop-down list.
  17. Drag the Xsales column to the Rows area.
    Tableau automatically provides the sum of sales in the Rows area.
  18. Change the chart formatting as desired.