Provide the total purchased amount of dollars for each Genre?
The graph shows that there are 24 out Total purchases in $ dollars for each Genre
of 25 types of Genre that were ordered type
826.7
900.0
by the customers. It tells us that the
800.0
most purchased Genre is Rock with 700.0
Types of Genre
826.7 of total dollars, which considered 600.0
382.1
as the top line within the Music Store 500.0
261.4
241.6
(outlier). However, Latin, Metal, and 400.0
300.0
Alternative & Punk range between
93.5
79.2
200.0
60.4
57.7
40.6
40.6
39.8
29.7
27.7
almost 250-400 dollars. While the total
19.8
17.9
16.8
14.9
13.9
12.9
11.9
11.9
11.9
9.9
5.9
100.0
dollar of other genres ranges between 0.0
Electronica/Dance
Metal
R&B/Soul
Rock And Roll
Comedy
Pop
Jazz
Bossa Nova
Alternative
Hip Hop/Rap
Reggae
Alternative & Punk
Latin
World
Soundtrack
Sci Fi & Fantasy
Drama
Blues
TV Shows
Rock
Easy Listening
Heavy Metal
Science Fiction
Classical
$100-0, Meanwhile, Rock and Roll have
the lowest total od dollars with only
$5.9.
Total purchases in $ for each Genre
For each type of Playlist, How many type of Genre did they have?
Number of purchased Genres in each As presented in the graph, shows critical
Playlist insights about customers preferences.
25 Which tend mostly toward the Music
20
20 playlist, means this playlist contributes with
Types of Playlist
16
15
a high percentage of revenue to the Music
Store with 20 types of the purchased
10
5
genre, generates substantial traffic for the
3 3 5
1 1 1 1
2 2 2 music store. The second type of playlist
0 that contribute to the highest traffic goes to
On-The-Go 1
Music Videos
Classical 101 - The
Brazilian Music
Grunge
Classical 101 - Next
Classical 101 - Deep
Heavy Metal Classic
Classical
TV Shows
90's Music
Music
90’s Music, which has 16 number of
Basics
purchased genre. Meanwhile, Other
Steps
Cuts
playlists have a low number of purchased
Genres that range between 1 to 5 only.
Number of ordered Genre in each Playlist Therefore, it means that it generates weak
traffic for the store.
Provide the Name of the Media Type in each Top Playlist with the largest amount of
total sales that is Above 50 dollars
As the graph shows, three main types of
The Media name used in each purchased media that have been used mostly by the
Playlist with a maximum amount of total customer for the Music Store’s product
Maximum total profits of sales for each playlist
sales that is Above $ 50 with maximum sales that are above $50.
4500
3912.48 There are only three types of playlists that
4000
3500 generate the most significant amount of
3000 total sales. Their total is above 50
2500 dollars, which means other invisible
2000
playlists have total sales the are below
1500
884.07 1000
$50. The outstanding performance of
441.78 289.08
59.4 500 media type goes to “MPEG audio file,”
0 which mostly was used for Music Playlist
TV Shows Music 90’s Music Music 90’s Music
with almost $4000 of total dollars,
Protected Protected AAC audio file MPEG audio file
MPEG-4 video whereas 90’s Music has around 1000
file dollars. Meanwhile, other media have the
the Name of the largest playlist for each Media Type
largest amount of total sales that range
between $500 to $50.
How many customer for each Sales Support Agent that they mange?
The number of a managed The graph shows that there are three
customer for each Employee as employees at the music store with a Sales
Sales Support Agent Support Agent title. Moreover, Jane has
22 the highest total of 21 customers that she
Number of Customer
21
21 was in response to their sales. But for
20
19
20 Steve, he only had an answer to only 18
18 customers.
18
17
16
Jane Peacock Margaret Park Steve Johnson
The Sales Support Agent responsible name for each
customers