Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Developing SSAS Data Mining Models

Chapter 9. Developing SSAS Data Mining Models

Reports created with SQL Server Reporting Services (SSRS) are probably the simplest business intelligence (BI) tools you can use. However, end users have very limited dynamic capabilities when they view a report. You can extend the capabilities of SSRS with the help of Report Models (which are covered in Chapter 11, “Formatting and Extending SSRS Reports”), but using Report Models to build reports is an advanced skill for end users, and the reports’ performance is limited. In addition, classic reports do not show analysis over time.

You can eliminate both the need for advanced skills and the problems with limited performance of SSRS reports by implementing data warehouses (DW) and Online Analytical Processing (OLAP) systems. End users get analysis that occurs at lightning speed, and they can change the view of information in real time, drilling down to see more details or up to see summary information. However, end users are still limited in a few ways with these systems. Typically, users do not have time to examine all possible graphs and pivot tables using all possible attributes and hierarchies. In addition, they are limited to searching only for patterns they anticipate, and OLAP analysis is typically limited to basic mathematical operations, such as comparing sums over different groups.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint