Data Management & Warehousing - Specialist Consultants in helping you and your Data Warehousing projects
 
 Data Management & Warehousing
 
 • Home • Knowledge Base • Hints & Tips • About Us • Contact Us • Bookmark Us • 
Log In

Username

Password

Remember Me



Main Menu


Quotes

"Each problem that I solved became a rule which served afterwards to solve other problems." --René Descartes (1596-1650)

Data Warehousing Links


Science & Technolgy News


PC Security


Welcome

Data Warehousing, Data Marts, Business Intelligence, OLAP, Data Management, Balanced Scorecard - our Knowledge Base has free publicly available hints and tips written by our consultants


We also offer a complete consultancy service that will ensure the success of your data warehouse project. If you are interested in our services please contact us

Created on 12/25/2003 01:09 PM by datamgmt
Updated on 08/03/2007 09:27 AM by datamgmt
 Printable Version

The Data Management & Warehousing Knowledge Base provides information and techniques about the design, build and implementation of data warehousing solutions that we as a company use and hope that you will also find useful.

How Data Works
How business store and manage their data can have critical effect on data quality and consistency as well as performance and development times. This paper examines how data works and explores techniques exploited from understanding how data works
Updated:
Continuous Data Quality Process Wallchart
A wallchart outlining the process required to develop continuous data quality within an organisation is available for download
Updated:
Data Warehouse Documentation Roadmap
All projects need documentation and many companies provide templates as part of a methodology. This document describes the templates, tools and source documents used by Data Management & Warehousing. It serves two purposes:

* For projects using other methodologies or creating their own set of documents to use as a checklist. This allows the project to ensure that the documentation covers the essential areas for describing the data warehouse.
* To demonstrate our approach to our clients by describing the templates and deliverables that are produced.
Updated:
Data Warehouse Governance
An organisation that is embarking on a data warehousing project is undertaking a long-term development and maintenance programme of a computer system. This system will be critical to the organisation and cost a significant amount of money, therefore control of the system is vital. Governance defines the model the organisation will use to ensure optimal use and re-use of the data warehouse and enforcement of corporate policies (e.g. business design, technical design, and application security) and ultimately derive value for money.
Updated:
Overview Architecture for Enterprise Data Warehouses
This is the first of a series of papers published by Data Management & Warehousing to look at the implementation of Enterprise Data Warehouse solutions in large organisations using a design pattern approach. A design pattern provides a generic approach, rather than a specific solution. It describes the steps that architecture, design and build teams will have to go through in order to implement a data warehouse successfully within their business
Updated:
Job scheduling - fixed and relative timing
This article looks at the relatve merits of two types of processing schedule, once based on a fixed times (similar to 'cron' on a unix system) and onebased on relative times (similar to 'at' on a unix system)
Updated:
Data Transformation - Procedural and Non-Procedural Solutions
This paper looks at a somewhat awkward data transformation, and at solutions written in SQL and in a procedural language. It describes some techniques which can be used to develop the solution in both languages. It also compares the solutions in terms of ease of development, performance and cost of maintenance.
Updated:

Category: Data Warehousing

More Feeds


The Information Life Cycle
This article is based on the forthcoming book, <i>Executing Data Quality Projects: Ten Steps to Quality Data and Trusted Information</i>, by Danette McGilvray, published by Morgan Kaufmann Publishers, Copyright 2008 Elsevier Inc.

Grounding Your IQ Management in Sound Quality Management Systems
For an information quality management function is to succeed, it must be based on the same fundamental principles that led to effective quality systems in manufacturing and the service sector.

Dark Data
Data hidden within the enterprise will inevitably be challenged, and it will be up to enterprise information management to tame it.





Gaining Insight through Analytics - It Takes More than OLAP
What are the keys to real business insight? Dave Wells describes the nature of insight and what is required to gain true insight.

Communication in Business Intelligence Teams
Many companies see the need for effective communication for business intelligence professionals, but they often fail to provide the opportunities to focus on the skills required to achieve it.

Data Stewardship and Pain
Do we really need data governance?





Data Warehousing Architecture
The data warehouse architecture and the blueprint that will drive its construction are critical to the success or the failure of the program and its projects.

Is Data Warehousing Essential to Business Intelligence?
The role of data warehousing is changing as companies move toward using new business intelligence approaches.

Improving Service Line Performance with Healthcare Business Intelligence
Business intelligence and analytics can help to get a comprehensive picture of the standard financial and clinical performance measures and then build on these standard measures to find trends and patterns.





Activity versus Achievement in Telecom
The telecom industry might be the poster child for issues associated with mis-definition of measures and key performance indicators, and the ineffective use of those measures across departmental lines.

Expanding the Envelope
The aviation industry provides a metaphor for the state of data warehousing.

Your Business Intelligence Program
Taking the time to establish a common vocabulary around business intelligence and master data management projects gets everyone on the same page and also is a means by which to enlist business involvement.





Danger - BPM Ahead, Part 1
This article, the first in a two-part series, covers two of the three problems that can cause significant issues for the companies implementing business performance management solutions.

Competing on (Customer) Decisions
Competing by focusing on customer treatment decisions should be a core element of a customer-centric strategy.

Implementing a Successful Business Intelligence Competency Center
Developing a centralized strategy and framework can lead to faster application delivery, greater cost reduction and better decision making.





Category: Uncategorized

More Feeds


RSS Feeds


Are you linked in ?

See David Walker's
View David Walker's profile on LinkedIn
Profile

googlesvcs from Data Management & Warehousing, the Data Warehousing knowledgebase and consultancy

WWW   Site


Mailing Lists

Choose a list:


Email Address:

HTML Text


London Weather

weather_block
(20°C)
Partly Cloudy

Today's Details
Extended forecast

Winning Teams -
Great Team Players

We are delighted to announce our continued player sponsorship for the 2006/07 season of Joe Worsley, utility back row with the English Rugby Premiership Champions London Wasps.

Joe has helped London Wasps win the Powergen Cup in 2005/6, Zurich Premiership in 2002/3, 2003/4 and 2004/5 as well as the Heineken Cup in 2003/4. Joe was also a member of the England World Cup squad and was awarded an MBE by the Queen.

Who's Online

There are currently
7 guest(s) and
0 member(s) online.
You are an
Anonymous user.
You can register for
free by clicking here

No Members are currently logged in.

Your IP address :
38.103.63.16

Your country is :
Unknown
Unknown

Legal



Valid RSS!
The content of this site is Copyright (©) 1995-2007 Data Management & Warehousing Ltd
Valid XHTML 1.0! Valid CSS!
Registered Office: 138, Finchampstead Road, Wokingham, Berkshire, RG41 2NU, United Kingdom
Registered in England and Wales; Registration Number: 3526504; VAT Registration Number: GB 724 4482 36
This site is powered by phpWebSite © The Web Technology Group, Appalachian State University and licensed under the GNU LGPL