Excel Data Analysis between 2 Retail Catalogs
Budget: $30 – $250 USD
I am looking for a proficient data analyst who can assist me in providing data analysis using Excel.
Specific tasks include: I have two online retail catalogs that sells similar products as one another. Medline & CVS Health.
Medline has 313 products listed and CVS Health has 892.
I need a comparison chart in any format (Excel or Word) that addresses:
1.) how many brand name products are under Medline. List then out.
2.) how many brand name products are under CVS Health. List them out.
3.) how many Medline specific products are under Medline. List them out.
4.) how many CVS branded products are under CVS Health. List them out.
5.) Which products does CVS health have that Medline does not? (Ex: reading glasses)
6.) Which products does Medline have that CVS Health does not? (Ex: hearing aids)
7.) any other similarities that both catalogs share among the products shown?
8.) any other differences between the products in the two catalogs?
Ideal Skills and Experience:
- Proficiency in Excel, including advanced features and formulas.
- A strong understanding of data analysis and visualization principles.
- Ability to clearly and effectively communicate complex data in a simple and engaging form.
Due date: I would need to have this completed by 4/8 at 10am EST.
I will send over the two catalogs (in PDF format) once I find the freelancer.
Specific tasks include: I have two online retail catalogs that sells similar products as one another. Medline & CVS Health.
Medline has 313 products listed and CVS Health has 892.
I need a comparison chart in any format (Excel or Word) that addresses:
1.) how many brand name products are under Medline. List then out.
2.) how many brand name products are under CVS Health. List them out.
3.) how many Medline specific products are under Medline. List them out.
4.) how many CVS branded products are under CVS Health. List them out.
5.) Which products does CVS health have that Medline does not? (Ex: reading glasses)
6.) Which products does Medline have that CVS Health does not? (Ex: hearing aids)
7.) any other similarities that both catalogs share among the products shown?
8.) any other differences between the products in the two catalogs?
Ideal Skills and Experience:
- Proficiency in Excel, including advanced features and formulas.
- A strong understanding of data analysis and visualization principles.
- Ability to clearly and effectively communicate complex data in a simple and engaging form.
Due date: I would need to have this completed by 4/8 at 10am EST.
I will send over the two catalogs (in PDF format) once I find the freelancer.