Closed

Help setting up FTP and SQL data server and analytics

I need to run data analysis on a big data set that is uploaded to an FTP server once a week.

The data consists of several data tables.

I need to set up a server or software that automatically grabs the data fresh every week, does some automated cleaning and linking, and then allows me to create customer queries and reports.

Some options:

Give me access to the data and the queries in something like Toad or HeidiSQL.

Create a web-based GUI where I can write and run queries and see data output,charts, graphs, etc.

There will probably be a few steps to this project.

1) Automate downloading FTP data to new server

2) Automate cleaning data

3) Create place to run custom queries and reports

4) Help automate some of the reports/queries that I find useful and want to run every week

Skills: Data Processing, Database Administration, SQL

See more: need sql help, graphs of data, graphs data, data in graphs, data graphs, data and graphs, data analysis reports, data analysis help, data 3, create charts and graphs, sql server gui, sql data, sql data analysis, Help me write something , downloading data, Data tables, sql analytics, ftp setting, set project server 2013, custom sql queries, processing gui, write sql queries, set server 2013, data cleaning software, queries sql

About the Employer:
( 6 reviews ) Capital, United States

Project ID: #4934422

9 freelancers are bidding on average $570 for this job

toinnisfree

pls chk pmb

$600 USD in 7 days
(26 Reviews)
5.3
expertcoder1vw

I'm an expert Windows database application developer with significant experience developing FTP and SQL Server applications. I can do the job for you, and can deliver a nice user interface with graphs and ability to ru More

$399 USD in 5 days
(13 Reviews)
4.8
truongngocthanh

Hello, I can do this task, please check your PM for more detail. Thanks

$500 USD in 7 days
(19 Reviews)
4.7
elboukharimu

I can help you please check your Inbox.

$600 USD in 15 days
(12 Reviews)
4.4
kchg

Hi, I got interested of this work. Hopefully your project would be done successfully. I'll do it for you. :) Thanks.

$515 USD in 5 days
(5 Reviews)
3.3
hbxfnzwpf

I am linux administrator myself, and I am very proficient in sql server and ftp, it is easy job for me, please let me do it.

$473 USD in 3 days
(4 Reviews)
2.8
sunshinelabs

I'm American, live in NY, have a BS and a day job. I need extra projects this month. I've been building MSSQL and .NET projects for over 20 years (or traditional VB before that). Let's discuss this and see if we can More

$566 USD in 3 days
(1 Review)
2.7
vnjoom

Let me care it.

$526 USD in 30 days
(1 Review)
1.8
expertjlm

i expert sys admin. Let me care it.

$666 USD in 30 days
(1 Review)
0.0
level20peon

Hello! I have ample experience in automation as well as in SQL and reporting. I could deliver what you need within one week.

$688 USD in 7 days
(0 Reviews)
0.0