Data Engineering Podcast Building Self Serve Business Intelligence With AI And Semantic Modeling At Zenlytic
49:19
Goldman Sachs Hallucination
- Ryan Janssen's wife's ChatGPT biography mentioned Goldman Sachs.
- She never worked there, highlighting the risk of AI hallucination in business.
Evolving Self-Serve BI
- Self-serve BI's definition has evolved alongside technology.
- It now focuses on enabling non-technical users to answer their own questions without SQL or Python.
Conversational BI
- Conversational interfaces are key for self-serve BI.
- They enable clarifying questions, guiding users to the specific data they need.
Get the Snipd Podcast app to discover more snips from this episode
Get the app 1 chevron_right 2 chevron_right 3 chevron_right 4 chevron_right 5 chevron_right 6 chevron_right 7 chevron_right 8 chevron_right 9 chevron_right 10 chevron_right 11 chevron_right 12 chevron_right 13 chevron_right 14 chevron_right 15 chevron_right 16 chevron_right 17 chevron_right 18 chevron_right 19 chevron_right
Introduction
00:00 • 2min
ZnLitik: A Data Consulting Business
01:52 • 2min
The Importance of Self-Serve in Analytics
03:27 • 3min
Building a New Entrant Into the Business Intelligence Market
06:18 • 4min
The Evolution of Semantic Modeling
10:08 • 3min
How to Setup a Semantic Layer in GPT
13:30 • 2min
ZenLitic's Semantic Layer Architecture
15:00 • 4min
The Evolution of Semantic Layers
18:34 • 3min
The Evolution of Large Language Models
21:33 • 4min
ZenLitic: A Data Warehouse for Single Applications
25:31 • 2min
ZenLitic: A Data Exploration Platform for Data Discovery
28:01 • 2min
Zenoletic: A Fully Functional BI Tool
29:55 • 3min
How to Use Self-Serve to Guide People Into the Pit of Success
33:13 • 4min
The Unexpected Uses of ZenLitic on Flat Charts
37:05 • 2min
The Unexpected Edge Cases of Large Language Models
38:51 • 2min
ZenLitic: The Art of the Possible
40:42 • 2min
ZenLitic: The Future of Data Management
42:52 • 2min
The Biggest Gap in Data Management Today
44:56 • 3min
ZenLitic: AI and Machine Learning
48:07 • 2min
Summary
Business intellingence has been chasing the promise of self-serve data for decades. As the capabilities of these systems has improved and become more accessible, the target of what self-serve means changes. With the availability of AI powered by large language models combined with the evolution of semantic layers, the team at Zenlytic have taken aim at this problem again. In this episode Paul Blankley and Ryan Janssen explore the power of natural language driven data exploration combined with semantic modeling that enables an intuitive way for everyone in the business to access the data that they need to succeed in their work.
Announcements
- Hello and welcome to the Data Engineering Podcast, the show about modern data management
- RudderStack helps you build a customer data platform on your warehouse or data lake. Instead of trapping data in a black box, they enable you to easily collect customer data from the entire stack and build an identity graph on your warehouse, giving you full visibility and control. Their SDKs make event streaming from any app or website easy, and their extensive library of integrations enable you to automatically send data to hundreds of downstream tools. Sign up free at dataengineeringpodcast.com/rudderstack
- Your host is Tobias Macey and today I'm interviewing Paul Blankley and Ryan Janssen about Zenlytic, a no-code business intelligence tool focused on emerging commerce brands
Interview
- Introduction
- How did you get involved in the area of data management?
- Can you describe what Zenlytic is and the story behind it?
- Business intelligence is a crowded market. What was your process for defining the problem you are focused on solving and the method to achieve that outcome?
- Self-serve data exploration has been attempted in myriad ways over successive generations of BI and data platforms. What are the barriers that have been the most challenging to overcome in that effort?
- What are the elements that are coming together now that give you confidence in being able to deliver on that?
- Can you describe how Zenlytic is implemented?
- What are the evolutions in the understanding and implementation of semantic layers that provide a sufficient substrate for operating on?
- How have the recent breakthroughs in large language models (LLMs) improved your ability to build features in Zenlytic?
- What is your process for adding domain semantics to the operational aspect of your LLM?
- For someone using Zenlytic, what is the process for getting it set up and integrated with their data?
- Once it is operational, can you describe some typical workflows for using Zenlytic in a business context?
- Who are the target users?
- What are the collaboration options available?
- What are the most complex engineering/data challenges that you have had to address in building Zenlytic?
- What are the most interesting, innovative, or unexpected ways that you have seen Zenlytic used?
- What are the most interesting, unexpected, or challenging lessons that you have learned while working on Zenlytic?
- When is Zenlytic the wrong choice?
- What do you have planned for the future of Zenlytic?
Contact Info
Parting Question
- From your perspective, what is the biggest gap in the tooling or technology for data management today?
Closing Announcements
- Thank you for listening! Don't forget to check out our other shows. Podcast.__init__ covers the Python language, its community, and the innovative ways it is being used. The Machine Learning Podcast helps you go from idea to production with machine learning.
- Visit the site to subscribe to the show, sign up for the mailing list, and read the show notes.
- If you've learned something or tried out a project from the show then tell us about it! Email hosts@dataengineeringpodcast.com) with your story.
- To help other people find the show please leave a review on Apple Podcasts and tell your friends and co-workers
Links
The intro and outro music is from The Hug by The Freak Fandango Orchestra / CC BY-SA
Sponsored By:
- Rudderstack:  RudderStack provides all your customer data pipelines in one platform. You can collect, transform, and route data across your entire stack with its event streaming, ETL, and reverse ETL pipelines. RudderStack’s warehouse-first approach means it does not store sensitive information, and it allows you to leverage your existing data warehouse/data lake infrastructure to build a single source of truth for every team. RudderStack also supports real-time use cases. You can Implement RudderStack SDKs once, then automatically send events to your warehouse and 150+ business tools, and you’ll never have to worry about API changes again. Visit [dataengineeringpodcast.com/rudderstack](https://www.dataengineeringpodcast.com/rudderstack) to sign up for free today, and snag a free T-Shirt just for being a Data Engineering Podcast listener.