Data Visualization with Microsoft Power BI

Part II Quiz

1. Choose the source data table that will allow us to create this waterfall chart.

   

   1. Factor	Value
      TARGET	3,200
      Sales	-24
      Materials	39
      Production	-110
      Marketing	-145
      Distribution	-66
      Others	-42
      ACTUAL	2,852

   2. Factor	Version	Total
      Sales	TARGET	500
      Materials	TARGET	550
      Production	TARGET	600
      Marketing	TARGET	650
      Distribution	TARGET	700
      Others	TARGET	200
      Sales	ACTUAL	476
      Materials	ACTUAL	589
      Production	ACTUAL	490
      Marketing	ACTUAL	505
      Distribution	ACTUAL	634
      Others	ACTUAL	158

   3. Factor	Target	Actual
      Sales	500	476
      Materials	550	589
      Production	600	490
      Marketing	650	505
      Distribution	700	634
      Others	200	158

2. Which waterfall chart is depicted incorrectly?

   

   

   

3. Which funnel chart is applied correctly?

   

4. We have the data in the table. What visualization would be better to create based on this data?

   Stage	Number
   Response	16
   Initial interview	11
   Test	7
   Re-interview	5
   Job offer	3
   Recruitment	2