The Best Choice For A Web-enabled Tronics Data Warehouse Is To Adopt An

The best choice for a web-enabled Tronics data warehouse is to adopt an extranet web information delivery strategy. If the data warehouse is to serve one of its purposes of serving the needs of outside members, it should give access to company information to selected users who can do so through proper authentication channels.
In addition to what was previously mentioned about the value of the web in data warehousing, a web-enabled data warehouse can have the other following advantages:
1. Suppliers, Customers, and Tronics top level management will have a single point of entry and reference for information thus eliminating the overlapping of information.
2. There will be minimal training for web users since the use of the web is already a part of our everyday lives.
3. Web browsers will run on any computer systems.
4. The web will enable users to receive multiple data formats like text, video, charts, images, and audio. Tronics suppliers can be shown a graphical representation of products which are commonly purchased.
5. The sharing of information through the web will foster, strengthen and deepen collaborations and partnerships.
6. It will allow the sharing of information on an unlimited time basis.
7. The web will add another type of crucial data needed for decision support analysis. This is called clickstream data. Clickstream data tracks how users navigated through the Tronics web site and what sections or areas usually attract users the most.
8. The web can handle OLAP (online analytic processing).
Online Analytical Processing (OLAP) Technology at Tronics PLC
The different fields of a particular database are interrelated to different business dimensions. If we try to take a look at the field NetSales of the table named tblSOLINE, we will notice that it is directly related to product id (or the product itself!). The POCost is related to the PODate (through the POHeaderID).
Most analysts dig through data through scenarios. In today's analytical processing, a query like how many units of Headsets did we sell in Bradford is likely to satisfy an ordinary user but it probably won't satisfy a manager who wants to find out more about the trends of sales for the last 3 years in individual branches. In order to maximize the value of data analysis at this point, the user usually performs a multiple set of queries so that he or she may be able to get what is needed.
Time is usually a critical dimension of analytical processing. Hardly is any query performed without any time dimension to it. Aside from time dimensions, there are also business dimensions like sales which can be related to time dimensions in performing queries. Top management usually monitors performances over time and use this as a form or basis of comparison.