Find Jobs
Hire Freelancers

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

$10-1000 USD

Closed
Posted about 10 years ago

$10-1000 USD

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.
Project ID: 5369387

About the project

15 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
15 freelancers are bidding on average $715 USD for this job
User Avatar
Hello! Being a Chartered Accountant and excel specialist, i would love to work on this project. Looking forward to hear from you soon. Thanks!
$1,000 USD in 10 days
4.8 (70 reviews)
6.3
6.3
User Avatar
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 and large data analysis in Excel and SPSS softwares. Looking forward to further discussion.
$24 USD in 2 days
4.8 (37 reviews)
6.0
6.0
User Avatar
Would it be possible to send me the file (or sample file) so I can better understand the project --------------------------------------------------
$400 USD in 2 days
5.0 (42 reviews)
5.6
5.6
User Avatar
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 response. Thanks.
$666 USD in 30 days
5.0 (52 reviews)
5.3
5.3
User Avatar
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
$1,333 USD in 15 days
3.8 (6 reviews)
4.0
4.0
User Avatar
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
5.0 (12 reviews)
3.6
3.6
User Avatar
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 provide "best value" to the company from your ideas. For twenty years at a leading Multinational company I helped the company decide which measure should be used as internal Key Performance Indicators (KPIs) and external Perception Measures. I then produced the Excel dashboards, reports and interactive spreadsheets that enabled management to measure and compare performance across one hundred countries. The results were so successful the Company won "Business Excellence" Awards and Prizes at regional, national and European levels. I would normally provide samples to let you judge my Excel skills for yourself, But you made this a "restricted" project. Which means I cannot send an attachment unless you send me a Private Message first. We can work together under a Confidentiality and Non-Disclosure Agreement if required. I will start as soon as you pay the fee into the site. I will then help you decide which things to measure. I will then put the Excel file together to produce the graphs and summaries and reports you want, Hope you find this of interest and look forward to hearing from you Bob Allen-Turl
$566 USD in 5 days
4.8 (5 reviews)
3.5
3.5
User Avatar
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
5.0 (6 reviews)
3.4
3.4
User Avatar
A proposal has not yet been provided
$1,000 USD in 5 days
4.8 (7 reviews)
3.1
3.1
User Avatar
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 dont have it :( ) I am not expert in forecasting, but I can try to implement the logic in excel (using formulas and logic), if you have a forecasting method. My only intention to place bid was to tell you that, I think what you need is forecast and there are established processes to forecast things Regards, Swapnil
$300 USD in 1 day
5.0 (1 review)
0.6
0.6
User Avatar
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 Operations Management, Supply Chain Management, Project Management, Theory of Constraints etc in MBA courses in the most renowned private university ‘Amity University Uttar Pradesh, Noida’. I have guided about 60 dissertation studies and have evaluated dissertation reports. I have written six books and 50 research papers. The details of the books are given below: a. Purchasing in Industrial Sector. b. Warehousing Management and Inventory Control. c. Production and Operations Management. d. Flexible Systems Management – An Application in Energy Conservation in Cement Plants. Refractory Engineering and Kiln Maintenance in cement plants. e. Cement Rotary Kiln – Total Productive Maintenance Techniques and Management.
$561 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$888 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
 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, CHAID, Decision Trees, Econometric modelling and clustering  Good command over SAS, SPSS, minitab, advanced excel  Exposure to other tools such as Cognos, Tableau, MS access and business objects  Six Sigma Black belt trained and Lean Certified from UK  Analytics o Have been working on SAS and big data o Very comfortable in handling complex analysis o Very comfortable with complex modelling techniques such as logistic regression, linear regression, decision tree etc  Process Improvement o Continuously involved in process improvements, using tools and techniques of lean, six sigma and other improvement methodologies
$611 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
0.0
0.0

About the client

Flag of SLOVENIA
Ljubljana, Slovenia
5.0
13
Member since Jan 27, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.