from BIG DATA to BIG IMPACT

(1)

dashboard in a day

from

BIG DATA

to

BIG IMPACT

Sarah Williams @Cloud2Ltd

15th September 2015

(2)

Successful SharePoint Delivered Fast

What to expect…

•

Great speakers & industry experts

•

Networking

•

Lunch and learn BI demo

(3)

Stuff you need to know…

•

In case of fire…

•

Facilities

(4)

Time Agenda Speaker Job Title Organisation

09.00 – 09.30 Registration Opens

9.30 – 10.15 Welcome and Keynote Simon Hudson Co-Founder & Director Cloud2 10.15 – 11.00 The big impact we are making

to realise our BI vision

Paul Morris Head of Business

Intelligence RLBUHT 11.00 – 11.30 Refreshments and

Networking Break

11.30 – 12.00 Our BI Vision Cain Cookson Business Development Cloud2 12.00 – 12.45 Getting BI right Tom Zglobicki

Partner – Business Intelligence, Systems and

Delivery

SE CSU 12.45 – 13.45 Lunch and Networking Lunch

13.34 – 14.00 Meson BI demo Sam Codman Business Development Cloud2 14.00 – 14.45 Making machines think Ric Howe Partner Technology

Strategist Microsoft 14.45 – 15.00 Looking after your big data Graham Bennett Co-Founder & Director Insource 15.00 – 15.15 Licence to BI Lee Latham Licensing Business

manager, Public Sector Softcat 15.15

And the winner is… Microsoft band prize give

away

Sarah Williams Business Development Cloud2

(5)

Welcome and keynote

Simon Hudson

Co-Founder & Director

(6)

(7)

(8)

(9)

(10)

(11)

(12)

(13)

(14)

(15)

(16)

(17)

(18)

The big impact we are making to

realise our BI Vision

Paul Morris

Head of Business Intelligence

Royal Liverpool and Broadgreen University

Hospital Trust

(19)

Realising our BI

Vision – The Big

Impact

Paul Morris

Head of Business Intelligence

The Royal Liverpool and Broadgreen University Hospitals NHS Trust

(20)

Introduction to Liverpool

2 site Trust (RLH & BGH) Population 1.5m Major teaching and research Trust City centre location

6,000+ staff New hospital

(21)

The Vision

“Deliver a comprehensive analytical platform to support

improved decision making for the health and wellbeing

(22)

The Strategy

Establish a culture of information consumption across the Trust Increase use of information for decision making

Develop a single portal for access to information Deliver self-service BI Overhaul our information processing, analytical and delivery capabilities Enhance/expand data quality services

Stop churning; start analysing

Focus on advanced analytics

(23)

(24)

BI Maturity

(25)

Tools / Process

Data Warehouse

Data

processing Querying Analysing

Data

(26)

BI Audit

Audit undertaken by

Cloud 2

Comprehensive and rapid

Clear recommendations

aligned to our strategy

(27)

(28)

The Journey So Far

Established a dedicated BI development team

Upskilled the existing Information and

analytical staff

Implemented dedicated BI infrastructure

Multiple clinical and corporate systems now

feed data warehouse

Deployed a single portal for accessing information with

self-service BI Information processing and delivery is automated for majority of reports Started to establish a culture of information consumption across the Trust Up-to-date information is now

used for decision making

Starting to focus on advanced analytics

(29)

BI Tools / Automated Processes

Extract, Transform & Load (ETL) Data processing & querying

Modelling Analysing Data

(30)

Coeus

Common unified platform for all reporting requirements

Incorporates structured data from all appropriate patient,

clinical and corporate systems Easy to use environment Key information immediately presented Self-service BI

(31)

Report Examples

(32)

BI Maturity

2015

2018

(33)

Tangible Difference

Queries take minutes not hours;

Data processing automatically runs overnight each day;

Reports are refreshed overnight;

Reports available from the moment a user logs in;

Reports available through Coeus;

Interactive reports with drill through capability; PTLs refreshed automatically twice a day;

Structured multi-dimensional and tabular data models;

Improved performance against national standards;

Patient focussed reporting;

Consolidated Clinical and Corporate data reporting;

Average of 75 hits per day;

(34)

Demonstration

(35)

Next Steps

Continue to

change the culture Collaboration

Embedded self-service BI Mobile BI and mobile collaboration Establish a BICC with virtual elements i.e. IG Predictive Analytics i.e. Big

Data; Risk Stratification Continue to

integrate more systems into the

data warehouse

Review

system/hardware architecture

(36)

(37)

Back to Presentation

(38)

(39)

(40)

(41)

(42)

(43)

(44)

(45)

(46)

(47)

(48)

(49)

(50)

(51)

Refreshments

& Networking

(52)

Our BI Vision

Cain Cookson

Business Development Executive

(53)

2008

150+

(54)

The problems we face

How can I make insightful decisions when my data

is already out of date?

How do I know which of my reports is correct?

How can I view this data in a different way, quickly? How can I see what I need to

(55)

What are the answers?

•

A single version of the truth

•

Real-time interactive and interrogateable data

