Description:

In this episode of the Data Analyst Show, Christopher Fiore and his team engage in a lively discussion with Jason Ganz about the Model Context Protocol (MCP) and its implications for data analysts.

They explore how MCP can enhance the interaction between AI and structured data, the challenges faced by data analysts in utilizing data effectively, and the exciting potential of AI tools in streamlining data analysis processes.

The conversation also includes a live demo of MCP, showcasing its capabilities and the future of data analysis in a rapidly evolving technological landscape.

  Featuring:

• Jason Ganz, Head of AI Strategy & Developer Relations
• Chris Fiore, Sr Data Analyst, dbt Labs
• Paige Berry, Lead Data Analyst, dbt Labs
• Alex Talbott, Data Analyst, dbt Labs
• Logan Cochran, Data Analyst, dbt Labs
• Yesi Cisneros, Data Analyst, dbt Labs

 

Takeaways:

• MCP serves as a bridge between data and insights.
• AI can alleviate tedious tasks for data analysts.
• Documentation is crucial for effective data analysis.
• Stakeholder engagement is key to successful data initiatives.
• The importance of auditability in AI-driven tools.
• MCP can empower self-service data access for stakeholders.
• Data analysts should focus on high-value tasks.
• The semantic layer is essential for consistent metrics.
• Collaboration between analysts and stakeholders enhances data utilization.
• AI tools can help analysts understand complex data models.

 

Chapters:

• 00:00 Introduction to the Data Analyst Show
• 03:43 Understanding Model Context Protocol (MCP)
• 06:12 The Importance of Data Utilization
• 09:34 Connecting AI with Data Analysis
• 13:38 The Future of Self-Service Data
• 19:04 Adoption of MCP by Analysts and Stakeholders
• 19:28 Understanding the Semantic Layer and Its Impact
• 23:27 Pilot Programs and Stakeholder Engagement
• 27:19 The Role of Analysts in Data Trustworthiness
• 33:08 Demonstrating the MCP in Action
• 35:01 Building AI Models with Business Context
• 37:42 The Role of Analysts in AI Integration
• 38:52 Understanding the Semantic Layer
• 41:40 Demo Insights: AI and Data Interaction
• 44:45 Challenges and Next Steps in AI Implementation
• 46:34 Feedback and Future Directions for AI Tools

 

The Data Analyst Show is created and produced by:

 Bolaji Oyejide, Community Manager at dbt Labs.

In this episode of the Data Analyst Show, the hosts discuss their experiences with new features at dbt, particularly focusing on the Insights feature, Co-Pilot, and Canvas.   They share how these tools enhance their workflows, improve documentation, and facilitate collaboration among data teams.   The conversation highlights the importance of cost management in data operations and the benefits of a visual approach to data modeling, making analytics more accessible to non-technical stakeholders.   Read the dbt Launch Showcase 2025 recap https://www.getdbt.com/blog/dbt-launch-showcase-2025-recap   Watch the webinar on demand  https://www.getdbt.com/resources/webinars/2025-dbt-cloud-launch-showcase     Takeaways

• dbt Insights feature allows for easier data exploration and analysis.
• Bookmarking queries in Insights promotes intentional documentation.
• dbt Co-Pilot helps automate documentation, saving time for analysts.
• dbt Canvas provides a visual interface for data modeling, making it accessible to non-SQL users.
• Cost management features help teams understand the financial implications of their data operations.
• Collaboration is enhanced through shared insights and documentation.
• The integration of tools within dbt streamlines workflows for analysts.
• Using Canvas can improve project management and stakeholder communication.
• The ability to self-serve data insights empowers stakeholders.
• Continuous feedback from analysts shapes the development of dbt features.

Chapters

