Create Price Analysis tool in SQL. (Internal [login to view URL] for IT products
Where comes data from?
1. Distributors via XML, FTP, CSV 20 suppliers with daily 100.000 import
2. Manual import via XLS, 200+ items daily.
3. Archive biggest data supplier after few days
4. Separate project: Webscraping comparison websites in EU.
Create SQL database in Azure.
What kind of fields?
1. Product number, manufacturer number, description, price, Promo price, Dealer Price, currency, date, Qty, Manufacturer, Supplier name, Status of product, Product group 1, Product group 2,
What do we want to see? Automatic daily queries
Visual in a simple web interface
1. Products with high discounts compared with other suppliers.
2. Our cost vs others
3. Search on part number or xxx, and show all suppliers with prices.
4. Top 20 highest % price difference per category, Laptops, PC’s, etc
Export results to:
[login to view URL] BI, XLS, XML
2. Simple web interface