Using Databases to Analyze Sales Trends Assignment

Enjeru Tuesday, April 28, 2015

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

Modify the database table, if necessary, to provide all of the information you require. Print your reports and results of queries.

analyze sales trends PPT

pw : my username

READ

14 Comments

Unknown28 April, 2015
Good article; though I think it the biggest issue would usually be getting that database to begin with :)
Unknown28 April, 2015
Sorry, I don't really get what is this article about, maybe I don't really analyze sales trends etc. Thanks for sharing!
lovemindanao29 April, 2015
i was in sales before and doing everything manually to get a projection on sales.. it is good thing there are programs now doing the math and it is just one click.
Lee29 April, 2015
This seems to be a great software for retail owners. Does this have any support online and is available around the globe?
Fred Said29 April, 2015
I am not in business nor in sales so I cannot completely grasp the meaning of this post. However, I do know the importance of databases for any profession.
RUSS29 April, 2015
I see the importance of databases especially in Sales. It makes planning and decision-making easier.
Raine Pal29 April, 2015
Hmmm...Honestly, I don't get the post. But as far as I know about business, as a marketing graduate, e-Commerce is quite easy to use. You can handle your database, you can add products, you can upload anything you want. You can also track records, etc...
Makeba Giles29 April, 2015
This is some good information. I have lots of friends who work in sales, and this would benefit them greatly.
papaleng29 April, 2015
Oh my, I know nothing about what you are talking here. Nevertheless, nice info to study.
Pooja Kawatra29 April, 2015
Does this help in doing the management reports using macros to generate the trends etc ?
Franc29 April, 2015
These database can really help you strategize on your sales. It can also affect your order cycle.
Sunshine Kelly30 April, 2015
Thanks for sharing this tips and information. I m sure it will benefit those who need data to help them to make correct decision.
Sin Yee02 May, 2015
Why this tip isn't available when I am still studying . Database is very important to do analysis and for reference.
Justin Vawter02 May, 2015
I personally use database for SEO purposes