Questions for Review
Questions for Discussion
Excel Pivot Table Exercise
The Pivot Table tool in Microsoft Excel has some similarities to many OLAP tools. Create a small table with 5 columns (time, shoe style, store, price and quantity). Load some data into the table and launch the Pivot Table tool. Place the column dimensions in the Row, Column and Page fields; put the measures price and quantity in the data area.
1. Evaluate Data-Driven DSS Vendors. Critique and evaluate a group of DSS vendor Web sites and read their product information. Product categories and vendor groups include OLAP/Multidimensional database vendors, data mining, Executive Information Systems, GDSS, Report and Query tools, Geographic Information Systems. Check Larry Greenberg's "Data Warehousing Information Center" (http://www.dwinfocenter.org) Web site and the DSSResources.COM Vendors (http://dssresources.com/vendorlist/) Web page. Questions you should try to answers include: what is the product category? what is the product used for? how informative about the vendor's products are the web sites ? which are the best web sites? worst web sites? which products would you want to test or learn more about?
2. Visit Data Warehouse and OLAP Information Web Sites. Check the following sites.
CIO (http://www.cio.com) maintains a Data Warehouse Resource Center
Datamation (http://www.datamation.com) maintains a comprehensive web site with information on OLAP and data warehouses.
Datawarehouse.com (http://www.datawarehouse.com) is a resource for Business Intelligence and Data Warehousing.
Data Warehousing Institute is at URLhttp://www.dw-institute.com. It is a great site for finding information on upcoming DW events, white papers, data warehouse case studies, publications you can order, and a large directory of data warehousing vendors.
Data Warehousing on the Internet athttp://datawarehousing.com is dedicated to documenting all data warehousing related information on the Internet.
The Data Warehousing Information Center (http://www.dwinfocenter.org/) is a major collection of relevant information for data warehousing practioners.
Data Warehousing Knowledge Center (http://www.datawarehousing.org/) has good articles and information.
DM Review (http://www.dmreview.com) covers data warehousing and business intelligence issues and solutions for executive and IT management.
The OLAP Council. Its mission is to educate OLAP users about new technology emerging in the market, provide standard and common definitions of what OLAP product are, and sponsor industry research.http://www.olapcouncil.org
The OLAP Report site provides regularly updated information on the OLAP market and OLAP products. This site is primarily designed for people and businesses that purchase "The OLAP Report" by Nigel Pendse and Richard Creeth.http://www.olapreport.com/
3. Visit Bernard Lupin's OLAP Database tutorial page. "Best Foot Forward" Company example at URLhttp://perso.wanadoo.fr/bernard.lupin/english/index.htm.