Data Access and Reporting Clause Samples
Data Access and Reporting. It is important for the Respondent to understand our current state of reporting. SFPUC supports approximately 68 reports related to CCB using one of our approaches – Ad-hoc, OUA, or COGNOS. In many cases SFPUC takes advantage of and has extended the Oracle Utilities Analytics data warehouse to accomplish goals and objectives. The historical information has been deemed important by our business partners. SFPUC expects that the business functions supported by these reports will be supported with the new solution. SFPUC is looking for the Respondent to offer a complete data and reporting strategy and solution based on their experience with similar projects. SFPUC will consider all reasonable options including the use of a self-managed data warehouse if deemed necessary. If a Data Warehouse is recommended, the Respondent is to supply the recommended approach including the full effort and costing within the Proposal. All solutions should be considerate of cost-effectiveness, maintenance, and accessibility of data. SFPUC currently has the following tools and skillsets available to contribute: BI Publisher, PowerBI, some data warehousing experience. It is SFPUC’s preference that all reporting come from one tool, if possible (e.g. Oracle data analytics).
Data Access and Reporting. Selection of the license inventory by freely configurable criteria CSV, XLS(X), and XML export for external report generation, e.g. in Excel or Crystal Reports Predefined report formats with dynamic generation of PDF files Individual reports based on a professional reporting engine with common emitter for all Office formats Scheduler for automatic creation and distribution of reports Management console / KPI dashboard (“Cockpit”) with intuitive, graphical representation, e.g.: degree of licensing, degree of under-licensing, top ten over-licensed products, important manufacturers, etc.