DATAMART DEVELOPMENT

DEVELOPMENT

A datamart is a repository designed to hold data specific to a given business purpose.  This is done by merging disparate databases into one centralised location, allowing greater visibility and improved business insights.

WHAT IS A DATAMART, AND HOW ARE THEY DEVELOPED?

Datamarts are developed and implemented to make it easier for business to get better value from data.  They are smaller than a data warehouse and usually aligned to a specific department or business project.  By combining different databases into one smaller repository, organisations can understand a person’s total relationship with their company, and their current and potential value.  To get an even better picture, relevant external data like Census and Quotable Value data and/or attitudinal research data can be appended.

DatamartDatamarts are fully customisable and can either be installed in-house or hosted externally at Datamine.  The data is regularly refreshed and cleaned (daily, weekly or monthly) to provide up-to-date, current and accurate data. This can easily be tracked and enable reporting on initiatives in order to develop a continuous learning and improvement culture.  Having a datamart with clean and accessible data also makes it much easier for Datamine to work on other data analytics projects, as the project delivery timeframe is reduced.

The first step of a Datamart Development project is a workshop with stakeholders to scope and understand the intended use for the datamart.  Questions to be answered:

  • Who are the 'users' for this datamart?  Marketing?  Product?  Risk?  IT?  All of the above?
  • What is the purpose of the datamart?  Analytics only?  Or will campaign lists be required?
  • What data sets are available and in what formats?  Who 'owns' these data sets within the business?
  • How and how often are they updated and how often can Datamine receive a data refresh?
  • Are there any 3rd party data sources of interest, e.g. Census.
  • What cleaning and processing will be required, e.g. Address cleaning?  Name cleaning?  Email pinging?
  • Is a Single Customer View (SCV) a development requirement at this stage?  Or later?
  • Who will host the datamart, Datamine or the client?

BENEFITS AND INDUSTRIES

Datamart business benefits:

  • Datamarts deliver value and ROI almost immediately

  • They’re scalable, agile and deliverlong term business value

  • Datamarts can be used as a stepping stone to a data warehouse, allowing clients to access and use relevant data while a warehouse is being built

  • One datamart can later be expanded to include additional datamarts, user-friendly reporting and campaign management data solutions

Industries covered:

  • Retail
  • FMCG
  • Banking and finance
  • Travel and Tourism
  • Telecommunications
  • Utilities
  • Healthcare
  • Insurance

CASE STUDY

Datamart

WHAT NEXT?

Schedule a free phone chat with a Datamine consultant

Interested in learning more about how Datamine could help you develop and implement a datamart?  Fill out the form below to schedule a call with us.