Find Jobs
Hire Freelancers

data analysis

₹100-400 INR / hour

Imefungwa
Imechapishwa 6 months ago

₹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)
Kitambulisho cha mradi: 37453007

Kuhusu mradi

24 mapendekezo
Mradi wa mbali
Inatumika 5 mos ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
24 wafanyakazi huru wana zabuni kwa wastani ₹227 INR/saa kwa kazi hii
Picha ya Mtumiaji
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 ndani ya siku 40
5.0 (3 hakiki)
2.8
2.8
Picha ya Mtumiaji
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 ndani ya siku 40
4.6 (1 hakiki)
3.0
3.0
Picha ya Mtumiaji
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 ndani ya siku 40
5.0 (3 hakiki)
1.6
1.6
Picha ya Mtumiaji
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 ndani ya siku 20
4.9 (2 hakiki)
1.2
1.2
Picha ya Mtumiaji
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 ndani ya siku 40
5.0 (1 hakiki)
0.6
0.6
Picha ya Mtumiaji
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 ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
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 ndani ya siku 40
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
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 ndani ya siku 40
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
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 ndani ya siku 40
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
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 ndani ya siku 40
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
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 ndani ya siku 40
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
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 ndani ya siku 40
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
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 ndani ya siku 40
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
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 ndani ya siku 40
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
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 ndani ya siku 40
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I am doing my best please give me you project i handle it.
₹100 INR ndani ya siku 50
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Interested Good accuracy and timely completion guaranteed. Am accountant and have proper working knowledge of typing and product entry
₹350 INR ndani ya siku 40
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
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 ndani ya siku 40
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
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 ndani ya siku 40
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
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 ndani ya siku 14
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya INDIA
Bhopal, India
0.0
0
Mwanachama tangu Nov 20, 2023

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.