• Channels

  • Contact

  • Main Site

  • More

    To see this working, head to your live site.
    1. Elastacloud Channels
    2. Software Engineering
    3. Comparing results in Azure Data Studio
    Search
    Darren Fuller
    Oct 26, 2018

    Comparing results in Azure Data Studio

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


    Results from SQL query
    Results from SQL query

    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.


    Chart showing trends in the data
    Resulting chart

    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.

    0 comments
    0
    • Twitter Social Icon
    • LinkedIn Social Icon
    • Facebook Social Icon

    Visit the Elastacloud website