1 2 Title of your report Your name, your id Course name, Assignment … VIT address Supervisor/Lecturer name Abstract A very brief summary of 5-10 lines, what analytics you are doing here, steps and so...

1 answer below »
I HAVE ATTACHED ALL OF THEM. THIS IS A GROUP PROJECT.SO NEED A QUALITY WORK. PLEASE USE THE TEMPLATE AND NEED A PRESENTATION FOR THIS ASSIGNMENT. IT SHOULD BE 10MINUTES AND NEED SPEAKER NOTES AS WELL. ALL THE INSTRUCTIONS ARE AVAILABLE IN THE ASSIGNMENT PLEASE GO THROUGH ALL OF THEM PROPERLY.NEED A BEST WORK


1 2 Title of your report Your name, your id Course name, Assignment … VIT address Supervisor/Lecturer name Abstract A very brief summary of 5-10 lines, what analytics you are doing here, steps and so on. I. Introduction O verviw of project you are doing. This is kind of introduction and literature review of the report. When someone read only this part, should understand what you are going to do in next section and the motivation and why someone spends time to read your report. You should also talk about the data and steps in brief. I expect a page of writing for summary. You can do some literature review from internet and use them here. I expect at least the following sections after this: 1) Discussion, 2) Conclusion, 3) Reference and 4) Appendix for your code. The below is only a template. Remove the text and type your own discussion and graphs. In reference section, you might have references. II. Discussion and Analytics Your discussion and your graphs all should be here. Graphs need to be labeled, e.g. Fig 1, and discussed inside the context. Put label below the figure and discuss them inside the text. At least 4-6 plots. Plots should be the results of your python code. III. Conclusion You need to conclude your results and give recommendation. Recommendations and so on. Acknowledgment If someone helped you in preparing and implementing python code, you should acknowledge him/her here.. References [1] Reference 1. [2] Reference 2 [3] Reference 3. [4] Reference 4. [5] Reference 5. Appendix: Python Implementation Copy or type your python code here. Make sure it is enough clear to follow. When I implement your code, I should get the same results. November 2020 MITS6005 Big Data Major Assignment Copyright © 2020 VIT, All Rights Reserved. 2 MITS6005 Major Assignment Major Assignment – Group (2-3 members) Weightage: 30% Submission deadline: Session 12 The purpose of assessment is to assess students on the following Learning Outcomes: LO2: Expertly apply techniques to perform big data query manipulation, evaluate various data storage option and type of aggregated data modelling. Through a critical study, choose an appropriate storage model based on the application requirements for processing large amounts of structured and unstructured data. LO3: Independently perform data manipulation and querying (including updates, transactions, and indexes) big data applications dealing with high volume using NoSQL. Organize, store the collected data and manipulate by crafting queries. For example, using Hive, HBase and related data tools. LO4: Carry out research on emerging Big Data technologies to evolve models/solutions such as configurable and executable compute jobs on top of using distributed and shared memory architecture and Resilient Distributed Data Sets (RDDs). LO5: Implement typical solution use cases in big data context using technologies such as MapReduce and Spark Framework and using ecosystems such as Hadoop (or other similar platform). Objective You will work with your group and leverage the data provided by Pixystems (see the Data Overview above for a high-level explanation of data provided) and information obtained from the CFO to identify areas for financial and operational improvement, address issues and errors found in processing of data. To do this your group must create analytics that will assess the validity of data and provide the insight the CFO is looking for. It is expecting that you have a visualization report representing the analytical procedures you performed and assumptions you made. The project data required for the given case study is Copyright © 2020 VIT, All Rights Reserved. 3 MITS6005 Major Assignment provided in “Fictional Project Data.xlsx” with the relevant records as tabs in the spreadsheets. You will have 10 mins minutes to present this visualization, assumptions made, and recommendations. Each member of your group must have an active speaking role within the presentation. Description Read carefully “Pixystems_Toys_Information.pdf” file. You are going to do the analytics using Packages in Python or the choice of your package. You can use “Tableau Server Client” and write your code in Python https://github.com/tableau/server-client-python , or you can use other libraries in Python or choice of your package libraries; it is your choice. If you are using Python then it is one of the most frequently used programming languages in many fields, particularly in data science. There are many libraries in Python for various tasks including big data and data visualization. You must do some research on python packages or choice of your packages, find proper ones for the below task and use them for analysis and writing your report. But at the end, we expect a quality work from you. For Python code, you can use Python Anaconda or Google Colab. Colab is a free notebook environment that requires no setup and runs entirely in the cloud. You need to login to google Colab to enable to use it. https://colab.research.google.com/notebooks/welcome.ipynb Your report should have 1000-1500 words addressing the business questions, challenges, analytics and data visualization in “Pixystems_Toys_Information.pdf”. It should cover what you are going to solve and how, plots and recommendations. The report should have at least 6-10 plots (screenshots) from your findings with explanations. The program code needs to be added at the end of the project. The template of the word file is provided as “MITS6005-Report format for assignment-3.doc”. The presentation should be a maximum of 10 minutes for the whole team. Each member should talk at least 2 minutes related to the project and findings. The whole presentation should cover the data, business questions, research findings and visualization and step by step discussion on how you’ve achieved this project. You will also prepare a final report outlining the following: https://github.com/tableau/server-client-python https://colab.research.google.com/notebooks/welcome.ipynb Copyright © 2020 VIT, All Rights Reserved. 4 MITS6005 Major Assignment • Results of the analytics you performed along with your rational for performing and assumptions made. • Insight that the analytics provided management • Explanation of any analytics you decided not to perform • Recommendations your team has for improving Pixystems’ processes • Overview of any other issues that Pixystems should follow-up on • Recommendations on system controls that could be put in place • Any other data you would like to have obtained from Pixystems General Instructions 1. Your writing should be clear and concise and be in your own words. 2. The report must be in the range of 1,500-2,500 words in length excluding references. 3. Your report should be a single word or pdf document containing your report and need to be submitted through Moodle. 4. One submission per group and make sure all group members there with contribution table at the end of the report. 5. One submission per group and make sure all group members are active in the video with at least 2 minutes talk from the project. 6. Use headings to guide the reader and include tables or diagrams that make the case clearer. 7. The program code needs to be attached at the end of the report as an Appendix. 8. The referencing style must follow the IEEE referencing style. Submission Guidelines 1. Follow the links in Moodle to upload your report on or before the deadline. The report must be submitted on the LMS in the respective link i.e. MITS6005 Major assignment- (Melbourne/Sydney) 2. All submissions are to be submitted through turn-it-in. Drop-boxes linked to turn-it-in will be set up in the Unit of Study Moodle account. Assignments not submitted through these drop-boxes will not be considered. 3. Late penalty applies on late submission, 10% per day would be deducted. Submissions must be made by the due date and time (which will be in the session detailed above) and Copyright © 2020 VIT, All Rights Reserved. 5 MITS6005 Major Assignment determined by your Unit coordinator. Submissions made after the due date and time will be penalized at the rate of 10% per day (including weekend days). 4. Incidence of plagiarism will be penalized. The turn-it-in similarity score will be used in determining the level if any of plagiarism. You can see your turn-it-in similarity score when you submit your assignment to the appropriate drop-box. If this is a concern you will have a chance to change your assignment and re-submit. However, re-submission is only allowed prior to the submission due date and time. Marking Guide: 100 Marks (scale to 30%) 1. Structure of the written report: Background information is relevant, issues are logically ordered, recommendations clearly relate to the issues. 2. Choice of the analytics: Method chosen and Rationale for performing analysis. 3. Results of the analytics: Output of Analytics and Discussion of it in context of case study. 4. Write clearly and concisely: Arguments are explicit and succinct, appropriate headings are used, grammar and spelling are accurate. 5. Presentation: Presentation Style, Content and Q&A Rubrics for MITS6005 Major Assignment Task Description Marks Report Structure Relevant background information clearing relating the issue 10 Choice of Analytics Method chosen and Rationale for performing analysis. 10 Results of the analytics Proper insight analysis is shown using appropriate charts/graphs using appropriate package as given in the case study. 15 Demonstration of program code Valid and error-free code demonstrated and submitted along with the report. 25 Arguments Each individual recommendations/output of the analytics are discussed specified appropriately in context with the case study. 20 Presentation Content and Style of Presentation, effective communication and satisfactory Q/A session 20 Copyright © 2020 VIT, All Rights Reserved. 6 Student Guidelines Assessment 3 Pixystems Toys Project Due: 31 January 2021. 11:59 pm Weightage: 30% Pixystems Toys Information Pixystems Toys is a leading manufacturer and distributor of children’s toys across the globe through third party distributors (non-company owned stores) and through their flagship store located in New York. The company is headquartered in Cleveland, Ohio, and has manufacturing locations in Brazil, China, Mexico, and across the United States. Product development is also done in Cleveland with new products released every six months. The majority of the toys manufactured by Pixystems are top sellers that are sell outs during holidays
Answered 10 days AfterMay 12, 2021MITS6005

