Find Jobs
Hire Freelancers

Create a Scrum Report in Excel

$80-100 USD

In Progress
Posted about 8 years ago

$80-100 USD

Paid on delivery
I am a scrum master that requires a reporting dashboard displaying various KPIs and determinants of performance. After the completion of every sprint, I will copy and paste various data gathered throughout the sprint into excel. I expect that excel will process this data automatically and generate a report on a dashboard page. I should be able to print this out in an A4 sheet. KPIs include: 1. Epics in the sprint & number of tickets in those epics, per sprint and over time 2. Epics in the sprint vs. hours logged in those epics, per sprint and over time 3. Statuses of the tickets and their frequency, per sprint and over time 4. Tickets resolved vs. tickets unresolved, per sprint and over time 5. Category prevalence per sprint and over time 6. Remaining time estimate changes per sprint and over time 7. Remaining time at the start vs. remaining time at the end of the sprint, per sprint and over time. We should be able to use pivot tables so that we can compare the performance across various metrics, issues added to the sprint, issues removed from the sprint, and all the variables above. The report should have text fields for us to log particular events, or changes that could account for the performance of the sprint, and over time. We should have a section for each sprint to explain why certain tickets could not be completed. these tickets will be assigned categories that correspond to the metric in #5. I need someone who is exceptional with Excel and capable of brainstorming with me on how to improve this report, and other KPIs that I haven't considered above. I should be able to show performance per iteration (2 week sprints) and those iterations across time to measure workflow effectiveness. I need someone whose English is perfect, can understand what I am requesting and can deliver without complication. I'm on a tight time crunch so help is appreciated. Please do not bid more than 100 USD. Thank you for bidding!
Project ID: 9696906

About the project

