Reference no: EM132718222

1. Create a dashboard that answers the following two questions:
What is the total number of disputed items?
What is the total number of disputed items per item category?
Your dashboard should look as follows:

Make sure to use the exact same formatting: color of Text box, "NUMBER OF DISPUTED ITEMS" in descending order, borders, etc.

2. Create a dashboard that ranks artists based on percentage (%) of disputed items (descending order).
Include icons using the following rules:

Make sure to use the exact same formatting: Inclusion of icons, icon colors, "NUMBER OF DISPUTED ITEMS" in descending order, borders, etc.

3. Create a dashboard that shows the following information for each of the renowned artists:

The artist's name
The total prize money earned by the artist
The number of prizes the artist has won

4. Create the dashboard below, which shows the following information for each artist:
The artist's name
The number of outstanding items (length of bar)
Make sure to include the two vertical bars, which indicate:
avoid ordering from artists with 10 or more outstanding items (the red line).
be cautious ordering from artists with 5 or more outstanding items (the orange line).

5. Create the dashboard below, which shows the total number of items bought per week.
The chart starts from week six since Kado's first items were delivered on February 6. The slicer can be used to display, for each week, the number of items bought of a specific item category.

6. Create the Box and Whisker chart below to explore the differences in revenue generated across product (item) categories and by the different product (item) types within a product category.

Make sure to use the exact same formatting: titles x-axis and y-axis, color data points, color means, border, etc.

7. Create a dashboard that answers the following two questions:
What is the total amount Kado owes artists (vendors) (Accounts Payable)?
What is the total amount Kado each artist?

8. Create a dashboard that shows Revenue ANALYSIS
Using Matrix table (look at the example posted in ilearn) design a dashboard that provides information regarding the profitability of item types (revenue -cost) offered by Coop1. Such information is helpful when making decisions such as:
• What products are profitable
• What categories are profitable
• Should they focus on selling a specific item type or category?

9. Design your own dashboard that answers a question you want to explore in the dataset (you should come with your own question that requires you to create a new measure).

Attachment:- Box and Whisker chart.rar