~/talk

Power BI + Azure Synapse Analytics. All you need to start creating a unified analytics solution

on YouTube 52m
Talkat SQLBits 2023 · 2023-03-14..03-18· [databases]

speaker

name:Pawel Potasinski
website:https://infinite-services.com

resources

video:https://youtu.be/Wpi3qJg7TTU
slides:none on file

summary

Demo builds a lakehouse on Azure Synapse: ingesting NYC Yellow Taxi files into a bronze folder, running a parameterized pipeline that copies ~11 tables, transforming with Spark into curated Delta Lake files and writing gold tables, then serving BI via serverless SQL and Power BI with an aggregation table to avoid scanning 1.5 billion rows. Uses Synapse Studio, Azure Synapse Link for Dataverse and serverless SQL; the pipeline runs and reports success, reports render from the aggregated cache.

AI-written summary · about

chapters (15)

  1. 0:00Power BI + Synapse intro
  2. 1:03Analytics data challenges
  3. 5:25Introduction
  4. 6:50Azure Synapse benefits
  5. 11:50Demo setup
  6. 12:34Synapse workspace setup
  7. 18:53Data ingestion
  8. 23:28Exploring Synapse data
  9. 29:27Combining data sources
  10. 32:42Notebooks and Spark
  11. 35:10Lake house solution
  12. 40:48Power BI + Synapse integration
  13. 43:36Power BI reports from Synapse
  14. 47:48Key takeaways
  15. 50:44Q&A

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.