Uploaded May 2026 | Updated November 2026, 4 days ago
ADD THE DATA SCIENCE HANGOUT TO YOUR CALENDAR HERE: https://pos.it/dsh - All are welcome! We'd love to see you!
This week's guest was Jason Frederick, Corporate Treasurer (Interim) at Texas Capital!
Some topics covered in this week's Hangout were building dashboards for banking and finance (really, we got deep into the dashboard zone!), deploying Shiny applications on first AWS and then leveling up to Posit Connect, dashboard design principles and stakeholder communication (these go hand in hand), and using AI tools to accelerate development work.
One community member asked: "For someone who's getting into dashboards, what are tips and tricks that you wish you knew when you started?"
Jason answered: The first thing I would do when asked to create a dashboard is step back and get out a piece of paper or whiteboard to draw it out visually. You need to understand what the stakeholder wants, though they often don't always know. It's your job to interpret what they're saying. Then figure out your data source and access, and always recommend separating the data processing from the dashboard itself. Write a script that generates and summarizes your data to create an intermediate file, then have your dashboard read from that file. This allows the dashboard to run independently when you update data. For the visual design, pick the right architecture, keep your pages simple, and remember the three-click rule: executives need to see information and gather it from visual cues very quickly, in about 3 clicks or less. (Paraphrasing Jason a little here of course.)
Resources mentioned in the video and chat:
π Big Book of R Finance Section β bigbookofr.com/chapters/finance
π Dask for Parallel Computing β dask.org
π CARFAX Customer Story with Tiger Tang β posit.co/about/customer-stories/carfax
π Posit Fraud Detection and Claims Analytics Demo β posit.co/product-demo/fraud-detection-and-claims-analytics
π Hangout Episode with Jay Sewell on Dashboard Management β posit.co/data-science-hangout/52-jay-sewall
π TidyTuesday Dataset Repository β github.com/rfordatascience/tidytuesday
π Gregory Power's Public Dashboard Example β data.carync.gov/page/cassi-autonomous-shuttle-bond-park
π Hangout Episode with Libby and Rachael on Community building β youtu.be/lc6ad15gjeo
π Ted Laderas' Databot TidyTuesday Project β github.com/laderast/astronomy-pod
π Credit Card Fraud Prediction Project β github.com/InfiniteCuriosity/InfiniteCuriosity.github.io/blob/main/_posts/2026-03-31-Predicting-credit-card-fraud.md
π Rachel K Collier Ableton Live Music Production Course (lots of music production talk in the chat this week!) β maryspender.teachable.com/p/how-to-produce-music-in-ableton-live
π Posit Connect Cloud β https://connect.posit.cloud/
π PositConf 2026 Registration β conf.posit.co/2026
π Introducing Posit AI for Positron and RStudio β youtu.be/4er6aua7zyI
π Making a Business Case for Posit Tools β posit.co/champions/business-case
βΊ Subscribe to Our Channel Here: bit.ly/2TzgcOu
Follow Us Here:
Website: posit.co
Hangout: https://pos.it/dsh
The Lab: https://pos.it/dslab
LinkedIn: linkedin.com/company/posit-software
Bluesky: https://bsky.app/profile/posit.co
Thanks for hanging out with us! π
Timestamps:
00:00 Introduction
13:00 "What are interesting problems specific to banking or finance-related data science?"
16:22 "How can I prepare myself to land an entry-level data role?"
23:15 "How do you convince leadership of the value of using and paying for a tool like Connect or Connect Cloud?"
27:01 "For someone getting into dashboards, what are tips and tricks that you wish you knew when you started?"
35:47 "How do you strike the balance of what you put into a dashboard and what you don't? What do you consider pertinent information and what do you consider fluff?"
41:00 "What advice can you give to stay up to date with data science developments as a manager who is no longer as close to the code?"
45:03 "How and from who do you acquire feedback for your dashboards? What kind of questions do you ask to get the feedback you want?"
46:44 "How would you recommend people get domain experience without being part of a team working in that specific domain, like fraud and compliance?"
ADD THE DATA SCIENCE HANGOUT TO YOUR CALENDAR HERE: https://pos.it/dsh - All are welcome! We'd love to see you!
This week's guest was Jason Frederick, Corporate Treasurer (Interim) at Texas Capital!
Some topics covered in this week's Hangout were building dashboards for banking and finance (really, we got deep into the dashboard zone!), deploying Shiny applications on first AWS and then leveling up to Posit Connect, dashboard design principles and stakeholder communication (these go hand in hand), and using AI tools to accelerate development work.
One community member asked: "For someone who's getting into dashboards, what are tips and tricks that you wish you knew when you started?"
Jason answered: The first thing I would do when asked to create a dashboard is step back and get out a piece of paper or whiteboard to draw it out visually. You need to understand what the stakeholder wants, though they often don't always know. It's your job to interpret what they're saying. Then figure out your data source and access, and always recommend separating the data processing from the dashboard itself. Write a script that generates and summarizes your data to create an intermediate file, then have your dashboard read from that file. This allows the dashboard to run independently when you update data. For the visual design, pick the right architecture, keep your pages simple, and remember the three-click rule: executives need to see information and gather it from visual cues very quickly, in about 3 clicks or less. (Paraphrasing Jason a little here of course.)
Resources mentioned in the video and chat:
π Big Book of R Finance Section β bigbookofr.com/chapters/finance
π Dask for Parallel Computing β dask.org
π CARFAX Customer Story with Tiger Tang β posit.co/about/customer-stories/carfax
π Posit Fraud Detection and Claims Analytics Demo β posit.co/product-demo/fraud-detection-and-claims-analytics
π Hangout Episode with Jay Sewell on Dashboard Management β posit.co/data-science-hangout/52-jay-sewall
π TidyTuesday Dataset Repository β github.com/rfordatascience/tidytuesday
π Gregory Power's Public Dashboard Example β data.carync.gov/page/cassi-autonomous-shuttle-bond-park
π Hangout Episode with Libby and Rachael on Community building β youtu.be/lc6ad15gjeo
π Ted Laderas' Databot TidyTuesday Project β github.com/laderast/astronomy-pod
π Credit Card Fraud Prediction Project β github.com/InfiniteCuriosity/InfiniteCuriosity.github.io/blob/main/_posts/2026-03-31-Predicting-credit-card-fraud.md
π Rachel K Collier Ableton Live Music Production Course (lots of music production talk in the chat this week!) β maryspender.teachable.com/p/how-to-produce-music-in-ableton-live
π Posit Connect Cloud β https://connect.posit.cloud/
π PositConf 2026 Registration β conf.posit.co/2026
π Introducing Posit AI for Positron and RStudio β youtu.be/4er6aua7zyI
π Making a Business Case for Posit Tools β posit.co/champions/business-case
βΊ Subscribe to Our Channel Here: bit.ly/2TzgcOu
Follow Us Here:
Website: posit.co
Hangout: https://pos.it/dsh
The Lab: https://pos.it/dslab
LinkedIn: linkedin.com/company/posit-software
Bluesky: https://bsky.app/profile/posit.co
Thanks for hanging out with us! π
Timestamps:
00:00 Introduction
13:00 "What are interesting problems specific to banking or finance-related data science?"
16:22 "How can I prepare myself to land an entry-level data role?"
23:15 "How do you convince leadership of the value of using and paying for a tool like Connect or Connect Cloud?"
27:01 "For someone getting into dashboards, what are tips and tricks that you wish you knew when you started?"
35:47 "How do you strike the balance of what you put into a dashboard and what you don't? What do you consider pertinent information and what do you consider fluff?"
41:00 "What advice can you give to stay up to date with data science developments as a manager who is no longer as close to the code?"
45:03 "How and from who do you acquire feedback for your dashboards? What kind of questions do you ask to get the feedback you want?"
46:44 "How would you recommend people get domain experience without being part of a team working in that specific domain, like fraud and compliance?"
![querychat in R: Query Your Data with Natural Language | Shiny + LLMs | Veerle van Leemput
Learn how to use querychat, an R package that lets users query data using natural language instead of predefined filters. Perfect for data scientists who want to build flexible, interactive Shiny dashboards without anticipating every possible user question.
In this tutorial, youll discover:
- How querychat translates natural language to SQL using LLMs
- Setting up querychat in seconds with your data
- Building custom Shiny interfaces with reactive data frames
- Why its reliable, transparent, and safe for production use
- Enterprise deployment with Azure, AWS Bedrock, or Google Vertex AI
Key Features:
β Drop-in Shiny component
β Works with any DBI-compatible database
β Read-only by design for data safety
β Full SQL transparency for reproducibility
β Supports Claude, GPT, Gemini via ellmer
Resources:
- querychat Documentation: [https://posit-dev.github.io/querychat/py/index.html]
- Blog Post: Where Questions Become Queries [https://shiny.posit.co/blog/posts/querychat-python-r/
- Github repo: [https://github.com/posit-dev/querychat/tree/main/pkg-r]
Perfect for R users working with Shiny, data exploration, and interactive analytics.
Timestamps
00:00 - Introduction: The Dashboard Problem
00:50 - Why Dashboards Cant Answer Every Question
01:47 - What is querychat?
02:46 - Getting Started (Installation & Setup)
03:08 - API Key Setup (Claude, GPT, Gemini)
03:20 - First querychat App in 5 Lines of Code
04:04 - Live Demo: Querying Data with Natural Language
05:01 - How querychat Works Under the Hood
06:44 - Four Key Benefits (Reliability, Transparency, Reproducibility, Safety)
07:37 - Tool Calling & DuckDB Integration
08:46 - Building Custom Shiny Interfaces
09:01 - Customizing querychat Behavior (Greetings, Data Descriptions, Instructions)
11:00 - Creating Custom Dashboards with Reactive Data Frames
12:00 - Complete App Structure Walkthrough
13:10 - Safety & Security Deep Dive
14:00 - Enterprise Deployment (Azure, AWS, Google Vertex AI)
15:12 - Resources & Documentation querychat in R: Query Your Data with Natural Language | Shiny + LLMs | Veerle van Leemput](https://i.ytimg.com/vi/EQjr0p25KS8/mqdefault.jpg)









