1 / 18

NES Business Intelligence

NES Business Intelligence. Gary Young 29/07/2011. Attendance. Context: GM Business Intelligence. GMBIN recommendations (to Mike Burrows) SQL Server 2008 R2 / SSRS / SSAS CBS data warehouse / technical development team Standardisation to improve capability, quality and interoperability

ballou
Download Presentation

NES Business Intelligence

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. NES Business Intelligence Gary Young 29/07/2011

  2. Attendance

  3. Context: GM Business Intelligence • GMBIN recommendations (to Mike Burrows) • SQL Server 2008 R2 / SSRS / SSAS • CBS data warehouse / technical development team • Standardisation to improve capability, quality and interoperability • GM Cluster IM&T Transformation • Achieving QIPP targets • Peter Moseley leading BI workstream • Shared service model (CSS?) • Standardisation and integration (people processes and technology)

  4. NES Business Intelligence • Bury, HMR and Oldham to form sub-cluster • GY given remit by Stuart North (DoF Bury and HMR) and Steve Sutcliffe (DoF Oldham) to • Co-ordinate NES work programme • Improve capability and quality • Communication from Stuart North to follow • No changes to line management (yet?) • HR issues to be resolved

  5. Continuous Improvement Lean: kaizen

  6. Standardisation • Tools: SQL Server 2008 R2 • Common data source (Minerva) • Standard Operating Procedures • SQL Coding Standard • SSRS Report Development (to follow) • Consistent branding / look and feel • Templates • Professional development • Code of conduct / expected behaviours • Continuing Professional Development / UKCHIP

  7. Minerva • Roman goddess of • Wisdom • Medicine • (NHS?) Magic • Greek equivalent • Athena

  8. Architecture

  9. Data Warehouse Designs Star Snowflake Easier to understand 3rd normal form Best avoided!

  10. Minerva Database Design • Star schema • Conformed dimensions • Consistent across data sets • Surrogate keys • Integers rather than natural keys • Coding (diagnoses / procedures) abstracted into separate fact tables (unpivoted) • Extensive use of views

  11. Minerva Database Structure

  12. Minerva Data Already included… Coming soon… Elective admission list Births and deaths Mental health MDS What else? • Inpatient spells • Outpatient attendances • A&E attendances • SLAM* • GP practice list (Exeter)* • Prescriptions* *ETL processes require further development

  13. Access to Minerva • SSMS • rptdev.nwtis.nhs.uk • Login: surname initial (lysta) • Change password • sp_password 'OldPassword', 'NewPassword', 'UserName' • SSRS • http://rptdev.nwtis.nhs.uk/reportserver/ (publish) • http://rptdev.nwtis.nhs.uk/Reports (access) • Login: TIS\forename.surname (TIS\anna.lyst)

  14. SOP for SQL Server

  15. SOP for Reports • SSRS 2008 R2 • Single page of A4 wherever possible • Templates / branding • Don't reinvent the wheel • Filters • Provider • Commissioner (PCT / CCG / federations thereof) • GP practice • GP

  16. NES Reporting

  17. To Be Determined… • Training / learning requirements • HMR in-house • Train the trainer • Configuration of Report Manager • Folders / projects • Customer access • On demand / scheduled • Co-location?

  18. Actions • Send to GY • Required data feeds • Issues • Suggestions for NES reports • Create NHS Networks account • http://www.networks.nhs.uk/nhs-networks/gmbin

More Related