Strategic Reporting What kind of reporting do you

Strategic Reporting What kind of reporting do you need? what EDW is for …… Strategic Operational 1 Report contains historical data, and is concerned with aggregates, trends and patterns. Report contains current data and is typically concerned with events that happened today or yesterday. 2 The underlying data is rarely required to be close to ‘real-time’. Yesterday’s, last week’s or last month’s data is sufficient. The underlying data needs to be up-to-date e. g. it needs to be ‘real-time’, or close to it. It should be comparable to the contents of the operational system 3 Reports supports strategic and ad-hoc business decision making processes Report supports a set of defined, regular and repeated operational processes. within an organisation. 4 Report is presented at an aggregated and summarised level, but frequently Report relates primarily to some form of transactional activity, and as a result with drill-down access to the underlying transactional data. is quite granular in detail. 5 The information presented can be extracted from multiple, diverse operational systems. Reports will commonly cross departmental boundaries, and may contain information with different data owners. The information presented is extracted from a single operational system. 6 The information presented may not correlate closely with any single source The information presented is closely correlated to its source operational of data. E. g. the terminology, column headings etc. may be quite different. system. E. g. the terminology, columns headings etc. will match operational system. 7 Report can be presented in a tabular, matrix format, but also in a number of Report is normally presented in a tabular, matrix format. graphical and visually helpful ways e. g. Dashboards, Graphs etc. 8 Reporting is commonly produced using a set of Data Warehouse (DW), Business Intelligence (BI) and Management Information (MI) tools and techniques.