Lab 3 - Graded Lab
In this lab you will work with USDA dataset - in shared files.
Write answers for analysis questions using Text Box inside Qlik View application file.
- First, we will learn how to load data into QlikView application.
- Buid a bar chart with Expression Group. Dimension: Description.
Expressions: Sum(Cholesterol), Sum(Calories), Sum(VitaminC).
To create an Expression Group,
highlight second expression
and select Group. Perform the same action with the third
exression. Sort by Y-Value in Descending Order.
On Dimensions Limit Tab, show only 10 Largest value and clear Show
Others.
Analysis: Find an item with MAX Cholesterol, MAX Vitamin C
and MAX Calories.
- Build a Scatter Chart to find a correlation between
Carbohydrate and Protein content in different foods. Dimension:
Description. Expressions: X: Carbohydrate, Y: Protein.
On Presentation Tab, make symbol size 6pt.
Analyze the result.
- Find correlation between different
components of your choice and analyze the results: for instance, Cholesterol vs.
TotalFat, VitaminC vs.
Calories, etc. For each pair, build an appropriate chart and perform analysis.