Case study for a BI self-sufficiency solution for a direct marketing company
Once businesses realise that they need to place data at the core of their operation, decision-making and optimisation efforts, they soon understand that a self-service BI platform is essential to their business. A self-service BI platform frees up data analysts to focus on more strategic work than reporting and allows business users to access the data they need. Traditional BI tools often fall short in the realisation of BI self-sufficiency.
By 2020, Gartner boldly predicts that self-service BI platforms will make up 80% of all enterprise reporting.
A Provider of home décor
BI and Data Analytics
Our client, a leading provider of direct marketing in the home décor market, required greater self-sufficiency in the analysis and reporting of their core business activities. They required a solution that allowed the marketing team to obtain information and analyse it without reliance on other departments or third-party software.
DVT provided BI architecture and development services and created the solution using Microsoft technologies. Using a Kimball based data warehouse, the solution transforms data from existing source systems and makes it available to the marketing department in dashboards, data cubes and reports. The process is fully automated and runs on a daily basis.
- SQL Server 2012
- SSRS Pivot Table
- Pivot Charts
- Power Pivot