Search⌘ K
Home
Courses
Azure Data Studio Masterclass

SandDance

Explore how to use the SandDance visualizer in Azure Data Studio to create 3D data visualizations by adding additional data dimensions. Learn to enhance query outputs, set axes and sorting options, and gain insights from visualized data to deepen your analysis skills.

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 ...