~/talk

Predictive Maintenance with Azure Synapse

Talkat SQLBits 2020 · 2020-09-29..10-04· [machine-learning, data-engineering]
links:none on file
slides:none on file

A telecom use case processes 10 GB/day of set‑top box telemetry with about 140 event types to replace six‑week Excel reports. The pipeline uses Azure Synapse: serverless SQL on demand, managed Spark notebooks (PySpark), anomaly detection libraries, parquet outputs and Synapse pipelines/spark job definitions to parallelize per‑event modeling. The experiment targets detect anomalies within four hours, validates against historical outages, writes anomaly results to the data lake and surfaces them in embedded Power BI — proven to work end‑to‑end.

AI-written summary · about

  1. 0:00Introduction
  2. 0:41Overview
  3. 1:21Agenda
  4. 2:15Quality of Service
  5. 4:31Anomaly Detection
  6. 6:47Data Science
  7. 7:50Process
  8. 11:29Azure Synapse
  9. 14:40Azure Portal
  10. 19:42Synapse Studio
  11. 20:30Notebooks
  12. 22:27Spark Pool Definition
  13. 24:46Performance Optimization
  14. 26:11Reading and Writing Files
  15. 27:19Spark Job Definition
  16. 29:45Recap
  17. 30:42SQL Scripts
  18. 34:36PowerBI
  19. 36:33Azure Data Studio
  20. 37:24Custom Applications
  21. 38:20Architectural View
  22. 39:13Summary
~/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.