Experience our team has delivered.

/01 Case studies

The problem, what we did, and what changed.

• Case study · Hospitality

  Building an analytics function from scratch on Databricks and Power BI

  The platform keeps breaking

  The business had no internal reporting. We designed and built its whole analytics layer, from dimensional models on a new Databricks warehouse to self-service Power BI reporting, then set the architecture, modelling standards, governance and roadmap to take it forward.

  Results

  • →From no internal reporting to a full analytics layer
  • →Reporting on revenue, sales, marketing and website performance
  • →Self-service reporting for business users
  • →Data architecture, modelling standards and governance in place

  StackDatabricks · Power BI · DAX · SQL

• Case study · Financial services

  Consolidating 200+ Power BI reports into one trusted suite

  Nobody trusts the numbers

  An investment platform had more than 200 reports across 20+ apps, each with its own code and queries buried inside, and several versions of the truth. We built a single semantic model as the source of truth, moved the logic into it, and put it under version control with testing before each release.

  Results

  • →200+ reports consolidated into one suite
  • →One semantic model as the single source of truth
  • →Business logic in one place, not buried in each report
  • →In-house team trained in DAX and modelling

  StackPower BI · DAX · Microsoft Fabric

• Case study · Financial services

  Cutting an operations backlog by 75% with automated transaction monitoring

  Too manual, too slow

  Working with the financial crime team, we analysed a large set of transaction data to find the patterns behind common suspicious activity. Percentile analysis turned those patterns into clear rules. Manual reports and data scanning gave way to an automated process, and the team now steps in only when a transaction is flagged.

  Results

  • →Operations backlog down 75%
  • →Clear, data-backed rules for suspicious activity
  • →Manual scanning replaced by automated flagging

  StackSQL · Power BI

• Case study · Financial services

  Board KPIs and finance automation on Snowflake and dbt

  Nobody trusts the numbers

  We agreed the definitions of the board metrics (ARR, active customers, marketing spend, SLA) with their owners, built them in dbt on Snowflake and served them through Power BI. Reverse ETL into Salesforce automated invoicing and customer lookups.

  Results

  • →10–15 live dashboards across Operations, Finance, Marketing, People and leadership
  • →Board KPIs on agreed definitions
  • →Invoicing and customer lookups automated

  StackSnowflake · dbt · Power BI · Salesforce

No case studies match those filters yet. Choose “All” to see every one.