Wednesday, January 23, 2008

“Other” member in Data Visualization

One important and fabulous thing that I learned from "Data Analysis Using SQL and Excel" book is how I can represent correct data using correct SQL query.
Imagine that we have an orders table in which we have customer’s orders. Now we need to present the following query:
What is the distribution of the number of orders in the 5 states that have the largest number of orders? (By representing the Other‘s as a other category)

SQL:




Chart:


3 comments:

Pedro said...

Hi Amin!!
Thanks to write about the book!
A question.... do you link your chart directly to SQL Query?
Cheers!!
Pedro

Pedro said...

WE WANT MORE COMMENTS FROM YOU!!! :-)
Regards!! :-)

Amin said...

Hi Pedro
I drew the chart with excel and not with SQL Server, of-course you can link the excel charts with SQL directly, and it is easy.

Regards,
Amin

January 25, 2008 8:40 PM