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.

Q1 & 2 Ans

Report 1:

In the report “Gross Profit by Date by Sales Channel by Product”, we can compare the gross profit in different sales channel. By doing this, we can find the suitable sales channel for our products. Then we can put more resources and supporting on those products’ sales channel and gain more.

Report 2:

Through the report “Discount Amount by Geography by Date by Product”, we can understand which country we’ve offer most discount. That mean there might have some problems in that country regarding our product’s quality, shipment or marketing activities that couldn’t fulfill customer needs. Then we have to offer a discount to customer and keep the order.

Report 3

By reading the report “Sales Amount by Date by Geography by Sales Channel by Product”, we can find out the most effective sales channel also the most popular product in each country. So we can organize the suitable marketing activities on right country, right sales channel and right product.

Q3 Ans

The benefits of allowing users to query a data warehouse in the form of an OLAP cube through their Web browser are shown as below:

The OLAP cube can be analyzed data according to 3 dimensions, then user can view the data in different ways or different dimensions.

User interact with OLAP cubes through Web browser, so that they can run queries and print reports interactively.