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

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.

Навички: Бізнес-аналіз, Обробка даних, Excel, Технологія машинобудування, MySQL

Деталі: who need sap, who can expert in excel, when i come home from work, what kind of work can i do from home, what kind of work can i do at home, what does algorithm, what business to start using excel, users of business plan, types of data graphs, types of algorithm analysis, types of algorithm, type of graphs, tries algorithm, sap work from home, quality assurance work from home, purpose of a business plan, problem set analysis, priority algorithm in c, new home business plan, new company business plan

Про роботодавця:
( 13 відгуки(-ів) ) Ljubljana, Slovenia

ID Проекту: #5369387

15 фрілансерів(-и) у середньому готові виконати цю роботу за $715


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 за 10 дні(-в)
(70 відгуків(и))

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 Більше

$24 USD за 2 дні(-в)
(37 відгуків(и))

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

$400 USD за 2 дні(-в)
(42 відгуків(и))

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 Більше

$666 USD за 30 дні(-в)
(52 відгуків(и))

I am expert in creating info-graphic layouts to highlight data, statistics, and facts. Ready to discuss details. >>Portfolio: [login to view URL]

$1000 USD за 1 день
(15 відгуків(и))

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 за 15 дні(-в)
(6 відгуків(и))

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 за 15 дні(-в)
(12 відгуків(и))

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 Більше

$566 USD за 5 дні(-в)
(5 відгуків(и))

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 за 5 дні(-в)
(6 відгуків(и))

A proposal has not yet been provided

$1000 USD за 5 дні(-в)
(7 відгуків(и))

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 Більше

$300 USD за 1 день
(1 відгук)

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 Більше

$561 USD за 10 дні(-в)
(0 відгуків(и))

A proposal has not yet been provided

$888 USD за 15 дні(-в)
(0 відгуків(и))

 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 Більше

$611 USD за 5 дні(-в)
(0 відгуків(и))

Hello! After reviewing your post, I am confident that we can partner with you to develop a custom application for your data analysis. We will work with you every step of the way to make sure we meet your timeframe Більше

$2061 USD за 30 дні(-в)
(0 відгуків(и))

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 за 1 день
(0 відгуків(и))