Business Intelligence solutions
presented by: Taran Sohal, Director
Successful SharePoint delivered fast
“We’re delighted to be working in partnership
with Cloud2’s Hadron 8020 SharePoint design and
architecture as a platform for delivering rich, visual
dashboards connected to our i-health BI data
warehouse”
Haq Khan, Finance Director, WAHT
Successful SharePoint delivered fast
SharePoint 2013
SQL 2012
“SharePoint 2013 and SQL 2012 provide us with
superior reporting and data analysis techniques
giving the Trust instant drill down in “real-time“ to
compare data and trends, enabling the Trust to swiftly
highlight issues before they have a negative impact.
We're pleased to be working with Cloud2 to deliver
the instinctive dashboards that can deliver ”real-time”
browser-based reporting to share the information
rapidly and effortlessly with the people who need it
most.”
Tim Slater, Head of Performance Management, EMAS
Successful SharePoint delivered fast
SharePoint 2010
SQL 2012
Lancashire CSU selected Hadron 8020 SharePoint information
architecture to deliver its business intelligence services across all 8 of
the Lancashire Clinical Commissioning Groups CCGs
“We aim to deliver a broad range of business intelligence services in
Lancashire and efficient reporting is a key element in that delivery
strategy. Cloud2’s Hadron UI architecture and design provides a
stable platform for superior client reporting, delivering stunning
visual dashboards that are easy-to-use and very simple to customise
for stakeholders.”
Stewart Bond, Head of Business Intelligence & IT, Lancashire CSU
Successful SharePoint delivered fast
What is SharePoint?
Intranet &
Applications
100 million licences
$1billion product
Document
Management
Search
Business
Productivity
eForms &
Workflow
Collaboration
Business
Intelligence
Successful SharePoint delivered fast
Successful SharePoint
Successful SharePoint delivered fast
Gartner Magic Quadrant for BI 2011
Successful SharePoint delivered fast
Microsoft BI Strategy
The Tool:
Sharing
The Tool:
End user exploration
The stack:
Data Analysis with SQL
Successful SharePoint delivered fast
Excel Services
Visio Services
PerformancePoint
Excel
Power View
PowerPivot
Analysis Services
SQL Server
Integration Services
how this is typically done
Business
Analysts
Service Manager,
Executive
is any of this still
relevant?
what’s important?
Is it up to date?
why doesn’t it reconcile?
Knowledge Workers
Successful SharePoint delivered fast
how this can be done
Business
Analysts
Service Manager,
Executive
is any of this still relevant?
Yes it is
what’s important?
Poor Performance in Area x
Is it up to date?
Yes it is
Knowledge Workers
Successful SharePoint delivered fast
Centralised Data Store
why doesn’t it reconcile?
BI tools
Tool
Scope / Implementation
Dependencies
Excel Services (Rapid BI)
Power Pivot
Little BI
5-10 days, minimal training
Excel 2010, 2013
SharePoint 2010,
2013
Reporting Services
Mid BI
10-15 days, skilled team
SQL 2008 R2
SQL 2012
Power View
Little-Mid BI
10 days
SQL 2008 R2
SQL 2012
Qlikview
Dashboards
Mid BI
3-6 months, skilled team
Licencing model?
Performance Point
Big BI
Timescales depend on cubes, dw
Well trained and capable team
Data warehouse
(Cognos, Business Objects)
Successful SharePoint delivered fast
In house, Insource,
Ardentia
BI Build – Reports, Dashboards,
Scorecards
Mandatory
Operational
Finance
HR
Clinical Audits
National
Big Data
Insights
Successful SharePoint delivered fast