Inventory can
be adjusted according to the demands in various areas or even individual stores.
These daily reports are relatively high level, represent a snapshot of the previous
day??™s activities across the organization, and are used by everyone in the organization,
from the CEO on down. Analysts throughout the company can then perform more
detailed analysis using analytic tools against a wealth of data, including analysis of
products by various attributes.
As an example, a new dress shirt might sell well one season. However, this shirt
is available in a variety of different styles, such as with different fabrics, different
collars, different buttons, and so forth. All of the shirts sold well, but did a specific
combination of attributes sell better than others? If the shirt with mother of pearl
buttons and silk fabric outsells all shirts with either cotton fabrics or plastic buttons,
this information can be used for both stocking and pricing strategies.
This particular business intelligence solution builds warehouses out of
approximately 15TB of relational data. The relational data is stored in SQL Server
2005, while the cubes are built with Analysis Services 2005. Reports are generated
with Reporting Services 2005 and analysis is done with ProClarity.
20 B u s i n e s s I n t e l l i g e n c e w i t h M i c r o s o f t O f f i c e P e r f o r m a n c e P o i n t S e r v e r 2 0 0 7
Summary
As discussed in this chapter, the business benefits of business intelligence are real
and working for many companies worldwide.
Pages:
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54