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.