Simplifying Data Analytics: Gandalf Insights and the Power of Natural Language Queries

By Anish Machamasi, Cloud Data Engineer– Genese Solution
By Hassan Elsabaa, Senior Partner Solution Architect– AWS

Genese

In today’s data-driven landscape, businesses want to extract meaningful insights from their data. However, traditional approaches involving advanced SQL knowledge or reliance on specialized teams can lead to delays and inefficiencies, hampering the organization’s agility and responsiveness.

As companies grapple with ever-growing volumes of data across multiple platforms, the need for streamlined, user-friendly analytics solutions have become paramount. Manual querying processes slow down decision-making and introduce the risk of human error, which can negatively impact the customer’s business.

Empowering businesses with intuitive, self-service analytics tools allows customers to unlock the full potential of their data. By democratizing data access and analysis, organizations can accelerate their ability to identify growth opportunities, optimize operations, and make informed decisions that drive success in an increasingly competitive and data-driven world.

In this Blog, you will learn how Gandalf Insights can help to revolutionize how businesses interact with their data by simplifying the querying process. By enabling users to query databases using natural language, Gandalf Insights removes the technical barrier, allowing anyone, from business analysts to executives, to access and visualize critical data insights quickly. With powerful visualizations rendered in Metabase (an open-source business intelligence tool that helps users create interactive dashboards and reports), users can interpret data more effectively, accelerating the decision-making process and enabling businesses to stay agile in a competitive market.

Genese Solution: Powering Innovation Through AWS Partnership

As an Advanced Technology Partner in the AWS Partner Network, Genese Solution has been at the forefront of digital transformation since 2011. With deep expertise in AI and machine learning solutions, we’ve helped over 500 enterprises across 30 countries modernize their data operations. Our commitment to innovation is reflected in our AWS competencies in Machine Learning and Data & Analytics, alongside our track record of successful AWS implementations. Through our flagship product, Gandalf Insights, we’re leveraging AWS’s AI services like Amazon Bedrock to democratize data analytics for businesses worldwide. Our strategic collaboration with AWS enables us to deliver enterprise-grade solutions that combine the security and scalability of AWS with our innovative approach to solving complex business challenges. This partnership has been instrumental in our mission to make advanced data analytics accessible to organizations of all sizes, resulting in numerous AWS customer success stories and industry recognition.

Transforming Data Analytics with AWS Innovation

Gandalf Insights solution uses Amazon Bedrock for advanced natural language processing, Amazon OpenSearch for intelligent data retrieval, and Amazon Elastic Container Service for enterprise-grade scalability. This powerful combination enables business users to:

Transform complex queries into simple conversations
Access real-time insights without technical expertise
Scale analytics capabilities globally with AWS infrastructure
Maintain enterprise-grade security and compliance

Here are the real business impact our solution is delivering across industries:

Reduction in time-to-insight
Decrease in IT support costs
Increase in data-driven decision-making
Improvement in business team autonomy

High-Level Architecture

Figure 1: High-Level Deployment Architecture

How Gandalf Insights Works:

Secure Access: Users safely log into the platform through AWS’s enterprise-grade security system (Amazon Cognito), ensuring their data remains protected.
Reliable Performance: Users requests served by AWS’s global infrastructure (Application Load Balancer).
Easy Connection: Users can quickly connect their existing business databases and data warehouses to start analyzing their data.
Data Query: the uploaded CSV data from Business stored in a table in AWS Glue database and with the help of Amazon Athena and Amazon Simple Storage Service (S3) to store those data.
Data ingestion: User data getting processed and converted into JSON format and inference to Amazon Bedrock.
Enhanced Understanding: The system processes this enriched information to better understand your business context and terminology.
Natural Conversations: Using AWS’s advanced AI technology, the system translates everyday business questions into precise database queries.
Visual Insights: The platform automatically creates clear, meaningful visualizations of your data insights through Metabase.
History Tracking: All conversations and queries are safely stored for future reference and audit purposes.

Use-case: Accelerating Financial Decision-Making: A Real-World Success Story

Challenge: A Leading financial institution faced a critical business challenge wherein their lending analysis process was taking days. Business analysts were spending valuable time waiting for IT support to run complex database queries, causing delays in identifying market opportunities and assessing lending risks.

“Before Gandalf Insights, I spent most of my time either writing complex queries or waiting for IT support to pull the data I needed,” says Business Analyst. “In today’s fast-moving market, this delay was causing us to miss valuable lending opportunities.”

Solution: Implementing Gandalf Insights transformed data analysis process:

Replaced technical SQL queries with natural language questions
Automated report generation and visualization
Provided self-service analytics capabilities to business teams

Business Impact: By implementing Gandalf Insights, the financial institution transformed their reporting process from a multi-day endeavour to a two digits minute task, while dramatically reducing IT support costs and enabling real-time decision-making. The solution’s natural language capabilities revolutionized how teams access lending insights, with one Senior Business Analyst noting, ‘What used to require complex SQL queries and days of waiting is now as simple as asking a question in plain English—we’re seeing a big improvement in our response time to market opportunities.’ This transformation has not only optimized operational expenses, but has also significantly enhanced their ability to analyze lending opportunities and manage risk, resulting in measurable improvements to their bottom line.

Conclusion

The ability to quickly extract meaningful insights from data has become a crucial differentiator in today’s competitive business landscape. Through our strategic collaboration with AWS, Gandalf Insights is transforming how organizations interact with their data, converting complex analytics into intuitive conversations that drive business value.

The future of business intelligence belongs to organizations that can make data accessible across all levels of decision-making. With Gandalf Insights powered by AWS, you can transform your data from a complex challenge into a strategic asset that drives growth and innovation.

Looking ahead as an AWS Partner, we continue to innovate with new AWS services, ensuring our customers stay ahead of the data analytics curve. Our roadmap includes integration with additional AWS AI services and expanded capabilities for enterprise-scale deployment, reinforcing our commitment to making data analytics accessible to everyone in the organization.

As an AWS Partner, we continue to leverage the latest AWS innovations in AI and machine learning to enhance our solution’s capabilities. Looking ahead, we remain committed to our mission of democratizing data analytics, enabling businesses of all sizes to make faster, more informed decisions that drive growth and innovation.

The future of business intelligence lies in making data accessible to everyone, not just technical experts. With Gandalf Insights and AWS, organizations can turn their data from a complex challenge into a powerful competitive advantage.

.

.

Genese Solution — AWS Partner Spotlight

Genese Solution is an AWS Advanced Technology Partner and AWS Competency Partner that helps enterprises envision their journey in the Cloud. Genese Solution provides its customers with ICT consulting, engineering, and cybersecurity services to design, construct, and support cloud-based infrastructure solutions that enable business growth and innovation.

Contact Genese Solution | Partner Overview | AWS Marketplace

AWS Partner Network (APN) Blog