Improving Decision Making: Using Databases to Analyze Sales Trends Software skil
ID: 3872936 • Letter: I
Question
Improving Decision Making: Using Databases to Analyze Sales Trends
Software skills: Database querying and reporting
Business skills: Sales trend analysis
In this project, you will start out with raw transactional sales data and use Microsoft Access database software to develop queries and reports that help managers make better decisions about product pricing, sales promotions, and inventory replenishment. In MyMISLab, you can find a Store and Regional Sales Database developed in Microsoft Access. The database contains raw data on weekly store sales of computer equipment in various sales regions. The database includes fields for store identification number, sales region, item number, item description, unit price, units sold, and the weekly sales period when the sales were made. Use Access to develop some reports and queries to make this information more useful for running the business. Sales and production managers want answers to the following questions:
Which products should be restocked?
Which stores and sales regions would benefit from a promotional campaign and additional marketing?
When (what time of year) should products be offered at full price, and when should discounts be used?
What reports and queries do I need
Explanation / Answer
The database used for this project having following tables.
store_table(store_id, store_name, store_address, store_region, store_sales, sales_week)
product_table(item_number, item_description, unit_price, unit_sold)
region_table(region_id, region_store_count, region_sales)
For getting the answer of product that should be restocked, we can query the table "product_table". With query we can found the item number that having the maximum unit solds. And for that item we can do the restocking.
For getting the store name that needs promotional campaign and additional marketing we can query the the table "store_table" and can get the store name that have very less store sale, and for that store we required additional marketing and campaign.
We can query the table "store_table" to get the week for which minimum sale is recorded, so in future for that week or month we can provide discount or start the sale to boost the sales.
The reports we required are:
1) Sales report for each store.
2) Sales report of the each region
3) Report realted to each item.