Projects/Novartis: Business Intelligence Platform (SIGMA)
Novartis: Business Intelligence Platform (SIGMA)
Pharmaceutical industryFarmaNovartis

Novartis: Business Intelligence Platform (SIGMA)

Impact in numbers

+30%

efficiency in data analysis

40%

reduction in reporting time

90%

Visibility of main KPIs for performance and commercial impact

Problem

Novartis needed to consolidate sales and medical segmentation data from dispersed sources to obtain a unified view and make strategic decisions based on reliable data.

Strategy

A data warehouse was designed in Google BigQuery and dashboards were developed in Power BI. Data models were implemented for YTD/YTG projections and territorial coverage analysis.

Enterprise BI
Data Governance
Scalability

Results

The SIGMA platform provides sales and marketing teams with real-time actionable insights, improving the planning and execution of commercial and medical strategies.

Services

Business IntelligenceData WarehouseExecutive DashboardsAnalytics & Tracking

Technologies

Google BigQueryPower BINode.jsTypeScript

Should we build something like this for your business?

Tell us your goal and we will propose a clear path to create measurable impact.

IA