Data Visualization - Reporting

已关闭 已发布的 Jul 3, 2014 货到付款
已关闭 货到付款

We have a custom log file generated by a web site process that I would like broken down in every conceivable way, analyzed and a report generated with graphs and results to identify trends in terms of load time by specific time of day, by user type, by method, by type dealer vs. admin, by dealer to see if some are slower than others, by method, etc. to help us to determine the characteristics of the save process performance and identify the areas where we should focus our software developers to improve performance.

The log file (attached as csv) contains 300,342 records which represent all uses of the "edit vehicle" application from time to load the page, to each step in processing the form post for the complete days 6/30/14 - 7/2.14. There are two versions of the form; dealer and admin.

The user list export is also attached.

Here are a list of Fields with a description of each...

RecordID, UserID, UserType, UserName, MethodName, EventDateTime, TotalTime, Description

RecordID :

Just a standard auto-generated auto-incrementing integer record id for each entry

For example

80409

80410

80411

UserID :

This is a GUID (globally unique 40 character id) that identifies the user.

For example

a599c65e-ef51-4f8d-ba27-bd3ba42cf1b9

6d8523ff-3df4-46b9-83f6-700e1371e30f

fc856344-ea70-411e-af5c-f8f0f55b0333

These values can be used to look up the user record as the record userid will match the userid field in user export provided.

If the record exists then we'll want to pull in the user type as first and last name of the user which often also includes the dealer name if applicable.

UserType, UserName :

See UserID above.

Method Name

As I mentioned above the method name represents each unit of functionality of the save process.

For example

PageLoad

GetAlbumDateTime

UploadImage

UploadImageToDB

SaveImages

Some of the methods are summaries for a series of other methods. For example the GetAlbumDateTime, UploadImage and UploadImageToDB methods are looped for the total number of images attached via the edit form for the vehicle and the SaveImages represents the total time for the entire loop.

It is critical that you review the log data to gain an understanding of the various methods to how the process flows in order to properly analyze the data.

I will submit questions to the developer that wrote the logging feature on your behalf if necessary.

EventDateTime

This is a Date Time field that represents the time of day in server time, Eastern Standard Time (EST), when each event occurred. When exported to CSV this field takes the format dd/mm/yy hh:mm on a 24 hour clock. The data will need to be sliced and diced by date and time and reported using AM/PM notation rather than a 24 hour clock so you need to be experienced in working with and manipulating time date data elements.

For example

6/30/14 8:17

7/1/14 16:03

TotalTime

This represents to total elapsed milliseconds (1000th of a second) units this TotalTime/1000=time in seconds and (TotalTime/1000)/60=time in minutes.

Obviously when doing the analysis at a summary level you will need to make sure that the summary methods and the individual methods are not both included.

For example

1191

1

13

Description :

This is the description of the method

For example

PAGE LOAD FROM THE DEALER END. VIN:2G1FC1E30D9151435

Save the Interior Dimension feature from the dealer end

function called to get both album name & image name through an array object from the dealer end

商业分析 数据挖掘 数据处理 报告写作 软件测试

项目ID: #6145534

关于项目

14个方案 远程项目 活跃的Aug 3, 2014

有14名威客正在参与此工作的竞标,均价$273/小时

funnyhoney

PMP certified project manager, MBA in marketing and professional business consultant and analyst in the field of project management, excel analysis etc. Looking forward to further discussion.

$315 USD 在3天内
(60条评论)
6.4
topacademics

My basic objective is to provide high quality that completely fulfill your requirement in order to build Nice business relationship all I always write handle present original text. with no plagiarism issue.

$250 USD 在5天内
(70条评论)
6.3
ishtiak146

Sir I am an experienced academic writer having MBA..... It is a very easy project for me..... I promise you perfect completion of this project within the shortest possible time.... Please check my portfolio 更多

$147 USD 在3天内
(105条评论)
6.2
JonnaNueros121

I am a professional full time academic research writer fully proficient in HARVARD, APA, MLA, Chicago and Oxford writing styles. I am competent in writing dissertations, thesis, reports, case studies, personal developm 更多

$368 USD 在3天内
(60条评论)
6.0
ethicalboy

Hello ready to start asap to deliver you,but I like to create a free sample in advance, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel and vba expert. I have done similar p 更多

$199 USD 在5天内
(46条评论)
4.9
RafNancy

Being an experience academic writer and well researcher. I am 100% confident I can do this project perfectly. I have already written PhD and Master's Level Paper for UK and US Students and I can easily work on it. I am 更多

$300 USD 在4天内
(15条评论)
4.8
dobreiiita

Hi, I am interested in this project. I have past experience in similar projects. Here is what I did on this site: https://www.freelancer.com/projects/4783149.html Looking forward to hear from you. Please let me kno 更多

$300 USD 在10天内
(30条评论)
4.7
flashsaiful

Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful

$777 USD 在7天内
(29条评论)
4.7
liviakecskes

Dear employer! I'm Esther from Hungary and I think I can do this data visualization project for you. I'm learning business analysis at the university and I'm sure that my skills will be enough to do a meaningful analy 更多

$200 USD 在5天内
(14条评论)
4.3
Emam9109

Hi, I am a professional writer and I have some expert academic writers .They are very proficient. I always check and recheck before sending to the client .Do not worry about deadline. I am eagerly waiting for your r 更多

$309 USD 在4天内
(11条评论)
4.0
trichel

I am both and MBA and MS Excel/Access expert with 25 years of business analysis experience. You have 395 users, of whom 74 actually processed transaction during the 3 day time period. I was able to follow in you 更多

$200 USD 在3天内
(2条评论)
1.1
saurabhgoel85

Hello sir, I am working as an analytics professional with more than 4 years of relevant work experience. I have got huge exposure to Excel and other various forms of databases including sales force. I think i w 更多

$166 USD 在4天内
(0条评论)
0.0
pushar71

Hi I have been doign this kind of work for past 15 plus years, keen to do this taks for you, plese share with me the csv file and i can create some sample reports for you. rgds, Puneet

$155 USD 在3天内
(1条评论)
0.0