The project
To monitor and optimize the Balloon Management service, a Business Intelligence system was built starting from an ETL flow and the construction of a Data Warehouse. Data is extracted from Salesforce, transformed with SQL Server Integration Services (SSIS), centralized in the DWH (SSAS) and visualized with Power BI.
What it enables
- Assess the effectiveness of marketing strategies
- Support the planning of targeted promotional actions
- An integrated BI system that collects, transforms and analyzes data in a structured way
Reporting
Once loaded into the Data Warehouse, the data is available to the team in Power BI for dedicated reports and dashboards – balloon deadline monitoring, dealer processing times, renewal fees – enabling marketing to make strategic decisions.



