The visualization data tab

After preparing data, we can start to work with it more closely. In other words, we can visualize it with the charts in SAP Lumira.

Let's take a look at the visualization tab, and try various options and menus in order to build sharp visualizations like a data geek. Perform the following steps:

1. Click on File->New.

2. Select Query with SQL and our recently used connection from the MySQL database.

3. Enter the dataset name as Business Analytics and paste this SQL query:

   SELECT
     dim_products.Category,
     dim_products.`Sub-category`,
     dim_products.Brand,
     dim_products.Gender,
     dim_orders.Shipping_City_Name,
     dim_orders.Shipping_Method,
     fct_sales.Order_Date,
     dim_products.Price,
     sum(fct_sales.Revenue),
     sum(fct_sales.Shipped_Item),
     sum(dim_orders.Order_Shipped)
   FROM   
     dim_orders INNER JOIN fct_sales ON (dim_orders.Order_Id=fct_sales.Order_Id)
      INNER JOIN dim_products ON (dim_products.Article_Id=fct_sales.Article_Id)
     
   GROUP BY
     dim_products.Category, 
     dim_products...