Find Jobs
Hire Freelancers

Analytics & Optimization Analysis

$30-250 USD

Kansellert
Lagt ut nesten 6 år siden

$30-250 USD

Betalt ved levering
This Excel workbook has three other tabs: 1) AB Test 2) OrderDetails: a report on all the orders placed that were assisted by chat 3) TranscriptReport: a report with details on each chat interaction between a customer and an agent Part A: The AB Test worksheet contains instructions on analyzing an A/B test. Present your findings and recommendations in a client facing PowerPoint presentation. Please take this opportunity to demonstrate your data visualization skills. Also show your work in an Excel file. Part B: The tabs 'OrderDetails' and 'TranscriptReport' contain data for the same client for the same date range. Create a PowerPoint file (1-5 slides) to share your 5 most meaningful insights and any recommendations based off those insights. As above, this should result in a presentation that could be presented to a client in a real-life scenario, so please take this opportunity to demonstrate your data visualization skills. Also show your work in an Excel file. Here are some notes about the OrderDetails report: - Note that the “Product” column, column C, actually contains 3 columns worth of data all separated by a tilde “~” character. You should separate the data in this column into multiple columns. - Also note that the “Conversions” column only contains a 1 or 0.  A conversion represents a completed sale, which may consist of 1 or more products.  Each row represents a different product within an order.  Therefore, in rows 3-5, which are all part of the same order (which is apparent through columns A and B), only row 3 contains a “1” in the Conversions column, whereas rows 4 and 5 contain 0’s.  This means when you add up column E, it will give you the correct number of total orders (not products sold). Please note that we also track a conversion as 'chat assisted' when it occurs up to 30 days after the chat interaction ended. - Column J is the Business Rule column.  A Business Rule describes how chat is displayed on a client's website (eg: one business rule could be to show a yellow click to chat button on the shopping cart page, another one could be to show a chat window when a visitor has spent 90 seconds on the shopping cart page).  You don’t need to understand the naming conventions for the business rules at this point. - Column K is the Page column.  These represent different pages (or groups of URLs) on the client’s website. Here are some notes about the TranscriptReport report: - This worksheet lists every chat interaction that took place for the client, both those that resulted in an order and those that didn’t.  The only additional columns are the Disposition Category and the Disposition Reason (a.k.a., sub-category).  Dispositions are how chat agents categorize a chat interaction after it concludes.
Prosjekt-ID: 16772881

Om prosjektet

8 forslag
Eksternt prosjekt
Aktiv 6 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
8 freelancers are bidding on average $218 USD for this job
Brukeravatar
Hi there..... Warm Greetings We came along with your request for Analytics & Optimization Analysis and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Analytics, Business Analysis, Data Analytics, Excel, Powerpoint We have worked on 325+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
$250 USD om 3 dager
4,9 (298 omtaler)
7,8
7,8
Brukeravatar
Hi, I would like to work for you. I will provide highly credible and well-researched business analysis with my senior level experience. You may validate my profile which is also certified as “Preferred Freelancer” with highest trust score - 100%. You may also look at my outstanding reviews and sample portfolio published here. I am a qualified finance professional with national merit and 25+ years of experience around Business, Strategy and Finance in US / EU MNCs. Presently I am into my own consulting services. With this background, I will be able to deliver better service for you. Look forward to hear from you. Best Regards / Sanjib
$200 USD om 6 dager
4,8 (70 omtaler)
6,5
6,5
Brukeravatar
Analytics & Optimization Analysis i am sure i will do that For starters, I always meet my deadlines head-on. I can provide successful solutions for anyone seeking out Business Plan, Business Proposal, Business Writing, Business Report and much more .
$246 USD om 3 dager
4,9 (79 omtaler)
6,1
6,1
Brukeravatar
Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.
$250 USD om 4 dager
5,0 (33 omtaler)
5,6
5,6
Brukeravatar
Hey, I can help you in completing all 3 tasks of Excel workbook as I have fully command on Excel and have an experience of 6 years in writing so I can handle your task very well. I will complete both parts A and B as mentioned in the description and I assure you that I will provide you an exceptional quality work on your desired time. I am an experienced freelancer with more than 200 positive reviews from my clients living across the globe and I assure you that I won’t disappoint you with my work. Please message me so we can discuss about it more. Thank you! Regards, Jennifer!
$155 USD om 3 dager
4,7 (26 omtaler)
5,4
5,4
Brukeravatar
I have been working as a research writer for most of my career spanning over seven years and have worked for diverse employers and clients
$88 USD om 1 dag
4,3 (34 omtaler)
4,8
4,8

Om klienten

UNITED STATESs flagg
Chicago, United States
5,0
1
Betalingsmetode bekreftet
Medlem siden apr. 24, 2018

Klientbekreftelse

Andre jobber fra denne klienten

Paid Social Project
$30-250 USD
Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.