in one place

•

Tools and techniques to stop you drowning in

data

•

Analysts free to analyse

(56)

Our BI vision

“It’s about having one place, with the right

information, to allow informed decision

making and promote positive change.”

“Deliver a comprehensive analytical platform to support improved decision making for the health and wellbeing

of the population“

(57)

(58)

The 3 pillars of Meson-BI

Reporting

People

Source to

(59)

Reporting

Mandatory

Finance

HR

Clinical

Corporate

Operational

Ad-Hoc

(60)

People

Users

Analysts

Execs

IT

BI Team

(61)

With you every step of the way

SQL Integration

Services (SSIS) SQL Database Engine Services (SSAS)SQL Analysis Power Pivot Data

Model SSRS Power View Power Pivot Power Map Power BI App SharePoint etc. Source to Action Too ls and Tech nol ogy Meson -BI Meson-BI Audit BI Platform Meson-BI Reports Meson-BI Portal Meson-BI Embed Action

(62)

(63)

(64)

(65)

Successful SharePoint delivered fast BI Options Note SQL 2008 R2 SQL 2012 Report Builder / SSRS SharePoint 2010 SharePoint

2013 Office 2003 Office 2007 Office 2010 Office 2013 Multi-Dimensional Cube 1 *7

Tabular Cube 2 *1 *1

Report Builder / SSRS 3

SharePoint 4 *3 *3 *3 *2 *3

SharePoint Power Pivot 5 *7 *11 *7 *11

SharePoint Power View 6 *5 *7 *4 *7 *11 *7 *11

Performance Point 7 *14

Core Excel 8 *8 *13 *8

Excel Power Pivot 9 *8 *12 *13 *8

Excel Power View 10 *6 *6 *8 *8 *6

Excel Power Map 11 *6 *6 *15 *15 *6

Software Versions

Existing BI and Vision BI Maturity Assessment

Team Skills Matrix Technology Evaluation

Platform Architecture Recommendations _Report

(66)

The Key Considerations

Platform Data Journey Portal Design, IA Reports & Dashboards Collaboration & Action Team Skills & Processes Technology & Tools Embedding

(67)

Questions?

(68)

Getting BI Right

Tom Zglobicki

Partner

–

Business Intelligence, Systems and

Delivery

(69)

+

Getting BI Right

Successfully delivering BI programme for your organization

SQL BI

Analytics

(70)

+

BI – is it only a technology?

 BI usually refers to technologies used to deliver a set of data

warehousing and analytical solutions

 Organisations make significant investments into technical

solution that will allow them to analyse data available to them

 BI programmes frequently run into difficulties and fall short of

stakeholders expectations

 It is notoriously difficult to deliver an enterprise wide BI

solution that will fully meet the expectations and cater for all the requirments

 BI delivery is complex because is not only technology we

(71)

+

Magic number 3

Delivery of successful BI can be distilled to 3 core ingredients:

 People

 Processes  Technology

Neglect any of those ingredients and you will quickly run into the difficulties.

(72)

+

People

 Great products and services are always delivered by teams of

dedicated and highly motivated people that are prepared to go the proverbial extra mile and BI is no different. Everybody knows this and yet creating great working environment where collaboration, passion and commitment is valued and rewarded is often missing from BI programs objectives.

 Always start with the team; before a single report is created or a

single line of SQL is written make sure that not only you have the right people but you also have a team.

 Make sure that the team understands the objectives, what we are

trying to achieve by implementing a BI solution. Project plans will very often be adjusted or changed to address the changing circumstances but objectives usually remain the same. Team will find it much easier to adapt to the changing circumstances and make the right decisions if they understand and buy into the reason for the BI programme.

(73)

+

People

 Get the right skills, ensure that you always have leaders in the

team that have the right expertise and experience

 Provide ongoing training and development opportunities

 Engage with partners and vendors to transfer knowledge and

to ensure that your team fully understand the potential of BI technology being implemented and know the roadmap for the technology.

 If you work with a partner organisation(s) to deliver a BI

solution whenever possible create a mix team to bring all the key people together and to ensure that they work toward the common goals

(74)

+

Processes

 Create standard processes and make sure people know them.

Keep things simple and be outcome driven. Process is

nothing more than a communication mechanism describing how things should be done in order to achieve a desired

outcome. Make sure you put the emphasis on the outcome rather than the how.

 Adopt best practices and standards, we are fortunate that

there is a quite comprehensive set of approaches to most aspects of BI considered across the board to be good

practice. Make sure you will adopt those, it will save you time, effort, money and greatly increase chances of BI programe

(75)

+

Processes

 Have a defined development metrology and ensure that team

understands and follows it. Again focus on the desired

outcomes rather that the how as described in the book. This gives you a common language and framework to work within but don’t be afraid to adopt and change it to cater fot to your particular circumstances.

 Understand wider processes across the organisation and the

general culture. This is important as success of BI is multi team and multi department effort and if there is a

misalignment of processes and organizational culture clash, the BI programme will most definitely fail

(76)

+

Technology

 This traditionally has been considered the biggest challenge and

