Storing and retrieving analytical data for admin dashboard
I am developing pos software, for the admin view of the app we need to show various analytical data like number of sales made, total revenue, etc. We are having tables to store receipts generated. What will be the best way to retrieve the analytical data to be displayed in the admin dashboard?
