Ask Softcrylic Anything – Azure Synapse Analytics Re-cap!

| Last Updated June 28, 2023 - by sundars under data visualization

In the second edition of our “Ask Softcrylic Anything” series, our Azure and Power Platform experts answer a variety of questions surrounding Azure Synapse Analytics and how it can be related to Power BI as well! You may find the list of questions addressed in this video below. If you have further questions about our Azure Services, reach out to Info@softcrylc.com or attend our upcoming ASA -Azure on January 19^th.

Here are the highlights from our discussion:

What is an overview of Synapse and the capabilities it possesses? (2:57)
If I’ve already made an investment with data factory and/or data bricks, should I migrate to Azure Synapse? (7:17)
Are there any main glaring differences between Synapse and Data Bricks? (10:47)
Can a Power BI Source File-based data directly from azure data lake? (12:40)
Does Synapse SQL on Demand support the TSQL objects like stored processes et. C or is that a provision SQL only? (14:57)
Is there any advantage for this model over a separate Power BI service and getting data from the data lake? (16:50)
What are the various sources from which Synapse can ingest data from? (19:26)
The data model for Power BI can be created in data flow so the data transformation can be handled in data flow instead of ADF, is there any disadvantage for using Power BI with Synapse? (21:47)
The semantic layer is built on Synapse, can citizen data integrators use flow to use that semantic layer as a source to create tailored integrations? (24:12)
Can Azure Synapse help streaming data analysis? (26:33)
If someone was trying to adopt Synapse, how would you go about estimating the cost for Azure Synapse? (28:15)
Is there any idea how much percentage of cost savings people could assume if they were using Azure Synapse with other vendors? (34:08)
Is there a lower limit where projects can be too small to be effectively used in this platform? (38:18)
What is the idea that you spin up a cluster to carry out the compute, load the data into it, carry out the compute and spin it down leaving provision compute up and running would assumably be cost-prohibitive? (40:01)
What kind of monitoring and security capabilities does Synapse have? (40:49)
Is it true that there are a lot of performance issues while loading huge amounts of data into Azure Synapse? (45:51)
How is it possible to implement data governance and GDPR policy for Synapse? (48:51)
Bigquery allows logging of all adhoc queries and provides detailed metrics on them in terms of cost resources used, data scanned etc. Does Synapse offer this capability as well? (50:18)