ADVANCE DATA VISUALIZATION
PRACTICAL QUESTION BANK NOTES (Q11-Q20)
B.COM – BUSINESS ANALYTICS
SEM V
GLOBAL SUPER STORE ORDERS LINK
Global Super Store Data
Import Global Super Store Data from your files.
11. Percentage of total sales for each ‘Ship mode’.
Step1: Click on data
Step2: Click on New
Measure on Table Tool Bar
Step3: Enter “Total Sales = Sum(Orders[Sales])” and then click on tick mark.
Step4: A new field gets
added “Total Sales”
Step5: Go to “Report” just above the “Data”
Step6: Then select the table
from Visualizations.
Step7: Select “Ship Mode”
from the fields.
Step8: Select “Total Sales”
from the field.
Step9: Below the
visualizations there is columns field in that right click on the “Total Sales”.
Step10: Select the option
show values as
Step11: Click on Percent Of
Grand Total.
Step12: select the total sales and, now we can
view % of total sales as well as the total
sales.
Step13: Select pie chart from
visualizations.
Step14: Select Ship Mode and
Total Sales.
Q12. Category
with total sales higher than 4744000
Step1:
Select Matrix.
Step2: Drag
and drop Category on to the matrix.
Step3:
Drag and Drop total Sales on to the matrix.
Step4:
Drag and drop Total Sales on to the filters.
Step5:
Select Is Greater than from show items when the value
Step6:
Enter the value 4744000 and click on Apply filter.
Step7:
Filter is applied and we get Technology has greater value than 474400.
Q13: Insert
a pivot table shipping cost by category, region and segment.
Step1:
Select Matrix
Step2:
Drag and Drop Category and Shipping cost
Step3:
Select the bar graph.
Step4:
Drag and drop Category and Shipping cost
Step 5:
Select Matrix
Step6:
Drag and Drop Region and Shipping cost
Step7:
Select the bar graph.
Step8:
Drag and drop Region and Shipping cost
Step9:
Select Matrix
Step10:
Drag and Drop Segment and Shipping cost
Step11:
Select the bar graph.
Step12:
Drag and drop Segment and Shipping cost
In a new
sheet
Step 1:
Select Matrix
Step2:
Drag and Drop Region and Category in Rows
Step3:
Drag and Drop Segment in Columns
Step4:
Drag and Drop Shipping cost in Values
Step5:
Create a Decomposition Tree :
Step6:
Select Decomposition Tree
Step7:
Drag and drop Shipping cost
Step8:
Drag and drop Segment
Step9. Drag
and drop Category
Step10:
Drag and drop Region
Q14: Discount
by ship mode
Step1: Select Matrix
Step2: Drag and drop Discount and then ship Mode
Step3: Format the table as required
Step4: Select Doughnut Chart
Step5: Drag and drop Discount and then Ship mode
Step6 : Format as required.
Q15: Quantity
by segment and category
Step1:
Select Matrix
Step2: Drag and Drop Segment
Step3:
Drag and Drop Category and then quantity.
Step4:
Format the table as required
Step5:
Select a proper chart to visualize
Step6:
Drag and drop the fields
Q16: Make a decomposition table of sales.
Step1: Select the decomposition table.
Step2: Drag and Drop Sales
Step3: Drag and drop Segment
Step4: Select high value in the add on button.
Step5: Drag and drop Category
Step6: Drag and drop Sub-category
Step7: Drag and drop region
Step8: Drag and drop country
Step9: Drag and drop city
Q17:
Quantity over ship date. ( Insert line chart)
Step1:
Select the line chart
Step 2:
Drag and drop ship date
Step3:
Drag and drop quantity.
Q18:
Country and sales ______ country /profit / Quantity. Provide the maps.
Step1:
Select map.
Step2:
Drag and drop country
Step3:
Drag and drop sales
Step4:
Drag and drop profit
Q19.Ship mode & profit (doughnut
chart).
Step1: Select Doughnut chart
Step2: Drag and drop Ship Mode
Step3: Drag and Drop Profit
Q20.Discount shows a repeating
pattern over ship date.
Step1: Select line chart
Step2: Drag and drop ship date.
Step3: Drag and drop Discount.
Comments
Post a Comment