狠狠撸

狠狠撸Share a Scribd company logo
Music Store Data Analysis
1) INSIGHTS
? Senior most employee is Mohan Madan (Senior General Manager)
? Number of employees are more at junior level and as the seniority level increases number of employees decreases.
Name title levels
MohanMadan Senior General Manager L7
Andrew Adams General Manager L6
NancyEdwards Sales Manager L4
Michael Mitchell IT Manager L3
Robert King IT Staff L2
Laura Callahan IT Staff L2
Jane Peacock Sales Support Agent L1
Margaret Park Sales Support Agent L1
Steve Johnson Sales Support Agent L1
3
2
1 1 1 1
Sales Support
Agent
IT Staff Senior General
Manager
IT Manager General
Manager
Sales Manager
Count Of Employee Per Post
1) Who is the senior most employee, find name and job title.
2) Which countries have the most Invoices?
131
61
50
21
10
USA Brazil France India Australia
North America South America Europe Asia Oceania
Top Countries In Each Continent With Most Invoices
Continents Number of invoices Count of Country
Europe 297 17
North America 207 2
South America 79 3
Asia 21 1
Oceania 10 1
? It is clearly seen from the more the number of countries more will the number of invoices.
? Maximum countries are from Europe only.
? Europe is on the top in terms of invoices generated ,instead of this countries of Europe fail to be top in terms of invoices generated(Top country is of North
America(USA).
? USA played a major role in terms of invoices invoice generated in North America.
billing_country billing_city total
France Bordeaux 23.76
Canada Montréal 19.799999
Canada Winnipeg 19.799999
Canada Toronto 19.799999
Czech Republic Prague 19.799999
USA Orlando 18.809999
3) What are top 3 values of total invoice?
? Top 3 values of total invoice contain 4 Countries.
4) Cities with top customers
273.24
169.29 166.32 158.40 151.47
Prague Mountain View London Berlin Paris
InvoiceTotal
? These are the cities having in terms of maximum total invoice.
? So for throw a promotional music festival , choose any one of these.
? It is better to choose Prague because top 2 customers also belong to this city only(as shown next page graph).
144.54
128.70
114.84 111.87 108.90
Franti?ek Wichterlová Helena Hol? Hugh O'Reilly Manoj Pareek Luís Gon?alves
Prague Prague Dublin Delhi S?o José dos Campos
Czech Republic Czech Republic Ireland India Brazil
TotalSpent
5) Top 5 Customers In terms Of Total Money They Spend.
Customer
City
Country
6) Most Popular Music Genre For Each Country In Terms Of Purchase
Country Genre_name
Argentina Alternative & Punk
Australia Rock
Austria Rock
Belgium Rock
Brazil Rock
Canada Rock
Chile Rock
Czech Republic Rock
Denmark Rock
Finland Rock
France Rock
Germany Rock
Hungary Rock
India Rock
Ireland Rock
Italy Rock
Netherlands Rock
Norway Rock
Poland Rock
Portugal Rock
Spain Rock
Sweden Rock
United Kingdom Rock
USA Rock
Genre Count of Genre_name
Alternative & Punk 1
Rock 23
Grand Total 24
? Rock is the only music genre which is popular in all country except Argentina.
287
252
226
213
151
122
111 104 94 93
U2 Led
Zeppelin
Deep
Purple
Iron
Maiden
Pearl Jam Van Halen The Rolling
Stones
Kiss Queen Nirvana
7) TOP 10 Artist Who Have Written The Most Rock Music
19.80
19.80
19.80
23.76
27.72
Aaron Mitchell
Fran?ois Tremblay
Franti?ek Wichterlová
Wyatt Girard
Hugh O'Reilly
9) Amount Spend By Customer On Artist (TOP 5 Customers)
cust_name billing_city
HughO'Reilly Dublin
Wyatt Girard Bordeaux
AaronMitchell Winnipeg
Fran?oisTremblay Montréal
Franti?ekWichterlová Prague
10) Customer Spend Most On Music (TOP 5 Customers)
144.54
114.84 111.87 108.90
102.96
Franti?ek
Wichterlová
Hugh O'Reilly Manoj Pareek Luís Gon?alves Jo?o Fernandes
Czech Republic Ireland India Brazil Portugal
2) Conclusions
? Number of employees are less at senior level as compared to junior level.
? Maximum countries(where customers belongs) are from Europe only( ~70%).
? Maximum total invoice amount is from Prague city also top two customers in terms of money they spend also belongs to this city only.
? Rock is the only music genre which is popular in all country except Argentina in terms of purchase.
? U2 is the artist who has written the most rock music
THANK YOU
Ad

