Urgent Excel Data Analysis

₹100-400 INR / hour

Dalam Kemajuan

Disiarkan

3 bulan yang lalu

₹100-400 INR / hour

You are the sales manager for "BeerMart", an online beer store in the United States. You want to build a recommendation system (collaborative) for your store, where customers will be recommended the beer that they are most likely to buy. You collect data about the ratings that the customers have given in the past. You can download the dataset from the link below. Description: Each record includes a beer's name and the user's name, along with the ratings he/she has given to the beer. All ratings are on a scale from 1 to 5, with 5 being the best rating. As you solve the case study, you need to complete the following tasks: Data preparation Choose only those beers that have at least N number of reviews. Figure out an appropriate value of N using EDA; this may not have one correct answer, but you should not choose beers that have an extremely low number of ratings. Data exploration What are the unique values of ratings? Visualise the rating values and notice: The average beer ratings The average user ratings The average number of ratings given to the beers The average number of ratings given by the users Recommendation Models Divide your data into training and testing dataset. Build user-based and item-based models. Determine how similar the first 10 users are to each other and visualise it. Compute and visualise the similarity between the first 10 beers. Compare the performance of the two models using test data and suggest the one that should be deployed. Give the names of the top 5 beers that you would recommend to the users 'cokes', 'genog' and 'giblet' using both the models.

ID Projek: 37713639

Tentang projek

20 cadangan

Projek jarak jauh

Aktif 3 bulan yang lalu

Ingin menjana wang?

Alamat e-mel

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda

Dapatkan bayaran untuk kerja anda

Tuliskan cadangan anda

Ianya percuma untuk mendaftar dan membida pekerjaan

Dianugerahkan kepada:

@Shankar9289

"Expert data analyst with a focus on crafting an effective recommendation system for BeerMart. Utilizing advanced EDA techniques, I'll identify optimal thresholds for selecting beers based on ratings count. Building robust user-based and item-based collaborative models, I ensure accurate predictions for enhanced customer satisfaction. Let's elevate BeerMart's user experience together!"

₹300 INR dalam 50 hari

0.0

(0 ulasan)

0.0

20 pekerja bebas membida secara purata ₹208 INR/jam untuk pekerjaan ini

@ashiruddin

With the explosive growth of e-commerce, it is pivotal to understand your customers' preferences in order to stand out from the competition. As a seasoned software developer and data analyst with 20 years of experience, I have spent significant time working with databases, such as MS SQL Server and MySQL, perfecting my skills in data preparation, analysis and visualization technique. I am confident these skills are what you need to build a robust recommendation system for BeerMart. During my career, I have learned that data-driven insights can only be obtained through thorough understanding of the project requirements and efficient use of all available data. My expertise in Excel and data exploration will provide you with clear visualizations about the average ratings for both the beers and the users as well as help determine an appropriate threshold value N for beer recommendations. Additionally, my proficiency in EDA will enable me to identify any potential outliers or inconsistencies that may affect model performance.

₹250 INR dalam 40 hari

4.9

(11 ulasan)

4.3

@alfigotryozi

As an experienced professional in algorithms, software development, and machine learning using Python, I'm confident that my skills match your data analysis needs. Throughout my career, I've completed multiple projects leveraging advanced Excel skills - such as VBA - to extract valuable insights from complex datasets like yours at BeerMart. With this proficiency, I will efficiently handle your data preparation, exploration, and the building of recommendation models you require. Furthermore, using Python alongside with Excel enable me to automate data processing tasks, improving overall efficiency and accuracy. Combining this with my experience in EDA (Exploratory Data Analysis), I guarantee reliable identification of the appropriate values for N to maximize the effectiveness of your recommendation system. Lastly, concerning your task for visualizing average ratings per user/beer and determining similarity between them, rest assured that I am highly conversant with appropriate visualization tools like Matplotlib and Seaborn. Equipped with these skills and my past experiences on similar projects, I can effectively showcase the desired comparisons and provide a comprehensive evaluation of each model's performance using infographic-like visuals. Let's collaborate to help BeerMart pour its success!

₹250 INR dalam 40 hari

5.0

(1 ulasan)

2.4

@suneelkuppili2

Dear, I am writing to submit a bid for your data entry project. We understand the critical importance of accurate and efficient data entry in maintaining the integrity of your information. I am committed to deliver high-quality results within the specified time frame, which covers comprehensive data entry services, including data verification, organization, and input across various platforms. We assure you of our dedication to precision and confidentiality throughout the entire process. Thank you for considering, and I look forward to the opportunity to contribute to the seamless management of your data.

₹250 INR dalam 40 hari

0.0

(0 ulasan)

0.0

@Marcuspolo

Im really good in excel and has a very experienced as well as organised approach in the corresponding field. Eventhough i can't provide a much flexible work hour , i can assure the quality of the which you are expecting

₹150 INR dalam 28 hari

0.0

(0 ulasan)

0.0

@IzhanAliSyed

Hi there! I'm thrilled at the chance to optimize "BeerMart's" customer experience with a dynamic recommendation system. Here's why I'm the perfect fit: Data Preparation: I'll carefully select beers with a significant number of reviews (N) for a reliable dataset. Through insightful EDA, I'll pinpoint the optimal N, ensuring statistical significance. Data Exploration: Delving into the dataset, I'll explore unique rating values, visually presenting key metrics like average beer and user ratings. Recommendation Models: Efficiently splitting data for training and testing, I'll deploy user-based and item-based collaborative filtering models. Evaluating their performance, I'll identify the most effective one for deployment. Top 5 Recommendations: Implementing the chosen model, I'll provide personalized recommendations for users 'cokes,' 'genog,' and 'giblet,' enhancing their shopping experience. Excited about the opportunity! - Izhan Ali Syed

