Find Jobs
Hire Freelancers

data analysis

₹100-400 INR / hour

已关闭
已发布6 个月前

₹100-400 INR / hour

2. Use the below problem context associated with the data to answer the questions below An E-Commerce Platform - has one of its Mother Distribution Centres (DC) set up in Mumbai which coordinates with its Three Child DCs: 1. Pune, 2. Aurangabad, 3. Nashik. For this assignment, we are considering 10 categories; 5 products each leading up to 50 products. There are 4 data sheets in the Excel File provided to you. 1. SKU Master: It contains information of BU, SKU, Brand, Model and Average Price 2. Sales Data: It contains information on Date, SKU, City and Volume 3. OPN STK: Stock that is available as on 01-01-2023 4. Stock Transfer: Contains information on incoming stocks to Pune, Aurangabad and Nasik from Mumbai from 01-01-2023 – 30-01-2023. NOTE: THE SAME DATASET WILL ALSO BE USED FOR ASSIGNMENT 6. Questions to be solved 1. Over the 30 days of observed sales, what is the total sale value of SKU B003 ?(INTEGER) 2. How much percentage of total sale quantity (Volume) did Household category achieve in the first week? (Jan 1 to Jan 7, both days included) (FLOAT - 3 decimal places) Hint: Construct a Volume Pareto Chart 3. What is the maximum sale value by a single SKU in a day across all days? (INTEGER) (Sale Value = Sale Qty * Price per Qty) 4. What is the least revenue generating category across all days? (STRING) 5. What is the percentage of sale value in Mumbai across all categories and days? (FLOAT - 3 decimal places)
项目 ID: 37453007

关于此项目

