It is a visitor put up by Cynthia Valeriano, Jaime Olivares, and Guillermo Puelles from DeFontana.
Defontana develops absolutely cloud-based enterprise purposes for the administration and administration of corporations. Primarily based in Santiago, Chile, with operations in Peru, Mexico, and most not too long ago Colombia, our principal product is a 100% cloud-based enterprise useful resource planning (ERP) system that has been offering worth to our enterprise clients for about 20 years. Along with our core ERP product, we’ve got developed integration modules for ecommerce, banks, monetary and regulatory establishments, digital signatures, enterprise experiences, and plenty of different options. Our aim is to proceed constructing options for purchasers and make Defontana the very best enterprise administration instrument in Chile and Latin America.
Most of our clients are small and medium companies (SMBs) who must optimize their sources. Our ERP system helps clients handle money movement, time, human sources (HR), and different sources. As we had been exploring the right way to proceed innovating for our clients and on the lookout for an embedded analytics answer, we selected Amazon QuickSight, which permits us to seamlessly combine data-driven experiences into our internet software.
On this put up, we talk about how QuickSight has sped up our growth time, enabled us to supply extra worth to our clients, and even improved our personal inside operations.
Saving growth time by embedding QuickSight
We constructed our ERP service as an internet software from the start. 10 years in the past, this was a giant differentiator for us, however to proceed to serve the SMBs that belief us for data every day, we needed to supply much more superior analytics. By embedding QuickSight into our internet software, we’ve got been in a position to present enterprise intelligence (BI) functionalities to clients two or 3 times sooner than we’d have if we had opted for libraries for producing HTML experiences. Due to our embedded QuickSight answer, we’re in a position to focus extra of our power on analyzing the necessities and functionalities that we wish to supply our clients in every BI report.
The next screenshots present our ERP service, accessed on an internet browser, with insights and wealthy visualizations by QuickSight.
We take pleasure in utilizing QuickSight due to how effectively it integrates with different AWS providers. Our knowledge is saved in a legacy relational database administration system (RDMS), Amazon Aurora, and Amazon DynamoDB. We’re within the strategy of transferring away from that legacy RDMS to PostgreSQL by a Babelfish for Aurora PostgreSQL undertaking. This can permit us to cut back prices whereas additionally having the ability to use a multi-Area database with catastrophe restoration sooner or later. This is able to have been too costly with the legacy RDMS. To seamlessly switch knowledge from these databases to Amazon Easy Storage Service (Amazon S3), we use AWS Database Migration Service (AWS DMS). Then, AWS Glue permits us to generate a number of extract, rework, and cargo (ETL) processes to arrange the info in Amazon S3 for use in QuickSight. Lastly, we use Amazon Athena to generate views for use as base data in QuickSight.
Offering important insights for SMB clients
QuickSight simplifies the era of dashboards. We’ve made a number of out-of-the-box dashboards in QuickSight for our clients that they’ll use instantly on our internet app proper after they join. These dashboards present insights on gross sales, accounting, money movement, monetary data, and buyer clusters primarily based on their knowledge in our ERP service. These free-to-use experiences can be utilized by all clients within the system. We even have dashboards that may be activated by any consumer of the system for a trial interval. Since we launched add-on dashboards, greater than 300 corporations have activated it, with over 100 of them selecting to proceed utilizing it after the free trial.
Apart from generic experiences, we’ve got created a number of tailored dashboards in accordance with the precise necessities of every buyer. These are managed by a customer-focused growth course of by our engineering workforce in accordance with the specs of every buyer. With this selection, our clients can get experiences on accounts payable, accounts receivable, provide data (buy order movement, receipts and invoices despatched by suppliers), stock particulars, and extra. We’ve greater than 50 clients who’ve labored with us on tailored dashboards. With the broad vary of functionalities inside QuickSight, we will supply many knowledge visualization choices to our clients.
Empowering our personal operations
Past utilizing QuickSight to serve our clients, we additionally use QuickSight for our personal BI reporting. To date, we’ve got generated greater than 80 dashboards to investigate completely different enterprise flows. For instance, we monitor each day gross sales in particular providers, accounting, software program as a service (SaaS) metrics, and the operation of our clients. We do all of this from inside our personal internet software, with the ability of QuickSight, giving us the chance to expertise the interface similar to our clients do. In 2023, certainly one of our prime objectives is to supply a 360-degree view of Defontana utilizing QuickSight.
QuickSight has enabled us to seamlessly embed analytics into our ERP service, offering precious insights to our SMB clients. We’ve been in a position to minimize prices and proceed to develop all through Latin America. We plan to make use of QuickSight much more inside our personal group, making us extra data-driven. QuickSight will empower us to democratize the knowledge that our personal staff obtain, set up higher processes, and create extra instruments to investigate buyer data for behavioral patterns, which we will use to raised meet our clients’ wants.
To study extra about how one can embed custom-made knowledge visuals and interactive dashboards into any software, go to Amazon QuickSight Embedded.
Concerning the authors
Cynthia Valeriano is a Enterprise Intelligence Developer of at Defontana, with abilities centered on knowledge evaluation and visualization. With 3 years of expertise in administrative areas and a pair of years of expertise in enterprise intelligence initiatives, she has been in control of implementing knowledge migration and transformation duties with numerous AWS instruments, resembling AWS DMS and AWS Glue, along with producing a number of dashboards in Amazon QuickSight.
Jaime Olivares is a Senior software program developer at Defontana, with 6 years of expertise within the growth of varied applied sciences centered on the evaluation of options and buyer necessities. Expertise with AWS in numerous providers, together with product growth by QuickSight for the evaluation of enterprise and accounting knowledge.
Guillermo Puelles is a Technical Supervisor of the “Appia” Integrations workforce at Defontana, with 9 years of expertise in software program growth and 5 years working with AWS instruments. Chargeable for planning and managing numerous initiatives for the implementation of BI options by QuickSight and different AWS providers.