Power BI Receipts Data Analysis

Sum of Receipts Overview

The following notes provide an analysis of the sum of receipts recorded during different time intervals throughout the week, as collected using Power BI Desktop.

Monday
  • Time Intervals and Values:
    • 00:00 - 01:00: 12
    • 01:00 - 02:00: 8
    • 02:00 - 03:00: 10
    • 03:00 - 04:00: 7
    • 04:00 - 05:00: 8
    • 05:00 - 06:00: 8
    • 06:00 - 07:00: 7
    • 07:00 - 08:00: 8
    • 08:00 - 09:00: 10
    • 09:00 - 10:00: 11
    • 10:00 - 11:00: 11
    • 11:00 - 12:00: 15
    • 12:00 - 13:00: 14
    • 13:00 - 14:00: 17
    • 14:00 - 15:00: 19
    • 15:00 - 16:00: 17
    • 16:00 - 17:00: 18
    • 17:00 - 18:00: 22 (Highest)
    • 18:00 - 19:00: 19
    • 19:00 - 20:00: 15
    • 20:00 - 21:00: 15
    • 21:00 - 22:00: 18
    • 22:00 - 23:00: 13
    • 23:00 - 00:00: 11
  • Key Observations:
    • The peak receipt recorded was during 17:00 - 18:00 with a total of 22.
    • Time intervals 14:00 - 15:00 and 18:00 - 19:00 were tied for secondary peak values.
    • 17:00 - 18:00 represented 7.03% of the total receipts for Monday.
Tuesday
  • Time Intervals and Values:
    • 00:00 - 01:00: 9
    • 01:00 - 02:00: 8
    • 02:00 - 03:00: 8
    • 03:00 - 04:00: 8
    • 04:00 - 05:00: 8
    • 05:00 - 06:00: 7
    • 06:00 - 07:00: 8
    • 07:00 - 08:00: 7
    • 08:00 - 09:00: 8
    • 09:00 - 10:00: 10
    • 10:00 - 11:00: 9
    • 11:00 - 12:00: 11
    • 12:00 - 13:00: 14
    • 13:00 - 14:00: 15
    • 14:00 - 15:00: 16
    • 15:00 - 16:00: 17 (Highest)
    • 16:00 - 17:00: 18
    • 17:00 - 18:00: 17
    • 18:00 - 19:00: 17
    • 19:00 - 20:00: 14
    • 20:00 - 21:00: 15
    • 21:00 - 22:00: 17
    • 22:00 - 23:00: 11
  • Key Observations:
    • The highest peak was recorded during 15:00 - 16:00 with a total of 17 receipts.
    • This time represented 6.23% of total receipts for Tuesday.
Wednesday
  • Time Intervals and Values:
    • Highest recorded total was at various intervals:
    • 17:00 - 18:00: 20
    • 18:00 - 19:00: 22 (Highest)
    • The other intervals revealed relatively steady numbers, typically in the range of 8 to 12 receipts per hour.
Thursday
  • Interval Statistics:
    • Peak values were observed around 13:00 - 14:00 with 15 receipts
    • Consistency across the day with several intervals maintaining conditions above the 10 receipts mark.
Friday
  • Time Intervals and Values:
    • Most receipts appeared to peak during 16:00 - 17:00 with 17.
    • Evening periods of the day displayed a decline leading to final totals of about 9 to 12 receipts in ending hours.
Saturday
  • Peak Receipt Intervals:
    • Noteworthy peaks were recorded at 12:00 - 13:00, reaching up to 15 receipts, and maintaining numbers steadily over the evening.
Sunday
  • Summary of Trends:
    • Receipts maintained peak consistency around 10 to 14 throughout various time slots in the afternoon early evening.
    • The highest count reached again in the intervals near 12:00 - 13:00 and 18:00 - 19:00.
General Observations Across Days
  • Highest Daily Receipt Count by Day:
    • The highest single hour averages vary from Monday's 22 down to weekend values of 12 on Saturdays.
  • Trends:
    • Fluctuation exists with weekends yielding different patterns compared to weekdays indicating a potential differential in activity levels.