Using Data Warehousing in Business Intelligence

Following on from my last post – How should I implement a Business Intelligence Solution? – Today I wanted to have a look at another key aspect of that- the Data Warehouse.

Any good foundation for a business intelligence project starts with a well thought out data warehouse design.

The purpose of an Enterprise Data Warehouse (EDW) should be to provide an all-encompassing view of your organisation from whatever view point you are interested in.

The warehouse itself can be a logical design which includes multiple data marts servicing different areas of the business. It could also be a simple, small schema that simply serves as a master data repository for your organisations hierarchical data sets.

The most important part of any data warehouse project is to plan, discuss, design and test until you have a fit for purpose solution.

The mistake made by many DW projects is that it will grow out of an operational data store into a read only repository that just services a bunch of reports. That falls very short of a solution that anyone in the organisation can hook into to enhance and aid their day to day work activities.

A well designed data warehouse tells a story about your company. How are you doing? Are you expanding or retracting? What are your primary income streams? Where is your effort being wasted? The list is endless, but that storey will help you make better informed decisions in your business giving you a large return on investment from your DW project.

Governance – Are you doing everything right? What is right? What is not? These questions are usually defined internally unless you are adhering to an external standard or governing board such as an ISO. Whatever your reasons, a good simple and solid governance policy coupled with a DW steering committee will ensure that your data warehouse stays on track and services the whole business….not just localised departments. With many years of experience in managing large scale data warehousing projects, along with the guidelines of an enterprise architecture standard, (TOGAF – The Open Group Architectural Framework), Dolphin Networks can help you create a successful data warehouse project, or build upon an existing one.

Data volumes are increasing at an alarming rate. How do we keep up? How do we organise all that data? Do we need it? How do we unlock any value from it? The answer can be as simple as organising it into a structured data warehouse where you can make sense of it all, create useful reporting that is meaningful, and apply governance to keep things in line.

Big Data – Structured, unstructured and natural data can now merge seamlessly together in a data driven project with the help of big data technology. Hadoop and Insights now have tools and solutions to bring the worlds of structured and unstructured data together. When utilising the structure of a well-defined data warehouse, the power of Hadoop and big data, the interaction of business intelligence and the flexibility, speed and ease of a cloud hosted solution, the possibilities of what you can do are limitless.

The subject of data warehousing is large, but the effort involved in creating one doesn’t have to be.


This is just a quick run through of how to deploy an EDW solution, for expert advice and help, contact Dolphin Networks.

Talk to us today about our outsourcing services. We have a team of specialised, expert consultants ready to help you with you BI project.

Arrange Call Back

[contact-form-7 404 "Not Found"]


Enjoyed reading? Spread the love