Please summarize any insights from analyzing the datasets (2 attached Excel files) and prepare a one page summary for each exercise.
In order to better serve the customer database, public transit customer trip data through the use of Electronic Fare Cards, (EFC). An EFC is used for payment for each trip. Customers using an EFC are required to “tap” on and “tap” off each time they start and finish a trip. Each time a customer taps an EFC, data is stored. Customer trip data includes the following types of data:
- Tap ID: A unique record for each trip
- MTTapOnDateTime: The date and time that a customer taps on to a bus or train
- TapOnRouteName: The bus/train route that is used when the customer taps on
- TapOnLocationName: The location where the customer taps on to a bus or train
- TapOnGPS_X: The latitude of the stop location where the customer taps on
- TapOnGPS_Y: The longitude of the stop location where the customer taps on
- MTTapOffDateTime: The date and time that a customer taps off of a bus or train
- TapOffRouteName: The bus/train route that is used when the customer taps off
- TapOffLocationName: The location where the customer taps off of a bus or train
- TapOffGPS_X: The latitude of the stop location where the customer taps off
- TapOffGPS_Y: The longitude of the stop location where the customer taps off
- Distance: The total trip distance (in miles)
This particular dataset only shows customers that made at least one transfer. The data is not sorted in any particular order.
Prepare the following (from the Trip Data Excel File):
- Identify trends and breifly describe how you came to your findings.
- Prepare your findings on a one page summary
Exercise 2: Performance Data Exercise
With monthly operations performance meeting to discuss operational issues. A data file is attached consisting of the following performance metrics by four operating business units (A through D):
• On-time performance
Prepare the following From the Performance Data Exercise:
- Identify three areas of concern that you want to bring to the attention of the operations staff and develop charts using Excel to illustrate the three areas of concern.
- Prepare your findings on a separate one page summary
I have already worked as data/business analyst for retail/BFSI clinet doing the kind of analysis and strategy making requried for your project.I have experience in finding out areas of concern and trends for retail cli Plus
20 freelance font une offre moyenne de $149 pour ce travail
Hello, Hope you are doing well. I can help with your project Data Analysis. I can assure you the quality job. I have good experience in Algorithm, Data Entry, Data Processing, Electrical Engineering, Excel. We Plus
I have done MS Software Engineering. I had a course on DATA ENGINEERING, ML and Artificial Intelligence. I know all data mining techniques, Deep learning and data analysis techniques. I have worked on K-mean, ID3, Baye Plus
Hello, there, I am very happy to put my bid on your project. I am an expert of algorithm and data processing, so I am interested in and confident to do this project. I hope to discuss everything of the project in de Plus
Dear client I have read the description of the two exercises. I can do both and prepare summary report for both. please contact me. Roy
I have a good hands on working with Advanced R and Python and BI tools and technologies, AI, Big Data. I have quite a good knowledge of DL/ML Algorithm , have also developed Dashboards and Web Applications using flask/ Plus
I am data scientist and statistical analyst by profession with more than 4 years of experience. The requied analysis can be complete in a couple of days or earlier if needed. Being an analyst I have worked on similar Plus
Greetings, experienced professional in the field of Macros and Excel Spreadsheet, having more than 5 years experience in such projects. Allow me to complete your task. Best Regards Sample https://www.freelancer.c Plus
Hi Good day! A serious freelancer here! I have a lots of available time to this work. I can help you to complete this work, but need to know the full requirements to assess how long would it take to complete this Plus
Dear Sir. While reading your project description, I felt excited with intention to satisfy your demand. I’ll complete your project ASAP.
Dear client? I highly value professionalism and hold myself strictly accountable to represent my client’s work. I aim to form a long-term working relationship. For 3 years I’ve worked in Algorithm, Data Entry, Da Plus
Hi there, i understand your requirement and if you need a sample work,can provide within one hour. if you have any questions please let me know, can start now your project according to the your guide line with Con Plus
good with data science and machine [login to view URL] have good experience with neural network and deep learning so can increase the accuracy.
In addition to the requirement assigned, I'll use my Geospatial skills to provide you with the needed spatial analysis. bonus : I'll provide you with a simple web-map for you your exercise (for presentation purposes).
Have experience in pattern finding by correlation, clustering techniques, also working experience in process modeling
I have [login to view URL] Accounting. I have 6 years experiance in data entry and accounts.
Hi, i have 5 Years experience as Data Entry/Web Researcher/Web Designing/Ms-Access/Ms-Excel Expert Data Entry/Web Researcher/Web Designing/Ms-Access/Excel,MS SQL/HTML CODING. With over 05 years of experience,I am Plus
As i'm a skill able person for this project. Just trust me once you can't never look back. Currently, i'm a TCS employees as production support environment. Good command over the MS Office. If you giving me this oppor Plus
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I am a Plus