ASA – Azure Synapse Analytics Round 2!

We had so much fun our first time answering your questions about Microsoft Azure Synapse Analytics, and Power BI that we wanted to do it again! If you weren’t able to be there, watch our re-cap and join host Sami Anderson alongside panelists Sundar Sritharan, Natarajan Sivaramakrishnan and Corey Turner, as they answer questions surrounding the Azure Platform.

Questions Answered:

1. What will be more efficient, Connecting Power BI to Azure Synapse in Direct Query mode or developing a model on Azure Analysis services and using that tabular model to connect from Power BI also in Direct Query mode. (4:01)
2. In your opinion, why should anybody use Azure Synapse? (9:52)
3. How does Synapse compare with Redshift and Google Big Query (15:20)
4. Does Synapse have out-of-the-box ML capabilities? (18:52)
5. What languages does Synapse Support? (21:12)
6. How to manage workloads and resource utilization in Synapse (22:13)
7. How is running Spark and Synapse different than running it with data bricks? (24:02)
8. Is Synapse available in on-Prem mode? What’s the best strategy to run integrations into synapse? (30:59) (32:15)
9. Is CDS data, Power BI, and Synapse a good fit? (28:44) (30:05)
10. What are some best practices when it comes to data modeling? (25:58)
11. How efficient would it be running OLTP solutions on Synapse? (34:34)