Cotripal Case: Data Analytics with Redash
Case with the structuring of custom reports for real-time revenue tracking.
CadastraMarketing Team
July 19, 2023
![](https://cadastra.com/storage/articles/88/cover/original-20240130105032-wepik-export-20240130134250Zbxr.png)
The client was in search of low-cost BI tools for implementation and migration to replace internal Javascript development on the company portal, which displayed financial and performance data.
Custom Reports Case
Real-time revenue tracking.
Cotripal Agropecuária Cooperativa began its operations focusing on wheat storage and trading. Currently, the cooperative has an extensive business network divided into three major segments: agricultural production, livestock production, and retail. Rooted in cooperativism with a focus on member and community development, Cotripal prioritizes the quality of products and services, standing out for its socio-environmental responsibility.
The client sought low-cost BI tools for implementation and migration to replace internal Javascript development on the company portal, which presented financial and performance data.
Data Analysis through Redash
Facing this challenge, our Data & Analytics team found a solution by structuring reports for data analysis using Redash.
The proposed project involved creating custom reports for real-time revenue tracking and monthly results, pushing the boundaries of Redash solutions.
Using Redash, our team built specific queries in Cotripal's MySQL database to bring consolidated and structured information, allowing the graphs to function differently from other BI tools. As Redash doesn't store information in an internal data model, information consumption is real-time, directly from the company's database.
Two dashboards were developed, one focusing on the accounting view with result data by segment, group, and sector, while the second provides a real-time overview of the company's revenue.
Project Architecture
Results of the Strategies
The solution's outcome is dashboards built in Redash, delivering structured data in segments, groups, and sectors of the company, facilitating access to information and, crucially, generating reports to assist business decision-making.
Ease of Use User-friendly interface, enabling the creation of new views
Real-time Access to the company's database directly