digital technology PSA

• task 3a report

  • Trends
  • Patterns
  • Conclusion
  • Errors
• Errors

  • Anomalies (typos)
  • Min/ max values
  • Missing values
  • Check formulas used
• Typo errors in PSA

  "3015" if they tried to find all customers who joined in "2015" they would not be included
• customer " " " "

  Have gave ratings of 20 and 50 which could screw graph results displayed on dashboard which will lead to incorrect decision making (out of range)
• Missing values

  "Pat2016.." did week 1 rating but not week2 rating so could be issues with week2 rating as one is missing and 2018 "lego...."
• Missing values

  The year that "liso" created a loyalty card is also missing
• "Pug2017...." said yes and no either has to be "yes" or "no"


  ..
• Trends

  Method of payment

  Paying by moblie is increasing rapidly over the year span 2015 to 2025. Due to advanced technology now a days it is more convenient and a quick and easy method than cash
• Trends

  Yes or no

  Tight between store closed checkout would lose alot of revenue by the week4 ratings decreasing rapidly
• Joining loyalty card scheme

  Amount people creating cards is increasing each year due to eg.reward schemes the trend peaks after covid (2023) started at 3 a year to 8 a year
• Trends

  Patterns

  Method of paying people saying yes/no
• Conclusion

  • Need for data accuracy-presence of typos and incomplete data highlights the need to better manage and check data entered
  • Loyalty cards each year- consistent increase in joining is increasing their sales and growing meaning BuyIt can employee more or invest more into BuyIt
  • Ratings show people are happy and good statisifaction ratings and happy with the service provided at BuyIt