Recommended

Lagos School of Programming Final Project Updated.pdf
Lagos School of Programming Final Project Updated.pdf
benuju2016
?
music store.pdf
music store.pdf
YaminiSharma869205
?
Music Store Sales Analysis-- SQL Project
Music Store Sales Analysis-- SQL Project
mayanksri461994
?
Music world
Music world
Udayan Sikdar
?
Music Business for Fun & Profit 1
Music Business for Fun & Profit 1
MusicBusinessSource
?
Infomgmt Assignment 1 Real Groovy
Infomgmt Assignment 1 Real Groovy
namelis1
?
Interview with Faryal Khan-Thompson — SVP Marketing & Community, CD Baby.docx
Interview with Faryal Khan-Thompson — SVP Marketing & Community, CD Baby.docx
Faryal Khan Thompson
?
Recorded music industry – labels (2007)
Recorded music industry – labels (2007)
clacourt
?
The Current Situation Facing Real Groovy 1
The Current Situation Facing Real Groovy 1
sangjin LIM
?
Recording industry analysis
Recording industry analysis
JRolix
?
Basic Music Industry Research
Basic Music Industry Research
georgieann_
?
LT2014N - The South African Music Market 2010
LT2014N - The South African Music Market 2010
Marian Z.
?
Poster Information
Poster Information
Mark Williams
?
Around Asia'a Key Markets: Music Industry Overview
Around Asia'a Key Markets: Music Industry Overview
Branded Ltd
?
Situation analysis
Situation analysis
Nova Granite
?
Schulich MBA SGMT 6000 HMV
Schulich MBA SGMT 6000 HMV
Jeremy Wong
?
ChiragBansal_Dissertation.pdf
ChiragBansal_Dissertation.pdf
chiragbansal953902
?
Music industry 2017
Music industry 2017
Naamah Hill
?
Real Groovy - ibei001
Real Groovy - ibei001
_ian_
?
Music business
Music business
Diaz Bai
?
Info191 Assignment 1 Bcho032
Info191 Assignment 1 Bcho032
mojoblazer
?
Universal Music Group - SWOT, PEST, Porter Analysis
Universal Music Group - SWOT, PEST, Porter Analysis
Kevin Zi Liu
?
Top of mind Música & Mercado 2013 M.I and Pro Audio market in Brazil
Top of mind Música & Mercado 2013 M.I and Pro Audio market in Brazil
Música & Mercado
?
Record label
Record label
Alex McDowell
?
Flaxwood Guitars, Perspective of a "new" player entering the market - Rick Ne...
Flaxwood Guitars, Perspective of a "new" player entering the market - Rick Ne...
TonalInnovationCenter
?
Institutions and marketing
Institutions and marketing
latymermedia
?
Reorganization of music industry
Reorganization of music industry
Tamam Guseinova
?
Music industry 2015
Music industry 2015
JenniferAnnTrimnell
?
CIm production and industrail enasics.pdf
CIm production and industrail enasics.pdf
MuditK4
?
Computer numeric control cnc Machines.pdf
Computer numeric control cnc Machines.pdf
MuditK4
?

More Related Content

Similar to 2) Project PPT.pptxhhjhjgbbnnnnnnnnjkkkkk (20)

