Numerical Data Categorization Expert Needed

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

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

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! ”

Profile image shabanalhuniti, United Arab Emirates.

Top entries from this contest

View More Entries

Public Clarification Board

  • EmadOwaida
    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
      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
      EmadOwaida
      • 2 weeks ago

      #ContestHolder are you still interested ?! Please advise.

      • 2 weeks ago
  • Farrukh Saeed
    Farrukh Saeed
    • 3 weeks ago

    Hi
    Please wait I am working on it

    • 3 weeks ago
  • EmadOwaida
    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
    1. EmadOwaida
      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
      EmadOwaida
      • 3 weeks ago

      Hello #ContestHolder , I have some question and comments I replied on my Entry , appreciate your feedback ASAP. Entry #6

      • 3 weeks ago
  • Qasim7347
    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
    Qasim7347
    • 3 weeks ago

    hi, I have some question to question to asses your sheet?

    • 3 weeks ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!