際際滷

際際滷Share a Scribd company logo

Data Visualization Challenge - Product Performance analysis

Download as PPTX, PDF
Nicola Sandoli
Nicola Sandoli

How our beers are performing since the beginning of the year ? This is quite a standard question! Product performances are usually defined by 3 KPIs: - Revenues; Budget; Last Year

1 of 6
Download to read offline
@sandolinic Birra Bellazzi management asks: How have our beers performed since the beginning of the year? This is quite a standard question! Product performances are usually defined by 3 KPIs: Revenues Budget Last Year Data Visualization Challenge Data extracted on Apr 15th All Measures are Year to Date PRODUCT LINE REVENUES BUDGET LAST YEAR JAKE 120 150 89 JAKE PIMPED 73 80 53 ALLEY HOP 154 120 157 MY BO 236 280 321 JANA 92 100 122 CALABRIFORNIA 182 110 98 Year to Date REVENUES - BUDGET - LAST YEAR by Product [k]
@sandolinic Approach #1 Starting with the standards: - Insert a default Bar Chart I dont like this view! It is too difficult to understand Although I will probably change the overall approach I will try to fix the Legend. Bar Chart (1/2) #DataViz ChallengePRODUCT LINE REVENUES BUDGET LAST YEAR JAKE 120 150 89 JAKE PIMPED 73 80 53 ALLEY HOP 154 120 157 MY BO 236 280 321 JANA 92 100 122 CALABRIFORNIA 182 110 98 Year to Date REVENUES - BUDGET - LAST YEAR by Product [k] 0 50 100 150 200 250 300 350 JAKE JAKE PIMPED ALLEY HOP MY BO JANA CALABRIFORNIA Year to Date REVENUES - BUDGET - LAST YEAR by Product [k] REVENUES BUDGET LAST YEAR
@sandolinic LEGEND tip - Remove the legend - Embed legend colors within the title Still, I dont like this view! Three bars in the same chart make it too difficult to understand. I need a different approach. What do I have: - 3 KPI - REVENUE is the main one - BUDGET & LAST YEAR are supporting KPI Bar Chart (2/2) #DataViz ChallengePRODUCT LINE REVENUES BUDGET LAST YEAR JAKE 120 150 89 JAKE PIMPED 73 80 53 ALLEY HOP 154 120 157 MY BO 236 280 321 JANA 92 100 122 CALABRIFORNIA 182 110 98 Year to Date REVENUES - BUDGET - LAST YEAR by Product [k] 0 50 100 150 200 250 300 350 JAKE JAKE PIMPED ALLEY HOP MY BO JANA CALABRIFORNIA Year to Date REVENUES - BUDGET - LAST YEAR by Product [k]
@sandolinic Bar Chart series #DataViz ChallengePRODUCT LINE REVENUES BUDGET LAST YEAR BDG % LY % JAKE 120 150 89 20% -35% JAKE PIMPED 73 80 53 9% -38% ALLEY HOP 154 120 157 -28% 2% MY BO 236 280 321 16% 26% JANA 92 100 122 8% 25% CALABRIFORNIA 182 110 98 -65% -86% Year to Date REVENUES - BUDGET - LAST YEAR by Product [k] Year to Date REVENUES - BUDGET - LAST YEAR by Product [k] -35% -38% 2% 26% 25% -86% LAST YEAR % 20% 9% -28% 16% 8% -65% BUDGET % 120 73 154 236 92 182 JAKE JAKE PIMPED ALLEY HOP MY BO JANA CALABRIFORNIA REVENUES Approach #2 - 3 KPI probably means 3 charts - I try with 3 aligned bar charts - This time I use the % values for Budget and Last Year I like this solution way better! i.e. - CALABRIFORNIA performed way better than expected and Bellazzi was able to improve the results for this beer. - ALLEY HOP is under budget but it is 2% up compared with last year: something went wrong with the budgeting phase
@sandolinic Approach #3 Want they want is to understand if a Beer: - reached its budget - performed better or worse then last year Maybe a Bullet Graph is the solution I am looking for! Compared with previous approaches: - It provides the same information - It takes less space Issues: - Not many BI tools can draw it - No horizontal bullet graph with Excel Bullet Graph* #DataViz Challenge A bullet graph is a variation of a bar graph developed by Stephen Few More information: http://en.wikipedia.org/wiki/Bullet_graph Create Bullet Graphs in Excel: http://youtu.be/sAmWAiwUVIQ PRODUCT LINE REVENUES BUDGET LAST YEAR BDG% LY % MY BO 236 280 321 16% 26% CALABRIFORNIA 182 110 98 -65% -86% ALLEY HOP 154 120 157 -28% 2% JAKE 120 150 89 20% -35% JANA 92 100 122 8% 25% JAKE PIMPED 73 80 53 9% -38% Year to Date REVENUES - BUDGET - LAST YEAR by Product [k] 0 50 100 150 200 250 300 350 MY BO CALABRIFORNIA ALLEY HOP JAKE JANA JAKE PIMPED Year to Date REVENUES - BUDGET - LAST YEAR by Product [k]
@sandolinic Thank you to for sponsoring this Episode Data Visualization Challenge Contacts: info@birrabellazzi.it @birrabellazzi www.facebook.com/BirraBellazzi

