Spreadsheet Design Concepts Series
Spreadsheet eg. of Dimensionality 2
The number 338 represents
- Period 8 2005 in the Time dimension
- Actual Figure in the Type dimension (Actual, Forecast, Budget, etc)
- For Employment Costs in the P&L line item dimension
- For the North in the geography dimension
- For Large Co in the business unit dimension
So this simple report actually has 5 dimensions, 5-7 dimensions is a common occurrence in business analysis. Many OLAP tools are optimised for this number of dimensions.
Spreadsheets are generally not the best choice for storing data this complex, they work better where there are only 2 dimensions. Spreadsheets can still be used for effective analysis and reporting though, especially Excel Pivot Tables.
25 January 2012 - UK Excel Developer Conference - London
Products for sale:
New information about the missing FileSearch feature in Office 2007 and details of our pragmatic solution (Current price GBP 30.00)
Instant Excel worksheet protection remover and password recovery (Current price GBP 15.00)
Classic Ribbon Tab
Add Excel 97/2000/2002/2003 compatible menu structure to Excel 2007
(Current Price GBP 10.00)
Products coming soon:
(Find and control external links in Excel Workbooks)
Due by Q1 2111.
(Excel VBA based spreadsheet auditing tool)
Due before the end of 2111.