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

AlwaysOn AG + Replication maintenance - two scenarios to get the job done (2h)

What happens in a dual LEFT OUTER join when the second join is NULL in both tables? (3h)

How to set a variable from a table with comma? (1d)

SSRS Expression IIF Zero then ... Got #Error (2d)

Understanding 2 Left Joins in same query (2d)

Use a C# SQLReader to input an SQL hierarchyid (3d)

Translate into easier query/more understandable (3d)

Aggregation view with Min and Max (3d)

- Advertisement -