1 / 22

North West Ambulance Service Business Intelligence

North West Ambulance Service Business Intelligence. Barry Duke Senior Consultant, Ascribe. About NWAS.

aquila-mccarthy
Download Presentation

North West Ambulance Service 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. North West Ambulance Service Business Intelligence Barry Duke Senior Consultant, Ascribe

  2. About NWAS The North West Ambulance Service is the biggest ambulance service in the country providing 24 hour, 365 days a year accident and emergency services to those in need of emergency medical treatment and transport. Our highly skilled staff provide life-saving care to patients in the community and take people to hospital or a place of care if needed.

  3. About Ascribe… • Health & Social Care BI Portals • Microsoft • Integration to many key clinical and corporate systems • 70+ customers for BI • 75% coverage of NHS on other solutions • Public Sector (Health and Local / Regional Government) • Output: • Consulting • Accelerators • Hardened product

  4. Purpose • BI Challenges in NWAS • Methodology • Platform • What we did and what we produced …but first – what they said! http://www.itpro.co.uk/630817/introducing-excel-powerpivot

  5. BI Strategy • From department to enterprise • From reporting to knowledge • From submission to harvesting • From silos to warehouses • From batch to message • From desktop to web • From data sets to enterprise schematics • From bespoke to re-usable • From ad hoc to structured • From divisions to “Corp” • From reporting software to Microsoft BI stack

  6. Data Warehouse Methodology

  7. Microsoft BI Stack

  8. Issues Business Intelligence helps solve • Service design • Performance / contract / finance management • Capacity planning • SLR • Forecasting and projection • Trend and time-series • Service delivery - outcomes not inputs • Mergers and acquisitions – e.g. Public Health functions

  9. Sharepoint Portal ProClarity Scorecard RS BING Dundas / RS Datasheet View Drillable Chart Reporting Services Operational Data Store Cubes Analysis Services OLAP Application Data Store Data Set Integration Services MIS Application Report Server

  10. The matrix!

  11. Connecting you with your data: Sharepoint

  12. Sharepoint • Secure • Delineates users by capability / capacity • Board to incident record in less than 5 clicks • Scorecards for exceptions and assurance • Dashboards for drill-down • Designed to meet self-service needs • If a bus matrix is 100 measures by 20 dimensions then you can answer 2000 questions in seconds with no technical skills

  13. Connecting you with your data: Sharepoint

  14. Connecting you with your data: Excel

  15. Power Pivot • In-Memory BI • 6m rows in Excel • Slicers • Sparklines • Data mining features • Adding in new data sets on the fly • Direct interface to structured warehouse • Published via Excel (NOT e-MAILED!) • For analysts

  16. Power Pivot

  17. Bespoke presentation • Formatting and presentation influences consumption • … as much as content! • Gauges and dials don’t help analysts • … but they help others

  18. Same Platform Generates Operational Clinical Intelligence

  19. Public Health GIS

  20. Public Health GIS

  21. Summary • The Microsoft stack • A structured methodology • Accelerator products and consultancy projects • Meeting real business and clinical needs

More Related