There were different data sources which I had to merge as all of those were used in different views within same dashboard and multi-select filters had to work on that, I have cleansed and merged the data using Alteryx and made sure that the granularity of the data is not disturbed in the dashboard and implemented several dashboards with relevant KPI's using the cleansed data source

Lead a team of 4 people and developed backend database by gathering customer experience data and relate it with transactional data.

Brainstorm on the requirement and create Mock-up accordingly.

Developed & scheduled Tableau dashboard to display relevant KPIs enabling decision making.

Setting goals & threshold for Store/Region managers from various demographics & historical scores across drivers.

Created good visualizations using Tableau to report these metrics with their goal attainment to executives

Worked on analysis to change the business decision like:

Holiday period analysis: Suggested items that needs to be filled (stock issues) with respect to store/period & let them know on shortage of resources to fit part time employees.

Bike analysis: Inferred customers buying bikes wait longer from problematic department. Excluded bike customers for reporting so that store managers are not penalized

Managing resource utilization by changing pricing strategy

Test Control Analysis to measure Campaign effectiveness

Red store analysis

NPS deep dive

Item Preference Analysis

New vs Returning customers

churn rate

Customer concepts