When looking at overtime, one employee rose to the top by
C h a p t e r 1 : T h e C a s e f o r B u s i n e s s I n t e l l i g e n c e 19
earning more in overtime in a year than her base pay. This raised a red flag but after
investigation, the business learned that this was in fact the case for this particular
employee. More importantly, they began looking at seasonal adjustments to their
staffing and overtime levels and began setting boundaries for when such items
became too high or too low.
The technology used for this particular engagement was SQL Server 2000 and
ProClarity Analytic Server. Reports were created by a few users in Information
Technology and published to the internal PAS site. Department managers were
trained in how to view the reports and conduct some of their own analysis on the
data.
Tracking Retail Sales
A large retail chain in Europe, the Middle East, and Africa (EMEA) wanted to better
track and report on sales, as well as perform complex analysis on what sold well
in different areas and which combinations of attributes were included in the most
profitable items. Sales needed to be collected daily from each point of sale terminal
in each store in the chain. This data amounted to literally millions of records being
uploaded from the stores each night and loaded into the warehouse.
Each day, business decision-makers and managers of each product line consume
reports that show how each item in their product line sold and where.
Pages:
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53