that where the most of effort on any BI program is usually focused… however those days this is usually the easiest part of any

programme.

 Whether you do simple reporting, complex data mining or real time

analytics; a selection of solid technical platforms and technologies exists for your particular needs. It is very rare that you will need to navigate unchartered waters when it comes to BI.

 When choosing technology ensure that you have right skills

available and that there is a ecosystem you can afford to be part of. BI is an expensive business and although all top vendors provide great platforms very often at what initially appears to be affordable prices the costs of ecosystem; partners, consultants, additional

(77)

+

Technology

 Ensure that you don’t duplicate functionality, multi-vendor approach

is not necessarily bad however duplicated functionality that is

implemented in different ways will cost you significant time, effort and money. Having multiple department using separately Tableau, Qlick and Reporting Services is a bad idea. Make sure that

solutions are complementary and vendors support the chosen

components, the best idea if possible go with end to end with one vendor for the core part of BI stack and then fill the gaps with

complementary solutions.

 Remember simple works best, if a technical solution cannot be

explained in simple terms that can be understood by a reasonably technical business person in your organization the chances are you don’t need it.

(78)

+

BI Delivery Matrix

People

Proces

s

Technol

ogy

Information

Governance

Data Management

Education and

Training

Support and

consultation

Vendor and Partner

Relationship

(79)

+

Little things that make big

difference

 Communicate every achievement resulting from the

programme to all stakeholders

 Be agile and deliver in small chunks but frequently

 Go for the “quick wins” but do not use them all at once,

spread the delivery of those throughout the programme

 Ensure that with delivery of each component there is a visual

aspect to it; a dashboard, a reports, self service capability etc.

 Gather and publicise good feedback, there is nothing better

to encourage adoption than a good feedback from other users.

(80)

+

Go Beyond Dashboard

 Dashboard is only a beginning, a window into a BI world.

Make sure that a delivery of a set of dashboards is only a step one of your BI programme.

 To truly get return on your investment and harness the full

power of your data and BI technologies you need to focus on implementing knowledge driven decisions across your

organization and measure the outcomes. This is an iterative process that will ultimately transform your organization and a dashboard is only a beginning.

 Invest into BI skills across your workforce to ensure that a

(81)

+

(82)

(83)

Lunch and Learn

BI Demo

Sam Codman

(84)

Making machines think

Ric Howe

Partner Technology Strategist

(85)

Looking after your big data

Glen Burdett

Health Care Director

(86)

(87)

Looking After Your

Big Data

Glen Burdett

(88)

What you won’t be hearing

from me today!

(89)

Introduction

 Insource is a leading provider of Data Management

solutions to the Health and Private Sectors.

 NHS domain expertise - 19 years’ experience  Enabled improvements in 200+ healthcare

organisations across the UK

 Enabling DW Automation in the Private sector

(90)

Today

We must accept that the amount of data needed and the value demanded from that data are today

(91)

Here’s the dilemma

Data preparation is one of the most

difficult and time-consuming challenges

facing business users of BI and …

advanced analytics

(92)

(93)

“I think your figures are wrong, I’m sure mine are right”

(94)

What’s needed

CRM Orders Data Mart Reporting Tool Activity Data Mart Reporting Tool Performance Data Mart Reporting Tool Finance Data Mart Reporting Tool Absence Data Mart Reporting Tool HR Finance

Managed & Automated Data Layer

(95)

Unified data Layer

 Look at it  Count it  Measure it

 See where it came from  See where it’s going

 Manage it’s usage

 Manage who has access to it

 Ensure value is being derived from it  Ensure its consistency

A secure vault for one of your most valuable business asset – Your Data

(96)

The confidence

indicator

Ability to see

which data item in

the report is

missing data

(97)

Healthcare example –

Why is data not seen as business

critical pre and post PAS migration?

(98)

Be capable of consolidating Should support

any & multiple sources of data

PAS migrations

Transparently support change in source Migration issues the same for all

(99)

A healthcare data solution

Enterprise Data Processing Engine CDS RTT Others A sin gle so ur ce of al l data fr om the ent erpr ise

(100)

Reporting initiatives are usually approached separately and in isolation of each other during hospital PAS migration planning:

 Operational reporting continuity  Management reporting continuity  Statutory returns

 CDS - Commissioning datasets  RTT – Referral to Treatment

 Data quality – pre and post migration  System usage post migration

 Changing trends – due to migration or genuine change?

(101)

 Financial penalties  RTT

 Missed performance targets  CDS

 Payment challenges

 Not paid for actual service provided  Patient experience

 Reputation

 Reduced patient care  Project

 Significant resource cost  Lack of budget control

(102)

(103)

If you always do what you always did, you

will always get what you always got

Albert Einstein

Find out more…..

[email protected] 07967 478407

(104)

License to BI

Lee Latham

Licensing Business Manager (Public Sector)

(105)

And the winner is…

Sarah Williams

(106)

http://tdwi.org/pages/maturity-model/maturity-model-home.aspx

http://www.cloud2.co.uk/solutions/meson-bi/meson-bi-audit/