I've posted about Azure Data Studio before (then called SQL Ops Studio) but wanted to just bring it up again, specifically where it's helped me in a specific use case.
We have a scenario where a model created by one of our Data Scientists is predicting values for the next few days, what I wanted to quickly do is to take the current days next day forecast and compare it with the 2 day ahead forecast made the previous day to see how much it varied. In this case the values changing is expected behavior as more up-to-date information becomes available, but I wanted to see what kind of a difference it could make.
The system in question persists the results of the model to an Azure SQL database, from here I could have copied the data into Excel, but if you've read any of my previous posts you'll probably guess that I didn't go that way. I could have opened the data in Power BI, but that seemed like a little too much effort for this task. So instead I used the charting capabilities of Azure Data Studio.
A simple query gave me the results I needed in a format that looked as follows (values have been changed to protect the innocent).
From here I selected the chart option at the side of the results.
Currently there is a bug whereby if you want to see a line chart of the two series then you first need to go into the bar chart option and change the data direction to vertical. I did this as I really wanted a line chart.
This gave the following kind of a view of the data which showed that the overall trend was similar even if the values did vary because of up-to-date data.
Azure Data Studio is a great tool which is becoming more and more useful each release. If you've not looked at it yet I suggest you go and give it a go.
