Improving Decision Making: Using Databases to
Analyze Sales Trends
Software skills: Database querying and reporting
Business skills: Sales trend analysis
Effective information systems transform data into meaningful information for decisions that improve business performance. In MyMISLab, you can find a Store and Regional Sales Database with raw data on weekly store sales of computer equipment in various sales regions. A sample is shown below, but MyMISLab may have a more recent version of this database for this exercise.
The database includes fields for store identification number, sales region number, item number, item description, unit price, units sold, and the weekly sales period when the sales were made. Develop some reports and queries to make this information more useful for running the business.
Try to use the information in the database to support decisions on
- which products to restock
- which stores and sales regions would benefit from additional marketing and promotional campaigns
- which times of the year products should be offered at full price
- which times of the year products should be discounted
pw : my username