23 proposals
Remote project
Active 8 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
I am a Program Management professional and have experience in creating KPI based dashboards. I have the expertise in Excel & scripting in VBA and can do this task of dashboard creation, as per agreed scope and specification. Ready to start work immediately.
$100 USD in 3 days
4.9 (32 reviews)
4.5
4.5
23 freelancers are bidding on average $93 USD for this job
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) i can make copy paste job in excel will be automaticly via VBA :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely Prameswara
$100 USD in 3 days
4.9 (189 reviews)
6.2
6.2
User Avatar
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready to start Waiting for further discussion.. with thanks and regards
$88 USD in 2 days
4.5 (37 reviews)
5.5
5.5
User Avatar
Contact me for more info Dear employer: My name is Ana and I am interested in working with you. Efficiency, accuracy, adaptability, confidentiality and being always on time are my keys to success, which is exactly what I am willing to provide to you. I am fast learner and pay la lot of attention to details. I am fluent in English, French, Spanish and Romanian, and intermediate in German and Italian. I am working as paralegal since 2012, graduated from Law School in 2013 and was awarded many times for accounting and legal academic work, my studies being published. I have specialized myself in Civil, Administrative and Business Law so you can count on me for Legal writing (Academic, Contracts, Terms and Conditions), Legal research, Compliance and others on the Romanian and EU Legislation. I have also graduated from Business School in 2009, worked and I am still working as an accountant on my free time. I believe I can get you the results needed in the shortest time possible and in the most precise way, my received feed-backs being my testimony. If you believe we can work together, i am looking forward to hearing from you. Faithfully, Ana
$98 USD in 2 days
5.0 (2 reviews)
3.2
3.2
User Avatar
Greetings. I specialize in provide solutions for Business Administration, Data Base management, Key Performance Indicators design, Supply Chain Planning and Project Management for commercial and industrial companies. I am also able to develop complex and automated Excel spreadsheets and Access databases, including formulas creation, pivot tables, pivot charts, data manipulation and macros. I guarantee that I'm able to bring the solution for your project, with the dedication, seriousness and professionalism that it deserves. My work will give you the confidence to initiate a long term relationship. Thank you for your time
$100 USD in 0 day
4.1 (2 reviews)
2.8
2.8
User Avatar
Hello, I am very interested in your job post. I have done many jobs related to Internet Research, File Management, Saving & Organizing Files, Schedule & Calendar Management, Email Management, Social Media Accounts Management, Excel, Data Analysis, Data Scraping, Database Building, Data Processing, PDF Conversion, Data Entry, Email Marketing, Lead Generation, LinkedIn Research, Market Research and more. I am always online on Skype and Hangout. We can discuss there in details, if you are interested. Thank you in advance for your time and consideration. Regards, Hridoy
$100 USD in 3 days
5.0 (5 reviews)
0.8
0.8
User Avatar
I am expert on excel data entry and web research. The task is very easy as far I understand. I am able to start from now and complete the task with quick turnaround. I have several work experience like this, please see my work history at my profile. I assure you fast and accuracy service. You can take a test before give this job to me. If you impress then you give me contract and payment. Please consider my application. I am looking forward to hearing from you. Thanks tanzilarabeya
$88 USD in 3 days
5.0 (1 review)
0.6
0.6
User Avatar
Certified Scrum Master. Over 15 years in managing projects. Good with Excel Can work with you to get this done
$80 USD in 5 days
5.0 (1 review)
0.8
0.8
User Avatar
Hi there! I have read what you exactly need, however I would like to ask you a few questions. I would call myself a master of what I do, I do work smart and do not rest until I get the job done. Please feel free to ping me anytime so we can have a detailed discussion. If I can deliver I will deliver in best possible way. Thanks
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello dear, Can you please tell me how much scrum you have total and how much workers/employers scrums need to put on excel? I am ready to start now so that i could finished it in time. . . Knock me soon with your excel file with a sample scrum so that i can assure you about time. . . Regards
$90 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have designed dashboards before. I can share if you want. What is the time frame you willing to provide ? I would only be able to give a proper timeline when the sample data is shared and your requirement elaborated.
$83 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am WebScraping, Wordpress, eCommerce, Articles, Blog, Photoshop, PhotoshopDesign, WebsiteDesign, DataEntry, DataProcessing, WebSearch, CustomerSupport, MicrosoftOffice, Excel, InternetMarketing, SocialMediaMarketing, GoogleAdwords, InternetResearch. I am very much professional in this work I am pretty sure that you cant find a best person for this job like me so I am ready to work on your project with low rate and high quality.
$83 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Scope: The freelancer will assist the Scrum Master (client) in the development of a Performance Management Report in excel. The tool should be able to record the results of weekly sprints, as well as long term performance of tasks, stories, epics, etc. Deliverables Include: -Data Entry form for the scrum master to enter results -Summary KPI page with key performance indicators (below) -Possible dynamic story board page utilizing macros and or pivot tables -printable report on A4 size sheet -Impeded task/cancelled task summary/list KPIs include (but not limited to): 1. Epics in the sprint & number of tickets in those epics, per sprint and over time 2. Epics in the sprint vs. hours logged in those epics, per sprint and over time 3. Statuses of the tickets and their frequency, per sprint and over time 4. Tickets resolved vs. tickets unresolved, per sprint and over time 5. Category prevalence per sprint and over time 6. Remaining time estimate changes per sprint and over time 7. Remaining time at the start vs. remaining time at the end of the sprint, per sprint and over time. Freelancer Qualifications: -Over 10 years of process improvement and data analytics experience -Master excel user, VBA, Access, SQL -2 years experience with Agile program design at a major Fortune 50 Bank
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$92 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$88 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provide
$90 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Have done reporting for Mega projects run on Agile
$100 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have been a Scrum Master for more than 5 years and created various reports for the Product Owner and Stakeholders using mostly excel. I would be glad to assist you in creating and improving your reporting tools. I am also available to work immediately. Best Regards, Mark
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Have 2.5 years of work experience in scrum team
$80 USD in 0 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SWITZERLAND
Zurich, Switzerland
5.0
9
Payment method verified
Member since Apr 21, 2012

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.