₹100 INR dalam 40 hari

0.0

(0 ulasan)

0.0

@SHARMADISHA0405

I hope this message finds you well. My name is DIKSHA SHARMA, and I am a skilled freelancer with extensive expertise in Excel data analysis. I came across your project listing and am eager to offer my services to assist you in deriving valuable insights from your data. I am confident in my ability to contribute to the success of your project by leveraging my Excel skills to their fullest potential. I would love the opportunity to discuss your specific needs and how I can tailor my services to meet them. Please feel free to reach out to me to further discuss your project or to request additional information. I am excited about the possibility of working together and helping you unlock the insights hidden within your data. Thank you for considering my proposal. I look forward to the opportunity to contribute to your project. Best regards DIKSHA SHARMA

₹250 INR dalam 30 hari

0.0

(0 ulasan)

0.0

@vignesh31dr

Subject: Urgent Excel Data Analysis Bid Dear Client, I hope this message finds you well and I am writing to express my interest in providing you with urgent Excel data analysis services. I have a strong background in data analysis, particularly in using Microsoft Excel to derive meaningful insights from complex datasets.

₹100 INR dalam 40 hari

0.0

(0 ulasan)

0.0

@onyanjaratianara

Spécialisé en saisie, traitement, analyse de donnée, j'ai des années d'éxperiences en gestion et classification de donnée. J'ai suivie une étude universitaire en informatique d'où je suis cappable de vous fournir une bonne qualité de travail et dans le temps.

₹250 INR dalam 40 hari

0.0

(0 ulasan)

0.0

@rohan297

I am very Professional to this work. I have a lot of experience in Excel as a data analysis or Data Cleaning.

₹100 INR dalam 40 hari

0.0

(0 ulasan)

0.0

@divyansh2812

Hi! I read your all requriments I am Fully Expert In Data Entry School list Exam list any lists Numeric Data Entry I can revolve around entering numeric data I will Give you best work on your time and budget I'll keep working until you get Fully Satisfid with work. I'm New on Freelancer but Not For this job Trust Me sir/Mam just give me one chance to show my Experience in Data Entry thanks waiting for your Response...

₹300 INR dalam 40 hari

0.0

(0 ulasan)

0.0

@sujan51

Certainly! In data entry, I'd propose a systematic approach to accurately input information into databases, spreadsheets, or other systems. This involves meticulous attention to detail, ensuring data integrity, and employing efficient tools to streamline the process. Error-checking mechanisms and periodic audits would be implemented to maintain high-quality data.

₹250 INR dalam 40 hari

0.0

(0 ulasan)

0.0

@Venki00143

I am good in data entry and i have experienced of typing as well. I am current excel learning....

₹150 INR dalam 40 hari

0.0

(0 ulasan)

0.0

@rk7869955

₹100 INR dalam 42 hari

0.0

(0 ulasan)

0.0

@mausin3

I am good in data entry and i have experienced of typing as well .. . My typing speed is quick too ..

₹250 INR dalam 40 hari

0.0

(0 ulasan)

0.0

@Anshsood

I FEEL I AM VERY EFFICIENT IF I WORK IN AN ATMOSPHERE SURROUNDED BY LIKE MINDED PEOPLE. THE COMPANY HAS EMPLOYEES WHO ARE VERY PASSIONATE IN THE FIELD AND WORKING WITH THEM WOULD MAKE ME WANT TO PISH THE LIMITS AND DELIVER MORE

₹100 INR dalam 40 hari

0.0

(0 ulasan)

0.0

@rathodlaxman03

I'm expertise in using the excel and good in data cleaning so i hope I'm the best fit for this because i have work with excel data preprocessing, Data Entry, Data Visualization, Data Mining, Data Modeling etc all Concepts of data driven projects, i also work with Building reports in excel and making dashboard for getting business insights from the given data so i thilk i have enough knowledge and experience for this project

₹250 INR dalam 40 hari

0.0

(0 ulasan)

0.0

@bidipta6

As an highly skilled data entry specialist and Excel expert, I have a profound understanding of various data analysis techniques and can help you decipher invaluable insights within the BeerMart dataset. My three years of prior experience with ecommerce has taught me the importance and nuances of sales analysis and customer recommendations. Combining my knowledge of collaborative filtering models with your data, we can offer tailored recommendations to your customers based on their past ratings. My familiarity with EDA will ensure an appropriate selection of 'N' value to avoid extremely low-rated beers. Visualizations highlighting average user ratings, average number of ratings given by users, etc., would be graphically executed to aid comprehension. In order to intensify accuracy, I would partition the data into training and testing datasets for building user-based and item-based models. Moreover, my skills extend beyond data preparation and exploration; instead I'd equip you with the actionable points you need to develop a recommendation system that is efficient, scalable, providing suggestions that matter. Let's deploy not just one but a comprehensive solution that grants pre-eminence both in customer satisfaction and sales volume.

₹250 INR dalam 40 hari

0.0

(0 ulasan)

0.0

@Miss38

Hello, I acknowledge excel, microsoft word, and also data entry operators and also tele in please tell me the work sothat I will do that Thank you

₹250 INR dalam 40 hari

0.0

(0 ulasan)

0.0

@Gummadilaxman107

What are the unique values of ratings? Visualise the rating values and notice: The average beer ratings The average user ratings The average number of ratings given to the beers The average number of ratings given by the users Recommendation Models Divide your data into training and testing dataset. Build user-based and item-based models. Determine how similar the first 10 users are to each other and visualise it. Compute and visualise the similarity between the first 10 beers. Compare the performance of the two models using test data and suggest the one that should be deployed. Give the names of the top 5 beers that you would recommend to the users 'cokes', 'genog' and 'giblet' using both the models

₹250 INR dalam 40 hari