Understanding Data Collection and Analysis for Businesses
Explore the impact and role of data utilization in organizations through the investigation of data collection methods, data quality, decision-making processes, reliability of collection methods, factors affecting data quality, and privacy considerations. Two scenarios are presented: data collection by a supermarket via loyalty cards and data collection for a holiday company from various sources. Delve into characteristics of data, ways data is collected, issues with collection methods, data sensitivity, and the importance of data volume. Gain insights on improving data collection practices and understanding customer privacy implications.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
Start the Assignment - Word-processed Document Component 2 Part A Assignment Title: Data Collection and Analysis A: Investigate the role and impact of using data on individuals and organisation Task 1: Headings & Supporting notes 1. The Characteristics of Data and Information - Slide 5 2. Data Collection methods and features used( How data was collected) - Slide 6, 7, 8 & 9 3. The quality of data collected by each company - Slide 12 4. How data used by the company to make decision - Slide 15, 16 & 17 5. How reliable are the methods of collection that were used Slide 13 & 14 6. What factors that might affect the quality of the data - Slide 18 7. Suggestion on ways that data collection might be improved - Slide 19 8. How the collection of this data might affect the privacy of customers - Slide 20
Scenario Supermarket Data The first set of data has been collected by a supermarket. It has been collected automatically by the checkout computer system. The data is about customers who have loyalty cards and was collected over a limited period of time. The supermarket estimates that about 90% of its customers have a card. The data is in the file called Supermarket_data. The data contains: Customer Number Date Time Amount Spent Gender Self Checkout Minutes to Process
Scenario Holiday Data The second set of data is for the holiday company. The data has been collected from various sources: the company s booking system database, the electoral roll, and a specialist survey company who contacted the customers via an email survey. The company has calculated that only 50% of the customers who were contacted responded to the survey. The data is in the file called Holiday_data. The data contains: Customer email Accommodation Rating Date of Survey Booking Process Rating Gender Transport Holiday Date Transport Rating Holiday Duration (days) Recommend to Friend Holiday Type Price Paid The ratings are on a scale of 1 to 10, one being the lowest 10 being the highest.
Heading : The Characteristics of Data and Information Data type Column Number from the secondary Data What does it show? And Why do we need to collect this type of data? local-part@domain Short date format DD/MM/YYYY single letter format/short text Decimal places Numerical Data Text Decimal places British pounds/sterling to 2 decimals
Heading : How has the data been collected (Supermarket ) 1. State how the data has been collected? E.g automatically by the checkout computer system. It is primary data because it is collected directly by the company 2. Is there any issue with how the data has been collected i.e. people with no loyalty card has not been recorded how reliable is the method? Data has been collected over limited period of time what is problem with this? What are the pros and cons of collecting data this way? 3. 4. Is the data sensitive i.e. personal to the customer if so what do I need to tell the customer Yes 5. Does it matter how much data I have, compare with the data I don't have? i.e 90% of its customer have loyalty card, but not all customer visited the store on the time of collection, so small sample data) Has the data been crossed ref with any other data to check that the data collected is accurate? ( only one method of data collection used bt supermarket!) 6.
Heading : How has the data been collected (Holiday data ) 1. State how the data has been collected various sources - the company s booking system database, the electoral roll, and a specialist survey company who contacted the customers via an email survey 2. It is big data Primary data (the company s booking system database)and secondary data (electoral roll, and a specialist survey company who contacted the customers via an email survey) 3. What are the pros and cons of collecting data this way? 4. Is there any issue with how the data has been collected i.e. how reliable is the method? 5. Is the data sensitive i.e. personal to the customer if so what do I need to tell the customer Yes 6. Does it matter how much data I have, compare with the data I don't have? 7. Has the data been crossed ref with any other data to check that the data collected is accurate?
Heading : How has the data been collected Holiday data: the company s booking system database Pros Holiday data: Electoral roll Pros the data is accurate and up to date at the point of collection Big data so many data can be collected at once. The data is not sensitive so no need to contact customer to let them know that their data is being collected for data privacy GDPR The information collected will be accurate, because it is government collection and people must be honest Data can be cross referenced with other methods because there are other way of data collection used Cons Data can be cross referenced with other methods because there are other way of data collection used Cons System could malfunction at the time of collection and data would have not be easy to be collected The information might not be up to date because the electoral roll register is updated annually. Not all their customer booked holiday on the time of collection for the company to get the data, the sample data is small in this collection method
Heading : How has the data been collected Holiday data: specialist survey company who contacted the customers via an email survey) Pros Big data so many data can be collected at once Data can be cross referenced with other methods because there are other way of data collection used Cons Data may not be accurate as customer might not be honest in giving out answers Data might not be up to date as is not known when the data were collected Only 50% replied, so not all their customer replied to the customer survey for the company to get all customers information
Title : Data Collection methods and features used (How data was collected)
Title : Data Collection methods and features used (How data was collected)
Heading : Heading : The quality of data collected by each company Holiday Data Mixture of primary and secondary what are the pros and cons of how this might have been collected. Why would you have data collection by a company? Are there issues/limitations with this? Is this cost effective? Explain each collection method - (Primary (the company s booking system database) and secondary data (electoral roll, and a specialist survey company who contacted the customers via an email survey) 50% of people responded to the question what do we think about this, is it a good sample size? Why would you crossed Reference data, how will this help? How many time do I need to cross Ref data in order to increase its accuracy? Supermarkets Data: Computer/Digital data, no humans have been involved. Are there any cons to this? It is just primary (automatically by the checkout computer system.), what's are the issue with this? eg. haven't crossed Ref this with any other data, I don t have customer name or address on the data, which means no patterns can be picked up quickly. Using examples from the data show this What are the general issues with this section of the data How has the Data collected been used to make decisions
Tuesday, 10 September 2024 Heading: How reliable are the methods of collection that were used use screen shots from the data Validation methods Holiday data: how does the columns shows that validation might have been used? Give examples Company used validation method of type check to make sure the customer entered the data correctly Supermarket data: - how does the columns shows that validation might have been used? Give examples Verification methods - Ensures that inputs is checked more that once. Example passwords Holiday data: does this method presented? Give examples Eg. There is no evidence of this verification method in holiday data Supermarket data: does this method presented? Give examples
Heading Heading : How the data might be of use to the company Supermarket use screen shots from the data, when referring to the data, edit, sort data if needed Sales figures, trends, target products to the right customer, busy times, staffing numbers ( ref to the bust times), average price of purchase of sale. 3/4Examples needed I.e. In column 4 it shows the amount a customer spent, this could be average out to show to average a customer spends, cross ref this with the time of day, will also show busy times, for large purchases. Holiday use screen shots from the data, when referring to the data, edit, sort data if needed Quality of the holiday in different sections, targets products, average spend, Max and min spend, customer email contact , commons forms of transport taken targeting customer on promotional offers, transport updates, affordability.
Heading Heading : How data used by the company to make decision Holiday use screen shots from the data, when referring to the data, edit, sort data if needed Quality of the holiday in different sections ( rating columns), targets products, average spend, Max and min spend, customer email contact , commons forms of transport taken targeting customer on promotional offers, transport updates, affordability. Example: Company collected customers emails to enable them to contact customers and give them, new holiday deals available. Also by collecting holiday dates, this will help the company to determine the high holiday season and low seasons, that will help the company to plan prices, marketing and packages to suit their customers 3/4Examples needed
Heading Heading : How data used by the company to make decision Supermarket use screen shots from the data, when referring to the data, edit, sort data if needed Sales figures, trends, target products to the right customer, busy times, staffing numbers ( ref to the bust times), average price of purchase of sale. 3/4Examples needed I.e. In column 4 it shows the amount a customer spent, this could be average out to show to average a customer spends, cross ref this with the time of day, will also show busy times, for large purchases.
Heading : What factors that might affect the quality of the data Holiday Data Human error when entering data into a question or online Low return rate on information only 50% How can you encourage people to fill in the survey Spelling errors or types i.e. getting there email address wrong or how long they where away on holiday Cross referencing might not cross ref the same data, you need to set up the questionnaire or gathering the data the same to ensure that data in checking correctly. Rating can be inaccurate what does 5 mean in 1-10 Do people lie? Can people always remember want went on, I the questionnaire is online is being filled in after the even? Supermarket Data How has the company gone about collecting the data quality of equipment How much data do I have, is it too much, its enough, do I need to cross ref the data with other time of the day or years gone past. External factors such as weather, time of day, competition, traffic , road works, parking, time of year Data is not very detailed, and not from any location
Heading: Suggestion on ways that data collection might be improved Supermarket Users detail, location of data collection, any vouchers used, different data times of times of collection Holiday Example of what the rag rating meant i.e. what a 4 is?, company names, company transport names, numbers in groups, location of holiday, what section of the data have been collected and how? Ie how has the email address been collected, has this cross ref and with what? Dates of collection of the types of data ie when was the survey carried out, when was the email address collected?
Heading: Heading: How the collection of this data might affect the privacy of customers. You need to explain at least 4 from the list below: Data needs to be kept secure because of fraud Data needs to be kept update Customer needs to be kept informed if used or updated Must comply with GDPR Customer have the right to be removed Customers have the right be reclassified i.e. from a Miss to Mrs Customers have the right be object to the use of their data, if you ask them. Customer have the right to ask for their details under the freedom of information act
I need to check that I: have used/ am using a purple pen to react/ redraft/ elaborate on any feedback; 1. have used/ am using capital letters, commas, and full stops correctly and appropriately; 2. have used/ am using the proper spellings and appropriate use of subject/ module/ topic specific words (tier 3 3. vocabulary;) have used/ am using the proper spellings and use of conjunctions; 4. have used/ am using appropriate structure(s) for your work to make sense throughout; 5. have used/ am using paragraphs in the appropriate way throughout (if you are unsure, use TiPToP.) 6. have used/ am using the appropriate date and title; both underlined with a straight line; 7. have used/ am using handwriting that is clear and legible throughout all writing. 8.
