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

Chapter 9. Analyzing OLAP Data with Micr... > Introducing Microsoft Data Analyzer

Introducing Microsoft Data Analyzer

Organizations that record and store data over long periods of time, or organizations that record and store hundreds of megabytes, gigabytes, or even terabytes of data face the daunting task of trying to make sense of the data so that they can inform and improve their business decisions. For instance, sales teams might have data gathered over several years that is dispersed throughout their corporate offices as well as in sales offices throughout several regions. A retail organization might need to figure out which products have sold the best during a peak shopping season and which poorly selling products should be discounted or discontinued in the future. Manufacturing organizations might need to analyze historical defect counts and other factors that could require the business to retrain workers or retool machinery. Insurance organizations might want to add new lines of coverage or face the reality of raising policy premiums because of the quantity and severity of past claims.

PivotTable reports and PivotChart reports can be great data analysis tools for these types of data analysis scenarios. However, when working with large data sources, data sources distributed geographically, or data collected over long periods of time, creating several reports, linking them together, and synchronizing their data can be time-consuming. And viewing such reports on line can be difficult because of a limited screen area in which to show these reports and perspectives on the data all at once. Displaying multiple business dimensions or measures on a PivotTable report or PivotChart report can result in visual clutter or even be confusing. Microsoft Data Analyzer addresses these issues and provides tools to show trends over time and locate similar members in a dimension for business data comparisons.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint