Real time insights & intelligent Data Warehousing for We Are Social
To help We Are Social operate with greater clarity at scale, Firney implemented an ERP-inspired data foundation that connects teams, centralises systems, and delivers real-time operational insight across the business.
Real time insights & intelligent Data Warehousing for We Are Social
To help We Are Social operate with greater clarity at scale, Firney implemented an ERP-inspired data foundation that connects teams, centralises systems, and delivers real-time operational insight across the business.
What we achieved
Background
Goal: Enhance operational clarity through a unified view of operations
We Are Social, a global creative agency, recognised an opportunity to harness their data for a competitive edge. Due to their rapid expansion, their information (project management, client relations, and resource planning) were fragmented across multiple systems. They sought to empower their teams with instant, reliable insights to support strategic decision-making and unlock new efficiencies.
“Unifying our platforms has given us a source of truth for our global operations, eliminating guesswork and creating a foundation of reliable data.”
We addressed these challenges by drawing on ERP principles to connect their best-in-class tools and data into one data warehouse, using Google Cloud.
Our solution
This flexible system powers a suite of real-time Looker dashboards, giving teams across the globe a unified view of sales pipeline health, team utilisation, and project, client and company profitability.
- Centralised Data Integration:
- Consolidated project, CRM, and analytics data into a cloud data warehouse, eliminating silos and creating a single, trusted data foundation.
- CRM Data Reliability:
- Delivered a seamless Salesforce-BigQuery integration to ensure customer and pipeline data was always accurate and accessible.
- Scalable Reporting & Dashboards:
- Built interactive Looker dashboards, enabling teams to self-serve insights and leadership to monitor performance in real time.
- Streamlined Resourcing:
- Integrated Workbook and Float, aligning project data with scheduling to improve capacity planning and resource allocation.
Firney has given us the clarity we needed to run our global business more effectively. We can now see what’s happening in real-time, which allows us to be more agile and strategic.
Automating their data has transformed We Are Social's operations. They now produce faster, more accurate financial reports and have gained the day-to-day clarity needed to make smarter, more confident business decisions.
