Encerrado

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

Habilidades: Azure, Administração de Bancos de Dados, Microsoft SQL Server , SQL, XML

Veja mais: 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

Acerca do Empregador:
( 15 comentários ) Burgas, Spain

ID do Projeto: #19318380

17 freelancers estão ofertando em média €506 para esse trabalho

mingxiao2008

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 Mais

€500 EUR in 10 dias
(11 Comentários)
5.9
shaktistanwar

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 Mais

€764 EUR in 10 dias
(10 Comentários)
5.3
abstractsoftweb

[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 Mais

€500 EUR in 10 dias
(5 Comentários)
5.3
kipdev13

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 Mais

€250 EUR in 10 dias
(10 Comentários)
4.3
leemilun

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 Mais

€500 EUR in 10 dias
(3 Comentários)
4.1
dreamci

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 Mais

€555 EUR in 5 dias
(7 Comentários)
3.9
anuragiitk

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 Mais

€555 EUR in 10 dias
(1 Comentário)
2.8
jayantavkumar

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 Mais

€700 EUR in 15 dias
(3 Comentários)
1.7
akhileshgandhi

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 Mais

€300 EUR in 10 dias
(3 Comentários)
1.6
dhawansaahiljobs

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, Mais

€750 EUR in 15 dias
(1 Comentário)
0.5
D3itsolutions

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 Mais

€250 EUR in 10 dias
(0 Comentários)
0.0
INDOGICSOLUTIONS

***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 Mais

€250 EUR in 10 dias
(0 Comentários)
0.0
KGeorgy

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 Mais

€500 EUR in 10 dias
(1 Comentário)
0.0
DeZineCode

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 Mais

€555 EUR in 10 dias
(0 Comentários)
0.0
makelegend17

Hello, Sir. How are you? I checked your all requirement and understood what you want. I am a excellent database programmer and web scrapping expert. I have also enough experiences in SQL so I can help you in this pr Mais

€555 EUR in 10 dias
(0 Comentários)
0.0
santoshm143

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 Mais

€555 EUR in 10 dias
(0 Comentários)
0.0
joracab

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 Mais

€555 EUR in 10 dias
(0 Comentários)
0.0