0% found this document useful (0 votes)
13 views6 pages

Retail Data Analysis with R Techniques

The coursework involves a group assignment focused on analyzing retail transactional data to assess customer satisfaction and provide insights for decision-making. Students are required to utilize R programming for data exploration, manipulation, and visualization, while ensuring thorough documentation and adherence to academic integrity. Deliverables include a comprehensive report and RScript, with specific guidelines for content and structure.

Uploaded by

tommytommy200426
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
13 views6 pages

Retail Data Analysis with R Techniques

The coursework involves a group assignment focused on analyzing retail transactional data to assess customer satisfaction and provide insights for decision-making. Students are required to utilize R programming for data exploration, manipulation, and visualization, while ensuring thorough documentation and adherence to academic integrity. Deliverables include a comprehensive report and RScript, with specific guidelines for content and structure.

Uploaded by

tommytommy200426
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Programming for Data Analysis Page 1 of 6

1.0 COURSEWORK TITLE

Retail Transactional Data Analysis and Ratings Classification

THE COURSEWORK OVERVIEW

For the assignment, you are asked to explore the application of data analytics techniques to
the dataset that is provided. You must study data problems related to the dataset, giving
special consideration to the unique properties of the problem domain, and testing one or
more techniques on it.

Your analysis needs to be thorough and go beyond the scope of what has been covered in
this course. You should incorporate data exploration, manipulation, transformation, and
visualization concepts with data analysis techniques in your solution. It is crucial to provide
explanations and justifications for the chosen techniques.

You also may need to pre-process your data to get it into an appropriate format. The
assignment should involve several techniques by categorizing it into different criteria and a
detailed exploration of the commands used in each criterion. Outline the findings, analyze
them, and justify them correctly with an appropriate graph. Also, a supporting document is
needed to reflect the graph and code using R programming concepts.

2.0 OBJECTIVES OF THIS COURSEWORK

This assignment will help you to explore and analyze a set of data and reconstruct it into
meaningful representations for decision-making.

3.0 TYPE
Group Assignment (2–4 members)

4.0 COURSEWORK DESCRIPTION

This retail dataset consists of consumer demographics and transactional/purchasing history.


As a data analyst in the retail industry, you have been commissioned to conduct an in-depth
analysis on the consumers of various backgrounds and study their behavioural profile with

Level 2 Asia Pacific University of Technology and Innovation 2024


Programming for Data Analysis Page 2 of 6

the given dataset to identify the factors that measure customer satisfaction, represented in
the form of product ratings by consumers and provide recommendations to stakeholders.

Techniques
The dataset provided for this assignment consists of customer personal information (i.e.,
Name, Email, Phone, City, …), demographics (Age, Gender, Income, …) along with their
purchasing behaviour (Total Purchases, Total Amount, Product Brand, Product Type,
Feedback, Payment Method, …). In addition to the techniques (data exploration,
manipulation, transformation, and visualization techniques) covered in the course to
conduct analysis, you might consider exploring and implementing more advanced concepts
to enhance the effectiveness of data retrieval, especially if it fits your requirements.

5.0 GENERAL REQUIREMENTS


• This is a group assignment, with a maximum of 4 students in a group.
• You should state your hypothesis and objectives with each person one objective of
minimum one independent variables and one dependent variable.
• The R program should compile and be executed without errors.
• Validation should be done for each entry from the users to avoid logical errors.
• Do not use third-party tools such as Excel, OpenRefine and etc to pre-process or clean
the data. Cleaning and pre-processing must be done in R using scripting.
• No duplication is allowed in the dataset.
• You should:
o Include good programming practices such as comments, variable naming
conventions, and indentation.
o Perform additional research to further understand the information on the given
dataset during evaluation of the data.
• The analysis should be meaningful and effective in providing the information for
decision-making.
• Any additional features implemented must improve the retrieval effects.

Level 2 Asia Pacific University of Technology and Innovation 2024


Programming for Data Analysis Page 3 of 6

DELIVERABLES:
The complete RScript (source code) and report must be submitted to the APU Learning
Management System (Moodle).
5.1 RScript (Program Code):
• Name the file under your group number.
• Start the first few lines in your program by typing all member's names and TP
numbers. For example:
# Name1, TP000001
# Name2, TP000002
# Name3, TP000003
# Name4, TP000004
o For each objective example, provide student id and explain what you want to
discover. For example:
o Hypothesis 1: Customer segments with higher purchasing power (e.g., premium
or frequent buyers) tend to give higher ratings compared to segments with lower
purchasing power.
Objective 1: To evaluate the relationship between customer segments and level
of ratings. NAME, TPXXXXXX
Analysis 1-1: Is there any correlation between different customer segments
and level of ratings?
Analysis 1-2: Is customer segment a key predictor for ratings?
Analysis 1-3: What are the external factors, if any, that share a causal
relationship with customer segment to influence purchase ratings?
o For each additional example, provide an ID and explanation.
# Extra feature 1
# comments about the extra feature

6.2 Documentation (report):


ü A 5500 words (max 55 pages) report including appendix. The report should comprise
of the following content.

Level 2 Asia Pacific University of Technology and Innovation 2024


Programming for Data Analysis Page 4 of 6

A) Cover Page:
All reports must be prepared with a front cover. A protective transparent plastic
sheet can be placed in front of the report to protect the front cover. The front cover
should be presented with the following details:
Ä Module
Ä Coursework Title
Ä Intake
Ä Students name and id
Ä Date Assigned (the date the report was handed out).
Ä Date Completed (the date the report is due to be handed in).

B) Contents:
o Introduction
ü Data Description
ü Assumptions (if any)
ü Hypothesis and Objectives
o Data Preparation
ü Data import
ü Cleaning / pre-processing (if necessary)
ü Data Validation (if necessary)
o Data Analysis
ü Each objective (along with student name) must start in a separate page
and contain:
§ Analytical technique(s) – e.g. descriptive using statistics
§ Justification of technique(s)
§ Screenshot of source code with output/plot.
§ Outline the findings based on the results obtained.
ü The extra feature explanation must be in a separate page and contains:
§ Screenshot of source code with output/plot.
§ Explain how adding this extra feature can improve the results.
ü Interpret the results from each analysis

Level 2 Asia Pacific University of Technology and Innovation 2024


Programming for Data Analysis Page 5 of 6

o Conclusion
ü Overall discussion on the findings from all objectives
ü Recommendation
ü Limitation and future direction
ü State the word count (at the end of page)

C) Workload Matrix

D) References
Ä You may source algorithms and information from the Internet or books.
Proper referencing of the resources should be evident in the document.
Ä All references must be made using the APA (American Psychological
Association) referencing style as shown below:

6.0 ASSIGNMENT ASSESSMENT CRITERIA


The assignment assessment consists of 2 major components: Analysis (70%) and finding
and discussion (30%). Details of the division for each component are as follows:

Analysis (70%) Finding and Discussion (30%)

Criteria Marks Criteria Marks


Allocat Allocate
ed d
Analysis techniques 10% Finding and Discussion
ü Approaches used to ü Project Introduction
process, interpret, and (description, assumption,
extract insights from data. hypothesis, objectives)
Report content: ü Conclusion (result finding, 30%
à Methodology description discussion, recommendation
Analysis Methods 60% and future direction)
à Specific process employed ü Structure of the report and
to carry out the analysis references
(transform raw data into
meaningful insights)
[e.g. Exploratory data analysis,
Hypothesis test, Descriptive statistics
etc]
Report content:
à RScript – code snippet and
visualization screenshots
with explanation.

7.0 DEVELOPMENT TOOLS

Level 2 Asia Pacific University of Technology and Innovation 2024


Programming for Data Analysis Page 6 of 6

The program written for this assignment should be written in R Studio

8.0 ACADEMIC INTEGRITY


§ You are expected to maintain the utmost level of academic integrity during the duration
of the course.
§ Plagiarism is a serious offence and will be dealt with according to APU and De
Montfort University regulations on plagiarism. (20%)

Level 2 Asia Pacific University of Technology and Innovation 2024

Common questions

Powered by AI

Breaking down the analysis by individual objectives allows for a detailed examination of specific aspects of consumer behavior. Each team member addresses different independent and dependent variables, which enhances the depth of analysis. This detailed approach helps in identifying correlations, causal relationships, and key predictors, providing a more nuanced understanding of consumer behavior patterns and how these impact product ratings, ultimately aiding in strategic decision-making .

Students must observe ethical considerations such as avoiding plagiarism and maintaining academic integrity by properly referencing all sourced algorithms and information using the APA style. These considerations are significant because they uphold the integrity of the educational process, ensuring that work submitted is original and credits are given where due. Adhering to academic integrity fosters an environment of trust and respect, which is essential for collaborative group assignments .

The group dynamics and collaboration requirements of the coursework enhance the learning experience by encouraging students to work collectively towards a common goal, sharing diverse perspectives and skills. Each member is responsible for specific objectives, fostering accountability and detailed exploration of the dataset. Collaboration helps in problem-solving, fosters communication skills, and prepares students for real-world team-based projects .

Integrating data visualization techniques is significant because they help in elucidating complex data patterns and relationships within the retail transactional dataset. Visualization transforms raw data into accessible insights that can be easily interpreted by stakeholders, facilitating effective decision-making. By visualizing data, analysts can identify trends, anomalies, and correlations, enhancing the overall understanding and communication of findings .

Essential documentation elements required include a cover page, introduction, data description, assumptions, hypothesis, objectives, data preparation and analysis sections, conclusion, workload matrix, and references. These elements are important as they provide a comprehensive framework for presenting the entire analysis process, from introducing the problem and methods used to analyzing results and making recommendations. Proper documentation ensures clarity, replicability, and transparency of the data analysis process for stakeholders .

Students should ensure the validity and accuracy of their analysis by pre-processing data using R scripting without using third-party tools. This includes cleaning and pre-processing the data directly in R to avoid logical errors, validating each entry from users, and ensuring no duplication is present in the dataset .

The primary goal of the retail transactional data analysis assignment is to explore and analyze a dataset to reconstruct it into meaningful representations for decision-making. Advanced data techniques that can be utilized include data exploration, manipulation, transformation, visualization, and potentially more sophisticated methods not covered in the course, especially if they enhance the effectiveness of data retrieval and satisfy the analytical requirements .

Strategic recommendations derived from analyzing consumer feedback and purchasing patterns could include tailoring marketing strategies towards high-value segments, optimizing product offerings based on consumer preferences, and enhancing customer service to improve satisfaction scores. These insights should be used by stakeholders to inform decisions on product development, customer engagement initiatives, and market positioning strategies to enhance overall business performance .

The coursework format encourages the development of data analysis skills by requiring students to examine consumer demographics and purchasing behaviors through data exploration, visualization, and advanced analysis techniques. By focusing on a real-world retail dataset and setting objectives based on consumer behaviors, students learn to identify factors affecting customer satisfaction and product ratings. The requirement to use R for data manipulation and analysis fosters practical skills and problem-solving abilities, preparing students for real-world data analysis challenges .

Recommended programming practices include using comments, following variable naming conventions, and maintaining proper code indentation. These practices are critical because they enhance the readability and maintainability of the code, facilitate collaboration among group members, and help in debugging and verifying the accuracy and functionality of the R scripts. Good programming practices ensure that the code is not only functional but also comprehensible and systematic .

You might also like