We used our Data3 Discovery Process to capture all business requirements in a series of workshops with key stakeholders, and reviewed all data and relevant business information. We setup a system to convert business logic into data logic. In this stage we also discovered which BI tool would be the best for this solution.
UK
Case Study – Offspring
Offspring is a social saving tool. It helps family and friends save together for important occasions. Offspring have setup an easy and secure way to send cash gifts. We designed, developed & launched a dashboard solution for Offspring to track customer savings and journeys through the Offspring Website.
The Vision
To develop a new reporting solution for Offspring to be able to see their data for customer savings as well as their customers’ website activity to inform product enhancements and management decision making
The Problem
Offspring wanted a solution with a direct connection into their Big
Query database solution, something that would be near to live with automated updates in a fast and simple dashboard
The Objectives
To design, build & launch a new reporting solution, with near live data, a clean simple design, which taps into Google Big Query as a fully automated solution
We used one data source for this project – the productivity study data collection platform.
1
DISCOVERY
GO/NO GO
2
DESIGN
GO/NO GO
We used our Data3 Design Process to design a reporting wireframe based on brand guidelines and ensuring the solution between PowerBI and Google Big Query direct query was robust enough to allow for a consistent near live automated refresh.
3
BUILD
LAUNCH
We used our Data3 Build Process to build, test and launch the new Offspring reporting solution. We created SQL views in Google Big Query to avoid any transformations in PowerBI which cannot be achieved with a direct query connection. We created a simple and clean reporting solution that uses automated direct query data pulls to make sure Offspring’s data is always up to date.
“The Data3 team helped create an analytics dashboard that helps us make product development decisions. Their approach is collaborative and while they created the dashboard to spec, they also suggested ways to present data to best match our business needs.”
AVINASH RAJAN, CEO, Offspring
x