~/talk

Mastering Rapid Power BI Development with ChatGPT: A Deep Dive

on YouTube 50m
Talkat SQLBits 2024 · 2024-03-19..03-23· [ai-assisted-development]

speakers

name:Pedro Reis
linkedin:pedrogoncalvesreis
name:Ricardo Santos
links:none on file

resources

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

summary

Hands-on demo of using GPT-4 and 3.5 to generate a semantic data model, CSV sample data, a Python data generator, Power Query M code, DAX measures (YTD, rolling sum) and PowerShell scripts to list, back up, publish and refresh Power BI artifacts; many outputs require reprompting but ultimately run, insert rows, produce calendar tables and deploy reports. Claims include a BCG-style productivity lift: 25% faster, 40% higher quality, and larger gains for junior users; code sometimes hallucinates but is fixable with iterations.

AI-written summary · about

chapters (15)

  1. 0:00AI-powered Power BI development
  2. 3:39Speakers and session
  3. 6:09Power BI model with ChatGPT
  4. 8:17Artificial data for models
  5. 14:59Date table with Power Query
  6. 19:13DAX measures with ChatGPT
  7. 26:42AI visuals and themes
  8. 30:17Automate deployments with PowerShell
  9. 36:17Backup and manage reports
  10. 38:23Deploy between workspaces
  11. 40:30Refresh data sources
  12. 42:16AI productivity study
  13. 45:05Key takeaways and future
  14. 47:30Use cases and resources
  15. 48:36Q&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.