| Author: Nigel Pendse
Released: 2007
Pages: 235
Single User Price: $1495 USD
Multi-user license pricing on application
Now available at a special price, a collection of in-depth product reviews of the Microsoft BI/PM stack including 3rd party developed front-ends, a vendor lowdown and a tool selection case study
TABLE OF CONTENTS
Market Analysis: The Microsoft Effect
1. Why did Microsoft enter the OLAP market?
2. Options
3. Entry point
4. The other OLAP server vendors’ self-inflicted wounds
5. PerformancePoint
6. Early Service Pack insight
7. Packaging
8. Microsoft coverage in The OLAP Report
SQL Server Analysis Services 2005 Review
1. Vendor overview
2. Microsoft, ProClarity & PerformancePoint
3. Microsoft's OLAP origins
4. Product commercial issues
5. Pricing
6. Market share
7. Katmai (SQL Server 2008) preview
8. Database structure and capacity
9. Data write-back
10. Architecture and platforms
11. Data access functionality
12. Calculation functionality
13. Aggregations
14. KPIs
15. Reporting flexibility
16. Cube Analysis Excel add-in
17. Automatic detection of exceptions and data mining
18. Time series intelligence
19. Currency support
20. Security and DBMS issues
21. End-user human factors
22. Application building features
23. Performance
24. Conclusions and scores
ProClarity 6.1 Review
1. Vendor overview
2. Product commercial issues
3. Pricing
4. Architecture and platforms
5. Calculation functionality
6. ProClarity Selector
7. Reporting flexibility
8. ProClarity Desktop Professional
9. ProClarity Web Professional
10. ProClarity Web Standard
11. ProClarity Business Reporter for Excel
12. Automatic detection of exceptions
13. End-user human factors
14. Application building features
15. Conclusion and scores
Panorama Novaview 4.0 Review
1. Vendor overview
2. Panorama’s history
3. Panorama today
4. Product commercial issues
5. Pricing
6. Integration with Microsoft Analysis Services
7. Write back and ‘What if?’
8. Drill-through
9. Large dimensions
10. Other features
11. Architecture and platforms
12. Calculation functionality
13. Reporting flexibility
14. Interactive analysis
15. KPIs
16. Dashboard
17. Exploitation of Reporting Services
18. Automatic detection of exceptions
19. Security and DBMS issues
20. End-user human factors
21. Application building features
22. Administrator
23. Scalability and fault tolerance
24. Performance
25. Conclusions and scores
PerformancePoint Preview
1. Introduction
2. Product commercial issues
3. Pricing
4. Architecture
5. Data access functionality
6. Calculation functionality
7. Reporting flexibility
8. PerformancePoint Excel add-in
9. Time series intelligence
10. Currency support
11. Security and DBMS issues
12. Human factors
13. Application building features
14. Performance
15. Conclusions
OLAP & Spreadsheets
1. Introduction
2. Background
3. Problems with spreadsheets
4. Multidimensional formulas
5. Problems with OLAP servers
6. The best of both worlds?
7. Convergence
8. How widely used are spreadsheets as OLAP front-ends?
9. The perfect add-in
10. Not as easy as it seems
11. Costs
12. When to use (or not to use) an Excel add-in
13. What to look for in Excel add-ins
14. Getting OLAP data into Excel
15. Dealing with dynamic grid sizes
16. Complex report formats
17. Hybrid OLAP and relational reports
18. Advanced queries
19. Visualization
20. Drilldown
21. Drill-through
22. Automated report distribution
23. Compatible Web and Excel reports
24. Languages
25. Data entry
26. Model building
27. Automation, application control and workflow
28. Excel add-ins for Analysis Services
29. Success rate with different types of client tools
30. IntelligentApps
31. MIS Plain
32. Visual OLAP
33. XLCubed
BP Case Study
1. Background
2. The problem
3. The solution
4. Proof of concept
5. The roll-out
6. In use
7. Benefits
8. An analyst’s perspective of XLCubed
9. Low cost implementations
10. The Future
11. Conclusion
12. Lessons
For a product overview, click here
A sample of the numerous specially generated screenshots from this review. Click to enlarge.
  
|
