Transcript Improving Insight and Decision Making Using Microsoft
1
The Big Picture of Business Intelligence: Goals, Concepts, and the Platform Rafal Lukawiecki Strategic Consultant, Project Botticelli Ltd [email protected]
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.
2 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
3
Overview of BI and PM
4
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
5 1.
2.
BI and Power of Visualisation Balanced Scorecards
6
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
7
From Organizational BI to Personal BI
Enabling managed self-service BI Corporate BI Data Sources Data Marts BI and LOB Apps Portals and Dashboards
Empowered, Managed, Accurate
Accurate Secure Scalable Up to date Self Service Easy to use On and Offline Collaborative Reliant on IT Rogue “Spreadmarts” User Context Empowered 7
8
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
9 FY1 FY2 FY3 FY4 FY5 9
10 FY1 FY2 FY3 FY4 FY5 10
Classic Business Intelligence 11 FY1 FY2 FY3 FY4 FY5 11
Classic Business Intelligence 12 FY1 Self-Service Business Intelligence FY2 FY3 FY4 FY5 12
14
Three Contexts of BI Use
1
Personal BI
Built by me, for me, used only by me 2 3
Team BI
Built by someone on the team, shared inside a team
Organizational BI
Built and maintained by IT, for use across company 14
15
Technology Platform
16
Microsoft Business Intelligence
You may already have these products Business User Experience Business Collaboration Platform Data Infrastructure & BI Platform
Familiar User Experience
Self-Service access & insight Data exploration & analysis
Integrated Content and Collaboration
Data visualization Thin client experience Contextual visualization Dashboards & Scorecards Search
Data Infrastructure and BI Platform
Analysis Services Reporting Services Integration Services Master Data Services Data Mining Data Warehousing 16
17
Big Picture: Managing Information
Master Data Services
ERP CRM HRMS
Integration Services
Data Warehouse
Analysis Services
BI Developer or Analyst
17
18
Big Picture: Dashboards, Scorecards
Analysis Services
Cubes, Warehouse Knowledge Worker
18
19
Big Picture: Reporting
Analysis Services Reporting Services
Cubes, Warehouse End User
19
20
Big Picture: BI Analyst, Power User
Analysis Services PowerPivot for Excel PowerPivot for SharePoint 20
39
Conclusions
40
“
Implementing BI project in our bank finally helped us to see our data consolidated and give them additional meaning and value. Now we save weeks per year making our reports trough BI and most boring and slow service become fun and creative. That brought new vision of usability of data in our bank that has more than 16 systems now days
”
Dusko Markovic, IT Director, Findomestic bank., Belgrade Microsoft Office SharePoint Server 2010 CR Microsoft SQL Server 2008R2 Data consolidation and visualisation 40
Microsoft BI and PM Solutions At:
www.microsoft.com/casestudies 41
42
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 42
43 © 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.
43