Lab 2

Follow the steps below to design visualizations and answer analysis questions

Submit the application file (QlikView file) on Canvas. Make sure you answer all analysis questions inside the application file using Text Objects.

  1. When you open the file ABC_Sales_data, the first Sheet is called Main. On Main Sheet, you already created SIX List Boxes showing the following fields:

  2. Working with List Boxes you created, answer the following Analysis Questions:
    1. What categories sells Company Bobby Socks? Who is the Sales Person who sold to this Company? In what year, quarter and month this Company placed orders?
    2. Which customers (Company Names) have never purchased a product from the category Baby Clothes

  3. Create New Sheet "Product Details"

  4. On Product Details Sheet build the BAR CHART titled "Sales by Product" with the Dimension: ProductName and Expression: Sum(LineSalesAmount) and Label the expression Sales. Sort by Y-value Descending. On Presentation Tab, Enable X-Axis Scrollbar. For the Number format setting, select Integer

  5. Analysis Question: Find the product from the Category Children's Clothes with most sales (Use an appropriate List Box on Main Sheet to make proper selection)

  6. Add the second dimension to the chart you created above to show sales by Product AND Year. Modify the chart by adding the second dimension, Year. MAKE SURE, Year IS THE SECOND DIMENSION. In the Style tab select, Stacked. On the Presentation tab, select Show Legend, and then click the Settings button. The Legend Settings dialog displays. Select Reverse Order.

  7. Analysis Question: Analyze sales by Year for Top 3 products from Men's Footwear category. Try to describe the sales pattern.

  8. To show Ratio of Sales between Categories, design a Pie Chart titled "Sales by Category" using Dimension: CategoryName, Expression Sum(LineSalesAmount). Label this expression Sales and select Relative to display relative values. In Presentation Tab, select Show Numbers in Legend

  9. Answer the following Analysis question: write the name and the ratio of sales for Category with most sales and for Category with least sales.