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:
Click on File->New.
Select Query with SQL and our recently used connection from the MySQL database.
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...