The Current Situation Facing Real Groovy 1
The Current Situation Facing Real Groovy 1
sangjin LIM
?
Recording industry analysis
Recording industry analysis
JRolix
?
Basic Music Industry Research
Basic Music Industry Research
georgieann_
?
LT2014N - The South African Music Market 2010
LT2014N - The South African Music Market 2010
Marian Z.
?
Poster Information
Poster Information
Mark Williams
?
Around Asia'a Key Markets: Music Industry Overview
Around Asia'a Key Markets: Music Industry Overview
Branded Ltd
?
Situation analysis
Situation analysis
Nova Granite
?
Schulich MBA SGMT 6000 HMV
Schulich MBA SGMT 6000 HMV
Jeremy Wong
?
ChiragBansal_Dissertation.pdf
ChiragBansal_Dissertation.pdf
chiragbansal953902
?
Music industry 2017
Music industry 2017
Naamah Hill
?
Real Groovy - ibei001
Real Groovy - ibei001
_ian_
?
Music business
Music business
Diaz Bai
?
Info191 Assignment 1 Bcho032
Info191 Assignment 1 Bcho032
mojoblazer
?
Universal Music Group - SWOT, PEST, Porter Analysis
Universal Music Group - SWOT, PEST, Porter Analysis
Kevin Zi Liu
?
Top of mind Música & Mercado 2013 M.I and Pro Audio market in Brazil
Top of mind Música & Mercado 2013 M.I and Pro Audio market in Brazil
Música & Mercado
?
Record label
Record label
Alex McDowell
?
Flaxwood Guitars, Perspective of a "new" player entering the market - Rick Ne...
Flaxwood Guitars, Perspective of a "new" player entering the market - Rick Ne...
TonalInnovationCenter
?
Institutions and marketing
Institutions and marketing
latymermedia
?
Reorganization of music industry
Reorganization of music industry
Tamam Guseinova
?
Music industry 2015
Music industry 2015
JenniferAnnTrimnell
?
The Current Situation Facing Real Groovy 1
The Current Situation Facing Real Groovy 1
sangjin LIM
?
Recording industry analysis
Recording industry analysis
JRolix
?
Basic Music Industry Research
Basic Music Industry Research
georgieann_
?
LT2014N - The South African Music Market 2010
LT2014N - The South African Music Market 2010
Marian Z.
?
Around Asia'a Key Markets: Music Industry Overview
Around Asia'a Key Markets: Music Industry Overview
Branded Ltd
?
Schulich MBA SGMT 6000 HMV
Schulich MBA SGMT 6000 HMV
Jeremy Wong
?
Music industry 2017
Music industry 2017
Naamah Hill
?
Real Groovy - ibei001
Real Groovy - ibei001
_ian_
?
Music business
Music business
Diaz Bai
?
Info191 Assignment 1 Bcho032
Info191 Assignment 1 Bcho032
mojoblazer
?
Universal Music Group - SWOT, PEST, Porter Analysis
Universal Music Group - SWOT, PEST, Porter Analysis
Kevin Zi Liu
?
Top of mind Música & Mercado 2013 M.I and Pro Audio market in Brazil
Top of mind Música & Mercado 2013 M.I and Pro Audio market in Brazil
Música & Mercado
?
Flaxwood Guitars, Perspective of a "new" player entering the market - Rick Ne...
Flaxwood Guitars, Perspective of a "new" player entering the market - Rick Ne...
TonalInnovationCenter
?
Institutions and marketing
Institutions and marketing
latymermedia
?
Reorganization of music industry
Reorganization of music industry
Tamam Guseinova
?

More from MuditK4 (7)

CIm production and industrail enasics.pdf
CIm production and industrail enasics.pdf
MuditK4
?
Computer numeric control cnc Machines.pdf
Computer numeric control cnc Machines.pdf
MuditK4
?
Toyota_Supply_Chain_Case_Study.pptx case
Toyota_Supply_Chain_Case_Study.pptx case
MuditK4
?
awfknflkanwl management project notes5.pdf
awfknflkanwl management project notes5.pdf
MuditK4
?
project management 4aadadwdwafawffawf.pdfadfa
project management 4aadadwdwafawffawf.pdfadfa
MuditK4
?
PPawdwdawadadwddfsfssfsefesfsfT UNIT2.pdf
PPawdwdawadadwddfsfssfsefesfsfT UNIT2.pdf
MuditK4
?
Unit-3.pdf mechanical enginnering hydraulics
Unit-3.pdf mechanical enginnering hydraulics
MuditK4
?
CIm production and industrail enasics.pdf
CIm production and industrail enasics.pdf
MuditK4
?
Computer numeric control cnc Machines.pdf
Computer numeric control cnc Machines.pdf
MuditK4
?
Toyota_Supply_Chain_Case_Study.pptx case
Toyota_Supply_Chain_Case_Study.pptx case
MuditK4
?
awfknflkanwl management project notes5.pdf
awfknflkanwl management project notes5.pdf
MuditK4
?
project management 4aadadwdwafawffawf.pdfadfa
project management 4aadadwdwafawffawf.pdfadfa
MuditK4
?
PPawdwdawadadwddfsfssfsefesfsfT UNIT2.pdf
PPawdwdawadadwddfsfssfsefesfsfT UNIT2.pdf
MuditK4
?
Unit-3.pdf mechanical enginnering hydraulics
Unit-3.pdf mechanical enginnering hydraulics
MuditK4
?
Ad

