NEW
Font size
WorksheetsRetail Analytics & Business Performance
Total questions: 40
Worksheet time: 20mins
Which one of the following is NOT one of the phases in problem solving with analytics?
Analysing a problem
Designing a problem
Structuring a problem
Recognising a problem
Which one of the following data collection methods allow bias into the research which will affect the quality of the data?
Interviews
Focus group
Observational data collection
Opened ended survey questions
Which one of the following is NOT part of the 5 steps data collection strategy?
Collect the data
Start by formulating a plan
Determine your data collection method
Determine what information you want to collect
Which one of the following is an advantage of data cleaning?
Fix non-structural errors
Handle non-duplicated data
Filter duplicated and wanted outliers
More efficient business practices and quicker decision making
Determining the quality of data requires an examination of its characteristics, hence the degree to which your data conforms to defined business rules or constraint is called
validity
accuracy
consistency
completeness
Which one of the following is a tip to improve data accuracy?
Pressurise the data entry team every month end.
To improve the quality of data, use only one data source.
The company do not need to set an objective for data quality.
Do a data quality audit from time to time to find a prevalent issue like duplicate.
Identify the TWO data interpretation methods.
Nominal and Ordinal.
Discrete and Continuous.
Categorical and Numerical.
Quantitative and Qualitative.
Which one of the following is a qualitative research method?
Grade research
Narrative research
Cognitive research
Background research
Which quantitative data interpretation method is used to measure a numerical average for a set of data and is calculated by dividing the sum of values by the number of values in a dataset?
Mean
Median
Standard deviation
Frequency distribution
Which one of the following is an effective measure for managing data confidentiality?
To whom data can be disclosed.
Storing data in unencrypted databases.
Sharing sensitive data without confidentiality agreements.
Disclosing sensitive information to unauthorised individuals.
When managing data storage, an important guideline for ensuring confidential data storage security is
storing data in unencrypted formats.
unsecurely dispose of all data, devices, paper records.
implementing strong access controls and user authentication.
to dump paper documents containing sensitive information into trash or recycling bins.
What is one of the key purposes under the Personal Data Protection Act (PDPA)?
Organisations can collect and use personal data without consent.
Individuals have no rights to access or correct their personal data.
Recognises the right of individuals to protect their own personal data.
Personal data can be transferred across border without any restrictions.
Which one of the following cannot be included in embedded documentation?
Code, field and label descriptions.
Working papers or laboratory books.
Descriptive headers or summaries of files.
Recording information in the Documentation Properties function of a file.
Which one of the following is an element of a file name?
Do not use a ‘revision’ numbering system.
Exclude a ‘version control table’ for each file.
Do not identify the individual who has made the amendments.
Agree on a logical use of dates so that they display chronologically.
To speed up your data analysis process, you should consider integrating
data processing tools
data analysis tools
data research tools
data cleansing tools
Using machine learning with natural language processing (NLP) to organise unstructured text data is a form of qualitative analysis. For example, customers’ feedback. This data analysis tells us
"What happened”
“Why did it happen”
“What is happening”
“What is likely to happen”
Which one of the following is an important tip for effective data analysis?
Pick any research question or objective
Systematically reach out to your customers
Analyse the entire dataset without sampling
Skip the data cleaning and pre-processing step
Which one of the following is a best practice for designing a business dashboard?
Access to trends or deeper insights.
Line of sight into top-line organization KPIs.
Design your dashboard with your audience in mind.
Increased data awareness and access to time sensitive data.
Which one of the following is an advantage of a business dashboard?
Most dashboards are static.
Dashboards monitor known areas of interest or goals.
Dashboards shares information on known areas of interest or goals only.
All dashboards are not interactive and do not have live & dynamically updated data.
Which one of the following business dashboard would be most useful for the company to track customer acquisition effort?
Tactical Dashboards
Strategic Dashboards
Analytical Dashboards
Operational Dashboards
You are tasked with analysing the situation and propose solutions to help the company increase sales. When defining the problem, which one of the following action will you take?
Find the real problem and distinguish it from symptons.
Understand the limitation of models and their underlying assumptions.
Evaluate different scenarios, analysing risks associated with various decision alternatives.
State goals and objectives, characterising the possible decisions and identifying any constraints or restrictions.
There are many different techniques for collecting different types of quantitative data, but there is a fundamental process a researcher will follow. The second step to implement data collection strategy is to
compile the data
determine data collection method
set a timeframe for data collection
determine what information to collect
Process of converting data from one format or structure into another is known as data
alteration
revolution
sanitation
transformation
Which one of the following best illustrates the disadvantage of a table as compared to other types of visualisation techniques?
Unhelpful with observing trends.
Do not give detailed information.
Unable to reveal key assumptions, effects or patterns.
Cannot compare different variables at a single place or time.
Protecting data against unintentional, unlawful or unauthorised access, disclosure or theft is termed
data security
data confidentiality
information security
information confidentiality
All of the following are examples of embedded documentation EXCEPT
field descriptions
label descriptions
code descriptions
rubric descriptions
Catalogue metadata is usually structured according to an international standard and associated with the data by repositories or data centres when materials are deposited. One example of catalogue data is
designation
founder
keywords
style
Analysing data and sorting it as positive, negative or neutral to gain indepth knowledge about how customers feel towards each aspect is a form of
close analysis
sentiment analysis
inscription analysis
judgement analysis
You are tasked to conduct a market research. To facilitate the market research using primary data, you will obtain your data from
Statista portal
conducting surveys
reading newpaper articles
Singapore Department of Statistics website.
All of the following are open ended questions Ivy can include in her interview EXCEPT
Would the change in the café’s operating hours increase your visit frequency?
What are your thoughts on the café potentially adjusting its opening and closing times during weekends or public holidays?
Can you suggest a specific change to the café's operating hours that would better cater to your needs and preferences?
How would you feel if the café implemented flexible operating hours to accommodate customers with different schedules?
Identifying the FIVE characteristics of quality data.
Accuracy, consistency, inference, uniformity, validity.
Accuracy, completeness, consistency, regularity, validity.
Accuracy, completeness, consistency, uniformity, validity.
Accuracy, completeness, consistency, flexibility, uniformity.
Over the past years, Watsoons relied on manual input of employee details into the computer. Over time, employee details like house numbers and residential addresses become redundant. This data redundancy is an example of data
decay
mould
purge
rust
Explain ONE characteristic of conduct ethnographic research.
Investigates past events to learn present patterns and anticipate future choices.
Information laces a sequence of events usually from one or two individuals to form a consistent story.
Looks at large subject matters and attempts to explain why a course of action progresses the way it did.
Looks at people in their cultural setting, their behavior and words, interaction with one another and with their social and cultural environment.
Identify the type of charts shown.
Bar graph
Column chart
Scatterplot graph
Doughnut pie chart
Value Trading Pte Ltd arranges invoices by date, with the most recent invoice on top. What is the filing method used by Value Trading Pte Ltd?
Numerical filing method.
Vocabulary filing method.
Alphabetical filing method.
Chronological filing method.
As a research analyst, you are asked to perform inferential analysis based on the results of the survey conducted among youth about their perception of working in retail. You will conduct inferential analysis through
4Ps philosophy
hypothesis tests
demonstration theory
law of demand and supply principle
Wellness Store conducted different monthly marketing campaigns in 2022. The Marketing Manager is interested in finding out which marketing campaign is most effective in increasing sales. Which type of analysis techniques should Beauty Wellness Store use?
Indicative analysis
Root cause analysis
Measurement analysis
Result & effect analysis
What is the type of data analysis techniques used in this figure?
Predictive analysis
Attribution analysis
Descriptive analysis
Preposition analysis
Alice is interested in tracking the number of followings and comments across her social media channels. Propose ONE type of dashboard suitable for Alice.
Statistical Dashboard
Analytical Dashboard
Operation Dashboard
Data Analytic Dashboard
Just Mart is a 24 hour convenience store located in Ang Mo Kio Hub. As the Store Manager, which one of the following dashboards will you recommend to your Finance Director to track the monthly recurring revenue growth rate?
Operational Dashboard
Statistical Dashboard
Analytical Dashboard
Data Analytic Dashboard
