I have a client that wants to create an admin dashboard with lots of charting options. I'm not a sql guru so I'm wondering if some one out there is that can help me :-)
here's an example of the data we'll have, it's all based around tracking their sales from the stores they run.
we'll have an order, the number of items purchased, and info about each item:
[LOCATION] - this is the location of the store
[ORDER SALE DATE TIME] - date time the order was placed
[TOTAL ITEM COUNT] - total number of items in the order
[ITEM COUNT] - count of this item in the order (could have bought 2 shovels)
[ITEM PRICE PER] - this is the sale price of the item
[ITEM TOTAL PRICE] - this is the total sale price of the items based on the item count (see above)
[TOTAL ITEM PROFIT] - this is how much they made of the item so "ITEM TOTAL PRICE" - "TOTAL ITEM PROFIT" = the price they paid for it.
[ITEM NAME] - item name
[ITEM SIZE] - item size (optional - nullable)
[ITEM COLOR] - item color (optional - nullable)
some of the charts requested
popular items (weekly best selling products)
popular stores
items sold in the last day / week / year
profit in the late day / week / year
charts showing how they are tracking toward a given goal ($500 in sales this week / month / year etc)
product trends over a given time period (what's selling)
So I know about database normalization and I can write selects, but this needs to be fast and I'm not afraid to admit I think it's a bit over my head.
Start Free Trial
