Music Industry Evolution

Description :

Music sales in the 1900s were dominated by Physical formats like Records, Cassettes, CD's but after the launch of iTunes in 2003 this dominance shifted from Physical format to Digital format.

Tool Used : Microsoft Excel

Key Objective of Dashboard :

1. Using data from the RIAA to visualize how the composition of the music market has changed over the last 40 years for physical and digital formats?
2. Select an Effective Chart in Excel.
3. Use formatting to eliminate noise.
4. Add context to help tell the story.

Observation:

1. In 1999, Music Industry having highest revenue of $22 billion.
2. After the launch of iTunes in 2003, Physical format music revenue goes down & Digital format music showing its dominance in Music Industry, but revenues are half of what they were in their peak.

Data Source : RIAA (Recording Industry Association of America) - Physical & Digital Format Music Revenue from 1973 to 2019.

Dimensions & Measures :

1. Dimensions : Year
2. Measures : Revenue (Physical vs. Digital formats)

Concept Covered :

1. Inserting Charts.
2. Modifying Chart Elements.
3. Customizing Axis Labels.
4. Inserting Shapes.
5. Saving Chart as a Picture.