Lukket

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

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

Se mere: 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

Om arbejdsgiveren:
( 15 bedømmelser ) Burgas, Spain

Projekt ID: #19318380

17 freelancere byder i gennemsnit €506 på dette job

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 Flere

€500 EUR in 10 dage
(11 bedømmelser)
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 Flere

€764 EUR in 10 dage
(10 bedømmelser)
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 Flere

€500 EUR in 10 dage
(5 bedømmelser)
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 Flere

€250 EUR in 10 dage
(10 bedømmelser)
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 Flere

€500 EUR in 10 dage
(3 bedømmelser)
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 Flere

€555 EUR in 5 dage
(7 bedømmelser)
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 Flere

€555 EUR in 10 dage
(1 bedømmelse)
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 Flere

€700 EUR in 15 dage
(3 bedømmelser)
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 Flere

€300 EUR in 10 dage
(3 bedømmelser)
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, Flere

€750 EUR in 15 dage
(1 bedømmelse)
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 Flere

€250 EUR in 10 dage
(0 bedømmelser)
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 Flere

€250 EUR in 10 dage
(0 bedømmelser)
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 Flere

€500 EUR in 10 dage
(1 bedømmelse)
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 Flere

€555 EUR in 10 dage
(0 bedømmelser)
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 Flere

€555 EUR in 10 dage
(0 bedømmelser)
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 Flere

€555 EUR in 10 dage
(0 bedømmelser)
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 Flere

€555 EUR in 10 dage
(0 bedømmelser)
0.0