|
CHASS QuickPlan Business Intelligence Service
This service provides a rigorous process to help ensure that the core design
decisions required are covered effectively. At the end of the QuickPlan, you
will understand project requirements, including risks associated with resources
and technology, and have a high level plan for moving forward.
This service covers the following main areas:
Requirements:
The first step is to review the business requirements, vision, and scope of the
project.
Assessment:
Review your existing reporting and analysis facilities. Understand the business
intelligence requirements and strategy.
Analysis Services:
Identify the analysis capabilities, business advantages, and key concepts of
Online Analytic Processing (OLAP) cubes.
Data Warehouse and Cube Design:
Review the design requirements of the data warehouse. Identify business areas
and how they map to star/ snowflake schemas, fact tables, and dimensions.
Loading the Warehouse — Data Transformation
Services:
Determine how DTS’ Extract, Translation, and Load (ETL) capabilities can be
used effectively to populate and update your data warehouse.
XML(Extensible Mark-up Language) for
Analysis:
Examine your requirements and opportunities for using this technology.
Data Mining:
Identify how Analysis Services’ data mining capabilities can help you identify
trends
and make better decisions and predictions.
BI Accelerator:
Examine how the Microsoft SQL Server Accelerator for Business Intelligence
(SSABI) can help develop custom analytical applications.
Microsoft Office Support/Client Tools:
Review how your requirements can be addressed by Analysis Services’ open
architecture —specially Microsoft Office and other tools.
Reporting:
Consider how SQL Server Reporting Services can meet your reporting
requirements.
WebDB Services Architecture — Data Center
Management:
Consider data sizing, performance, availability, and security design issues for
your business intelligence solution platform.
Deployment and Operations Planning:
Develop deployment and operation plans to help ensure a smooth introduction and
transition to the proposed solution.
Our Approach
Risk Assessment
Risk assessment is a central element of a WebDB BI QuickPlan and is
incorporated into all activities. The final report you receive highlights
issues that may be a risk to your environment. Early identification of these
risks is vital so that they can be addressed quickly, before they jeopardize
your ability
to complete your project on time and on budget.
Deliverable
Interactive design sessions, in which your team learns how to apply Microsoft
best practices to your environment, are a key benefit of a WebDB BI QuickPlan.
Understanding how the decisions were made is critical to your ability to
implement the recommendations. You will receive a detailed written report
including the information gathered, decisions made, and a summary of the next
steps needed to successfully deploy a business intelligence solution.
Topics Covered
Assessment/BI Solutions:
-
Current business reports
-
Line of business systems
-
Organization infrastructure
-
Business intelligence platform components, third party products
-
Architecture
-
Warehouse, data marts and cube design
-
XML for Analysis
-
SQL Server Accelerator for BI (SSABI)
-
Data Mining: Microsoft Analysis Services
-
Populating the data warehouse (Data Transformation Service)
-
Microsoft SQL Server Reporting Services
-
Client access and tools
Logical Design
-
Server hardware and configuration
-
Analysis Services
-
Data warehouse and cube design
-
Loading the warehouse —data transformation services
-
XML for Analysis
-
Data mining
-
BI Accelerator
-
Microsoft Office support/client tools
-
Reporting
-
Microsoft Services Architecture —data center/management
For General Sales Enquiries, please contact Sales@CHASSasia.com
Back to Business Intelligence
|