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.
Posted by Jenny
Internet Sales Amount by Promotion by Date by Geography No Discount Volume Discount 11 to 14 Volume Discount 15 to 24
回覆刪除Sales Amount Revenue Goal Revenue Status Revenue Trend Sales Amount Revenue Goal Revenue Status Revenue Trend Sales Amount Revenue Goal
Abingdon FY 2002
FY 2003
FY 2004
FY 2005
Total
Albany FY 2002
FY 2003
FY 2004
FY 2005
Total
Alexandria FY 2002
FY 2003
$22,844,144.84 22844144.8429991 $263,425.57 263425.5733 $1,779.95 1779.9457
$31,564,385.44 26270766.5694489 $1,768,514.16 302939.409295 $278,685.31 2046.937555
$47,876,144.13 36299043.2507092 $2,864,512.18 2033791.28836999 $757,178.08 320488.1065
$50,840.63 55057565.749526 3294189.00159515 870754.790504999
$102,335,515.04 102335515.038282 $4,896,451.91 4896451.91240018 $1,037,643.33 1037643.3344
$22,844,144.84 22844144.8429991 $263,425.57 263425.5733 $1,779.95 1779.9457
$31,564,385.44 26270766.5694489 $1,768,514.16 302939.409295 $278,685.31 2046.937555
$47,876,144.13 36299043.2507092 $2,864,512.18 2033791.28836999 $757,178.08 320488.1065
$50,840.63 55057565.749526 3294189.00159515 870754.790504999
$102,335,515.04 102335515.038282 $4,896,451.91 4896451.91240018 $1,037,643.33 1037643.3344
$22,844,144.84 22844144.8429991 $263,425.57 263425.5733 $1,779.95 1779.9457
$31,564,385.44 26270766.5694489 $1,768,514.16 302939.409295 $278,685.31 2046.937555
Drop Slicer fields here
http://photos-b.ak.fbcdn.net/photos-ak-snc1/v2425/161/64/574377574/n574377574_2168673_8514.jpg
回覆刪除post by Anita
Question 2 part 3 )
回覆刪除OLAP allows users to view same date in different ways or from different dimensions . User can change the dimensions or data being viewed dynamically , unlike with paper-based reports . Just like our part2 answer , we can get data about " internet sales amount by promotion by date by geography " .
http://tinypic.info/files/f8zb8f2sgn5u1wsl13ff.jpg
回覆刪除I've noted your sample report which shows Internet Sales Amount and Target Sales Amount for each product/geography/promotion combination.
回覆刪除You may also add some insights or trends that may be gained from the report. For example, are there any insights regarding the effectiveness of promotions which can be seen using this report ?
Also noted your Q2 Part 3 answer !
part 2.)
回覆刪除We can see the sales amount and revenue goals of female or male of each country per year , So that , we can decide to develop more business in which country and for female or male .
image: http://tinypic.info/files/3sz1s53wmhnnf30cn86x.jpg