Fermé

Create 7 Datasets in Excel using dummy/sample data based on scenarios

Job Description:

I need help creating excel datasets using dummy/sample data based on 7 scenarios.

Help Desk

Employee Engagement

Sales Rep Performance

Shop Performance

Sales Performance

Inventory Management

Courier Analysis

Each scenario/dataset will have it's own excel sheet and a set of rules, and I have already made a start to each one adding in sample data. (some examples attached)

I need this sample data for reporting mockups so there needs to be a lot of it. Some datasets will be large and others small, depending on the scenario.

I will provide all the descriptions and business logic for each dataset/scenario

One example:

Help Desk Dataset

- Populate the Help Desk table with daily dummy data for 1.5 years (01/01/2020 to 30/06/2021).

- The Number of rows that have "Status = Resolved" should increase slightly over time

- The average value of "Interaction Time" should decrease over time

This job will need someone who is good at using excel, modelling and working with large datasets

Compétences : Excel, Saisie de Données, Data Cleansing, Data Analytics, Excel VBA

Concernant le client :
( 10 commentaires ) Tyldesley, Manchester, United Kingdom

Nº du projet : #30927567

38 freelances font une offre moyenne de 68 £ pour ce travail

daniyal3214

Hello, I will be glad to assist you with that. I am an experienced Data Analyst and Excel expert holding years of experience. Lets discuss your project in detail and how I am highly suitable for this.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(147 Commentaires)
7.0
sajibdigital

"Hi there, I am Sajib, I am really interested in this project. Please see my profile for trust me that I can do your project. Thanks"

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(91 Commentaires)
5.9
merinsinha

Excel VBA Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this pla Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(135 Commentaires)
5.4
arunkumar9896

Hi Hope you are doing good, I can perfectly help you with that. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA an Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(13 Commentaires)
3.7
VbaStudio

Hello. I'm a specialist in Excel and VBA. I can help you setting up this file. If interested send message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(15 Commentaires)
3.9
mdzahedhossain

Hello, I am expert in data entry work. I already go through your project details and also look after your attached format. In my experience and expertise I will accomplish your task 100% accurately. If you want I can Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(8 Commentaires)
3.4
Mendez61187

I did econometry, statistic and economy. I am qualified and full experience in Excel, macros and VBA, so I am very tecnic in this field. I am interested in this project because I like to make formulas and models and I Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(5 Commentaires)
3.1
ismail80196

Hi, I understand perfectly your requirements. I am ready to start right now. I have strong knowledge about it. I'll give you Unlimited revision. I am ready to start work right now and can assure best service from my en Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(9 Commentaires)
3.0
kmekbalhossain

Hi there, Hi, I have taken a deep look on this project, and I am sure that we can work together. I have experienced in this kind of task. I will complete this task with your timeline and budget. Please give me a chance Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(5 Commentaires)
1.7
kashifbe20

Dear Client, Glad to extend my services as this project attracts me to show my excel skills. I am new bee in this field yet I am passionate, committed and with my dedication and experience I feel confident to deliver y Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(1 Évaluation)
0.6
Pankaj9810

Hey there ! Good day. I am Pankaj Ranga I would like to work with your project and I can surely provide the details you have specified on the project description. I can confidently say that I am knowledgeable enough to Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(0 Commentaires)
0.0
taranchenkovlady

Hello. Ryan B Vladyslav is here. I have +6 years of experience in Machine Learning && Artificial Intelligence. Especially I am good in: - Python/Django, JavaFx, Java spring boot,C++, C#, QT, ASP.NET, Node.js, JavaFx. - Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(0 Commentaires)
0.0
Qualitywork500

Hello Sir/Madam,I have read very carefully about your project and I am very comfortable in doing this. I have handled such projects before and I can complete it with full accuracy and before time. Please give me a cha Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(0 Commentaires)
0.0
rrdeploy

Hey there, I read your post carefully and understand exactly what you're looking for.. I can help you with YOUR 7 eXcel shEET entry. #ASAP Feel free to interview me on the requirements and pricing. (please review my Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(0 Commentaires)
0.0
msakhr111

Hello there, I have read your post carefully and find this task according to my interest. I am a data entry expertise, adequate in data entry and order supporting with an immense ability in quick typing speed and zero Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(0 Commentaires)
0.0
SadatHamis

I have great skills on all Microsoft office programs, strongly on Microsoft excel advanced features plus python programming skills for data advanced manipulation I have data entry advanced skills plus high typing speed Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 4 jours
(0 Commentaires)
0.0
zohrachishti

Hi there I have gone through your project requirements and I'm more than capable and willing to deliver it you. Let me assure you that I have been working full time data analyst for the past two years and have extens Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(0 Commentaires)
0.0
pathak1975

Good job my data entry in India at five years already I have my job data entry , I am hard working this industry,

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(0 Commentaires)
0.0
Kels4real

Hello Prospective client, I have a good skill in Capturing and recording important data. Using shortcuts and formula functions. Building charts and graphs. Sorting and filtering data. Utilizing pivot tables. Detail eac Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(0 Commentaires)
0.9
SITISUFIAAZAHAR

Hi, I can help you as I am good in this field, I have read you proposal and I hope we can work together.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(0 Commentaires)
0.0