business intelligence and healthcare - collabcon · business intelligence and healthcare suthan...
TRANSCRIPT
Business Intelligence and Healthcare
SUTHAN SIVAPATHAM – SENIOR SHAREPOINT ARCHITECT
Solutions for Success
Agenda
• Who we are • What is BI? • Microsoft’s BI Stack • Case Study (Healthcare)
Solutions for Success
Who we are
• Point Alliance is an award-winning provider of information technology strategies and solutions.
• Our consulting practice is a recognized leader in delivering proven business solutions to Global 300 companies across many industries.
• Backed by over 12 years of proven results from over 200 organizations, we offer comprehensive products and solutions that drive your business growth and success.
Solutions for Success
What is Business Intelligence (BI)
• Quite Simply, Business Intelligence is the transformation of data into knowledge.
• It is about getting the “right information” to the “right people” at the “right time”.
• It is the ability for an organization to effectively utilize data to produce fact‐based, credible and actionable intelligence
Solutions for Success
BI Process
Solutions for Success
Demonstration of Microsoft BI Reporting Tools Via SharePoint
• Excel Service • PowerView • PerformancePoint • Reporting Services
Solutions for Success
Multidimensional SSAS Database
• Contains Pre aggregated Data • Answers questions related to summarizing
business operations and trends • Rapid processing of queries • Cubes (measure by one or more dimensions)
• E.g. – sales over time by city • Can have a hierarchy (e.g. cities roll up to provinces)
Solutions for Success
Self-Service
Self Service Tools: • Excel • PowerView
• Users can do pivoting and drilling down into the information. These business users need to be able to work independently of IT.
Solutions for Success
Scorecarding
• What is scorecarding? • A scorecard is a graphic that depicts the
progress over time of an enterprise, an employee or a business unit, toward some type of goal
• Key Concept: targets and kpi’s
Solutions for Success
Professional Reports
• Use SSRS • Pixel Perfect • Managed by IT • Secured
Solutions for Success
Performance Dashboards
• What is a dashboard? • Allows users to easily monitor the
performance of their business.
Solutions for Success
Case Study
WHY CAMH CHOSE MICROSOFT FOR THEIR BI IMPLEMENTATION
Solutions for Success
The Centre For Addiction & Mental Health (CAMH)
The Centre for Addiction and Mental Health (CAMH) is Canada's largest mental health and addiction teaching hospital, as well as one of the world's leading research centers in the area of addiction and mental health.
Solutions for Success
CAMH’s Vision for BI
…useful and actionable information, easily accessed when needed, to inform and enhance planning, decision-making and performance improvement…in support of transforming lives
Solutions for Success
Why SharePoint 2013 and SQL Server 2012
• One integrated platform for self-service business intelligence, collaboration and workflow
• Built-in capabilities for dashboard and scorecard creation for interactive analytics and visualizations
• Highly interactive and explorative ad-hoc reports
• Report and dashboard management and delivery across the organization
Solutions for Success
Project Charter
• BI Competency Centre: the people, process and technology to facilitate integrated, analytic reporting across the organization
• Automated, self-serve reports and dashboards to provide managers with the information they need, in a more timely manner
• The environment and tools to support more advanced analysis and ad-hoc reporting
• Replace manual processes
Solutions for Success
Project Scope
• BI Portal • Data warehouse
• integrating multiple sources of data together under one set of meta-data • Leveraging ETL and scheduling tools to automate the load and transformation
of data for BI • Self-service BI
• Dashboards • Scorecards • Reports
• Governance Framework (BICC) • Collaboration and workflow
• Report request and distribution process automation • Report collaboration
Solutions for Success
Governance Framework
Solutions for Success
Business Intelligence Competency
Centre (BICC)
Enterprise Reporting GOVERNANCE FRAMEWORK
Organizational Structures
(Resources)
Strategy & Leadership
Policy and Processes
BUSINESS INTELLIGENCE COMPETENCY CENTRE (BICC)
BI
DE
LIV
ER
Y
Solu
tio
n
De
plo
yme
nt
Solu
tio
n
De
velo
pm
ent
Pro
ject
M
ana
gem
en
t
DA
TA STEW
AR
DSH
IPRep
ort In
ven
tory
Meta
data
Stan
dard
s
CHANGE MANAGEMENT
STAKEHOLDER ENGAGEMENT
ENTERPRISE DATA WAREHOUSE
Architecture ETL Infrastructure
END USER SUPPORT
EducationIssue Mgmt. Access Mgmt.
REPORTING AND ANALYTICS
Advanced AnalyticsAnalytic Reports
Clinical Reports
BI Tools
Financial Reports Operational Reports
Dashboards
Dynamic dashboard dependent on logged in user’s role
Solutions for Success
Interactive Reports
Solutions for Success
Workforce Reports
Solutions for Success
Collaboration and workflow
• Review and discuss report results • Request report changes • Request new reports • Raise report issues • Provide feedback
Solutions for Success
What’s Next • SQL Server 2014
• Improved data exploration using Excel • Power View now supports multidimensional models (OLAP cubes) and can create a variety of data
visualizations including tables, matrices, bubble charts, and geographical maps • Big Data support including scaling up to 15k partitions in a data store and up to 640 logical cores on high-
end database servers • SQL Server Parallel Data Warehouse (PDW) which makes combining non-relational data and traditional
relation data fast and easy • Data Quality Services for end-to-end data management for building a knowledge base of data quality topics • Master Data Services add-in for Excel to map objects, reference data and control dimensions and hierarchies
of data • SharePoint 2016
• Sneak peak expected to be revealed in May 2015 at Ignite • Rumoured BI features
• Forecasting functions • Time Grouping for Model Based Pivot Tables • PowerView over an OLAP connection • Data model PivotTable automatic relationships detection • BI in Excel – BI features discoverability
Solutions for Success