Business Intelligence App
I have a SQL database that is the engine for a eBay listing tool. Teh reporting provided they Application i use is horriable at best.
I need and Application that will allow me to find some key metrics on the products i sell.
I need To know the percentage of times an item sells compared to the number of times it is listed.
I need to be able to do a Profit loss Per item.
With both of these sets of data i need to be able to select target numbers.
For instance with the Percentage sold i need to be able to select item that only sell 30% of the time. i need that 30% to be a user supplied variable. and report all items that fall below that thersehold. If less than 30% print to report. IF more than 30% ignore.
To find % sold for example would be number of times listed divided by the number that sold. If listed 10 times and 7 time it sold would be 70% and would be ignored by 30% query. But if only sold 2 times would show up on report.
For profit and loss i need report to take total cost (ebay fees, paypal fees, and item cost) for all items sold and unsold and calculate % made or lost based on item cost. For example item is listed 10 times each listing cost $1 and there is .60 fee for items that sell. item sold 7 times so for ebay fees we have (1*10)+(7*.6)+(paypal fees on sold item)+(cost of item * Number sold)+(shipping cost per item)=total cost to sell items then we take the monies collected for the 7 items subtract out the total cost to get profit or loss and then calculate the average profit or loss per sale of said item and report it as a percentage based on Item cost.
I would need to be able to have report show me all items that are under a user supplied variable and always show items that are negative. ( if value is greater then (user input) ignore) (if value is less than (user input) print to report) (if value is negative number then print to report)
This will run over a LAN
I have been told that Crystal reports should be able to do what i am asking for and expandable in the future. I perfer a desktop application over a web based application. I have also been pointed at Panthos BI its an open source Platforme that should do what i am looking for alo
