Business Intelligence

1
Business Intelligence
Microsoft
2
Improving organizations by providing business
insights to all employees leading to better,
faster, more relevant decisions

• Complete and integrated BI offering
• Widespread delivery of intelligence through
  Microsoft Office
• Enterprise grade and affordable

3
Pervasive BI
Operational
Strategic
Tactical
Execs
Strategic Value
Analysts/ Middle Mgrs
Ops
Number of decisions
4
(No Transcript)
5
Complete Offering
6
Microsoft Business IntelligenceAn end-to-end
integrated offering
Business Scorecarding (Business Scorecard Manager
2005)
Scorecards, Analytics, Planning (PerformancePoint
Server 2007)
AdvancedAnalytics (ProClarity 6.1)
Performance Management Applications
Collaboration and Content (Office SharePoint
Server 2007)
End-user Analysis (Excel 2007)
Integration Integration Services
Analysis Analysis Services
Reporting Reporting Services
BI Platform
SQL Server 2005 RDBMS
7
Business Intelligence Platform
8
Integration ServicesBreakthrough ETL Capabilities

• Enterprise ETL platform
• High performance
• High scale
• More trustworthy and reliable
• Best in class usability
• Rich development environment
• Source control
• Visual debugging of control flow and data
• Great range of transforms out-of-the-box
• Highly extensible
• Custom tasks
• Custom enumerations
• Custom transformations
• Custom data sources

9
SQL Server Integration ServicesNew Paradigm for
the ETL Platform

• Data Cleansing
• Provides data mining and AI expertise
• Domain-independent data cleansing
• Fuzzy lookup
• Lookup on approximate matches
• Do not reject if row could be correct!
• Tune for best match
• De-duplication
• Eliminate approximate duplicates
• Windows XP, WinXP, etc.
• Tune for confidence
• Managing Slowly Changing Dimensions
• E.g. Sales organization changes
• E.g. Customer movement
• E.g. Product category changes

10
Analysis ServicesEnhanced OLAP and Data Mining
Capabilities

• Unified Dimensional Model
• Pro-active caching
• Advanced Business Intelligence
• Key Performance Indicators
• Custom Aggregations and Semi-Additive Measures
• Web services
• Data Mining in the platform
• Integrated Developer Tools
• Failover Clustering

• plus
• Logistic Regression
• Linear Regression
• Text Mining

Decision Trees
Clustering
Time Series
Sequence Clustering
Association
Naïve Bayes
Neural Net
Introduced in SQL Server 2000
11
Enterprise Business Intelligence (BI) Today
Data Model
Tool
Data Source
MOLAP
Online Analytical Processing (OLAP) Browser (1)
MOLAP
OLAP Browser (2)
data warehouse (DW)
Reporting Tool (1)
12
Enterprise BI A Messy Reality
Data Model
Tool
Data Source
DW
Reporting Tool (1)
13
Relational Versus OLAP Reports
14
The Unified Dimensional ModelThe Best of
Relational and OLAP
The Unified Dimensional Model
15
Enterprise BI With A UDM
Data Model
Tool
Data Source
MOLAP
MOLAP
UDM
Reporting Tool (2)
Reporting Tool (1)
DW
BI Applications
16
Enterprise BI With A UDM
Data Model
Tool
Data Source
MOLAP
MOLAP
UDM
Reporting Tool (2)
Reporting Tool (1)
DW
BI Applications
A single dimensional model for all OLAP analysis
and Relational reporting needs
17
Analysis ServicesHigh-level Architecture
Analysis Services
Spreadsheets
SQL Server
Datamart
BI Front Ends
DW
Teradata
Ad Hoc Reports
Rich Reports
Oracle DB2
LOB
Cache
Dashboards
18
SQL Server Analysis ServicesNew Paradigm for the
Analytics Platform

• Business Intelligence Enhancements
• Add data-aware smarts
• Autogenerated
• KPIs, MDX scripts, translations, currency
• Data Mining
• 10 Mining Algorithms
• Smart applications
• XML standards for Data Access Web services
  integration
• saving for customers integrating our solution
  with other systems

• Unified Dimensional Model
• Powerful business information modeling
• Cross platform data integration
• Integrated Relational OLAP views
• KPIs Perspectives
• Proactive caching
• Real-time data in OLAP Cubes
• Very fast and flexible analytics

19
Business IntelligenceKey Performance Indicators

• Calculations that drive visual indicators
• Quick and easy way to manage by exception
• Set and Monitor Goals
• Monitor the trend, up or down

20
SQL Server 2005 Analysis Services Data Mining

• New Algorithms
• Two enhanced
• Eight new algorithms
• New Visualizations
• Enhanced tools
• custom visualizations
• Deep Integration
• OLAP, DTS, and Reporting Integration
• .NET programming model
• Completely extensible framework

21
SQL Server 2005 Analysis Services Data Mining

• Banking
• Anti-Money Laundering
• Credit Risk Management
• Credit Scoring
• Customer Retention
• Fraud Detection
• Marketing Automation
• Operational Risk Management
• Performance Management
• Risk Management
• Web Analytics Service

22
Value of Data Mining
SQL Server 2005

• 8 new algorithms, 10 in total
• Graphical tools/wizards
• 12 embeddable viewers

• SQL Server 2005 makes it easier
• Tightly integrated with AS, DTS, Reporting
• Integration with Web/Office apps

23
Complete Set of Algorithms

• plus
• Logistic Regression
• Linear Regression
• Text Mining

Decision Trees
Clustering
Time Series
Sequence Clustering
Association
Naïve Bayes
Neural Net
Introduced in SQL Server 2000
24
SQL Server 2005 Analysis Services Data Mining

• Decision Trees - Predict the odds that a future
  behavior will occur
• Association Rules - Provides insight into
  relationships of certain actions
• Sequence Clustering - Used to group or cluster
  data based on a sequence of previous events
• Neural Nets - Training a neural network on
  historical data, neural network analysis can
  identify the most relevant characteristics and
  use those to classify applicants
• Text Mining - Analyze the free text
• Naïve Bayes Show linkage between
  characteristics and metrics
• Logistic Regression A specialized variation of
  Decision Trees
• Linear Regression A specialized variation of
  Neural Nets
• Time Series Predict metrics (i.e., sales) based
  on patterns