Microsoft Data Analyzer - Review

By Bill Graziano on 18 February 2002 | Tags: Tools


When I launched Data Analyzer for the first time I was presented with an introductory wizard that wanted to assist me in creating my first view. A view to Data Analyzer is an association of connections, dimensions and measures that are used to make up what data you will see and how you will analyze it. To the OLAP (Online Analytical Processing) uninitiated, a dimension is a data element such as Regions, Time, Customers and Products that will form groupings based on other data elements that can be measured such as Cost, Profit, Sales, Quantity, etc. I connected to an OLAP cube that I had recently built in SQL 2000 Analytical Services that contained healthcare data dimensions and measures. I chose to use the default display of a bar graph instead of grid.

Link: Microsoft Data Analyzer - Review


Related Articles

Debugging Stored Procedures in Visual Studio 2005 (25 June 2007)

Free online SQL Formatter (5 April 2006)

Free tools for SQL Server (2 March 2006)

Software Review: SQLCompare (27 April 2004)

Compare SQL Server databases (2 May 2003)

Foam - FOR XML EXPLICIT Tool (9 August 2002)

Getting the Most Out of SQL Server 2000's Query Analyzer, Part III (7 August 2002)

How to troubleshoot orphan users in SQL Server databases? (6 August 2002)

Other Recent Forum Posts

Troubleshooting Deadlocks in SQL Server (1d)

Last Login date and time (2d)

Negative effects of High VLF counts (2d)

Need to return a value that indicates that a record has been added, but not when a record is modified (3d)

Indexex on low cardinality fields (4d)

Error in stored procedure (4d)

Spam post flagging (4d)

Update Microsoft SQL Server (RTM) 12.0.2000.8 to latest v14 (12.0.6449.1) (4d)

- Advertisement -