Create Price Analysis tool in SQL -- 2

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

Skills: Azure, Database Administration, Microsoft SQL Server, SQL, XML

See more: sql server management studio, sql server data tools 2010, sql server data tools 2014, sql server business intelligence development studio download, sql queries for stock market, sql server data tools - business intelligence, ssis visual studio 2017, install ssdt for visual studio 2017

About the Employer:
( 16 reviews ) Burgas, Spain

Project ID: #19318380

16 freelancers are bidding on average €502 for this job


Hello, Dear How are you? I have read your project description and am ready for discussing with you about project. I have experienced in developing Azure, Database Administration, Microsoft SQL Server, SQL, XML. I More

€500 EUR in 10 days
(12 Reviews)

[login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] https://datemyfriend.c More

€500 EUR in 10 days
(6 Reviews)

Hi I am a technical evangelist, developer and can do this task for you. I have more than 12 years of experience in software development and am a microsoft certified professional.I have strong work experience in Reac More

€764 EUR in 10 days
(14 Reviews)

This is really interesting project in terms of data analysis and reconciliation. I am ready to take this challenge. I will use SSIS ETL tool to load all your data into sql database and then we can do analysis. I am a More

€700 EUR in 15 days
(16 Reviews)

Hi, I have just read description of this project. I have been working in web development for 10 years. I am always interesting in web scrapping, so i have checked this project more carefully. There are 4 steps for t More

€500 EUR in 10 days
(4 Reviews)

Nice to meet you. I've read the project description and can develop definitely. I'll provide you with the highly skilled & professional HTML/CSS, PHP/WordPress/CodeIgniter, JavaScript, MySQL, Front & Back-End Web Dev More

€250 EUR in 10 days
(11 Reviews)

Good day Full Stack Expert development team is ready to serve you. To be able to give clients what exactly they want, we are working on hourly rate which is US$50 per hour Can you send me a message? Then we ca More

€555 EUR in 5 days
(7 Reviews)

Hello ?Will you please share your website URL here? ?Will you please share all the changes that you want in your website? I have more than 8 years experience. I have made many websites using magento, HTML5, PH More

€555 EUR in 10 days
(2 Reviews)

I am an IITK graduate and I have 13 years of experience in software development. I finish projects with the highest level of customer satisfaction. I have a team of rock star developers, who are working with top pro More

€555 EUR in 10 days
(1 Review)

***EXPERTISE IN C# PRGRAMMING,ASP.NET,MVC,VB.NET AND READY FOR LIVE INTERVIEW*** With over 12 years of producing corporate marketing projects for some of the most innovative companies in world, I’m here to bring yo More

€250 EUR in 10 days
(1 Review)

Hello There, I have a total of 18 years experience out of which I have worked for 12 years in US. Have done a lot of Azure configuration projects. Recently working on one similar project. Skills & Experience: * Cl More

€300 EUR in 10 days
(3 Reviews)

Certified MSBI -Data Warehousing expert, working in this tool from last 9 years. Have already worked on the script as source excel files to various destinations. Relevant Skills and Experience MSBI, SSIS , ETL, DW, More

€750 EUR in 15 days
(1 Review)

Hi Greetings! Want Create Price Analysis tool in SQL -- 2? I have vast experience in mobile and web application development with 15+ year experience in designing. If you are looking for mobile and website applica More

€250 EUR in 10 days
(0 Reviews)

Good day i am Sr dveloper and hosting solutions provider personally and sure can give u best of solutions for pricing sale sytem as per requiremnt look forward to disscuss more with details posted and sure can More

€555 EUR in 10 days
(0 Reviews)

Hi, Thanks for your job posting. I've read your project description carefully. You want to build price analysis tool. As a senior web developer, I have rich experience in this kind of projects . I am sure I can han More

€500 EUR in 10 days
(1 Review)

Dear sir /madam Please Look my freelancer portafolio With a Bachelor’s Degree and Master’s Degree in computer science, numerous years of hands-on experience creating and implementing software applications, a More

€555 EUR in 10 days
(0 Reviews)