Worldwide Commerce Performance

...

After exploring all of these business questions and analyzing them, I have come up with a plan to improve revenues and reduce costs. Tables, being sold frequently, but having negative profits is not ideal. The selling price of tables should certainly be increased; it is an item that is selling so it will not stop selling due to the price increase. Also, when looking at sales by month I have noticed that in June of every year since 2011 we have had increase sales. In order to create upward spikes for all twelve months of the year, we need to see what we are doing differently in June and implement it in all other months. I also strongly recommend we increase marketing techniques, especially in the months of July and October. I want to implement intense advertising for both of those months, to increase sales, which will take away from our downward trends in those months and give more profits overall. June is doing well in every category, except table’s margin and profits, as I can see by the heat map. Increasing the price of tables and increasing marketing techniques should increase revenues with this problem. With regard to countries, Canada and Netherland’s marketing techniques need to be altered, I would also recommend increased advertising in these country with TV and radio commercials all around the country. Canada’s market is emerging, but needs an extra push to be a competitor. The Netherlands are making the lowest profits in the EU, so I would like to improve that aspect with new marketing and advertising techniques.

After using Tableau to guide me in my questions and analysis, I have been able to make my recommendations to improve our current business approach. I strongly suggest management takes my recommendations into consideration. I was able to pin point exactly where our faults as a company lie, and what can be done to improve them. Without improving the certain countries, products, and seasons, profits and margins will not continue to grow and we won’t grow as a company. After implementing these proposals, I see no reason for the company not to prosper.

[pic 1]

[pic 2]

[pic 3]

Krystal Hamama

Data Analytics Director

...