Group Assignment: Post # 2

Group Assignment: Post # 2 Post by Jenny's IT class blog on Saturday, February 7, 2009

This week we learned how B.I. tools (business intelligence) allow businesses to get more value and insight out of their databases.

1. Visit the OLAP Service Online Demo and design three different grid reports using at least three dimensions per report. Each report must have at least one measure which is being analyzed along the chosen dimensions.

• You may choose from any of the dimensions found along the left-hand side of the demo: Customer, Date, Employee, Delivery Date, Product, Reseller, Employee, etc.
• You may choose from any of the measures under Internet Sales, Reseller Sales or Sales Summary (found along the left-hand side of the demo).

2. Post the following content on your blog regarding the grid reports you've designed:

• A screen capture of a section of the report which shows the included dimensions and measure(s);
• An explanation of the insights contained in the report and how these insights can be used by the company to understand their performance or make better decisions;

3. Describe the benefits of allowing users to query a data warehouse in the form of an OLAP cube through their Web browser.

1st Grid Report: Internet Sales Amount by Customer by Product by Date

By generating this report, sales amount in terms of Product & Customer is clearly shown.
Certain products selling revenue by different customer is indicated, this helps company understand its income source by Customer as well as locating the best selling item & year-run items.
This supports management future decision for product allocation by different customers and this also helps to plan the production for each kinds of products, thus stock level will be decreased accordingly to reduce cost of running the company.