Designing and implementing a streamlined dashboard for our Canada based online retailer client was a unique experience for us.
One of our client, a Canada based manufacturer and online retailer of kitchen and garden equipment products, has its sales across 6 countries namely Canada, US, UK, France, Germany and Japan, using Amazon as an online retail platform.
Amazon provides sales, inventory, competitor rankings, PPC (Price Per click) and other data on Amazon Seller Central. However, each country has a different data source and currency. Consolidating this data on a single platform is a major challenge. Moreover, analyzing this enormous aggregated data and generating day to day report out of it is a critical task.
SP consulting came up with a solution of designing a consolidated dashboard with the aid of which client can monitor his business at the click of a button.
We designed and developed a centralized database in SQL Azure that stores data from different countries in a single repository.
In the next stage, MS excel based tools were developed that pick up downloaded amazon seller data from different countries inserts that in a newly designed centralized database.
Our team members worked side-by side with teams from the client company and came with the smart analytic framework of the dashboard. The uniquely designed dashboard was an automated real-time dashboard.
Considering the advance features for graphics and computations and user friendly advantage of Power BI technology we decided to go with it to create dashboard. The dashboard contains following reports. All data can be filtered by country, team, product SKU, name, category, sub category and time.
SP consulting delivered a remarkable solution of consolidated dashboard which offered deeper data pool and unique analytic framework that would unlock all the data possibilities to yield actionable conclusions. Benefits gained by our client are listed below:
A Canada based online Retailer on Amazon
SP consulting implemented a database framework to consolidate Amazon central data across 6 countries (Canada, US, UK, France, Germany and Japan) and developed dashboard for Sales and Marketing departments. The sales data from different countries was aggregated into single currency.