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

Select a single row based on conditions in multiple rows (2h)

I want Help Managing Big Data Sets in T SQL Efficiently (14h)

SQL stored procedure to load the error and correct record based on some business rules (23h)

Query is running too long (1d)

Sql Query to check status change of an item (1d)

Can I create differential backups tied to a specifc Full backup instead of the most recent? (7d)

My informix Sql query retruns Null always (8d)

Vehicle availability query (9d)

- Advertisement -