More Related Content

Data Visualization Challenge - Product Performance analysis

  • 1. @sandolinic Birra Bellazzi management asks: How have our beers performed since the beginning of the year? This is quite a standard question! Product performances are usually defined by 3 KPIs: Revenues Budget Last Year Data Visualization Challenge Data extracted on Apr 15th All Measures are Year to Date PRODUCT LINE REVENUES BUDGET LAST YEAR JAKE 120 150 89 JAKE PIMPED 73 80 53 ALLEY HOP 154 120 157 MY BO 236 280 321 JANA 92 100 122 CALABRIFORNIA 182 110 98 Year to Date REVENUES - BUDGET - LAST YEAR by Product [k]
  • 2. @sandolinic Approach #1 Starting with the standards: - Insert a default Bar Chart I dont like this view! It is too difficult to understand Although I will probably change the overall approach I will try to fix the Legend. Bar Chart (1/2) #DataViz ChallengePRODUCT LINE REVENUES BUDGET LAST YEAR JAKE 120 150 89 JAKE PIMPED 73 80 53 ALLEY HOP 154 120 157 MY BO 236 280 321 JANA 92 100 122 CALABRIFORNIA 182 110 98 Year to Date REVENUES - BUDGET - LAST YEAR by Product [k] 0 50 100 150 200 250 300 350 JAKE JAKE PIMPED ALLEY HOP MY BO JANA CALABRIFORNIA Year to Date REVENUES - BUDGET - LAST YEAR by Product [k] REVENUES BUDGET LAST YEAR
  • 3. @sandolinic LEGEND tip - Remove the legend - Embed legend colors within the title Still, I dont like this view! Three bars in the same chart make it too difficult to understand. I need a different approach. What do I have: - 3 KPI - REVENUE is the main one - BUDGET & LAST YEAR are supporting KPI Bar Chart (2/2) #DataViz ChallengePRODUCT LINE REVENUES BUDGET LAST YEAR JAKE 120 150 89 JAKE PIMPED 73 80 53 ALLEY HOP 154 120 157 MY BO 236 280 321 JANA 92 100 122 CALABRIFORNIA 182 110 98 Year to Date REVENUES - BUDGET - LAST YEAR by Product [k] 0 50 100 150 200 250 300 350 JAKE JAKE PIMPED ALLEY HOP MY BO JANA CALABRIFORNIA Year to Date REVENUES - BUDGET - LAST YEAR by Product [k]
  • 4. @sandolinic Bar Chart series #DataViz ChallengePRODUCT LINE REVENUES BUDGET LAST YEAR BDG % LY % JAKE 120 150 89 20% -35% JAKE PIMPED 73 80 53 9% -38% ALLEY HOP 154 120 157 -28% 2% MY BO 236 280 321 16% 26% JANA 92 100 122 8% 25% CALABRIFORNIA 182 110 98 -65% -86% Year to Date REVENUES - BUDGET - LAST YEAR by Product [k] Year to Date REVENUES - BUDGET - LAST YEAR by Product [k] -35% -38% 2% 26% 25% -86% LAST YEAR % 20% 9% -28% 16% 8% -65% BUDGET % 120 73 154 236 92 182 JAKE JAKE PIMPED ALLEY HOP MY BO JANA CALABRIFORNIA REVENUES Approach #2 - 3 KPI probably means 3 charts - I try with 3 aligned bar charts - This time I use the % values for Budget and Last Year I like this solution way better! i.e. - CALABRIFORNIA performed way better than expected and Bellazzi was able to improve the results for this beer. - ALLEY HOP is under budget but it is 2% up compared with last year: something went wrong with the budgeting phase
  • 5. @sandolinic Approach #3 Want they want is to understand if a Beer: - reached its budget - performed better or worse then last year Maybe a Bullet Graph is the solution I am looking for! Compared with previous approaches: - It provides the same information - It takes less space Issues: - Not many BI tools can draw it - No horizontal bullet graph with Excel Bullet Graph* #DataViz Challenge A bullet graph is a variation of a bar graph developed by Stephen Few More information: http://en.wikipedia.org/wiki/Bullet_graph Create Bullet Graphs in Excel: http://youtu.be/sAmWAiwUVIQ PRODUCT LINE REVENUES BUDGET LAST YEAR BDG% LY % MY BO 236 280 321 16% 26% CALABRIFORNIA 182 110 98 -65% -86% ALLEY HOP 154 120 157 -28% 2% JAKE 120 150 89 20% -35% JANA 92 100 122 8% 25% JAKE PIMPED 73 80 53 9% -38% Year to Date REVENUES - BUDGET - LAST YEAR by Product [k] 0 50 100 150 200 250 300 350 MY BO CALABRIFORNIA ALLEY HOP JAKE JANA JAKE PIMPED Year to Date REVENUES - BUDGET - LAST YEAR by Product [k]
  • 6. @sandolinic Thank you to for sponsoring this Episode Data Visualization Challenge Contacts: info@birrabellazzi.it @birrabellazzi www.facebook.com/BirraBellazzi