This week we learned how B.I. tools (business intelligence) allow businesses to get more value and insight out of their databases.
- 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).
- 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;
- Describe the benefits of allowing users to query a data warehouse in the form of an OLAP cube through their Web browser.
Answer:
* Internet sales amount by date by customer by product
The company can do some comparison among the country’s customer, several years or different product. Then they can know the sales amount clearly.
The company can know the gain or loss in the past years. And know each product’s sales amount in each country’s customer that they can make better decision in future. e.g. the stock amount in each country or where need to have a promotion.
They also can use these data to know which product has potential, and then do more promotion to gain profit.
The company can do some comparison among the country’s customer, several years or different product. Then they can know the sales amount clearly.
The company can know the gain or loss in the past years. And know each product’s sales amount in each country’s customer that they can make better decision in future. e.g. the stock amount in each country or where need to have a promotion.
They also can use these data to know which product has potential, and then do more promotion to gain profit.
* Internet sales amount by data by sales channel by product
The company can know which product is the best selling product in particular year or several years. If it shows the product is no or less profit that we can fake it out.
It also shows the trend of the sales channels or methods within the range that we can choose the better sales way in the future. And do the comparison and analysis among these year to help to make the future planning and goals.
The company can know which product is the best selling product in particular year or several years. If it shows the product is no or less profit that we can fake it out.
It also shows the trend of the sales channels or methods within the range that we can choose the better sales way in the future. And do the comparison and analysis among these year to help to make the future planning and goals.
* Internet Sales Amount by by Product by Employee by Date
This report objective is to reflect the sales executive who had a better performance in the specific period and what products are they keen on to sell it. Therefore, management can arrange different performance sales executive to cater different kind of customer accounts.
* BENEFITS.
Increase the user's self-service and productivity, users can create and modify their own reports, create new calculations from existing metrics or apply filter conditions to the report. And same data can be viewed in different ways or from different dimensions. User can change it to view dynamically, unlike with paper based reports.
Less administrative burden, users manipulate reports on a multi-dimensional cache of data rather than a limited, proprietary cube database.
More user functionality and less maintenance lead to greater value from all enterprise BI application.
This report objective is to reflect the sales executive who had a better performance in the specific period and what products are they keen on to sell it. Therefore, management can arrange different performance sales executive to cater different kind of customer accounts.
* BENEFITS.
Increase the user's self-service and productivity, users can create and modify their own reports, create new calculations from existing metrics or apply filter conditions to the report. And same data can be viewed in different ways or from different dimensions. User can change it to view dynamically, unlike with paper based reports.
Less administrative burden, users manipulate reports on a multi-dimensional cache of data rather than a limited, proprietary cube database.
More user functionality and less maintenance lead to greater value from all enterprise BI application.
Good examples ! To increase the variety of the reports, you may also try to add other measures aside from Internet Sales Amount, such as Gross Profit.
ReplyDelete