Data Visualization - Reporting
$30-250 USD
货到付款
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名威客正在参与此工作的竞标,均价$273/小时
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.
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.
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 更多
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 更多
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 更多
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 更多
Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful
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 更多
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 更多
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