Data Analysis Expert Needed (Business Warehouse, Excel, SAP, Quality Assurance)

Closed Posted Jan 28, 2014 Paid on delivery
Closed Paid on delivery

I work in quality department of some manufactory that produce different kind of property's/apartment's accessories. Located in quality of data analysis subsection. Prefer to not reveal what exactly (will later if needed) is being produced, although at the end of reading my post you would probably know what accessories they are. In reality always can go something wrong. No matter what kind of environment we work in. My project contains the case when whichever kind of problem occurs on client end location (property/apartment). Clients might be end users or resellers if some intermediate locations exist. For that project this isn't revelant but relevant is that the project includes situations when/where accessories are already physically on locations where they should operate. This is most likely user's living place. I plan to analyze within my project only situations when users contact repairmans to physically come to the doorstep, visit them, and fix the problem that occured on our manufactured accessories. Users might recognize this problem either by failure or by its consequence – it depends what failure is and what situation it is. Most of times by its consequence unless if failure is, e.g. noise (which happens very rarely, we all know noise is consequence of something going wrong). Such failure is recognized (heard) by users. But usually consequence is the red alert which causes user to contact repairman. How contact is being done doesn't matter. The only important fact is that user contacts repairman. Entire project is based on this assumption. If user tries to fix the problem on his or her or their own and even successfully, this does NOT count in the project. I don't even want to know this, it has zero meaning. Only situations I include are that users contact repairmans when something is wrong AND (!) that repairmen come to visit them with purpose to fix the problem. Just those two conditions matter. It doesn't matter if repairman comes within the deadline set by user, neither if repairman successfully fixes (usually they do) the problem on their first visit of user's living place already. Also it is completely irrelevant (but in analysis I might need to include such info too) when user contacts repairman. Problems for sure have priority than others: e.g. failures related to accessory' functionalities usually have priority than failures related to exterior shape/looking. Everything is in the database and I see all info/data. I analyse it in Excel, although I might need to work with data inside some other software such as mysql. I know data from Business Warehouse (excel's addon) can be transfered there from excel but I don't know much about mysql. Currently I work with few hundreds filters (I list few on request) and few thousands of conditions/parameters in those filters. I do NOT need to care about way how data is being filled into database, who exactly is filling it, neither whether or not something is missed. Just using data.

***So what Im trying to do: We have different manufactory departments. Each for its own type of accessories. Several types are being produced in our company. WHAT I WANT TO HAVE IS possibility to be able to announce for the FUTURE how many visits by repairmen will happen in unit % with accuracy up to two decimal digits. Such factor is number of visits divided by number of accessories produced. This is equation. Announcements should be grouped based on manufactoring department and based on country where visit happens (where user calls repairman and repairman comes to user's home). Many graphs comparions would need to be done. A lot needs to be done, towards getting this method, on how particular graphs are performing and compare pieces of them with same or similar pieces of new graphs. I would like to know some tips/suggestion where/how would I need to start with trying to develop such complicated data analysis algorithm.

Business Analysis Data Processing Excel Mechanical Engineering MySQL

Project ID: #5369387

About the project

15 proposals Remote project Active Mar 6, 2014

15 freelancers are bidding on average $715 for this job

xazoo

Hello! Being a Chartered Accountant and excel specialist, i would love to work on this project. Looking forward to hear from you soon. Thanks!

$1000 USD in 10 days
(70 Reviews)
6.3
funnyhoney

PMP, MBA in marketing and professional business analyst and advisor in the field of project management, marketing and branding, operations and team management/ training. Hourly rate $15. I have worked with extensive an More

$24 USD in 2 days
(37 Reviews)
6.0
zExcel

Would it be possible to send me the file (or sample file) so I can better understand the project --------------------------------------------------

$400 USD in 2 days
(42 Reviews)
5.6
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$666 USD in 30 days
(52 Reviews)
5.3
onlyshakil

Experienced statistician with a lot of practical knowledge in the field. Expert in all kinds of hypothesis/statistical analysis using tools like SPSS, R, Stata, SAS and AMOS

$1333 USD in 15 days
(6 Reviews)
4.0
caabdul

Greatings! I am chartered accountant and also have very fine experience in building excel based business tools. I am ready to provide you exactly what you want, in excel environment. Thank you

$640 USD in 15 days
(12 Reviews)
3.6
Midlander

I have the skills you need to predict future service levels with high accuracy, to develop "Benchmarks" for every Department for every country, to find who is "Best In Class", and - through those measure - you will pro More

$566 USD in 5 days
(5 Reviews)
3.5
mariannedelcu

PhD and MBA. Undergraduated courses in resource management. Large experience in logistics. Please send a message back to establish the details. I will be glad to help you. Respectully, Marian Nedelcu

$111 USD in 5 days
(6 Reviews)
3.4
vviswanathan88

A proposal has not yet been provided

$1000 USD in 5 days
(7 Reviews)
3.1
swapnildhake

Hey dear, All you need is a "Forecast". I would strongly suggest you should finalize the forecasting method. Then you can hire some other freelancer who has a past experience in forecasting.(being an R&D guy I don More

$300 USD in 1 day
(1 Review)
0.6
jpsaxena

High quality & timeliness. A Professor and Writer with multi-disciplinary professional qualifications, PhD, MBA, PGDM in Labor Laws, PGDM in Industrial Management, BE (Electrical) and BE (Mech.). I have taught O More

$561 USD in 10 days
(0 Reviews)
0.0
dogradiwakar

A proposal has not yet been provided

$888 USD in 15 days
(0 Reviews)
0.0
jugnuv

 Over 10 years of experience in analytics, consultancy, process improvements, operations and client relationship  6 years of rich experience in Analytics, predictive modelling, linear regression, logic regression More

$611 USD in 5 days
(0 Reviews)
0.0
imanindra47

when you need data processing or macro developer, i am the right person. I dont have any experience with real estate data, but if you tell me how its going, ill try to simplify your database by macro visual basic

$561 USD in 1 day
(0 Reviews)
0.0