Answer To: 1 2 Title of your report Your name, your id Course name, Assignment … VIT address...

Neha answered on May 19 2021
143 Votes
1
2
Title of your report
Your name, your id
Course name, Assignment …
VIT address
Supervisor/Lecturer name
Abstract
In this report we will try to analyse the data provided by the toy company. The data contains information about the scenes, purchase, customer and their behaviour. So, this analysis the is performed to understand the outflow and inflow of the money in the organization. For analysing the data present in the Excel sheet, I have used Python language because it pro
vides different inbuilt libraries which allows us to easily draw the visualization for the user. We will perform some visualization which can be useful for the organization to understand and more also find out the error. The organization is one of the top leading manufacturing company which is known for manufacturing the different types of toys. In this report we will discuss about the issue and perform analytics over the data, and these can be used for visualising the results in the form of graphs. Python is the easiest language for creating the different visualizations and analyse the data.
I. Introduction
T
HIS report was created to understand the production and sales of the organization which is a leading company for manufacturing their toys. In this report we will try to analyse the data provided by the toy company. The data contains information about the scenes, purchase, customer and their behaviour. So, this analysis the is performed to understand the outflow and inflow of the money in the organization. For analysing the data present in the Excel sheet, I have used Python language because it provides different inbuilt libraries which allows us to easily draw the visualization for the user. We will perform some visualization which can be useful for the organization to understand and more also find out the error. The organization is one of the top leading manufacturing company which is known for manufacturing the different types of toys. In this report we will discuss about the issue and perform analytics over the data, and these can be used for visualising the results in the form of graphs. Python is the easiest language for creating the different visualizations and analyse the data.
The data set which has been shared by the organization has been collected from different stores which are located at different corners in the world. The data set provides different units which are present in the organization like payment, inventory, order customer and many others. The organization was having Lord's so find out the errors they tried to analyse their account and they found that the outflow of the company it is much higher than the inflow of the money in the organization and hence it is important for them to perform the data analysis over the data set. The data analysis can be performed with the help of Python language as it is much easier to implement the code. The Python code has been used over different aspects of the data which is present in the Excel sheet and then I try the visualization as it can help me out company for understanding the overall distribution of money among the stocks, payments and in other criteria as. There are multiple sheets in the Excel sheet which have information about the medical plants and other information related with the customers and the employees but it needs to be analysed separately and also the saving plans needs to be analysed with a linked with organization.
This report has discussion and analytics over the results. I have included the different visualization graphs which I created with the help of the code on the basis of data and they can be used to analyse the actual error present in the organization so that it can be eliminated to enhance the inflow and reduce the financial loss.
II. Discussion and Analytics
When we are working with a data set then it is important to make sure that data set has accurate and clean data. The first step for analysing the data is to understand what is present in it and how it will be easier to achieve their goal. The current Excel sheet has multiple sheets about the customers, employee, inventory adjustment, formula, finished goods on hand, invoice, medical plan, location, inventory count, raw materials on hand, payroll, payment, savings plan, product master, purchase order, received and the sales information. All these sheets are related with the organization and they have the information which can be utilised to understand the inflow and outflow of the organization. This data set help the information about the customers and employees and few more columns which are not required to perform analysis and hence before starting with the analysis we can remove those columns to reduce the overall size of the data set and make it reduce that time complexity and space complexity for the code.
The customer shipment in the Excel data has the...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here