Automated Excel-Based FP&A Solution

The platform is an innovative financial planning and analysis (FP&A) solution designed for Excel users seeking to leverage automation in their financial processes. It streamlines data collection, analysis, and reporting while allowing finance professionals to work within their familiar Excel environment

Financial Planning
Analysis
Automation
Excel
Data Collection
Python
Back-end development

Customer

industry
Finance
region
Israel
client since
2021

Our client is a multinational software development company. It offers financial planning and analysis (FP&A) platforms for Microsoft Excel users.

Detailed information about the client cannot be disclosed under the provisions of the NDA.

Challenge

The primary challenge was to design and implement a comprehensive and dynamic backend for the financial planning and analysis dashboard. The client required real-time updates, a diverse range of graph displays, and advanced data sorting, filtering, and aggregation functionalities. All these features needed to be integrated seamlessly to handle complex financial data and generate detailed reports automatically.

Solution

In response to the client’s requirements for an intricate and detailed financial planning and analysis (FP&A) solution, our team assumed a comprehensive set of responsibilities geared towards developing an exceptional back-end infrastructure. This included the creation of a sophisticated financial dashboard and much more.

A significant portion of our task entailed the development of a system for real-time data processing and updates. With the continuously evolving nature of financial data, this was critical for maintaining the relevance and accuracy of the dashboard’s array of data visualization elements, which included column, waterfall, stacked column, bar, stacked bar, table, combo, and pie charts.

Another substantial responsibility we undertook was the design and development of a fully functional online Excel editor. This unique tool allowed users to upload, edit, and store Excel files online, removing the need for cumbersome email attachments or file transfers.

A key aspect of the project was the creation of an automated report generation and delivery system, designed to deliver periodic reports to specific email addresses. This ensured consistent updates and reduced the manual effort required for report generation.

We also developed an advanced data management system that incorporated the ability to sort, filter, and aggregate data. We incorporated time-based filters like YTD, YTG, MTD, and MTG, allowing users to undertake more comprehensive and detailed data analysis based on specific timeframes.

One of the critical tasks was to implement an access control system to the dashboard. This regulated user access based on predefined access rights, thus enhancing data security.

Furthermore, we took on the essential responsibility of facilitating seamless integration with the client’s existing workflows and systems. This involved creating a series of APIs, implementing custom business logic, and maintaining system stability and performance under high load conditions.

In conclusion, our team not only developed a dynamic and secure back-end infrastructure that supports an interactive financial dashboard, but also successfully delivered a full-scale FP&A solution. This facilitated improved decision-making and operational efficiency for the client, thereby meeting their specific business needs and surpassing their expectations.

Results

By focusing on the backend development of the dashboard, our team has successfully contributed to the creation of a highly functional and dynamic financial planning and analysis tool. The solution provided businesses with real-time data analytics capabilities, diverse graph displays, and advanced data management functionalities. This enhanced their decision-making process, as they could now access up-to-date financial information, perform complex analyses, and generate detailed reports swiftly and accurately. The solution thus significantly improved the efficiency of their financial planning and analysis tasks.dfgdfd

45M

dollars raised

120

new clients per year

Team

8

Back-end engineers

2

Fullstack engineers

1

Dev-ops

Technology stack

backend

Python
Django
Django REST Framework
Celery
RabbitMQ

Dev-ops

Docker
Docker-compose
Kubernetes
Terraform
CircleCI

Platforms

Microsoft Azure