2009年3月1日星期日

Group Assignment: Post # 2 (Answer)

Online analytical processing, or OLAP, is an approach to quickly answer multi-dimensional analytical queries. OLAP is part of the broader category of business intelligence, which also encompasses relational reporting and data mining. The typical applications of OLAP are in business reporting for sales, marketing, management reporting, business process management (BPM), budgeting and forecasting, financial reporting and similar areas. The term OLAP was created as a slight modification of the traditional database term OLTP (Online Transaction Processing). Databases configured for OLAP use a multidimensional data model, allowing for complex analytical and ad-hoc queries with a rapid execution time. They borrow aspects of navigational databases and hierarchical databases that are faster than relational databases.



1) Internet Sales Amount by Geography by Product by Date by Sales Channel





Measure: sales amount both internet

Geogharpy: united states

Date: financial year:04, 05

Product: category(bikes, accessories, clothing)

Report 1: According to the shown report, we can saw the different between total of the financial year 2004 and 2005. It separates into several items and each item show its own total. It helps the company to find out the balance from each item. And set up some relevant policies to deal with.


2) Reseller Gross Profit by Reseller by Promotion by Customer by Date






Measures: reseller gross profit

Reseller: specialty bike shop, value added reseller, warehouse

Promotion: new product

Date: financial year 04,05

Customer: united states

Report 2: As the Grid shown to us, we can see the reseller from United States that the new product promotes. It shows us the gross profit between the new product and the regular products. It helps us to know the effective and efficiency of the product promotion.


3) Order Count by Ship Date by Geography by Product by Date







Measures: order count

Ship date: financial year 04, 05

Product: bikes

Geography: united states

Date: financial year 04,05

Customer: united states

Report 3: Base on the Grid, classify with date, product and geography. It shows all the products with detail information. Moreover, the Grid helps to find out the most efficiency suppliers and contractors.

發佈者： 於

2 則留言:

  1. Jenny N Lim2009年3月7日 上午6:49

    I've noted your definition of OLAP and I look forward to seeing your sample reports.

    A good rule to follow in designing OLAP reports is to use Time, Location and Product as the three dimensions. Quantity Sold and Sales Amount can be the two measures, or actual/target amounts can be compared.

    In case you have quoted directly from any sources, please include references at the end of your blog post.

    回覆刪除
  2. Jenny N Lim2009年4月9日 下午11:50

    I've noted your OLAP grid report examples ! All reports look good and are well-organized. For report # 3, I'm not sure how this shows how efficient suppliers and contractors are. The shipping of products to customers is probably done by the company itself or by its resellers.

    回覆刪除

訂閱： 發佈留言 (Atom)