24提案
远程项目
活跃5 个月前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
24威客以平均价₹227 INR/小时来参与此工作竞价
用户头像
Hello, I bring a wealth of expertise in data analysis using Python, offering you a reliable partner to extract meaningful insights from your datasets. My proficiency in Python programming is complemented by a deep understanding of data analysis libraries, ensuring that I can efficiently manipulate and analyze your data with precision. My data cleaning and preparation skills are robust, guaranteeing the highest data quality. I excel in handling missing values, removing duplicates, and structuring data for analysis, paving the way for accurate results. Exploratory Data Analysis (EDA) is where I excel. I have a keen eye for identifying patterns, relationships, and anomalies in your data, and I present these findings visually to ensure crystal-clear comprehension. When it comes to statistical analysis, rest assured that I'm well-equipped to perform tests and hypothesis testing to derive actionable insights from your data. My goal is to empower your decision-making process with data-driven, statistically sound conclusions. Should your project require machine learning capabilities, I have experience implementing machine learning models using Python, enabling predictive and prescriptive analysis to further enhance your insights. Confidence, precision, and a commitment to delivering actionable results define my approach to data analysis. I look forward to collaborating with you and contributing to your project's success. Best regards, Derrick
₹507 INR 在40天之内
5.0 (3条评论)
2.8
2.8
用户头像
Hi, I am the best candidate for this job as I am proficient in data analysis and I can show you my assignments. I can easily meet your targeted deadline. Please inbox me to discuss further.
₹250 INR 在40天之内
4.6 (1条评论)
3.0
3.0
用户头像
Hello, I understand that you are looking for someone to analyze your data and provide the answers to your questions. I'm a experience in data analysis, specifically in Python, data science. I would be delighted if you could contact me for more information. Please feel free to reach out with any questions or concerns you may have regarding this project! Gickel O
₹500 INR 在40天之内
5.0 (3条评论)
1.6
1.6
用户头像
Hello, I am interested in your project and i can complete it within required time. I have appropriate experience in Microsoft Office Products(Word, Excel, PowerPoint, Visio, Project as well as VBA etc) of more than 10 years. I have completed different project in excel using inbuilt as well as custom formulas. You can share your project details with me in chat. Regards
₹250 INR 在20天之内
4.9 (2条评论)
1.2
1.2
用户头像
Hi , This is Jamal, I have read the requirements, please find the answers for the requested questions. Let me know if these are accurate and if I can be a fit for the project. Questions to be solved 1. Over the 30 days of observed sales, what is the total sale value of SKU B003 ? Answer (3590) 2. How much percentage of total sale quantity (Volume) did Household category achieve in the first week? (Jan 1 to Jan 7, both days included) (FLOAT - 3 decimal places)Hint: Construct a Volume Pareto Chart -- Answer 21% 3. What is the maximum sale value by a single SKU in a day across all days? Answer -- (V001) (Sale Value = Sale Qty * Price per Qty) 4. What is the least revenue generating category across all days? Answer (Mobiles) 5. What is the percentage of sale value in Mumbai across all categories and days? Answer (36.468%)
₹200 INR 在40天之内
5.0 (1条评论)
0.6
0.6
用户头像
I am willing to solve these questions in a matter of 2h for 110INR, i'm a beginner freelancer and i will try my best to be accurate and precise with my answers. looking forward to working with you!
₹100 INR 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
Dear Sir, With reference to your job vacancy advertisement published in this platform, I am writing to offer myself as a candidate for the post. I am skilled in MS Word, Excel, Web Search, Data Entry, Lead Generation, Copy-Typing, Email Typing. data mining You will be served flexibility and honesty. My communication level is super friendly and easy to reach. I hope my experience and other skills will fulfill the requirements for the job. I therefore, look forward to hearing from you. Feel free to message me anytime. Thank you.
₹250 INR 在40天之内
0.0 (0条评论)
0.0
0.0
用户头像
Dear Sir/Ma'am, I have clear understanding of your project. I am well versed in Microsoft Excel- its Graphical User Interface and VBA. I will handle this project efficiently. There may also be a room for automating your project so that you may do it again with few clicks. I will do this according to your formatting requirements. You can communicate to me right now. [1_753900_2_2.950%_3_94230500_4_Books_5_34.158%] Regards, Assefa Tesfaye
₹350 INR 在40天之内
0.0 (0条评论)
0.0
0.0
用户头像
Dear sir. I am Ashish Kumar. I understand that you looking for someone to analyze your data and provide the answer to your question. thanks.
₹250 INR 在40天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hey guys I am from INDIA and finding a project of data entry. I am expert in typing and data entry in speed. I can type in neat and secure manner. If you have any project like this you can inform me. Thank
₹250 INR 在40天之内
0.0 (0条评论)
0.0
0.0
用户头像
As a seasoned freelance data analyst, I bring expertise in transforming raw data into actionable insights. With a proven track record of delivering data-driven solutions, I excel in extracting meaningful patterns and trends to inform strategic decision-making.
₹250 INR 在40天之内
0.0 (0条评论)
0.0
0.0
用户头像
Prepares, compiles, and sorts documents for data entry. Verifies and logs receipt of data. Transcribes source data into the required electronic format. Transfers information from paper formats into computer files using keyboards, data recorders, or optical scanners
₹250 INR 在40天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hello I'm an graduate student, i can do your for within a day and if you aren't satisfied you don't have to pay
₹100 INR 在40天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi there, I'm a data enthusiast with a knack for transforming raw data into actionable insights. My expertise lies in data processing, data entry, research, Excel, and data mining, and I'm well-versed in tools like Excel, SQL, and Python. I'm a stickler for detail and a master problem-solver, always up for unraveling complex data puzzles. I'm also a team player with a collaborative spirit, always ready to share my knowledge and lend a helping hand. I'm particularly excited about the opportunity to contribute my skills to your organization's data analysis endeavors. I'm confident that my passion for data and commitment to excellence will make me a valuable asset to your team. Let's chat and see how I can help you achieve your data-driven goals. Thanks for considering my application!
₹100 INR 在40天之内
0.0 (0条评论)
0.0
0.0
用户头像
I understand that you are looking for someone to help you analyse two sets of data related to an e-commerce platform. You would like me to use the data analysis assignment to answer the following questions: 1. Over the 30 days of observed sales, what is the total sale value of SKU B003 ?(INTEGER) 2. How much percentage of total sale quantity (Volume) did Household category achieve in the first week? (Jan 1 to Jan 7, both days included) (FLOAT - 3 decimal places) 3. What is the maximum sale value by a single SKU in a day across all days? (INTEGER) 4. What is the least revenue generating category across all days? (STRING) 5. What is the percentage of sale value in Mumbai across all categories and days? (FLOAT - 3 decimal places). I have experience in preparing and sorting documents for data entry and entering data into database software and checking to ensure the accuracy of the data that has been inputted. Additionally, I have experience in resolving discrepancies in information and obtaining further information for incomplete documents as part of a contingency plan. I would be delighted to assist
₹100 INR 在40天之内
0.0 (0条评论)
0.0
0.0
用户头像
I am doing my best please give me you project i handle it.
₹100 INR 在50天之内
0.0 (0条评论)
0.0
0.0
用户头像
Interested Good accuracy and timely completion guaranteed. Am accountant and have proper working knowledge of typing and product entry
₹350 INR 在40天之内
0.0 (0条评论)
0.0
0.0
用户头像
Good evening. I offer Data Analysis on excel, I can answer any question. I also offer Data cleaning. hope to hear from you soon.
₹250 INR 在40天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hello sir, I am a student, I have come to this platform for the first time and I would like to work with you as a part-time. also, I have experience in writing on a ( project, topic, or article ) completing computer courses with an experience like... ( M.S.C.I.T, TYPING, MS WORD, MS POWERPOINT ) So pls give me a chance and I will do the job well on time with the expected results. thank you...
₹100 INR 在40天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi, This is Anirudh and I would like to explore this opportunity. I have prepared reports and dashboards in excel and this experience will surely help me to solve this problem. A solution sheet with the answers for all the above problems will be added, the sheet will be dynamic in nature if required. Suitable charts will also be presented for better understanding of data. I humbly request you to provide me this opportunity
₹100 INR 在14天之内
0.0 (0条评论)
0.0
0.0

关于客户

INDIA的国旗
Bhopal, India
0.0
0
会员自11月 20, 2023起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。