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

Cerrado Publicado Oct 21, 2014 Pagado a la entrega
Cerrado Pagado a la entrega

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.

Algoritmos Extracción de datos Servidor de Microsoft SQL SQL

Nº del proyecto: #6622609

Sobre el proyecto

30 propuestas Proyecto remoto Activo Nov 27, 2014

30 freelancers están ofertando un promedio de $617 por este trabajo

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 Más

$555 USD en 10 días
(50 comentarios)
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 Más

$500 USD en 15 días
(77 comentarios)
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 Más

$833 USD en 10 días
(8 comentarios)
4.6
scsBiswas

I can do it. .

$250 USD en 10 días
(28 comentarios)
4.7
gargitservices

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

$500 USD en 4 días
(5 comentarios)
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 Más

$736 USD en 14 días
(3 comentarios)
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 Más

$250 USD en 10 días
(8 comentarios)
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 Más

$722 USD en 10 días
(2 comentarios)
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 Más

$555 USD en 10 días
(3 comentarios)
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 Más

$500 USD en 14 días
(4 comentarios)
3.2
cscinstructor

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

$722 USD en 10 días
(4 comentarios)
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 Más

$444 USD en 6 días
(0 comentarios)
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 Más

$555 USD en 10 días
(0 comentarios)
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 Más

$500 USD en 7 días
(0 comentarios)
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 en 10 días
(0 comentarios)
0.0
pashotoska

A proposal has not yet been provided

$750 USD en 5 días
(0 comentarios)
0.0
ferminquant

A proposal has not yet been provided

$750 USD en 15 días
(0 comentarios)
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 en 15 días
(0 comentarios)
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 en 7 días
(0 comentarios)
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 Más

$555 USD en 10 días
(0 comentarios)
1.1