Lab 2
- In this lab you will work with file ABC_Sales_data (make sure
you are
openning an ORIGINAL FILE, not the modified one you created last week)
- Open ABC_Sales_data and then save it with the following name:
ABC_Sales_data_Lab2_YourInitials
- You will write answers to analysis questions in QlikView file, using
Text Object. I will show how to work with Text Objects at the beginning of
the lab
Follow the steps below to design visualizations and answer
analysis questions
Submit the application file (QlikView file) on Campus Cruiser. Make sure you answer all
analysis
questions inside the application file using Text Objects.
- When you open the file ABC_Sales_data, the first
Sheet
is called
Main. On Main Sheet, create SIX List Boxes showing the following fields:
- CategoryName
- CompanyName
- SalesPerson
- Year
- Quarter
- Month
- Working with List Boxes you created, answer the following
Analysis
Questions:
- 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?
- Which customers (Company Names)
have never
purchased a product from the category
Baby Clothes
- Create New Sheet "Product Details"
- 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, and
write $ for Symbol, M$ for Million Symbol, K$ for Thousand Symbol
- 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)
- 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.
- Analysis Question: Analyze sales by Year for Top 3 products from Men's Footwear
category. Try to
describe the
sales pattern.
- 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
- Answer the following Analysis question: write the name and
the ratio of sales
for Category with most sales and for Category
with least sales.
- Build the Line Chart to show the Order Trend. Use Dimension: Year,
and Expression: Count(Distinct
OrderID). Sort Year by Numeric Value in Ascending order. On Axes tab choose Show Grid
for Dimension and
Expression
- Add additional dimension to the line chart,
CategoryName and compare trends between
Baby Clothes and Children's Clothes (Hint: First, select both categories in the List
Box CategoryName on the Main Sheet. To select both categories together, first select
Baby Clothes, then hold Ctrl Key and select the second category)
- Analysis Question: Write 3 analysis questions of your choice and answer
your
questions. While creating your questions, try to use ALL charts you created in this lab