About
The client is a policy-making body of the state of Georgia. The client provides subject-matter expertise on policy, court innovation, legislation, and court administration to all Georgia courts. It also furnishes information technology, budget, and financial services to the judicial branch. The client wanted to develop a data repository that would serve as a single source of information.
Project Highlights
Brainvire’s development experts built cloud platform integration, managed to create a statewide data repository of juvenile justice data using Odoo, and connected it to the Oracle database. The web solution uses data extraction to access data and provide analytics using Power BI.
The Challenges
- Analytic Tools Integration with Odoo:It was necessary to integrate analytics tools with Odoo.
- Provide access to Odoo Portal Users:Managing users to keep costs within budget.
- Multiple user roles and accessibility:A hierarchy for user roles was needed.
- Data Extractor and Dashboards:It was important to create a simple dashboard.
Tech Stack
Odoo
PostgreSQL
Python
Oracle
Power BI
Data Extractor
Result
Reduced human effort
With the development of the Odoo CMS portal, users had access to critical information all under one platform. This greatly reduced human effort. It helped save time and improve the productivity of the team.Faster navigation speed
With an optimized code, system usability increased along with speed. The web solution had a user-friendly system enabling more users to use it easily without any dependencies.Dashboards and KPIs
The customized dashboards allow users to easily navigate through their day to day activities, make conclusions of various analytics with enhanced user experience.Varied Search Options
The elastic search options help generate any kind of data with ease through quick system response. All the user documents, attachments, etc., could be easily searched anytime.