jsoma / data-studio-projects

12 stars 18 forks source link

[Project] Nike spent a lot on advertising. Is it useful? #276

Open dz2383 opened 6 years ago

dz2383 commented 6 years ago

Pitch

Summary

I found Nike's North America revenue from 2009-2018 and Nike's revenue worldwide from 2005 to 2018 . Also, I got its worldwide advertising spent and US advertising spent.

I want to make bar graphs for each excel I got, then compare the relationship of advertising spent and net income using the year's percentage changes.

My assumption is: as marketing spent increase, overall revenue increase and net income increase.

Here are some bar charts I want to create: revenue in North america:

screen shot 2018-08-06 at 10 21 39 pm

ad spent in North America:

screen shot 2018-08-06 at 10 28 33 pm

Details

Possible headline(s): The more marketing spent, the more net income Data set(s): Nike's US revenue from 2009-2018 Nike's revenue worldwide from 2005 to 2018 . direct-to-consumer revenue worldwide ad spent worldwise ad spent US. Code repository:

Possible problems/fears/questions:

Checklist

This checklist must be completed before you submit your draft.

sarahslo commented 6 years ago

let's get some more labeling on your chart. the value is in millions if US dollars, yes? also it can be helpful to change a font for the year or the scale to differentiate them. one can be bold for instance.

you are also missing a label that says, what the chart is. so this is Nike's worldwide revenue? when you make the next round of charts, give us some labeling. :)