The main purpose of any Business Intelligence system is to provide business users ability to answer questions that are important to running the part of the business for which they are responsible. For example:
- Show me sales for each client by month.
- Show me the average sales amount for each client by month.
- Show me the running total amount by date.
If Business Intelligence system designed really well your business users just have fun asking questions of their data.
But there are many questions to answer Business Intelligence system need to work with data that has been aggregated to different levels of detail.