Reference no: EM133775491 , Length: word count:2000

Big Data

Tableau & Splunk Project

The Assignment consists of a research report of 1500 words

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.