← BIT 405 Business Intelligence and Data Warehousing
OLAP, Dashboards and Management Reporting
Notes
Multidimensional analysis
Online analytical processing, or OLAP, supports rapid examination of measures across dimensions such as time, product and location. Slicing selects one dimension value, while dicing selects a combination of values across dimensions. Drill-down moves from summary to greater detail, such as annual sales to monthly sales, and roll-up aggregates in the reverse direction. These operations depend on consistent hierarchies and measure definitions. A percentage should generally be recalculated from its underlying numerator and denominator rather than averaged indiscriminately across groups with different sizes, because misleading aggregation can reverse apparent performance comparisons.
Designing decision-focused reports
A dashboard presents selected indicators so users can monitor progress and identify exceptions. A key performance indicator connects a measurable result with an important objective and usually includes a target, owner and reporting period. Effective dashboards show units, refresh times and comparison baselines, and allow appropriate investigation of anomalies. Visual choices should match the question: lines reveal trends and bars compare categories. Role-based access prevents unnecessary exposure of sensitive details. Reporting teams should document calculation rules, distinguish estimates from confirmed figures and avoid decorative displays that obscure evidence needed for practical management decisions.
Practical example
A Kisumu SACCO reports loan collections for two branches. Branch A collects KES 900,000 against KES 1,000,000 due, achieving 90%. Branch B collects KES 100,000 against KES 200,000 due, achieving 50%. The combined rate is 1,000,000 ÷ 1,200,000 = 83.33%, not the simple average of 90% and 50%, which is 70%. A dashboard shows the weighted overall rate alongside each branch result and an 85% target. Management drills down into overdue accounts at Branch B, while access controls limit account-level details to authorised collection staff.
Quiz
1. Why should a dashboard show refresh time?
2. Which operation moves from annual sales to monthly sales?
3. What is the correct combined collection rate?
Sign in to submit and securely grade your quiz.