Why you should look at Azure Synapse Analytics!

Have you heard about Azure Synapse Analytics! Is your data in Synapse? It's so much more than SQL Server! Adam and Patrick look at why you should care about it!

What is Azure Synapse Analytics?


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#AzureSynapse #Intro #GuyInACube

[Jonesc]

I’d like to see a “data solution in 10 minutes” built in Synapse. Would be really powerful if that included SQL and Python to demonstrate the flexibility.

[Real]

I JUST got access to our Azure instance Friday and was starting to look for resources to watch. Then this video comes up.

You guys are the best and your timing is _impeccable_ .

[SamuelMohammedOmer]

We are moving to ASA recently and couldn't be happier. I hope you guys will have more vids on it in the future.

[pawelpotasinski]

Love it! Really happy to see you guys recording this series. Looks like it's going to be one of these "must see on Azure Synapse" materials we will share with the community!

[antoniocolombo]

In brief, as per my understanding:
- Power BI provides strong ETL with Power Query and even data modeling. Moreover Power BI golden rule is to use a star schema.
- ASA for sure provides the all the tools for datawarehose while lacks visulization features as far as I know. For DW, PBI star schema (e.g. 1:n dim to fact relashionship) is not striclty a must

Moreover, because of the tons connector and modeling capabilities available in PBI, it can be used to pull and shape data from existing data marts and provide "enterprise" solutions just within PBI

So what is/are the trigger(s) point(s) that suggest to move from pure PBI solution to ASA+PBI?
I know, depends...

[alfredsfutterkiste]

So happy you guys are branching out to Synapse! Very much looking forward to more videos with the GiaC production quality on this topic!

[ahmadsawal]

Yes Please, we need detailed videos about Synapse with databriks, power bi etc. all the Azure data services please

[prawnyowl]

Is there a good YT channel for learning Synapse, like Guy in a Cube? Where do I start?

[sbksai]

1) Major drawbacks of Spark Pool in Synapse vs Data Bricks and vice versa? Which is better? When we are doing POC initially to evaluate Spark pool in Synapse, we have observed lot of drawbacks when compared to Data bricks. I would love hear from you with all the recent updates, can Spark pool perform much beyond than Data bricks? If yes on what basis?
2) Why not Azure Purview in Synpase? We can do governance directly there itself instead of a separate service? Any reason for making it separate?
3) One major drawback I observed is, sql pool can't support three part naming and we need to create separate schemas in the same sql pool to differentiate instead of creating different sql pool which is a costly operation. But it all together doesn't correlate with the traditional EDW modeling we do like we keep separate staging, logging, edw databases etc.
4) Why can't we delete duplicates direcly querying CTE pointing to Original table if the sharding pattern is other than Hash? We have alternatives to perform this task. But want to know the reason for why can't we directly delete using CTE?
5) Any concept of queue while submitting Spark jobs in Spark Pool? How much time will it take to spin up the cluster and run the jobs that are in queue? Comparison with data bricks make us learn better.

Please help us in letting know the above queries. Will post further questions once they arise.

[karthi-hy]

Glad that you are going to do a detailed series on Azure Synapse. I just joined Microsoft and i have a opportunity to work on Azure Synapse and your detailed explanation will surely help me

[samanthapikus]

Love your videos... Always so filled with the right kind of Energy. You mentioned data orchestration and learning the clicks... What does that mean?...How do I start going from Power BI analyst to using Synapse and become more of a data engineer?

[KahanDataSolutions]

Really helpful overview. For some reason I always assumed Synapse was just Azure's cloud database offering - didn't realize it was all of these other concepts too. Thank you!

[marlucaplus]

Amazing video guys!
It would be nice to know the difference between the power bi in synapse and the regular one. what can I do in synapse and what I can't. and of course why would I use the one in synapse...

[Shadeth]

Subbed in the hopes of synapse analytics content! Keen to see it in action, the whole process from ingestion to transformation to power bi. Would love some demos, touching on the main functionalities.

[chrisretsin]

Great videos, as always. I have a couple of question regarding lake house. 1/ Our IT department is moving the analytical data to the Azure cloud. Upon this move they want to add a non-azure product for data virtualization. Does this make sense? What are the azure possibilities here? 2/ what about erroneous data in the data lake, how the identify the erroneous data, correct it and restart the process without the erroneous data 3/ what about showing data in reports containing enough data in order to avoid possibility to identify the source

[jitendrabisht]

I was waiting for this video.👍 Great work

[jayopachecoea]

Ayer vi un vídeo de ustedes, y hoy los busqué para que me expliquen Azure Synapse Analytics, y seguiré así porque explican bien. ¡Suscrito!

[nclsduran]

I would LOVE you explain spark! The way you explain the topics are great!!

[joeseroski]

Love this. This is the content I'm looking for as I take the next step in my Power BI learning and my data journey.

[cooky]

I'd like to know more about when to use Synapse Analytics vs DataBricks