Business Intelligence with Microsoft SQL Server 2005

1
Business Intelligence withMicrosoft SQL Server
2005

• Opportunities, Tools and Resources for Microsoft
  Partners

2
Topics

• Business Intelligence Market Opportunity
• Microsoft Vision Stack
• Microsoft BI in the Real World
• Conclusions

3
Why Business Intelligence?
Poor Visibility and Reaction to Market Events
Inefficient Supply Chains and Demand Chains
High Business and IT Operation Costs
80 of IS Budget to business as usual
Poor Understanding of Customer Needs
Poor Business Performance
Todays information TECHNOLOGY
Management by Spreadsheets
Data Privacy Concerns and Information Overload
Compliance (BASEL, Sarbanes Oxley)
4
The UK BI Market

• What IT blues?
• Relatively untapped
• More complex
• More accessible to non-specialists
• Beyond the Finance team
• Focus on Portals
• Top information sources
• References from colleagues/peers
• Downloads of demonstration software
• Customer reference sites

Sources Conspectus, PMP Research
5
Our Perspective on the BI Market

• BI is not as pervasive in organisations as it
  should be
• Major customer trend towards BI rationalisation
• Customers want to deploy and use BI differently

6
Microsoft and the UK DB/BI Market

• SQL Server leads in Penetration and Share
• Most common SQL Server workloads BI
• SQL Server leads future deployment plans
• Ca. 1/3 respondents plan to upgrade to SQL 2005
• Ca. 1/2 Oracle and DB2 users have SQL 2005 plans
• SQL Server as favorite standard platform

Source MS Internal Research
7
OLAP Leadership

• http//www.olapreport.com

8
Whats in it for Partners?
Opportunities
Challenges
Leverage current strong interest in Reporting
Services Capitalise on end user requirements to
visualise BI data in Excel Build business
analytics apps in VS/.Net Integrated business
apps Dynamics and SQL BI Bring BI to the Masses
Always demonstrate the ROI on BI
tools Consistently raise the awareness of
Microsoft BI/DW solutions Tie SQL Server 2005 and
Office 12
9
BI Platform Selection Requirements

• Focus on operational BI
• Extending the reach of BI
• Scope of functionality
• Scalability
• Availability
• Simplicity

10
Microsoft BI Vision

• Reach every employee
• Add value to every decision
• Bring BI into collaboration and business
  processes
• Increase the impact of information workers
• Increase the business performance of organisations

11
Analysis Services
5-10 of users
Analysts
Information Explorers
15-25 of users
65-80 of users
Information Consumers
12
(No Transcript)
13
Microsoft BI Components
14
Whats New in SQL 2005 for BI?

• Integrated platform.
• End-to-end business intelligence platform
• Integrated approach enables organisations to
  build and deploy robust BI applications while
  controlling costs
• Improved decision making.
• OLAP and data mining advancements
• New reporting server
• Security and availability.
• Scalability, availability, and security
  enhancements
• Uninterrupted access to business intelligence
  applications and reports.
• Enterprise-wide analytical capabilities.
• Improved ETL tool
• Competitive edge through a holistic understanding
  of their business.

15
Business Intelligence Opportunity
Integrate
Analyse
Report

• Data acquisition from source systems and
  integration
• Data transformation and synthesis

• Data enrichment, with business logic,
  hierarchical views
• Data discovery via data mining

• Data presentation and distribution
• Data access for the masses

16
Microsoft Offers An Unparalleled Degree Of
Simplicity And Time-To-Value
Tightly integrated all-in-one technology
solution increased manageability and the best
economics
Highly intuitive, visual toolsgreater
productivity from developers to users
Comprehensive ability to integrate any data
improved data completeness
Information Delivery
Client
Portal
EnterpriseReporting
Data Marts
SourceSystems
Business Insights
ERP
Familiar,PowerfulBI Tools
CRM
Third Party Applications
Interactive Reports
LOB
EnterpriseETL
Devices
DataWarehouse
Data Analysis(OLAP, DataMining)
Performance Scorecard
Familiar tools, look and feelmore productive
users
User empowerment to create own analyses and
reportstime to value
Automated data integration and manipulation..
enhanced data integrity and reliability
17
Business Value of SQL Server 2005 Business
Intelligence for SQL Server 2000 Users

• Building on the foundation of SQL 2000
• Extensibility
• Rapid upgrade, immediate ROI
• Faster, better business results
• Advanced analytics
• Controlling the costs of BI

18
Comprehensive Scorecarding for All

• Deep contextual insight
• Collaborative group analysis and action
• End user empowerment
• Extensibility

Evaluate Business Scorecard Manager 2005!
http//office.microsoft.com
19
Microsoft BI and Microsoft Dynamics

• Delivering integrated business solutions SQL
  Server 2005 and Dynamics
• Seamless access to business data
• Simplify installation and management
• Enhanced performance and availability
• Leading TCO

Users can seamlessly report on external and CRM
data and can use any report types inside the CRM
application, including Excel, SharePoint,
Access, Business Objects and more.
20
BI/DataWarehouse Customers
2.5 TB retail BI/DW, end-to-end BI OLAP, RS, IS
running on SQL Server 2005
World-wide manufacturing reporting solution on
MSFT BI platform AS, RS and DTS on SQL Server
2005
SQL Server 2005 BI platform for financial AS,
UDM, RS, IS and DM in ETL. SharePoint Portal
Server to host
5 TB retail DW, 2 TB Marts, 800 retail stores
60 efficiency gains for developers
6 TB of Basel 2 Compliance data, 23 dimensions,
up to 18M rows
21
Analysts and Press
Microsoft has now clearly overtaken Hyperion to
become the largest OLAP vendor
Nigel Pendse, The OLAP Report
Butler Group expects SQL Server 2005 to increase
Microsofts BI market penetration. In particular
we predict that the enhanced Reporting Services
will cause further shakeout in the reporting end
of the BI market.
Michael Azoff, Butler Group
We expect SQL Server to continue its relentless
march up the performance and scalability
hierarchies
Philip Howard, Bloor Research
22
SQL Server 2005 BI Resources

• SQL Server 2005 Evaluation http//www.microsof
  t.com/uk/technet/evaluation.mspx
• Business Scorecard Manager 2005
  http//office.microsoft.com
• IT Pro Knowledge Base TechNet
  http//www.microsoft.com/technet/prodtechnol/sql/d
  efault.mspx
• Developer Knowledge Base MSDN
  http//msdn.microsoft.com/sql/
• Partner Homepage for SQL Server 2005
  http//www.microsoft.com/uk/partner/sol_and_produc
  ts/servers/sql/default.aspx

23

• Get the facts about migrating to Microsoft SQL
  Server 2005.  
• Experts from Scalability, DevelopMentor, and
  Solid Quality Learning will present practical,
  real-world information in three tracks -
  administration, development and business
  intelligence.

TM
6th February 2006 London Hilton Metropole
REGISTER NOW! http//www.sqlmag.com