Saturday, February 7, 2009

Group Assignment: Post # 2

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.

No comments:

Post a Comment