Integrated%20Collections%20Portal

1
Integrated Collections Portal

• Chris Fussell, Microsoft
• MCS-NSP

2
Presentation Goals

• Demonstrate the value of BI
• Provide an overview of an existing BI solutions
  pilot project
• Drill down into the parts of the solution
• Answer questions on the development of a BI
  solution

3
Pilot Project Goals

• Prove that we could do it
• Provide a better picture of the companys
  collections status
• Ability to interactively look for trends and
  customers who fall through the cracks
• Solution which meets client needs by improving
  business processes
• Ultimately Improve rate and amount of
  collections recovery

4
Description

• All collections data and analysis is available in
  a single place
• Simple access to desired collections information
• Interactive, graphical analysis views of
  collections data

5
Reliable Telecom Portal demo

• ltdemogt

6
Technologies

• Data Analyzer 3.5
• SPS
• SQL Server 2000 Analysis Services
• Office XP OWC Excel client
• Future Mappoint 2002

7
Data Analyzer Highlights

• Quickly view data
• Improve data analysis productivity
• Easily share and publish information
• Fully integrated with SQL Server 2000
• Flexible deployment and extensibility

8
Quickly View Data
Quickly view multi-dimensional data
Choose from multiple view types
Immediately find data anomalies
New View Wizard
Color Scale
Data Analyzer Views
Pie, Bar, and Grid Views
9
Improve Data Analysis Productivity
Quick, easy data analysis
Guided analysis to common questions
Extend and customize views
Filter
Sorting
Filter by Criteria
BusinessCenter
Reverse Filter
Template Measure Editor
10
Easily Share and Publish Information
Easily publish results
Integration with Office applications
Publish to PowerPoint
Publish to Web
Publish to Excel
Send View as Email
11
Fully Integrated with Analysis Services
Leverage power of the server
Provides a flexible architecture
Actions
Disconnected Analysis
MDX Support
Flexible Dimension types
Drill through
HTTP Connectivity
12
Flexible Deployment Options and Extensibility

• Access OLAP cubes via network, Internet, or local
  cubes
• XML support, documented API

13
3rd Party BI Clients

• Cognos, Proclarity, etc.
• http//microsoft.com/business/bi/

14
SPS

• Mostly using Digital Dashboard webparts
• Possible issue of scalability for a full
  deployment in a large organization

15
SQL Server 2000 Analysis Services

• OLAP data source
• Direct OLEDB access to data or HTTP access
• Includes data-mining services

16
Traditional Client-Server
Architecture
Analysis Server
17
HTTP Connectivity
Architecture
msolap.asp
msmdpump.dll
18
Excel Pivottable Client

• Pivot table view of select OLAP cube
• Easy to perform aggregate functions on cube
  measures
• Intuitive for simple data sets

19
Things to think about

• Becoming familiar with the industry specific
  terms is a significant part of the process
• Beware the politics of data integration in a
  large client
• Most of the focus is on the OLAP client, most of
  the work is the ETLM
• Become familiar with Microsofts BI strategy

20
Things learned

• OLAP HTTP access does a good job of solving
  client data access issues
• DTS is super powerful, but need to be familiar
  with ALL of the objects before developing
• Separate the DTS loading step from the
  transforming/cleansing
• Data cleansing is EXTREMELY time consuming

21
External BI Resources

22
Questions