It is a visitor submit by Cynthia Valeriano, Jaime Olivares, and Guillermo Puelles from DeFontana.
Defontana develops totally cloud-based enterprise purposes for the administration and administration of corporations. Based mostly in Santiago, Chile, with operations in Peru, Mexico, and most lately Colombia, our primary product is a 100% cloud-based enterprise useful resource planning (ERP) system that has been offering worth to our enterprise prospects 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 stories, and lots of different options. Our purpose is to proceed constructing options for purchasers and make Defontana the perfect enterprise administration software in Chile and Latin America.
Most of our prospects are small and medium companies (SMBs) who must optimize their sources. Our ERP system helps prospects handle money move, time, human sources (HR), and different sources. As we have been exploring methods to proceed innovating for our prospects and on the lookout for an embedded analytics resolution, we selected Amazon QuickSight, which permits us to seamlessly combine data-driven experiences into our internet utility.
On this submit, we focus on how QuickSight has sped up our improvement time, enabled us to supply extra worth to our prospects, and even improved our personal inner operations.
Saving improvement time by embedding QuickSight
We constructed our ERP service as an online utility from the start. 10 years in the past, this was an enormous differentiator for us, however to proceed to serve the SMBs that belief us for data every day, we wished to supply much more superior analytics. By embedding QuickSight into our internet utility, we’ve got been capable of present enterprise intelligence (BI) functionalities to prospects two or thrice quicker than we’d have if we had opted for libraries for producing HTML stories. Due to our embedded QuickSight resolution, we’re capable of focus extra of our vitality on analyzing the necessities and functionalities that we wish to supply our prospects in every BI report.
The next screenshots present our ERP service, accessed on an online browser, with insights and wealthy visualizations by QuickSight.
We take pleasure in utilizing QuickSight due to how nicely 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 mission. This may permit us to cut back prices whereas additionally with the ability to use a multi-Area database with catastrophe restoration sooner or later. This might 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, remodel, and cargo (ETL) processes to arrange the information 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 prospects
QuickSight simplifies the era of dashboards. We’ve got made a number of out-of-the-box dashboards in QuickSight for our prospects that they’ll use immediately on our internet app proper after they join. These dashboards present insights on gross sales, accounting, money move, monetary data, and buyer clusters primarily based on their knowledge in our ERP service. These free-to-use stories can be utilized by all prospects within the system. We even have dashboards that may be activated by any person 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.
Moreover generic stories, we’ve got created a number of tailored dashboards in line with the particular necessities of every buyer. These are managed by a customer-focused improvement course of by our engineering crew in line with the specs of every buyer. With this feature, our prospects can get stories on accounts payable, accounts receivable, provide data (buy order move, receipts and invoices despatched by suppliers), stock particulars, and extra. We’ve got greater than 50 prospects who’ve labored with us on tailored dashboards. With the broad vary of functionalities inside QuickSight, we are able to supply many knowledge visualization choices to our prospects.
Empowering our personal operations
Past utilizing QuickSight to serve our prospects, we additionally use QuickSight for our personal BI reporting. Up to now, we’ve got generated greater than 80 dashboards to research totally different enterprise flows. For instance, we monitor every day gross sales in particular providers, accounting, software program as a service (SaaS) metrics, and the operation of our prospects. We do all of this from inside our personal internet utility, with the facility of QuickSight, giving us the chance to expertise the interface similar to our prospects do. In 2023, considered one of our prime targets is to supply a 360-degree view of Defontana utilizing QuickSight.
QuickSight has enabled us to seamlessly embed analytics into our ERP service, offering worthwhile insights to our SMB prospects. We’ve got been capable of lower 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 data that our personal workers obtain, set up higher processes, and create extra instruments to research buyer data for behavioral patterns, which we are able to use to raised meet our prospects’ wants.
To be taught extra about how one can embed personalized knowledge visuals and interactive dashboards into any utility, go to Amazon QuickSight Embedded.
In regards to the authors
Cynthia Valeriano is a Enterprise Intelligence Developer of at Defontana, with abilities targeted 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 command of implementing knowledge migration and transformation duties with varied AWS instruments, akin to 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 improvement of varied applied sciences targeted on the evaluation of options and buyer necessities. Expertise with AWS in varied providers, together with product improvement by QuickSight for the evaluation of enterprise and accounting knowledge.
Guillermo Puelles is a Technical Supervisor of the “Appia” Integrations crew at Defontana, with 9 years of expertise in software program improvement and 5 years working with AWS instruments. Accountable for planning and managing varied initiatives for the implementation of BI options by QuickSight and different AWS providers.