Single Party Framework Agreement for the provision of Professional Services and Support for Business Intelligence for the 4 Dublin Authorities

Tender description

Single Party Framework Agreement for the provision of Professional Services and Support for Business Intelligence for the 4 Dublin Authorities - Dublin City Council, Dun Laoghaire Rathdown County Council, Fingal County Council and South Dublin County Council Initially for 2 years and may be extended for a further 2 years The professional services required include, but are not limited to, the following: 1. BI requirements analysis – respondent must describe methodologies and approach used to guide users through requirements definition. 2. Review and provide advice on BI system designs including ETL. 3. Develop and implement BI solutions including SQL Reporting Services and Oracle OBI. 4. Review and support current and future systems as requested including ETL scripting and processes. Respondents must provide details of support structures, including response times and SLAs available. 5. Review and advise in respect of developing a BI Strategy in the participating authority. 6. Assist in determining appropriate standards, procedures and benchmarks. The successful tenderer will be expected to provide advice on best practice in cube/warehouse design. 7. Review and provide advice in respect of open source solutions. 8. Must be able if required to provide DBA skills, make recommendations, and liaise with the DBA Unit of the participating authority or third party support companies. DBA skills should include Oracle and SQL but tenderers should provide a complete list of database products that they support including open source products. 9. Training in BI tools and methods including SQL Report Writer, self-service analysis, trend analysis and Oracle Business Intelligence. Respondents must supply a brief outline of course content for relevant courses.