Send us a text

This week we discuss Azure Synapse Analytics

This is, in essence, a cloud-based distributed database system.  It is aimed at larger scale analytics applications rather than transactional processing.

The approach taken by Synapse to processing queries is to break them down and process parts of a query across different computing nodes.  The result sets are returned to a control node where the final result is processed.  If, for example, you request an average of a field, the control node will request the various compute nodes to calculate the sums and record counts, that can be returned and recombined into the average originally requested.

It is important to note that the higher performance in processing analytical queries tends to come at the expense of concurrency - but in an analytical application, this tends to be less of an issue.

Finally, we should also note that given the price point of Synapse, any company embarking on a data analytics journey with any expectation that their data may get large, should seriously consider Synapse as part of the tool set they are considering.

More about Synapse can be found here.

If you already use Power BI, or are considering it, we strongly recommend you join your local Power BI user group here.

To find out more about our services and the help we can offer, contact us at one of the websites below:
UK and Europe: https://www.clearlycloudy.co.uk/
North America: https://www.clearlysolutions.net/