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.