Transcript Improving Insight and Decision Making Using Microsoft

The Big Picture of Business
Intelligence: Goals, Concepts,
and the Platform
Rafal Lukawiecki
Strategic Consultant, Project Botticelli Ltd
[email protected]
1
1
Objectives
Overview state of Business Intelligence in 2010
Discuss the technology platform
Optionally, introduce BI concepts
This seminar is based on a number of sources including a few dozen of
Microsoft-owned presentations, used with permission. Thank you to
Chris Dial, Tara Seppa, Aydin Gencler, Ivan Kosyakov, Bryan Bredehoeft,
Marin Bezic, and Donald Farmer with his entire team for all the support.
The information herein is for informational purposes only and represents the opinions and views of Project Botticelli and/or Rafal Lukawiecki. The
material presented is not certain and may vary based on several factors. Microsoft makes no warranties, express, implied or statutory, as to the
information in this presentation.
Portions © 2010 Project Botticelli Ltd & entire material © 2010 Microsoft Corp. Some slides contain quotations from copyrighted materials by
other authors, as individually attributed or as already covered by Microsoft Copyright ownerships. All rights reserved. Microsoft, Windows,
Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The
information herein is for informational purposes only and represents the current view of Project Botticelli Ltd as of the date of this
presentation. Because Project Botticelli & Microsoft must respond to changing market conditions, it should not be interpreted to be a
commitment on the part of Microsoft, and Microsoft and Project Botticelli cannot guarantee the accuracy of any information provided after the
date of this presentation. Project Botticelli makes no warranties, express, implied or statutory, as to the information in this presentation. E&OE.
2
2
Overview of BI and PM
3
Business Intelligence
BI - Improving Business Insight
“A broad category of applications
and technologies for gathering,
storing, analyzing, sharing and
providing access to data to help
enterprise users make better
business decisions.”
– Gartner
4
4
1. BI and Power of Visualisation
2. Balanced Scorecards
5
Business Intelligence Today
Low end-user adoption rates and high reliance on IT
Analyst Issues:
Hard to access organizational data
Reliant on IT for reporting
Difficult to share insight
IT Pro Issues:
No time for ad-hoc BI requests
Lack of control
Organizational BI often expensive
6
6
From Organizational BI to Personal BI
Enabling managed self-service BI
Empowered,
Managed, Accurate
IT Involvement
IT
Unmanaged
IT
Managed
Corporate BI
Data
Data
BI and
Portals and
Sources Marts LOB Apps Dashboards
Self Service
Easy to use
On and Offline
Collaborative
Rogue
“Spreadmarts”
User Context
Reliant on IT
7
Accurate
Secure
Scalable
Up to date
Empowered
7
Microsoft BI Strategy
Democratizing Business Intelligence
Improving organizations by
providing business insights to all
employees leading to better,
faster, more relevant decisions
Familiar environment
Integrated into Microsoft Office
Built on SQL Server
8
8
FY1
9
FY2
FY3
FY4
FY5
9
FY1
10
FY2
FY3
FY4
FY5
10
Classic Business Intelligence
FY1
11
FY2
FY3
FY4
FY5
11
Classic Business Intelligence
Self-Service Business Intelligence
FY1
12
FY2
FY3
FY4
FY5
12
Three Contexts of BI Use
Personal BI
1
Built by me, for me, used only by me
Team BI
2
Built by someone on the team, shared inside a team
3
Organizational BI
Built and maintained by IT, for use across company
14
14
Technology Platform
15
Microsoft Business Intelligence
You may already have these products
Business User Experience
Business Collaboration Platform
Data Infrastructure & BI Platform
16
Familiar User Experience
Self-Service access & insight
Data exploration & analysis
Integrated Content and
Predictive analysis
Collaboration
Data visualization
Thin client experience
Contextual visualization
Dashboards & Scorecards
Search
Data
Infrastructure
Content
Management
and
BI Platform
Compositions
Analysis Services
Reporting Services
Integration Services
Master Data Services
Data Mining
Data Warehousing
16
Big Picture: Managing Information
Integration Services
Master Data Services
ERP
Data
Warehouse
CRM
HRMS
17
BI Developer or Analyst
Analysis Services
17
Big Picture: Dashboards, Scorecards
Analysis Services
Cubes, Warehouse
18
Knowledge Worker
18
Big Picture: Reporting
Analysis Services
Cubes, Warehouse
19
Reporting Services
End User
19
Big Picture: BI Analyst, Power User
Analysis Services
PowerPivot for Excel
PowerPivot for SharePoint
20
20
Conclusions
39
Microsoft BI and PM Solutions At:
www.microsoft.com/casestudies
40
Summary
Business Intelligence is a top IT priority for
businesses
Self-service analytics are quickly becoming
crucial tools enhancing employees’
performance
Good data warehouse design, master data
management, data integration, and
multidimensional design enable rich BI
41
41
© 2010 Microsoft Corporation & Project Botticelli Ltd. All rights reserved.
The information herein is for informational purposes only and represents the opinions and views of Project Botticelli and/or Rafal Lukawiecki. The material presented is
not certain and may vary based on several factors. Microsoft makes no warranties, express, implied or statutory, as to the information in this presentation.
Portions © 2010 Project Botticelli Ltd & entire material © 2010 Microsoft Corp. Some slides contain quotations from copyrighted materials by other authors, as
individually attributed or as already covered by Microsoft Copyright ownerships. All rights reserved. Microsoft, Windows, Windows Vista and other product names are
or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the
current view of Project Botticelli Ltd as of the date of this presentation. Because Project Botticelli & Microsoft must respond to changing market conditions, it should
not be interpreted to be a commitment on the part of Microsoft, and Microsoft and Project Botticelli cannot guarantee the accuracy of any information provided after
the date of this presentation. Project Botticelli makes no warranties, express, implied or statutory, as to the information in this presentation. E&OE.
42
42