​Data Warehouse Strategy

GETTING ACCESS to information about your business and using it to achieve strategic company objectives differentiates successful companies in the highly competitive, global marketplace. Whether through the acquisition of new businesses or the implementation of disparate transaction systems, data is often inaccessible to the people who need it most.  A data warehouse that integrates information about your business, your customers and your competitors may be the solution.

The Challenge

But is data warehousing right for you?  What are the implications?  What are your options?  What are your priorities?  If your instincts tell you that your organisation is missing an opportunity to exploit business intelligence systems, but you’re not sure where or how, this service offering is designed to clear the air and help you move ahead at Internet speed.  It’s a potent way to align your business with market demands, using information technology as the enabler.
​
BISOFT, a leader in data warehousing, has the expertise to effectively put data warehousing to work for you.  The critical first step toward realising the benefit of a data warehouse is the development of a plan that supports the strategic business objectives, with data warehouse strategy, technical architecture, and an implementation roadmap. The Data Warehouse and Business Intelligence Strategy, an offering from BISOFT, is available to assist organisations in constructing such a vision and plan.

Data Warehouse Strategy Overview

The DW&BI Strategy is a framework for data warehouse development and deployment.  It aligns information needs with strategic business objectives in order to guide the development effort toward the areas of highest relevance and value to the organisation.  Factors covered in a DW&BI Strategy include the following:

Business Requirements

  • Gather and review reference materials
  • Obtain strategic goals and vision of the data warehouse
  • Define objectives and purpose of data warehouse
  • Collect business information requirements
  • Create high-level subject area data model
  • Build business case for data warehouse

Data Quality

  • Determine initial data quality
  • Document error and exception handling procedures
  • Develop data quality management process

Data Acquisition

  • Identify high level data sources
  • Document source system process flows
  • Document existing data source system(s) interfaces
  • Determine data warehouse interface requirements
  • Conduct subject area gap analysis
  • Document data publishing requirements
  • Develop first-time load process
  • Develop ongoing data acquisition process

Technical Architecture

  • Document system operational requirements
  • Prepare initial data warehouse capacity plan
  • Prepare initial data warehouse technical architecture
  • Develop initial backup and recovery strategy
  • Develop initial security and control strategy
  • Determine service level objectives
  • Recommend hardware & software foundation
  • Create technical risk assessment
  • Develop data warehouse infrastructure requirements

​Warehouse Management

  • Determine administration practices
  • Design management reporting

Metadata Management

  • Develop metadata strategy
  • Determine metadata management practices
  • Develop metadata transition plan

Customer Benefits

The Data Warehouse and Business Intelligence (DW&BI) Strategy targets warehouses of almost any size – from single area data warehouses to total enterprise implementations. Project deliverables include a set of business requirements, technical architectures and implementation plans that are essential to the success of the data warehouse. The DW&BI Strategy will provide the following benefits upon successful completion:
  • Focus on the business intelligence opportunities with greatest benefit
  • Blueprint and framework for deploying a high-quality data warehouse
  • Shorter time-frame to a production-ready, fully operational data warehouse
  • Technical architecture implementation roadmap supportive of additional functionality
  • Methods to familiarise your staff with the best practices and proven techniques to develop a business intelligence capability and data warehouse
  • Knowledge transfer between skilled BISOFT consultants and your own staff when understanding specific business intelligence opportunities and leveraging the latest proven BISOFT data warehouse architectures

Customer Deliverables

​​The main deliverable is a document describing the strategy for the areas listed above along with the data warehouse needs and delivery approach.

Getting Started

DW&BI Strategy Services prices depend on the size of the organisation, business coverage and technology standards already in place, but typically start at $25,000* with a duration of three weeks, rising to around $100,000* for an eight-week engagement that requires two experienced consultants. 
​
Use BISOFT’s DW&BI Strategy to guide your organisation through implementing a data warehouse.  We will discuss your requirements and then create a project proposal for review and approval.

*Exclusive of  GST and expenses