Build A Dashboard

In this section, we will use the same QDS Notebook used in previous exercise to create the following charts:

Total orders by date

  1. Switch over to Notebooks interface
  2. Click on {{ config['spark_dashboard_notebook_name'] }} notebook which we created for you. You can find the notebook on the right in the Common space.
  3. Execute the paragraph named Initialize by clicking button placed on the top right corner of the paragraph
  4. Execute the paragraph named Total orders by date by clicking button placed on the top right corner of the paragraph
  5. By default, you will see that the results are displayed in tabular format--which works for many types of datasets, but in this case it might make more sense to represent orders by date as a graph. In QDS Notebooks, this is easily done by clicking on a chart icon.

Now let’s look at how we can create interactive graph using the same dataset in our QDS Notebook. To accomplish this, we will take advantage of Apache Zeppelin’s dynamic forms capability and create three form fields - Month1, Month2 and Year.

Interactive chart - total orders by month range and year

  1. Execute the paragraph named Total orders by month range and year by clicking button placed on the top right corner of the paragraph
  2. As shown above, you are now able to easily query the data based on month range and year without havingto rewrite or modify the existing SQL. (Change month and year values to update chart.)

Top 5 products with total transactions per order status

  1. Execute the paragraph named Top 5 products with total transactions per order status by clicking button placed on the top right corner of the paragraph

Top 10 most viewed products vs revenue generated from sales

  1. Execute the paragraph named Top 10 most viewed products vs revenue by clicking button placed on the top right corner of the paragraph
  2. Key insight

    By inspecting the results closely you may realize that this list contains many of the products on the most sold list from previous exercise except one product: Adidas Kids' Mid Football Cleat. This product seems to be viewed a lot, but not purchased. In reality, there could be several reasons for this; for example, on the product view page where most visitors spent time, the sales path of the product can have a typo in the price.

    Note: Without access to efficient and interactive tool that enables analytics on high-volume semi-structured data, this loss of revenue could be missed for a long time.