Six relational tables that builtDashboard building of sales KPI and overall sales performance of an ecommerce. There are six relational tables that joined using Tableau.
Null data imputed with ‘unknown’ string and translating the portugese category to english using googletrans library.
Scorecard for main KPI metrics to monitor the ecommerce performances through time
Showing the time series of sales performance (sales & orders) for each months, geospatial data of which region that has high sales and bar chart performance of its AOV. The region map is dynamic, thus if one region clicked, all the data shows only specific region that clicked.
This section helps to get insights which category and seller that has the best performance. And also the current delivery status performance