1 of 5

Chinook DB Analysis #DFND

PROJECT 3

2 of 5

#1 What are customer distribution among sales agents?

The Customer distribution among sales agents are nearer to each other as depicted

Steve Johnson-30.5%

Jane Peacock-35.6%

Margaret Park-33.9%

This implies that there is near to uniform customer distribution among sales agents.

3 of 5

#2 Which playlist has the maximum track?

Total 8715 Tracks-

“Music” playlist has the maximum number of tracks constituting 75.5%, the 2nd in the list is “90s Music” with 16.9% coverage and 3rd is “TV Shows” with 4.9% coverage.

4 of 5

#4 Which media type has the most unit sold?

According to the data-set MPEG Audio file is most sold with the maximum count of 1976 units,the 2nd most sold unit is of Protected AAC audio file and 3rd most sold format is Protected MPEG-4 Video file.The 2nd and 3rd preferred formats are quite nearly preferred and preferred very less in comparison to the 1st one. This also shows,audio files are preferred over video files.

5 of 5

#4 Which Bands/Artists are in top 10 as per Sales total?

Included here heading as “Bands/Artists” because some artist perform solo and they are counted as Artist not band.Overall,the performers are of two types-Band-type,Solo-type

Top 10 Bands /Artists on the basis of units sold are-Iron Maiden,U2,Metallica,Led Zeppelin, Lost,The Office,OSParallamas Do Successo,Deep Purple,Faith No More,Eric Clapton.

Among all highest sales acquired by Iron Maiden near to 150 counts as in the visual. 9th and 10th ones have nearly same sales as per the visual.

​