Grupo Panvel Achieves 90% Faster Analysis with Genie Integration
With the integration of Genie One, Grupo Panvel empowers its leadership to access essential sales data in real-time, revolutionizing decision-making processes and overcoming the bottleneck of traditional dashboard reporting.
Key Facts
- Grupo Panvel reduced analysis time by 90%, enhancing decision-making speed and agility.
- Genie’s integration allows real-time insights, shifting from reactive to proactive market responses.
- Over 1,500 questions answered in months indicate high user engagement and data-driven culture.
- Analysts can focus on strategic tasks, improving overall financial performance and operational efficiency.
- Scaling Genie to hundreds of users will democratize data access, fostering competitive advantage.
Summary
Summary
Grupo Panvel, one of Brazil's largest pharmacy chains, faced delays in accessing sales data due to a backlog of dashboard requests. To address this, they implemented Genie One integrated with Genie Agents, allowing leaders to ask questions in natural language and receive immediate, governed answers. As a result, the time required for margin and performance analysis dropped by at least 90%.
Background
Grupo Panvel operates in the pharmacy retail industry and has a significant presence in southern Brazil, with a growing digital footprint in São Paulo. Prior to deploying Genie, the company struggled with an overwhelming number of dashboards that couldn't adapt to evolving business questions, leading to delays in obtaining critical sales data.
Challenge
The main challenge was the inefficiency of the existing dashboard system. Whenever a question arose that deviated from the predefined metrics, employees had to file requests with the BI team, resulting in long wait times for answers that often led to further inquiries.
Solution
Grupo Panvel implemented Genie One, integrated with Genie Agents, to enable conversational analytics. This system allows users to ask questions in Portuguese, such as "how did generics sell last week, broken down by store," and receive immediate answers without the need for new dashboard creation. Genie processes these inquiries by converting them into queries, retrieving data from governed tables, and displaying the results along with the underlying query for transparency.
Results
The deployment of Genie led to significant improvements:
- Time for margin and performance analysis decreased by at least 90%.
- Access to historical sales data expanded from a standard three-year window to over eight years within the same conversation.
- Over 1,500 questions were answered by pilot users in the initial months. The data team transitioned from being a bottleneck to a support layer, allowing them to focus on complex issues rather than routine requests.
Key Insights
The case of Grupo Panvel illustrates the importance of removing bottlenecks in data access. By enabling natural language queries, organizations can empower users to find answers independently, fostering a culture of data-driven decision-making. Additionally, integrating tools directly into existing workflows can enhance user adoption and streamline processes.
Customer Testimonial
"Genie didn't just speed up our reports; it changed how our leaders think. They stopped waiting for the answer and started finding it themselves." — Max Reis, Data Engineering Specialist at Grupo Panvel.
Entities Mentioned
Companies
Products
Technologies
People
Key Concepts
Definitions
- Genie One
- A conversational analytics tool that allows users to ask questions in natural language and receive governed answers quickly.
- Genie Agents
- The conversational capability integrated with Genie One that facilitates natural language interactions with data.
- business intelligence (BI)
- Technologies and strategies used by enterprises for data analysis of business information.
- data governance
- The management of data availability, usability, integrity, and security in an organization.
- self-service analytics
- A process that allows business users to access and analyze data without needing extensive technical knowledge.
Use Cases
- →Margin analysis
- →Comparing branch performance across regions
- →Real-time sales data retrieval
- →Scheduled tasks for recurring reports
- →Embedding analytics within existing platforms
- →Improving data team efficiency
Frequently Asked Questions
What is Genie?
Genie is the conversational analytics agent on the Databricks Data + AI Platform. It enables users to ask business questions in natural language and receive answers based on governed data.
How does Grupo Panvel use Genie?
Grupo Panvel uses Genie to streamline data access and reporting by allowing users to ask questions directly, reducing dependency on the data team for answers.
What are the benefits of using Genie?
The benefits include significant time savings in data analysis, improved access to historical data, and the ability for managers to get answers quickly without waiting for reports.
How does Genie ensure data governance?
Genie respects access rules defined in Unity Catalog, ensuring that users only see data they are permitted to access while providing transparency in the answers it generates.
What future plans does Grupo Panvel have for Genie?
Grupo Panvel plans to scale Genie to hundreds of users and extend its capabilities beyond sales data to include inventory, expenses, and logistics, fostering a culture of data-driven decision making.