Case Studies

A collection of our software solutions projects and related services.

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.


Direct marketing


A Provider of home décor


BI and Data Analytics

Business Challenge

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 Solution

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
  • SSIS
  • SSAS
  • Tabular
  • SSRS Pivot Table
  • Pivot Charts
  • Power Pivot

DVT Services you may be interested in

Contact Us

If you require more information about our services, contact us today.

DVT 25 Years of Service