When is a database approach better than spreadsheet pivot tables for analysing a data set with several reports?

Question

The data is for a small hotel that in different months runs different numbers of events of differing duration, with differing number of participants and with differing variable costs. The combined gross margins need to cover the hotel's fixed costs. I want to explore that data, and it's sub sets from various directions in order to develop robust forward plans.

Answer 1

Pivot tables still require the data to be entered and order, so if you have to do that anyway why not put it in to a database.



The database can still be used to create pivot tables but will give you a much expanded functionality without any significant increase in workload.



Creating subsets of the data is as simple as querying the database with the appropriate conditions.

Answer 2

it is better purely gazing the appliance you're using it for. each and every specifically circumstances spreadsheets are better. additionally, there are all varieties of databases. yet i think of you're speaking a pair of Relational Database. That has the skill to narrate different tables of a database mutually by columns. That makes it extra common to artwork with documents for many applications that a spreadsheet won't be able to preserve.

Answer 3

dimensions and orthogonality



Data bases reflect/record records which can be more qualitative than quantitative



Spreadsheets are quantitative



A database approach used properly will highlight management effects



spreadsheets will show logistic detail



Good Business modeling is the key