Customer segmentation and behaviour analysis – Client Project – Alcohol Retailer
● Led customer segmentation project to target churn, enabling tailored promotions and retention strategies
● Analyzed repeat and occasional shopper behaviours using Tableau, informing a nuanced understanding of customer dynamics
● Led competitor analysis, integrating API data to assess neighbouring store influence on sales, guiding strategic decisions
● Consulted with client to determine the best metrics to be displayed on final product
Identifying postcodes for charity to target for donations – Client Project - Charity
● Employed Alteryx for data processing, pinpointing target postcodes based on income, donor activity, and donation thresholds
● Created a dashboard using Tableau revealing key demographic insights, aiding in targeted marketing strategies
● Enhanced fundraising efforts by identifying target postcodes and providing actionable insights through demographic analysis
Streamlining Financial Reporting with Dynamic Tableau Dashboards – Client Project - Transportation
● Transformed Excel profit and loss statements into dynamic Tableau dashboards
● Implemented drill-down functionality for detailed account analysis within Tableau
● Automated monthly statement generation in Tableau, streamlining manual processes
● Utilized Tableau's LOD calculations for dynamic financial reporting needs
Identify business and employee performance – Client Project - Sales
● Utilized SQL to extract data from several different related tables from Snowflake databases
● Conducted data preparation in Tableau Prep, combining tables and cleaning data ready for visualizing in Tableau
● Developed a Tableau dashboard with dynamic alerts to track salespeople's performance across metrics and targets