Case Studies

6 entries

Case Studies

Dashboards, data pipelines and automations — each written up as the problem, the constraint, the approach and what changed.

  1. 2025 Business intelligence Vodafone Stars Award, July 2025

    Dashboard for tracking Learning hours

    People Managers had no quick way to see learning hours across their direct and indirect reportees.

    Outcome Managers can spot lagging teams at a glance instead of filtering and interpreting manual reports.

    • Power BI
    • Power Query
    • DAX
  2. 2026 Process automation

    Automated Multilingual Email Flow

    Recurring email batches of 1,000+ recipients were prepared and sent by hand, across different languages and templates.

    Outcome Handles 1,000+ multilingual emails per batch and reduced manual workload by the equivalent of one FTE.

    • Power Automate
    • Excel
    • Outlook
  3. A product performance dashboard showed every filter and slicer at once and split comparisons across several pages.

    Outcome Less clutter, faster movement between views, and active filters visible without opening the pane.

    • Power BI
    • DAX
    • Bookmarks
  4. A dashboard depended on several source files with different structures, consolidated manually before each refresh.

    Outcome A refreshable, dashboard-ready dataset that updates when the source files change, with less manual preparation.

    • Power Query
    • Excel
    • Power BI
  5. In progress Reporting automation

    Automated Multi-File Excel Reporting with Python

    A recurring report had to be assembled by hand from multiple Excel files — merging columns and appending rows before reporting could start.

    Target Reduces report preparation from 12–16 hours of manual work to around 2 hours.

    • Python
    • pandas
    • NumPy
    • openpyxl
  6. In progress Text analytics

    eNPS Feedback Analysis with Python

    Natural-language eNPS feedback is hard to read at scale, so recurring themes in employee comments are easy to miss.

    Next (planned) Sentiment scoring — positive, neutral or negative — for each comment.

    • Python
    • pandas
    • scikit-learn
    • Plotly
    • openpyxl

Figures are illustrative diagrams of each mechanism, not screenshots of client or employer systems.