• 00:00: Introduction to Data Analysis and dbt Labs Tools
• 01:53: Insights Feature: Enhancing Data Analysis Workflows
• 04:21: Handling Data Outages and Using Insights Effectively
• 06:28: Bookmarking and Sharing Queries for Collaboration
• 09:09: The Role of Documentation in Data Analysis
• 11:44: Exploring Canvas: A Visual Tool for Model Building
• 14:28: Self-Service Data Exploration with Canvas
• 16:55: Integrating Stakeholder Needs into Data Models
• 20:12: Project Management in Analytics
• 22:25: Collaborative Data Modeling
• 24:45: Ecosystem of Features in dbt
• 27:45: User Feedback and Product Development
• 29:08: Cost Management in Data Operations
• 33:35: Ensuring Data Quality and Efficiency

 

Hosted by: 

• Chris Fiore, Sr. Data Analyst @ dbt Labs
• Paige Berry, Lead Data Analyst @ dbt Labs
• Logan Cochran, Data Analyst @ dbt Labs
• Jules Arombo, Analytics Engineer @ dbt Labs

 

Created and Produced by: 

• Bolaji Oyejide, Community Manager @ dbt Labs

 

—

 About the dbt Community:

We’ve always believed the best way to get better at data is by sharing what you’re learning.

That’s why we built the dbt Community—a place where data pros at every level can ask questions, debate ideas, and push each other forward.

It’s not just about solving today’s problems—it’s about building what’s next, together.

dbt Community - for and by data pros. 

• Build reliable transformation pipelines.
• Test & deploy models.
• Optimize queries.
• Structure data for self-serve analysis.

Come hang out and transform with 70,000 of the brightest Analytics Engineers, Data Engineers, Data Analysts, and Data Scientists in the world

 

Join the dbt Community

 

In the inaugural episode of the Data Analyst Show, the hosts introduce themselves and delve into the essence of being a data analyst.   They discuss the importance of storytelling in data analysis, the role of curiosity, and the detective-like approach analysts take to uncover insights. The conversation then transitions to the impact of AI on the field, exploring both its potential benefits and limitations, particularly in terms of data accuracy and the necessity for critical questioning.   In this conversation, the participants explore the integration of AI in their daily tasks, the evolution of data analytics, and the importance of collaboration and understanding in their roles. They discuss how AI tools enhance efficiency and the changing landscape of data analytics, emphasizing the need for continuous learning and adaptation in the field.   Hosts:

• Chris Fiore, Sr Data Analyst, dbt Labs
• Paige Berry, Lead Data Analyst, dbt Labs
• Alex Talbott, Data Analyst, dbt Labs
• Logan Cochran, Data Analyst, dbt Labs

Takeaways

• Being a data analyst is about storytelling, not just dashboards.
• Curiosity is a key trait for successful analysts.
• AI tools can assist but should not replace critical thinking.
• Analysts often come from unconventional backgrounds.
• The role of an analyst is to provide context for decision-makers.
• AI can help identify trends but lacks deep nuance.
• Effective communication with stakeholders is crucial.
• Analysts should be the best question askers in their organizations.
• AI can save time by automating routine tasks.
• The future of AI in data analysis is promising but requires careful implementation. Chat GPT is a go-to tool for ideation and design.
• AI excels in tasks that are quick to verify.
• Documentation and ideation are great use cases for AI.
• The landscape of data analytics has evolved significantly.
• Collaboration and sharing knowledge are key in analytics.
• AI tools help streamline troubleshooting and learning.
• Understanding the context behind data is crucial.
• The role of data analysts is becoming more defined.
• Continuous learning is essential in the analytics field.
• The excitement in analytics comes from unlocking insights for others.

  Sound Bites

• "Being a data analyst is like being a detective."
• "Curiosity is key in data analysis."
• "Analysts hate unearned conviction."
• "AI can save us time by alerting us."
• "It's super helpful to essentially pair with AI."
• "It's all about the people."

 

The Data Analyst Show is created and produced by:

 Bolaji Oyejide, Community Manager at dbt Labs.