I have a databse that i want to perform some analysis on to identify some trends. The database consists of album sales of a year. I have availble all details of orders, customers and albums. All tbales are joined with one to many relationships. Can anyone suggest some queries that i could do to perform some meaniful analysis to identify some trends in the data. :confused:

Are you the architect as well as the builder?

It seems to me that you have decided to collect a lot of data then at the end say "Ok what do I do with it now?".

If someone else has given you a spec for this app then it would be them that dictate what analysis they want.

In the past when I have spoke with clients the first thing I ask is "What do you want this system to provide you with?" This then dictates what needs ot be collected in order to achieve this. If you are writing this up fromt hoping to find buyers afterwards then you must ask yourself what would temp them to buy it.

Show them it can graph out the sales by artist,
Number of sales by month
Top ten artists
Bottom ten sales.

The list is endless.

CodeMaster::cool:

I'll make it no secrect that i have been given the data as a csv file i was meant to extract relevant data out into additional tables, once i have done that i have to perform the analysis. There is no specific requirement. So how do you create some of those queries tha you mentioned such as showing how it can graph out the sales by artist, Number of sales by month, Top ten artists and Bottom ten sales?

also any other sugestions from the endless list would be nice :D

any one got any suggestions?

is this a school project?

Yes this is a school project, why do you ask?

Yes this is a school project, why do you ask?
If it was me, then I would pull out from helping since that's what you have lecturers for. To ask your questions. It's their job.

Using forums to get results that then get passed off as all your own work doesn't sit easily with me, especially when the grades that go against such assessments stick for life. I would like to think a person's academic achievements are their own.

If it was me, then I would pull out from helping since that's what you have lecturers for. To ask your questions. It's their job.

Using forums to get results that then get passed off as all your own work doesn't sit easily with me, especially when the grades that go against such assessments stick for life. I would like to think a person's academic achievements are their own.

Aah but these are just practice files, to familiarise our selves with content. the real work will be given to us through an exam. I am just experimenting with the options at the moment. So my academic achievements will be my own seeing as though i will learn from you experts!

If you switch to the SQL View of your query, you can substitute SELECT, with SELECT TOP 10 to get your, you guessed it, top ten.

Thanks! I'll give that a try

because generally you should do your own projects - i mean come on, asking what statistics can you prepare.

which artist sold the most/least
which albums sold the most/least
which period was best/worst

just play around and see what happens
look at different query types, totals queries etc