Reference no: EM133910580

Business Intelligence

Assessment Item 1: Case Study analysis: Investigation of business intelligence, decision making and decision support systems

Introduction

This assignment necessitates the analysis of a dataset, the interpretation of findings, and the presentation of conclusions through a written report. It is imperative that you complete this assignment on an individual basis and submit it electronically via the Learning Management System (LMS) before the specified due date. Ensure that you follow the LMS instructions to verify the correct submission of your work. Please note that we do not accept hard copies or assignments submitted via email. The assignment relies on the dataset found in the file Assignment1_RetailStore_Dataset.xlsx, which can be downloaded from LMS.

Case Study: Retail Store Data Set:
Supermarkets are on the rise in densely populated urban areas, leading to heightened market competition. This data set represents historical sales data from a supermarket company with records from three different branches over a three-month period. Utilizing predictive data analytics techniques with this dataset is highly accessible and straightforward.

Data Description:
The "Data Description" sheet describes all the variables used in the "Retail Store Dataset" and is copied below for your convenience. Invoice id: Computer generated sales slip invoice identification number
Branch: Branch of supercenter (3 branches are available identified by X, Y and Z). City: Location of supercenters
Customer type: Type of customers, recorded by Members for customers using member card and Normal for without member card. Gender: Gender type of customer

Product line: General item categorization groups - Electronic accessories, Fashion accessories, Food and beverages, Health and beauty, Home and lifestyle, Sports, and travel
Unit price: Price of each product in $
Quantity: Number of products purchased by customer Tax: 5% tax fee for customer buying
Total: Total price including tax
Date: Date of purchase (Record available from January 2022 to March 2022) Time: Purchase time (10am to 9pm)
Payment: Payment used by customer for purchase (3 methods are available - Cash, Credit card and Ewallet) COGS:
Cost of goods sold
Gross margin percentage: Gross margin percentage Gross income: Gross income
Rating: Customer stratification rating on their overall shopping experience (On a scale of 1 to 10)

Task:
The task of designing a comprehensive Decision Support System (DSS) for a retail business based on the retail score dataset is a multifaceted assignment that requires students to apply their knowledge and skills in the domain of business intelligence and data analysis.
Let's elaborate on this assignment:
Designing a Comprehensive DSS:
Understanding the Retail Score Dataset: To begin with, students should thoroughly understand the given retail score dataset. This entails examining the dataset's structure, variables, and the kind of information it contains. They should also consider the specific objectives and needs of the retail business in question. Get Assignment Help from trusted tutors.

Defining DSS Components: Next, students need to design the components of the Decision Support System. A DSS typically includes various elements, such as a database, user interface, analytical tools, and reporting capabilities. Students should explain how each of these components will be integrated into the system.

Data Integration and Transformation: The retail score dataset might not be in the ideal format for decision support. Students should describe how they will integrate the dataset into the DSS and what preprocessing steps, like data cleansing and transformation, will be necessary to make the data suitable for analysis.

Analytical Tools and Algorithms: The heart of the DSS lies in its analytical capabilities. Students should select and justify the specific analytical tools, algorithms, and models they will use to extract insights from the data. For example, they might opt for clustering algorithms to segment customers or time series forecasting to predict sales trends.

User-Friendly Interface: Designing a user-friendly interface is critical. Students should discuss how they plan to present the data and insights to end-users, which may include retail managers and executives. This interface should be intuitive and facilitate data exploration and decision-making.

Aiding in Strategic Decision-Making:
Identifying Key Business Objectives: Students should define the strategic objectives of the retail business. These objectives could include enhancing customer experience or increasing sales. They need to explain how the DSS will align with and contribute to achieving these goals.

Data-Driven Insights: The core function of the DSS is to provide data-driven insights that support decision-making. Students should illustrate how the DSS will generate actionable insights from the retail score dataset. This could involve identifying customer preferences, forecasting demand, or detecting sales trends.

Scenarios and "What-If" Analysis: A robust DSS allows for scenario analysis. Students should describe how their system will enable users to conduct "what-if" analyses, helping decision-makers explore the potential impact of different strategies or market conditions.

Visualization and Reporting: Effective communication of insights is crucial. Students should outline how the DSS will present findings through visualization tools, dashboards, and reports. Visualizations can make complex data more understandable and actionable.

Monitoring and Adaptation: A good DSS should not be static. Students should discuss how the system will monitor the retail environment, collect real-time data, and adapt its recommendations based on changing conditions.

Overall, this assignment challenges students to think holistically about designing a DSS that leverages the retail score dataset to aid in strategic decision-making. It also highlights the importance of aligning the DSS with the specific needs and objectives of the retail business.

The report's length should be approximately 1500 words (excluding references). Utilize 1.5 line spacing and a 12-point Times New Roman font. Employ both numerical and graphical statistical summaries, as sometimes insights can be gained from one that are not apparent in the other.
Once you have drafted your report, it can be valuable to set it aside for a day and then revisit it with fresh eyes. Read it as if you were unfamiliar with the analysis. Does it flow smoothly? Is it comprehensible? Can someone without prior knowledge understand your conclusions from the written material? This review process often reveals opportunities to edit the report for greater clarity and directness.

Statistica, Data Miner, Weka, RapidMiner, KNIME and MATLAB etc. Your submission should consist of two separate files:
Ensure the inclusion of the results produced by the software that was employed.
Provide a Microsoft Word document containing your comprehensive report.