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

Why am I receiving an error about a column in the select list not being in an aggregate function or in the GROUP BY? (6h)

How to I insert records based on one to many relationship? (1d)

Transfer to new windows 11 computer (9d)

Pivot data but keep equal number per metric (12d)

Change Font Size In T-SQL Message Window? (13d)

Who has joined and who has left (15d)

Linked Server Selection Query Fails with "MS DTC has stopped this transaction" (19d)

Query almost perfect but brings wrong record (20d)

- Advertisement -