Recently uploaded (20)

Fundamental Analysis for Dummies.pdf somwmdw
Fundamental Analysis for Dummies.pdf somwmdw
ssuserc74044
?
Veilig en vlot fietsen in Oost-Vlaanderen: Fietssnelwegen geoptimaliseerd met...
Veilig en vlot fietsen in Oost-Vlaanderen: Fietssnelwegen geoptimaliseerd met...
jacoba18
?
unit- 5 Biostatistics and Research Methodology.pdf
unit- 5 Biostatistics and Research Methodology.pdf
KRUTIKA CHANNE
?
apidays Singapore 2025 - 4 Identity Essentials for Scaling SaaS in Large Orgs...
apidays Singapore 2025 - 4 Identity Essentials for Scaling SaaS in Large Orgs...
apidays
?
最新版美国佐治亚大学毕业证(鲍骋础毕业证书)原版定制
最新版美国佐治亚大学毕业证(鲍骋础毕业证书)原版定制
Taqyea
?
Managed Cloud services - Opsio Cloud Man
Managed Cloud services - Opsio Cloud Man
Opsio Cloud
?
Pause Travail 22 Hostiou Girard 12 juin 2025.pdf
Pause Travail 22 Hostiou Girard 12 juin 2025.pdf
Institut de l'Elevage - Idele
?
apidays New York 2025 - Life is But a (Data) Stream by Sandon Jacobs (Confluent)
apidays New York 2025 - Life is But a (Data) Stream by Sandon Jacobs (Confluent)
apidays
?
REGRESSION DIAGNOSTIC II: HETEROSCEDASTICITY
REGRESSION DIAGNOSTIC II: HETEROSCEDASTICITY
Ameya Patekar
?
apidays New York 2025 - Beyond Webhooks: The Future of Scalable API Event Del...
apidays New York 2025 - Beyond Webhooks: The Future of Scalable API Event Del...
apidays
?
Power BI API Connectors - Best Practices for Scalable Data Connections
Power BI API Connectors - Best Practices for Scalable Data Connections
Vidicorp Ltd
?
5. & 9. Packing material and Labelling_AP-60,XP-60.pdf
5. & 9. Packing material and Labelling_AP-60,XP-60.pdf
maricruzduranpaterni
?
YEAP !NOT WHAT YOU THINK aakshdjdncnkenfj
YEAP !NOT WHAT YOU THINK aakshdjdncnkenfj
payalmistryb
?
Addressing-the-Air-Quality-Crisis-in-New-Delhi.pptx
Addressing-the-Air-Quality-Crisis-in-New-Delhi.pptx
manpreetkaur3469
?
最新版美国芝加哥大学毕业证(鲍颁丑颈肠补驳辞毕业证书)原版定制
最新版美国芝加哥大学毕业证(鲍颁丑颈肠补驳辞毕业证书)原版定制
taqyea
?
apidays New York 2025 - The Future of Small Business Lending with Open Bankin...
apidays New York 2025 - The Future of Small Business Lending with Open Bankin...
apidays
?
11th International Conference on Data Mining (DaMi 2025)
11th International Conference on Data Mining (DaMi 2025)
rinzindorjej
?
SAP_S4HANA_EWM_Food_Processing_Industry.pptx
SAP_S4HANA_EWM_Food_Processing_Industry.pptx
vemulavenu484
?
METHODS OF DATA COLLECTION (Research methodology)
METHODS OF DATA COLLECTION (Research methodology)
anwesha248
?
SQL-Demystified-A-Beginners-Guide-to-Database-Mastery.pptx
SQL-Demystified-A-Beginners-Guide-to-Database-Mastery.pptx
bhavaniteacher99
?
Fundamental Analysis for Dummies.pdf somwmdw
Fundamental Analysis for Dummies.pdf somwmdw
ssuserc74044
?
Veilig en vlot fietsen in Oost-Vlaanderen: Fietssnelwegen geoptimaliseerd met...
Veilig en vlot fietsen in Oost-Vlaanderen: Fietssnelwegen geoptimaliseerd met...
jacoba18
?
unit- 5 Biostatistics and Research Methodology.pdf
unit- 5 Biostatistics and Research Methodology.pdf
KRUTIKA CHANNE
?
apidays Singapore 2025 - 4 Identity Essentials for Scaling SaaS in Large Orgs...
apidays Singapore 2025 - 4 Identity Essentials for Scaling SaaS in Large Orgs...
apidays
?
最新版美国佐治亚大学毕业证(鲍骋础毕业证书)原版定制
最新版美国佐治亚大学毕业证(鲍骋础毕业证书)原版定制
Taqyea
?
Managed Cloud services - Opsio Cloud Man
Managed Cloud services - Opsio Cloud Man
Opsio Cloud
?
apidays New York 2025 - Life is But a (Data) Stream by Sandon Jacobs (Confluent)
apidays New York 2025 - Life is But a (Data) Stream by Sandon Jacobs (Confluent)
apidays
?
REGRESSION DIAGNOSTIC II: HETEROSCEDASTICITY
REGRESSION DIAGNOSTIC II: HETEROSCEDASTICITY
Ameya Patekar
?
apidays New York 2025 - Beyond Webhooks: The Future of Scalable API Event Del...
apidays New York 2025 - Beyond Webhooks: The Future of Scalable API Event Del...
apidays
?
Power BI API Connectors - Best Practices for Scalable Data Connections
Power BI API Connectors - Best Practices for Scalable Data Connections
Vidicorp Ltd
?
5. & 9. Packing material and Labelling_AP-60,XP-60.pdf
5. & 9. Packing material and Labelling_AP-60,XP-60.pdf
maricruzduranpaterni
?
YEAP !NOT WHAT YOU THINK aakshdjdncnkenfj
YEAP !NOT WHAT YOU THINK aakshdjdncnkenfj
payalmistryb
?
Addressing-the-Air-Quality-Crisis-in-New-Delhi.pptx
Addressing-the-Air-Quality-Crisis-in-New-Delhi.pptx
manpreetkaur3469
?
最新版美国芝加哥大学毕业证(鲍颁丑颈肠补驳辞毕业证书)原版定制
最新版美国芝加哥大学毕业证(鲍颁丑颈肠补驳辞毕业证书)原版定制
taqyea
?
apidays New York 2025 - The Future of Small Business Lending with Open Bankin...
apidays New York 2025 - The Future of Small Business Lending with Open Bankin...
apidays
?
11th International Conference on Data Mining (DaMi 2025)
11th International Conference on Data Mining (DaMi 2025)
rinzindorjej
?
SAP_S4HANA_EWM_Food_Processing_Industry.pptx
SAP_S4HANA_EWM_Food_Processing_Industry.pptx
vemulavenu484
?
METHODS OF DATA COLLECTION (Research methodology)
METHODS OF DATA COLLECTION (Research methodology)
anwesha248
?
SQL-Demystified-A-Beginners-Guide-to-Database-Mastery.pptx
SQL-Demystified-A-Beginners-Guide-to-Database-Mastery.pptx
bhavaniteacher99
?
Ad

2) Project PPT.pptxhhjhjgbbnnnnnnnnjkkkkk

  • 1. Music Store Data Analysis
  • 3. ? Senior most employee is Mohan Madan (Senior General Manager) ? Number of employees are more at junior level and as the seniority level increases number of employees decreases. Name title levels MohanMadan Senior General Manager L7 Andrew Adams General Manager L6 NancyEdwards Sales Manager L4 Michael Mitchell IT Manager L3 Robert King IT Staff L2 Laura Callahan IT Staff L2 Jane Peacock Sales Support Agent L1 Margaret Park Sales Support Agent L1 Steve Johnson Sales Support Agent L1 3 2 1 1 1 1 Sales Support Agent IT Staff Senior General Manager IT Manager General Manager Sales Manager Count Of Employee Per Post 1) Who is the senior most employee, find name and job title.
  • 4. 2) Which countries have the most Invoices? 131 61 50 21 10 USA Brazil France India Australia North America South America Europe Asia Oceania Top Countries In Each Continent With Most Invoices Continents Number of invoices Count of Country Europe 297 17 North America 207 2 South America 79 3 Asia 21 1 Oceania 10 1 ? It is clearly seen from the more the number of countries more will the number of invoices. ? Maximum countries are from Europe only. ? Europe is on the top in terms of invoices generated ,instead of this countries of Europe fail to be top in terms of invoices generated(Top country is of North America(USA). ? USA played a major role in terms of invoices invoice generated in North America.
  • 5. billing_country billing_city total France Bordeaux 23.76 Canada Montréal 19.799999 Canada Winnipeg 19.799999 Canada Toronto 19.799999 Czech Republic Prague 19.799999 USA Orlando 18.809999 3) What are top 3 values of total invoice? ? Top 3 values of total invoice contain 4 Countries.
  • 6. 4) Cities with top customers 273.24 169.29 166.32 158.40 151.47 Prague Mountain View London Berlin Paris InvoiceTotal ? These are the cities having in terms of maximum total invoice. ? So for throw a promotional music festival , choose any one of these. ? It is better to choose Prague because top 2 customers also belong to this city only(as shown next page graph).
  • 7. 144.54 128.70 114.84 111.87 108.90 Franti?ek Wichterlová Helena Hol? Hugh O'Reilly Manoj Pareek Luís Gon?alves Prague Prague Dublin Delhi S?o José dos Campos Czech Republic Czech Republic Ireland India Brazil TotalSpent 5) Top 5 Customers In terms Of Total Money They Spend. Customer City Country
  • 8. 6) Most Popular Music Genre For Each Country In Terms Of Purchase Country Genre_name Argentina Alternative & Punk Australia Rock Austria Rock Belgium Rock Brazil Rock Canada Rock Chile Rock Czech Republic Rock Denmark Rock Finland Rock France Rock Germany Rock Hungary Rock India Rock Ireland Rock Italy Rock Netherlands Rock Norway Rock Poland Rock Portugal Rock Spain Rock Sweden Rock United Kingdom Rock USA Rock Genre Count of Genre_name Alternative & Punk 1 Rock 23 Grand Total 24 ? Rock is the only music genre which is popular in all country except Argentina.
  • 9. 287 252 226 213 151 122 111 104 94 93 U2 Led Zeppelin Deep Purple Iron Maiden Pearl Jam Van Halen The Rolling Stones Kiss Queen Nirvana 7) TOP 10 Artist Who Have Written The Most Rock Music
  • 10. 19.80 19.80 19.80 23.76 27.72 Aaron Mitchell Fran?ois Tremblay Franti?ek Wichterlová Wyatt Girard Hugh O'Reilly 9) Amount Spend By Customer On Artist (TOP 5 Customers) cust_name billing_city HughO'Reilly Dublin Wyatt Girard Bordeaux AaronMitchell Winnipeg Fran?oisTremblay Montréal Franti?ekWichterlová Prague
  • 11. 10) Customer Spend Most On Music (TOP 5 Customers) 144.54 114.84 111.87 108.90 102.96 Franti?ek Wichterlová Hugh O'Reilly Manoj Pareek Luís Gon?alves Jo?o Fernandes Czech Republic Ireland India Brazil Portugal
  • 12. 2) Conclusions ? Number of employees are less at senior level as compared to junior level. ? Maximum countries(where customers belongs) are from Europe only( ~70%). ? Maximum total invoice amount is from Prague city also top two customers in terms of money they spend also belongs to this city only. ? Rock is the only music genre which is popular in all country except Argentina in terms of purchase. ? U2 is the artist who has written the most rock music