Закрыт

Build me an SQL version of an excel spreadsheet -- 2

I have a spreadsheet that is getting very busy and I need to move it now to SQL and then have a web page reporting the data.

I need this excel sheet to log the information direct to MSSQL server for the reporting.

I need the vehicles to each have an individual trackable with each of the tasks

I need for each of the locations to report and count the number of buckets placed into them or removed from them.

I need the reports capability at a minimum for the ones shown in the excel file.

Also I need a html or browser version of a live reporting

Web page to be Total movement from a selected date and time with bucket and tonnes and a target tonnes for the period of time. THis should update every 5 minutes.

Location of materials - a live tracker showing the actual current live totals of each of the locations. Need a way to add in new locations and an estimated target material storage value

Need to be able to track the vehicle that is moving the material, where it moved it, and how long it took to move, also the operator driving the vehicle.

Material is not always dirt - Ore or Waste, for drills it it bolts, Upholes, Down holes, face holes

For Agigitator it is Paste fill mix cubic meter

Need also to refer the material as Production or development

Also need the SQL to capture data direct from FTP file transfers and also source other information through an API from Pi, Postgress, Oracle or SQL.

Квалификация: Управление базами данных, Программирование баз данных, SQL

Показать больше sql server 2017 versions, sql express version numbers, how to check sql server version through query, sql server 2016 versions, sql server 2012 build versions, sql server versions, sql server versions and features, sql server version query, can build front end excel spreadsheet, upload excel spreadsheet mysql database phpmyadmin version, fair value excel spreadsheet, sql bulk load excel spreadsheet, load excel spreadsheet sql server, sql 2005 create job import excel spreadsheet sql, build widget excel spreadsheet, update sql server excel spreadsheet, build excel spreadsheet, update sql database excel spreadsheet, import excel spreadsheet sql, import excel spreadsheet sql table

О работодателе:
( 37 отзыв(-а, -ов) ) faridabad, India

ID проекта: #20746705

11 фрилансеров(-а) в среднем готовы выполнить эту работу за $152

jayantavkumar

Proposal - The best way to fulfill your requirement is to use SSIS tool to extract your excel data and move into sql server. And then generate SSRS reports on top of it. Let me know if you want to discuss further. I Больше

$120 AUD за 7 дней(-я)
(7 отзывов(-а))
3.7
masterb325

-I have done Certifications in Business Analytics and working as Analyst for 3 years. -Looking to bring the benefits of data analysis to your business, the company might have analytics already implemented but with the Больше

$140 AUD за 4 дней(-я)
(2 отзывов(-а))
2.5
Ramarajuget2me

I am having 4 years of experience in Sql and Plsql programming and also having good experience in loading data to Database tables from flat files.

$130 AUD за 7 дней(-я)
(0 отзывов(-а))
0.0
segmentsonline

Hi I can handle this project. I am Microsoft technology specialist and have 10 years of strong hands on experience in desktop, web and mobile application development. I can work for you as time and cost mode Больше

$466 AUD за 18 дней(-я)
(0 отзывов(-а))
0.0
mahinikam42

Hi Dear, For your requirement the good approach will be SSIS package. We will import the excel data into the sql Server with scheduling some SQL jobs, it will run on periodic time depends on your requirement(i.e Dai Больше

$135 AUD за 10 дней(-я)
(0 отзывов(-а))
0.0
jiangalexsander

I am ready for your project now. I can do it and start right now and available for you with fulltime manner. I would like to have a more detailed discussion with you on the chat. Thanks.

$80 AUD за 2 дней(-я)
(0 отзывов(-а))
0.0
AlsayedKhalid

I have a 15 years of experience on building Oracle database applications, I am a very good in writing Oracle SQL and PL/SQL codes. Hire me if you want your project accomplished very well. This is my first task, i have Больше

$222 AUD за 5 дней(-я)
(0 отзывов(-а))
0.0
sanjaysaradhi

I am backend ETL developer currently working as a Business Technology Analyst in an MNC. I have 1.5 years of experience in ETL , MySQL, Oracle and Business Intelligence tools like MicroStrategy and Tableau. With my ex Больше

$133 AUD за 7 дней(-я)
(0 отзывов(-а))
0.0
nandasheetal22

Hi, looking at your project description, I think this is the best suited job for me as I have over 8 years of experience in Database Development along with Performance Tuning. I have worked on various Databases like O Больше

$80 AUD за 7 дней(-я)
(0 отзывов(-а))
0.0
moizdewaswala

I am data warehousing professional with 11 years of experience and i have proven expertise in handling various file formats and develop code to parse various file formats

$88 AUD за 10 дней(-я)
(0 отзывов(-а))
0.0
carolynmiami

I am an expert level SQL programmer, with over 15 years of experience coding, able to solve bugs that have stumped other people. I also have extensive experience in Excel and Access.

$80 AUD за 7 дней(-я)
(0 отзывов(-а))
0.0