Building and Deploying a Data Reporting Web Application: Integrating Salesforce, Google Analytics, and Azure Storage with the PERN Stack Technology
Islam, Md Aminul (2025)
2025
All rights reserved. This publication is copyrighted. You may download, display and print it for Your own personal use. Commercial use is prohibited.
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-2025051311117
https://urn.fi/URN:NBN:fi:amk-2025051311117
Tiivistelmä
This thesis focuses on the design, development, and deployment of a data reporting application which facilitates the collection of users data from Salesforce, Google Analytics, and Azure Storage using the PERN stack (PostgreSQL, Express.js, React, Node.js). The project addresses the inefficiencies of manual data reporting processes by introducing an automated system that can ensure scalability, accuracy, and real-time data insights. The implementation is commissioned by Mobimus Oy, operating under Osuria brand, which provides digital secretary services to property management companies.
The application uses APIs to fetch data from multiple sources and displaying it through an interactive dashboard developed with React. The backend, built using Node.js and Express, follows a modular architecture while PostgreSQL stores authentication data to ensure efficiency. The frontend is implemented using React components to provide dynamic user interactions and data visualizations, improving user experience. In terms of secure communication between frontend and backend, JWT is implemented as authentication approach.
By using Docker for containerization and Azure Container Apps and Container registry for cloud deployment, the project highlights modern deployment practices. The Dockerized application ensures consistent performance across development, and production environments while Azure Container Registry and Azure Container Apps provide Perfect Combination for Containerized Application Deployment.
The results demonstrate the practical advantages behind data automation, such as reduced manual workload, and real-time access to the information. The project contributes to a broader understanding of multi-sources REST APIs applied in application development. It highlights best practices in using containerization and cloud services to create scalable and efficient business applications.
The application uses APIs to fetch data from multiple sources and displaying it through an interactive dashboard developed with React. The backend, built using Node.js and Express, follows a modular architecture while PostgreSQL stores authentication data to ensure efficiency. The frontend is implemented using React components to provide dynamic user interactions and data visualizations, improving user experience. In terms of secure communication between frontend and backend, JWT is implemented as authentication approach.
By using Docker for containerization and Azure Container Apps and Container registry for cloud deployment, the project highlights modern deployment practices. The Dockerized application ensures consistent performance across development, and production environments while Azure Container Registry and Azure Container Apps provide Perfect Combination for Containerized Application Deployment.
The results demonstrate the practical advantages behind data automation, such as reduced manual workload, and real-time access to the information. The project contributes to a broader understanding of multi-sources REST APIs applied in application development. It highlights best practices in using containerization and cloud services to create scalable and efficient business applications.