Find Jobs
Hire Freelancers

Analytics _ Excel

£20-250 GBP

Completed
Posted about 5 years ago

£20-250 GBP

Paid on delivery
You have been provided with sales data, in a CSV file, for the trading period 01/01/18 to 31/03/18 inclusive. The sales data is from nine separate M&S stores in the North of England. Daily sales are recorded at the departmental level: Food, Homeware and Clothing & Footwear. There is also information on whether there was a major sales promotion in a particular department for each trading day. Additional information is also available (i.e. see excel doc name: "Additonal_Info): • Store code • The size of each department in each store to aid comparative analysis • Daily capacity of food distribution centres in revenue terms, together with distribution costs to each store per £1 of food sales revenue (food sales revenue is used as a proxy for the amount of food actually transported). You have been asked to perform some analyses on this data set and develop analytics functionality for the use of the regional directors. Specifically: 1. Inspect and clean the dataset plus comment upon the overall validity of the sales data. 2. Develop and demonstrate an Excel-based dashboard to summarise the main points of interest from the data set and allow further detailed data enquiries. 3. Utilise Monte Carlo simulation to perform a risk analysis of profitability levels in the Leeds Homeware department (Note: the analysis should assume overall gross profit margins between 60% to 70% on revenue sales. The department also makes a daily contribution to overheads of £6,250. Use non-promotion sales only for your simulation). 4. Use optimisation processes to minimise the transportation costs of food from the M&S northern distribution centres (Note: the distribution centres must be able to deliver, at least, the equivalent of maximum non-promotion day sales to each store). 5. Demonstrate a critical awareness of the impact of the data. Further information: 1. The tasks will be performed and presented in Excel 2016. 2. Explain in a clear and comprehensive way the analysis of the data. Do not get too technical.
Project ID: 18656260

About the project

22 proposals
Remote project
Active 5 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
Awarded to:
User Avatar
Hi there, My name is Prateek, I have gone through the data and I will prepare the dashboard and the data compilation as required. I have more than 7 years of experience in working with excel skills. Message me so that we can discuss in detail the requirements. Thanks
£100 GBP in 2 days
4.9 (23 reviews)
4.8
4.8
22 freelancers are bidding on average £186 GBP for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
£220 GBP in 3 days
4.9 (335 reviews)
8.0
8.0
User Avatar
Hi, I know business analysis, statistics and excel very well. I can perform this project with a high quality. I have completed many similar tasks. Regards, Alex.
£250 GBP in 5 days
5.0 (34 reviews)
7.3
7.3
User Avatar
Hello? How are you? I have good experiences in "Analytics _ Excel" as you can see my profile for these (Business Analysis, Data Entry, Data Processing, Excel, Web Search). I have been working for 7 yrs in this scope. While we contract and work in our jobs, I will get paid once you have confirmed satisfied result. If I do not deliver satisfied result, I will never get paid from you. We can discuss more details to understand more easily if you have other infos. Hope to work with you. Thank you.
£155 GBP in 3 days
4.9 (101 reviews)
6.8
6.8
User Avatar
Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, PYTHON, WEKA, TABLEAU and EXCEL tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash
£500 GBP in 3 days
4.8 (81 reviews)
6.8
6.8
User Avatar
Hi Do you want to see a sample of your project on analyzing some data set and developing analytical functionality of the use of the regional directors completed before you award the project? You can consider it professionally done in less than 24 hrs. I am confident I can exceed your expectations since I am accustomed to doing this sort of job on a regular basis. I am highly skilled in the following areas: 1. Excel 2. Data Entry 3. Web Search 4. Data Analysis 5. Data Processing 6. Business Analysis I am passionate about flawless results and I can assure you of a job well done. I’d love to discuss more about what would make this project a success for you. Can we have a quick chat? Thanks for your time.
£150 GBP in 3 days
4.9 (58 reviews)
6.5
6.5
User Avatar
I have a good hands on working with Advanced R and Python and BI tools and technologies, AI, Big Data. I have quite a good knowledge of DL/ML Algorithm , have also developed Dashboards and Web Applications using flask/django. My area of expertise is building financial models (Stock Markets) , Image Processing and building models for food, healthcare and telecom sector, Classification/Prediction/Clustering, NLP and Chatbots. Specifically, I have worked for long on machine learning and Deep learning including computer Vision and natural language processing and model building for the same. I understand the project requirement and will deliver the desired product within the time specified. I would like to hear from you. Thanks Shivam
£250 GBP in 3 days
4.7 (54 reviews)
6.5
6.5
User Avatar
I possess exceptional data and statistical analysis experience. I use Excel, STATA, R-Programming and SPSS software’s in qualitative and quantitative research and report writing. I hold MBA (Strategic Management) undergraduate degree (Statistics) & CPA.K (Accounting and statistics.) As a data and research analyst, I have attained utmost discipline in delivering quality, accurate and reliable results. Happy to work with YOU
£300 GBP in 3 days
4.7 (112 reviews)
6.2
6.2
User Avatar
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
£100 GBP in 3 days
4.6 (84 reviews)
5.8
5.8
User Avatar
I am experience SPSS, Minitab. Excel. Presentation, Power pivot table, regression (Trend line) & correlation analysis, statistical test, linear programming, formula creation, graph creation and report writing. You may go through Finance Trading Statistical Analysis, Academic Research Paper and Water Bottle Market Survey file (https://www.freelancer.com/u/EngrShahidul.html), for my relevant skill please. Let me know your data and objective of study (requirement of analysis), so that I can think of job.
£100 GBP in 3 days
4.9 (34 reviews)
4.9
4.9
User Avatar
Dear Customer, your project is really interesting and I can help you in this quantitative analysis. More specifically, - point 1 is pretty simple, although it requires several effort, because one error might be crucial for the analysis. - Point 2 requires a meaningful summary of the main findings of the analysis, also imagining directions of the future research. - The Monte Carlo simulation included in point 3 can be done. I see you did not refer to any statistical distribution. We should set this point before doing the analysis. - Transportation costs can be assessed and optimized through the usual methods of transportation problems. - Point 5 is strictly connected to point 2, depending on the real findings. I understand that you need a comprehensible report, not written in too technical language, and I can do it. Please, feel free to contact me in chat if you want to share with me some further detail. Best Regards, Marzio
£333 GBP in 7 days
4.8 (8 reviews)
4.1
4.1
User Avatar
As an: - Bachelor of Applied Mathematics - Engineer in Statistics and Applied Economics - Microsoft Office Technician (Microsoft Graduate: MOS Diploma), - I have skills in programming language R, Python, Minitab, SPSS I am able, available and ready to do this kind of work in the best conditions,
£50 GBP in 5 days
5.0 (11 reviews)
3.9
3.9
User Avatar
Hello, am glad I have found your task. I have been a freelance writer for more than 5 years and guarantee well-researched work full of content matched with timely delivery. I guarantee that if you hire me, I will deliver professional work that meets your specifications. Kindly get back to me so that we can discuss further concerning the task. I am also ready to attach a Turnitin report if required. Am looking forward to hearing from you. Thanks.
£45 GBP in 3 days
3.6 (4 reviews)
2.6
2.6
User Avatar
hello,i am an experienced data analyst with skills in excel,power BI,tableau and spss,i can work on your project for you.i wont let you down when given the chance,i hope to hear from you soon
£166 GBP in 2 days
5.0 (1 review)
0.6
0.6
User Avatar
Trust us we Able to do this task and we can give you a living example before we start working with us the Company Professional in: Data Entry Data Processing, Excel Virtual Assistant PHP Software Architecture Hello I have seen your project and I think we will do a good job together
£55 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I work in top Chinese stat-owned Enterprise, professional in data immigration & data query. expert in mySQL, postgreSQL, I have experiences in processed billions of data every day.
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I AM HARDWORKING AND FIRM DETERMINE PERSON.I HAVE A SEVERAL HOURS PROGRAMMING EXPERIENCE IN GOVT SECTOR .I HAVE A WELL VERSED KNOWLEDGE IN MS OFFICE PACKAGE .
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
work in time and full accuracy with satisfaction. i am believe in hard work and value of time. I am any work done with full planning for taking less time.
£555 GBP in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Accurate report to be submitted on agreed time of submission. Looking forward to do the project for you.
£20 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have project management experience for 15 years. I have used MS office extensively for my projects. I have done this kind of work before. Thank you, Deb mazumder
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
LONDON, United Kingdom
5.0
1
Payment method verified
Member since Feb 4, 2019

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.