Advancements in Text to SQL and Data Visualization Accessibility

The R Weekly Highlights podcast returns for Our first episode of 2025! We learn how hosted and self-hostem LLM's perform in the summarization of Bluesky R posts, as well as how models hosted on Azure infrastructure summarize cycling destinations. Lastly, we visit the visualization corner once again to bring a little (or a lot) of color in your next graphics created with R.
Episode Links

• This week's curator: Batool Almarzouq - @batool664 (X/Twitter)
• Bluesky conversation analysis with local and frontier LLMs with R/Tidyverse.
• Harnessing Azure OpenAI and R for Web Content Summarisation: A Practical Guide with rvest and tidyverse
• Working with colours in R
• Entire issue available at rweekly.org/2025-W01

Supplement Resources

• Rasa open-source documentation https://rasa.com/docs/rasa/
• Brand.yml https://posit-dev.github.io/brand-yml/
• {rix} updates https://docs.ropensci.org/rix/news/index.html
• Strategic Investment Analysis: Key Questions Generated by DoTadda’s Knowledge Platform https://www.spsanderson.com/steveondata/posts/2024-12-26/

Supporting the show

• Use the contact page at https://serve.podhome.fm/custompage/r-weekly-highlights/contact to send us your feedback
• R-Weekly Highlights on the Podcastindex.org - You can send a boost into the show directly in the Podcast Index. First, top-up with Alby, and then head over to the R-Weekly Highlights podcast entry on the index.
• A new way to think about value: https://value4value.info
• Get in touch with us on social media
  • Eric Nantz: @rpodcast@podcastindex.social (Mastodon), @rpodcast.bsky.social (BlueSky) and @theRcast (X/Twitter)
  • Mike Thomas: @mike_thomas@fosstodon.org (Mastodon), @mike-thomas.bsky.social (BlueSky), and @mike_ketchbrook (X/Twitter) 

Music powered by OCRemix

• Peacemaker - Sonic Adventure - halc - https://ocremix.org/remix/OCR02187
• The Quick and the Blue - Mega Man 2 - The Megas - https://ocremix.org/remix/OCR02090