Benchmarking • Sargable • Making your data available

Data

1.

[Information quality]

Your data warehouse supports queries and reports with few errors

1 2 3 4 5

2.

[Information quality]

Your data warehouse supports the level of data correctnesss needed for its intended purpose

1 2 3 4 5

3.

[Information quality]

Your data warehouse includes data about all business processes and subject areas that are required by users and applications

1 2 3 4 5

4.

[Information quality]

All necessary decision support data is available within the data warehouse

1 2 3 4 5

5.

[Information quality]

Your data warehouse provides all the data needed by users and applications

1 2 3 4 5

6.

[Information quality]

Your data warehouse provides a single version of the truth

1 2 3 4 5

7.

[Information quality]

Your data warehouse reduces data inconsistencies

1 2 3 4 5

8.

[Information quality]

Your data warehouse architecture provides a single system of record for decision support data

1 2 3 4 5

9.

[Information quality]

Is the system foolprooof - can different users easily obtain differing figures?

1 2 3 4 5

10.

[System quality]

Your data warehouse architecture makes it easy to add new business processes and subject areas

1 2 3 4 5

11.

[System quality]

Your data warehouse provides the capability to satisfy new requirements quickly

1 2 3 4 5

12.

[System quality]

Your data warehouse provides the capability to easily support future application needs

1 2 3 4 5

13.

[System quality]

Your data warehouse architecture is scalable to handle increases in the number of users without negatively impacting system performance.

1 2 3 4 5

14.

[System quality]

Your data warehouse is scalable to handle increases in the complexity and number of simultaneous queries without degrading system performance.

1 2 3 4 5

15.

[System quality]

Your data warehouse architecture is easily scalable to handle increases in the structure of data.

1 2 3 4 5

16.

[System quality]

Your data warehouse supports and facilitates the integration of data from multiple systems.

1 2 3 4 5

17.

[System quality]

Your data warehouse supports and facilitates the integration of internal and external data sources.

1 2 3 4 5

18.

[System quality]

Your data warehouse supports and facilitates the integration of all needed data around primary keys.

1 2 3 4 5

19.

[Individual impacts]

End users are using the data warehouse that was implemented.

1 2 3 4 5

20.

[Individual impacts]

Users can access the data more easily and quickly because of the data warehouse.

1 2 3 4 5

21.

[Individual impacts]

The data in the data warehouse is easy and intuitive tor users to understand and use.

1 2 3 4 5

22.

[Individual impacts]

Your data warehouse enables users to think about, ask questions and explore issues in ways that were previously not possible

1 2 3 4 5

23.

[Individual impacts]

Your data warehouse has improved decision-making capabilities of end users.

1 2 3 4 5

24.

[Organisational impacts]

Your data warehouse has met the business requirements for which it was implemented.

1 2 3 4 5

25.

[Organisational impacts]

Your data warehouse has greatly facilitated the use of business intelligence.

1 2 3 4 5

26.

[Organisational impacts]

Your data warehouse has enabled improvements to business processes.

1 2 3 4 5

27.

[Organisational impacts]

Your data warehouse has supported the achievement of strategic business objectives.

1 2 3 4 5

28.

[Organisational impacts]

Your data warehouse has led to high and measurable ROI.

1 2 3 4 5

29.

[Organisational impacts]

Your data warehouse has improved communication and cooperation across organisational units.

1 2 3 4 5

30.

[Development cost]

The cost to develop the first business process

1 2 3 4 5

31.

[Development time]

The time required to produce the first business process

1 2 3 4 5

How SQL configuration can save you money

How Policy Based Management can help you manage SQL Server

Use Extended Properties to store information about a database

Monitor and learn SQL Server for free

Open Source SQL Server monitoring framework

Data

Report Production

Delivery

Usage