Reference no: EM133928998

Business Analytics & Visualization

Assessment: Code/Script Listing (Group)

Screenshots of Visual Outputs (Group) Demonstration of Solution (Individual)

Assessment Item: Retail Sales Data Analysis

This is an ongoing assessment but can be treated as the third project milestone. A large part of this assessment is focused on code and script development and other technical solutions. Peer reviews and lecturer's guidance will be given, and emerging issues will be addressed continuously. you will be using popular tools such as Power BI, Tableau, Python or R for this task. Alternative approaches will also be discussed to achieve pragmatic and effective solutions.

Introduction
The third project milestone builds upon your group's progress and focuses on the development of technical solutions through code and script creation. This ongoing assessment emphasizes practical application and technical proficiency using popular tools such as Power BI, Tableau, Python, or R. Alternative approaches will also be explored to ensure pragmatic and effective solutions. Continuous peer reviews and lecturer guidance will help address emerging issues and refine your approach. Get expert online assignment help in the USA.

Task 1: Exploratory Data Analysis (EDA)

Objective: Analyse historical sales data for 45 stores to identify trends, patterns, and factors influencing sales performance.

Overview of Data:
Explore the structure and contents of the provided dataset.

Identify variables in each tab (Stores, Features, Sales) and their significance for analysis.
Historical Sales Analysis:
Analyze sales trends and patterns over time (2010-02-05 to 2012-11-01).
Identify seasonal variations, sales peaks, and dips.
Store-wise Analysis:
Identify stores with the highest and lowest sales revenue.

Task 2: Predictive Modeling
Objective: Develop predictive models to forecast future sales, predict the impact of markdown events, and predict holiday sales performance.

Sales Forecasting:
Develop time-series forecasting models to predict future sales for each store and department.
Evaluate model performance using appropriate metrics (e.g., Accuracy).
Holiday Sales Prediction:
Develop models to predict sales performance during prominent holidays (Super Bowl, Labor Day, Thanksgiving, Christmas).
Key Components for Submission:

Code/Script Listing (Group):
Provide a comprehensive listing of all code and scripts developed by the group.
Ensure that the code is well-organized, follows best practices, and includes comments for clarity and future reference.
This component will account for 10% of the total assessment grade.

Screenshots of Visual Outputs (Group):
Include clear and relevant screenshots of visual outputs generated using the tools.
Ensure that the visualizations effectively communicate key findings and insights.
This component will also account for 10% of the total assessment grade.

Demonstration of Solution (Individual):
Each group member will individually demonstrate their contribution to the project.
The demonstration should last 15 minutes and cover the code/scripts developed, the visual outputs, and the overall solution.
This component will account for another 10% of the total assessment grade.