Build out excel worksheets for presentation using test data

Exercise Details:

As the Senior Account Manager for the Lyft account, you are about to meet in person with our main contacts for a regular check-in. To prepare for the meeting, you need to perform a routine analysis on their usage; and be prepared to discuss product performance and potential growth opportunities.


You were able to download a usage report (csv provided as separate attachment) which, along with your knowledge of the use case and product, form the foundation of your investigation for the Lyft account. This usage file includes the API request from Lyft but not the API response that the customer would see. You’re not sure exactly what you’re seeking; you’re looking for any insight(s) you can derive from the data.

Please analyze the data provided using Excel (or similar), saving all views/manipulations of the data that you use to do your analysis. Save the output of your analysis within the same Excel file OR to whatever program you prefer.

Questions to guide your thinking as you perform your analysis:

• Are you finding any patterns, as you slice/dice the data?

• Which columns from the data might be helpful to report out on?

• What visualizations of the data will best equip our team to ask the right questions to Lyft, should we get the chance to talk with them?

This should only take a few hours for a veteran excel user.

Skills: Excel, Data Analysis, Data Visualization

See more: showing data excel internet explorer using excel macro, compare data across excel worksheets macro, import test excel quality center using vbscript, load data excel sql server using asp, compare data excel worksheets using macro, send data excel iseries as400 using vba, compare data excel worksheets, script pull data multiple excel worksheets, qtp vba macros excel create test data, excel spreadsheet test data, vba combine data excel worksheets, excel test data processing, create powerpoint presentation using excel, powerpoint presentation using excel data, calculate max drawdown excel using monthly data, insert data excel file database using jsp, monthly report excel using access data, inserting data excel file database using jsp

About the Employer:
( 0 reviews ) Seattle, United States

Project ID: #30213927

Awarded to:


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 comp More

$250 USD in 7 days
(14 Reviews)

5 freelancers are bidding on average $136 for this job

(19 Reviews)

will make your work as early as possible . we need to require your valuable confirmation sir/mam , we will complete your project on priority basis. thanks, Sushant Bhosale

$140 USD in 7 days
(0 Reviews)

Hello, I am a professional data entry specialist and a full time freelancer who can serve dedicated to you with experience of 6 years in my career as business consultant and auditor. I am honest and hard work person an More

$140 USD in 10 days
(0 Reviews)

I had studied MS excel so I am interester to do this [login to view URL] sure that I will summit the project within the given days with proper presentation.

$50 USD in 4 days
(0 Reviews)