Reference no: EM133763363 , Length: word count:2000

Big Data

Report -Assessment of high- volume data processing

Tableau & Splunk Project

Part 1: Business Data Analysis Problems to be addressed in the report

The report should provide an analysis and evaluation of Global Superstore financial performance over a five-year period from 2014 to 2018 on its global reach of 165 countries. Conduct a comprehensive analysis of revenue, profit, discounts and customer behaviour. Analyse the Key Performance Indicators (KPI) in monitoring, assessing and managing a firm's performance in terms of:

Diverse product range generating higher sales revenue and translation into superior profit
The influence discounts and promotions have on sales and customer loyalty.
Predicting sale trends in product sub-categories in different regions

Investigate which categories and products are the most popular and the most profitable. Should the Global Superstore consider streamlining their products offering, investing more heavily in products which are performing well and removing which are not?
Examine the relationship between purchasing patterns and the percentage of discount applied to determine the impact the discounts and promotions have on sales.
Customer service is another key factor that businesses use to differentiate themselves from their competitors. Determine the volume of repeat customers. Assess the level of customer service that they provide and make recommendations on how they can improve their service and customer retention.

Examine which countries and products have highest return rates. Determine if there are any products that the Global Superstore should consider removing from their product range, as well as aiding them in developing strategies to combat or reduce the rate of return in countries with a high frequency of returns. Perform a return analysis across categories and subcategories.
Evaluate the average shipping cost, most popular mode of shipping and shipping latency to establish if there is a connection between these variables and purchases made.
Predicting future revenue streams is an essential component when determining merchandising decisions.
This report should build a predictive model to determine sales revenue from a given product in each region. This should be limited to the top five sub-categories.

The research report must have the format:

Cover sheet (make sure each team member's name and student no are on the coversheet)
Executive Summary
Table of contents
Company Information
Problem Identification
Data Collection
Analysis and Discussion
Recommendations
References

Part 2: Network Data Analysis
In this part of the assessment, you must analyse the log details of the global super store in Australia with Splunk.
Perform a basic search for errors and any type of failures in all data sources. Provide a screenshot of the entire page once completed.
Perform a new search for password and any type of failures on port 22 in all data sources. Provide a screenshot of the entire page once completed.
Do you see trends over time? If so, what were they?
Use the output of your search to refine the results by adding a new field to the search
Take a screenshot of your ‘Activity Jobs Menu' detailing the current job saved with expiration date.
Take a screenshot of your search history. Set a filter to narrow down your search results.
Show where are selected field, interesting fields and all fields located. How do you use fields to perform a search.
How do you add time range when performing search.

Students need to demonstrate to the tutor that each team member has made a significant contribution to the report. It is suggested the group use a collaborative environment such as google drive to store documents and work on the assignment. You will also create a document that lists each task and the name of the team member/s responsible for the task.
The task allocation must be approved by the tutor before commencing other work on the report. The group is also required to discuss their progress with the tutor on a weekly basis.

Additional information regarding this Assessment:
Report document standards
Normal font is Calibri, size 11 point for the body of all documents with the text fully justified.
Headings should not exceed 14 points in size except on a title page where larger fonts are appropriate for the title of a report.
Documents should use 1.15 spacing within a paragraph and have an 8-point space between paragraphs.
Footers should be created on the report that includes a page number.
Up to 15% of the Report contents may be quoted or paraphrased from
other sources provided you acknowledge and cite the original source of the material you use.
Use IEEE referencing on all quoted or paraphrased material.