Numerical Data Categorization Expert Needed

Status: Closed
Prize: $52
Entries Received: 17
Winner: MagedAtya

Winner

Contest Brief

**Project Brief for Data Analyst Freelancers**

### Overview
We are seeking a skilled data analyst to organize and create detailed furniture packages for various property types and customer segments. The goal is to systematically structure these packages in Excel, covering multiple styles and accommodating property sizes from studio apartments to 4-bedroom homes. Each style will cater to different client types: holiday homes, new homeowners, expats, and investors.

### Objectives
- **Create Defined Furniture Packages**: Develop comprehensive lists of items included in each package tailored to specific client types and property sizes.
- **Organize Data Efficiently**: Present the data in a clear, accessible format in Excel that allows our team to understand and utilize the information effectively for sales and marketing strategies.

### Scope of Work
1. **Data Organization**:
- Compile and categorize furniture items into sub-bundles based on their style and utility.
- Align furniture sub-bundles with corresponding client types and property sizes.

2. **Excel Sheet Structure**:
- **Sheet 1 (Package Overview)**: This sheet should include a matrix that outlines each style and the corresponding packages available for studio to 4-bedroom configurations. It should detail which package types (holiday homes, new homeowners, expats, investors) are applicable to each style and size.
- **Subsequent Sheets (Sub-Bundles Details)**: Each subsequent sheet will focus on a specific package, listing all items that make up the sub-bundles for that particular package. Include columns for item descriptions, dimensions, materials, and any other relevant specifications.

### Deliverables
- **Excel Workbook**: The final product will be an Excel workbook that includes:
- A summary sheet with an overview of all packages by style, property size, and client type.
- Detailed sheets for each specific package, showing the breakdown of sub-bundles and individual items.
- **Documentation**: A brief document explaining the organization of the sheets and any assumptions or rules used in the data compilation.

### Requirements
- **Experience with Data Analysis**: Proficiency in Excel, including the use of formulas, pivot tables, and data structuring.
- **Understanding of Product Categorization**: Ability to logically categorize and structure product data for easy retrieval and comprehension.
- **Attention to Detail**: High level of accuracy in data entry and organization.

### Timeline
- The project should be completed within 2 weeks from the start date.

### Budget
- The budget for this project is negotiable based on experience and proposed delivery schedule.

### Application Process
- Please submit a proposal outlining your approach to the project, any similar projects you have worked on, and your availability to start. Include your rate and estimated time to complete the project.

This brief aims to guide the freelancer through the process of creating an organized and detailed representation of our furniture packages, ensuring clarity and utility for both our internal team and our customers.

Recommended Skills

Winner

Post a Contest Like This

Employer Feedback

“Highly recommended, Maged has many qualities. The ones that stood out to me: He was quick to understand the inquiry, his proactivity to suggest solutions and enhancement and speed of work! He replied to each adjustment positively and in a very short period of time. Will work with him again for sure! ”

shabanalhuniti, United Arab Emirates.

Top entries from this contest

Arshad1978 Pakistan

0
Prasanna95 India

0
msohailab Pakistan

0
EmadOwaida Saudi Arabia

0
msohailab Pakistan

0
bhuvanabkp123 India

0
adeelkj Pakistan

0
mrumar707 Pakistan

0
Arshad1978 Pakistan

0
Mujahid15 Bangladesh

0

View More Entries

Public Clarification Board

EmadOwaida
- 2 weeks ago
Hello #ContestHolder , did you noticed my comments regarding missing items in 2BR bundle that I notified you in my earlier Entry #6 that you rejected?! (I highlighted several points regarding some costs missed priced, so it lead to negative margins, I hope you take in consideration to cover and update in your database) .
- 2 weeks ago
1. EmadOwaida
  - 2 weeks ago
  Appreciate if you check my semi final Entry #34 and comment on it if you prefer some other format!?
  - 2 weeks ago
2. EmadOwaida
  - 2 weeks ago
  #ContestHolder are you still interested ?! Please advise.
  - 2 weeks ago
Farrukh Saeed
- 2 weeks ago
Hi
Please wait I am working on it
- 2 weeks ago
EmadOwaida
- 3 weeks ago
Salam & greetings #Contest_Holder , this is amazing project, and I am really very interested. some how I did before similar project (it was related to selective bill of material (BOM) related to construction company. I can do better for your project since your project is more challengeable Includes multi options for each category .
- 3 weeks ago
View 3 more messages
1. EmadOwaida
  - 3 weeks ago
  allow me here , I will just temporary share in Demo Entry , some Sample of what I explained in my above previous briefing . I will highlight my initial Entry , because these screenshots will be only temporary , till I shared with you my final official entry
  - 3 weeks ago
2. EmadOwaida
  - 2 weeks ago
  Hello #ContestHolder , I have some question and comments I replied on my Entry , appreciate your feedback ASAP. Entry #6
  - 2 weeks ago
Qasim7347
- 3 weeks ago
you any kind of stock record beacause a stock record based any type of data base automation,
- 3 weeks ago
Qasim7347
- 3 weeks ago
hi, I have some question to question to asses your sheet?
- 3 weeks ago