Develop T-SQL to Answer Questions from data in SQL Server DB

Closed Posted Oct 21, 2014 Paid on delivery
Closed Paid on delivery

I have a SQL Server database with some test records related to a company and it's employees and their feedback. I have a list of questions that I need to answer with the data and I need a strong data analyst / statistician that can provide me with suggestions for the algorithms and then also code the T-SQL required to retrieve the data.

An example of one of the questions we need to answer might be "which employees are reporting statistically relevant higher levels of [x] than the rest of the company." Another example questions might be "which divisions are reporting statisically lower levels of [x] as compared to the rest of the company." You would need you to make a recommendation as to what constitutes a significant enough amount of data for an employee or division to be eligible for the report, and also to help us to determine what constitutes "significantly relevant" in some of these cases.

The data itself is fairly straightforward being values from 1 to 10 on 10 different fields. We also would require reporting at different org levels and the DB model accounts for that. We also have some questions that are fairly subjective and will require a bit of creativity.

If you think you are a fit please PM me and I can send over the full list of questions for you to review prior to bid.

Algorithm Data Mining Microsoft SQL Server SQL

Project ID: #6622609

About the project

30 proposals Remote project Active Nov 27, 2014

30 freelancers are bidding on average $617 for this job

karunakartiwari

hello Sir, Greeting for the day, Hope you are doing well We are group of Developer having more then 10 years of experience in Web designing,software Development,we pleased to work on Website Designing ,please con More

$555 USD in 10 days
(50 Reviews)
6.6
codetod

Hi I am a database expert with 12 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. With More

$500 USD in 15 days
(77 Reviews)
6.4
mosiddiqui

Hi there, I am SQL Certified developer and I can surely help you in extracting this information from your database. Please provide me a list of questions and access to database if possible to estimate the require More

$833 USD in 10 days
(8 Reviews)
4.6
scsBiswas

I can do it. .

$250 USD in 10 days
(28 Reviews)
4.7
gargitservices

Do you need reporting? SSRS ?.....................................................................................................

$500 USD in 4 days
(5 Reviews)
4.2
bigdognec

Very interesting project! There are many statistical tools that we can use and determine what base lines to draw and how to get the relevant data. Im sure there will be a lot of manual work to find relevance as well. Y More

$736 USD in 14 days
(3 Reviews)
3.6
leomedina01

Hi sir, My name is Leonardo Medina, and I´m from Brazil. I have lots of experience in PHP. Please drop me a line, so we can discuss this project in details and I can make a proper bid. I'm an experienced Web D More

$250 USD in 10 days
(8 Reviews)
3.4
MarcoAGarcia

Hi, I’m software and database developer with more than 30 years experience. In the past 20 years I have worked (in-situ) for two international organizations (Inter-American Tropical Tuna Commission, in San Diego, CA, a More

$722 USD in 10 days
(2 Reviews)
3.6
ivanivkovic

Hi! Sorry ... do not see a possibility to PM you before bidding so posting this one just so I can msg you :9 Anyway ... I've been dealing with similar requirements for some time although in telecomm area where I'm More

$555 USD in 10 days
(3 Reviews)
3.1
AlexYes

Hello, I'm an aspiring data scientist with an experience in various areas like databases, statistics, geospatial technologies, etc. You can see my qualifications on the exam badges below the profile, for instance I'm a More

$500 USD in 14 days
(4 Reviews)
3.2
cscinstructor

I have read and understand your requirements Please open chat window to discuss further.. ++++++++++++++++++++=====================================

$722 USD in 10 days
(4 Reviews)
1.6
Krishankarya1989

Hello! I can do this job for you. i having experience in this domain. also i am having team of professionals who are working with me. so this become an easy job for us. i am looking to get hearing from you ASAP. Th More

$444 USD in 6 days
(0 Reviews)
0.0
courteouselk

From the description of the problem it sounds like you have either some sort of company employee survey, or performance results (e.g. sales volumes) per department/employee. It could be rather hard to figure out tru More

$555 USD in 10 days
(0 Reviews)
0.0
ggenellina

I might use some data mining tools, but I think your questions can be answered by statistical analysis alone. I'm not sure of the required scope: do you want the analysis done on your current data? a methodology to More

$500 USD in 7 days
(0 Reviews)
0.0
kumarir01

The project requirement is relevant to my experience as I worked on many projects similar to this. Please contact me to discuss the project plan in details, Thanks,

$555 USD in 10 days
(0 Reviews)
0.0
pashotoska

A proposal has not yet been provided

$750 USD in 5 days
(0 Reviews)
0.0
ferminquant

A proposal has not yet been provided

$750 USD in 15 days
(0 Reviews)
0.0
sanjeevjbind

Sample questions mentioned in description are very relevant with my profile. I have been writing sql queries to get such reports for business decisions with high quality and in given time frame

$1111 USD in 15 days
(0 Reviews)
0.0
starbuck753

Please, share with me the questions, and i'll review them. It would also be very useful if you can share a model of the DB, to have an idea of how much information you have to answer thos questions. Thanks.

$250 USD in 7 days
(0 Reviews)
0.0
emihajloska

Dear Sir / Madam, For the lest 10 years, I have experience of working with Microsoft SQL Server as a database administrator and developer. I am responsible for design, development, implementation, normalization, o More

$555 USD in 10 days
(0 Reviews)
1.1