How Data Pilot developed an AI chatbot to improve its employee productivity
Duration
July 2024 - till today
Industry
IT Consulting
Services
AI/ML, MLOps, Capacity Building
Tools and Technologies
Company Background
Data Pilot is an all-in-one data product development and consulting services company that helps businesses in their journey from data to decisions.
We enable our partners to unleash the full potential of their data assets to maximize business value through our expert engineering and business skills.
Challenges
Unable to access documents
Our employees frequently needed assistance with understanding company policies, project-specific queries, and accessing various internal resources such as training notes, templates, and architecture diagrams. This led to disruptions in their productivity and delays in delivering key project deliverables.
Difficulty in understanding SOP’s
Data Pilot tracks hours for multiple clients using ClickUp, but the process was previously complex and inefficient, which led to confusion and delays in project management. Employees were unable to get answers regarding the use of ClickUp SOPs in creating and managing tasks.Â
No centralized system to manage inquiries
There was the lack of a centralized, easy-to-access system for managing and responding to the wide range of internal queries employees had. This issue not only caused delays in obtaining critical information but also created a significant burden on the administrative and management teams.
Solution
To solve the problem, Data Pilot first deeply understood the problem through the following:Â
- Retrieving Data from Internal Knowledge Bases
- Automating Generation of ClickUp tasks
- Providing Direct Access to Relevant Resources
- Providing Access to Meeting Summaries
The chatbot was designed to retrieve data integrated from internal knowledge bases and project management tools. This helped employees access necessary information without having to switch between multiple systems.
The chatbot was designed to automate task name generation in ClickUp, streamlining project management, reducing errors during manual data entry, and ensuring task nomenclatures were consistently followed.
The chatbot provided direct links to source documents in responses so that we can quickly navigate to detailed resources when needed.
The chatbot provided our employees with quick access to summary notes from internal meetings and external training sessions. This feature ensured that all team members were up to date on the latest developments and learnings, even if they could not attend the sessions in person.
The following technologies were employed to build the chatbot:
Pinecone
We used Pinecone for implementing advanced semantic search capabilities to retrieve relevant internal information efficiently.
Azure OpenAI
We used Azure OpenAI for natural language processing, enabling the chatbot to understand and respond to complex queries in a human-like manner.
Streamlit
Streamlit was used for deploying the chatbot on a user-friendly, web-based platform accessible to all employees.
Azure Blob Storage
We used Azure Blob Storage for securely storing large amounts of data, ensuring that the chatbot can access and retrieve information from a centralized repository.
Azure AD (Active Directory)
Azure AD was used for managing user authentication and ensuring that only authorized personnel can access the chatbot.
Azure Monitor
We used Azure Monitor for real-time monitoring of the chatbot’s performance and operational health, allowing for proactive maintenance and troubleshooting.
Azure Cognitive Services
Azure Cognitive Services was used for enhancing the chatbot’s ability to understand and process complex language queries, improving response accuracy.
The Impact
Increased employee productivity
Overall productivity has improved by 40%, as employees spend less time on administrative tasks and more on core activities.
Significant reduction in manual errors
The automation process of generating task names in ClickUp reduced manual errors, leading to more consistent project management practices.
Decreased workload on the administrative team
Additionally, the chatbot’s ability to handle a wide range of queries decreased the workload on our administrative team, freeing up valuable time for more strategic tasks.
Industry Applications
Personalized Client Portals
The chatbot can pave the way for
AI-powered client portals that provide real-time project updates and hour-tracking insights. These portals would offer tailored reports and support, enhancing transparency and strengthening client relationships.Â
Proactive Issue Resolution
The chatbot can leverage predictive analytics to predict project bottlenecks and resource needs. Predicting these bottlenecks can ensure projects are executed smoothly and delivered timely while aligning with strategic business goals.
Learning Development
The chatbot’s capabilities can be expanded to automate key aspects of student onboarding and provide real-time updates on academic policies and procedures. It can also deliver personalized learning recommendations, helping students navigate their educational journeys and enhance their academic experiences.Â
Ready for your transformation? Let’s connect
Your transformation starts here.