My good friend Will Riley posted last month on his blog a very good series about creating Dynamic OLAP Cube Reports in Excel. The series is in three parts and walk us through the required steps in order to create this type of reports.
In addition to its main purpose the series shows clearly, at least to me:
- The need to have access to several tools to create the reports.
- The requirement to, at least, have some basic knowledge about how to use the required tools.
- The need to understand how the data is built up, including the relations between the entities in the data.
- The need to communicate the reports to its audience which is perhaps the most challenging part of the whole process!
If You have some time over then I strongly encourage You to visit Will’s blog and read it Yourself:
Thanks Will! And I’m looking forward to take part of more series of this kind.