Search⌘ K
Home
Courses
Azure Data Studio Masterclass

SandDance

Let's try to visualize our dataset with the SandDance visualizer.

We'll cover the following...

Getting pixel perfect

For more control of your visual creation, you can try using the SandDance visualizer. Since we will gain an additional axis using SandDance, we will add the MONTH_NAME to our query by joining to the DATE dimension. Here’s the updated query:

MySQL
SELECT l.borough,
			 d.month_name,
			 Count(*) AS ACCIDENTS
FROM   edw.d_location l
			 JOIN edw.f_collisions c
				 ON c.location_id = l.location_id
			 JOIN edw.d_date d
				 ON d.date_key = c.date_key
WHERE  l.borough IS NOT NULL
GROUP  BY l.borough,
					d.month_name

Update your query in ADS using the above SQL script, and then click Run. Your results pane will now have an additional column, as shown below. Notice the ...