Page 117 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence

Notes
Customer
Cost to XYZ for each widget
Order date
Shipment date

Method and cost of shipping

Any of these pieces of data can function as a dimension in a data cube. We can take any two
dimensions and produce a 2-D table:
1. Thus we can correlate or track sales against individual stores or sales agents. Add in
a third factor, such as price, and we can produce a 3-D data cube,

2. That allows us to see how much each store or sales agent is selling in addition to
which type of widget. Swap in geography, and
3. We can now see who is selling where.

Questions:
1. What are different pieces of data available for the company here?
2. What can be effect of price change (increase by 25%) in United States on the sales in
this company?
Source: http://www.computerworld.com/s/article/91640/Data_Cubes

7.6 Summary

A Cube is the main object of a SSAS solution where the majority of fine tuning, calculations,
aggregation design etc. Now, we will create a cube using our dimension and fact tables.
We will use SQL Server 2008 here.

112 LOVELY PROFESSIONAL UNIVERSITY