Use Cases

Business Context

For French departments, DMTO (Droits de Mutation à Titre Onéreux) – commonly known as "notary fees" – represent a major part of their revenue, often more than 20% of their overall budget. The Var Department, an attractive area in the south of France, is particularly dependent on this revenue linked to the property market. In a fluctuating economic climate, the ability to anticipate this revenue is crucial for budget planning and investment decisions.

Challenges

• Lack of government forecasts: The government does not provide forecasts or detailed data to anticipate DMTO amounts.
• Volatility of the property market: In a fluctuating economic climate closely linked to property, revenues are difficult to predict.
• Critical budgetary issue: With more than 20% of the budget dependent on DMTO, uncertainty impacts all planning.
• Need for anticipation: Need to secure budget planning and adjust investments.
• Strategic decision support: Inform departmental decisions with reliable projections.

Solution implemented

• Trend curve: Monthly change in DMTO with smoothed trend
• Analysis by property type: Distribution of transactions (< €1,000,000, €200-500K, etc.)
• Transaction volume: Number of transactions per period
• AI prediction: META's PROPHET model for sales forecasting
• Historical data
• Confidence intervals
• Short- and medium-term forecasts
• Map of the Var: Geographical analysis by municipality with colour coding
• Comparative graphs: Gross/refunded amount including VAT vs property value

Key Results

• Visual predictive analysis: Short- and medium-term DMTO revenue projections
• Automation: Automatic updating of forecasts with new data
• Accessibility: Tool can be used without data science skills
• Transformed WebI: SAP WebI becomes a truly intelligent budget dashboard
• Informed public decision-making: Elected officials have reliable projections for their decisions
• Budget security: Better anticipation of tax revenues
• Extension to public policy: Management of RSA and childhood policies using the same technology

Business Contexte

The American Red Cross is one of the largest humanitarian organisations in the world. With a presence throughout the United States and numerous regional offices, it manages massive fundraising campaigns to finance its disaster relief operations. The organisation relies on SAP BusinessObjects and has existing donation universes containing complete contribution histories. Field staff, who are often mobile, need access to performance data from any device.

Challenges

• Attractive dashboards: Create modern visualisations from existing donation universes.
• Facilitate analysis: Speed up decision-making for fundraising teams.
• Mobility: Make data accessible to mobile staff in near real time.
• Cost control: Achieve these objectives without additional SAP BusinessObjects licence costs.
• Integrated mapping: Track territorial coverage and the performance of remote offices
• Field visibility: Improve responsiveness in the field

• N4V Maps: Intuitive analysis by region, state and office with Google Maps functionality
• Drillable widgets: Analysis of donations by marital status, race and gender
• Time series graphs: Donation trends over 6 months
• Export and navigation: Home, Search, Location, Download and Reset buttons

Key Results of the POC

• Mobile accessibility: Collection staff can access responsive HTML dashboards on any device.
• Segmented analysis: Fundraising efforts can be analysed by marital status, race and gender.
• Intuitive geographical analysis: N4V maps allow drill-down by region, state and office.
• Google Maps integration: All native mapping features are available.
• No additional licensing costs: Solution deployed without additional SAP licences.
• Improved field responsiveness: Better visibility for remote teams.

Business Context

UGAP (Union des Groupements d'Achats Publics) is France's leading public purchasing group. The figures speak for themselves: Nearly €7 billion in annual purchases managed 20,792 public sector customers 1.6 million products available Customer breakdown: Local authorities: 35% Ministries: 28% Public institutions: 16% Healthcare: 14% Funds and companies (social security funds, private institutions): 7% Every day, thousands of orders are processed and consolidated into a considerable volume of data.

Challanges

• In this context, UGAP's customers had high expectations:
• More interactive reporting: Enabling customers to explore their consumption data
• Customisation: Offering views tailored to each establishment
• Accessibility: Making data usable without technical expertise
• Clear vision: Providing a usable overview of expenditure, suppliers and market performance

Solution implemented

• The Dynamic Customer Dashboard developed with N4V FOR WEBI offers a comprehensive experience:
• Key features of the solution:
• ✅ Macro and detailed view: From the big picture to the details in just a few clicks
• ✅ Interactive dimension: Intuitive filters and drill-down
• ✅ Daily updates: Data updated every day
• ✅ Accessibility at all times: Available 24/7 via the UGAP portal
• ✅ Year-on-year comparison: Comparison of purchases between years
• Dashboard modules:
• Consumption: Purchase tracking by establishment
• Economic footprint: Territorial impact of purchases
• Quality of service: Supplier performance indicators
• Statistics: Detailed analyses
• Interactive map of France: Geographical distribution of purchases (e.g. £918,478 for a typical department)

Key Results

• ✅ Improved customer satisfaction: Customers have a real management tool at their disposal.
• ✅ Enhancement of UGAP data: Data made usable without technical expertise.
• ✅ Time savings: Automated reporting for internal teams.
• ✅ Leveraging transparency: Increased visibility on public procurement.
• ✅ Increased loyalty: Reporting becomes a value-added service
• ✅ Intuitive navigation: Immediate adoption without training

📋 Business Context

A large French distribution network, with hundreds of points of sale across the country, needed to modernise its sales management. Regional managers needed to be able to monitor the performance of their stores and make quick decisions to adjust sales activities. In an industry where responsiveness makes all the difference, having a consolidated and up-to-date view of sales is a major competitive advantage.

Challenges

• Data centralization: Consolidate sales data from all stores in real time
• Year-over-year comparison (YoY): Compare current performance with the previous year
• Rapid detection: Quickly identify underperforming regions and/or stores
• Decision support: Provide regional managers with a tool to adjust and optimize sales actions
• Easy adoption: Deliver a user-friendly dashboard requiring little to no training

Solution implemented

• Interactive sunburst: Revenue breakdown by region and sector with drill-down
• N vs N-1 chart: Visual comparison of revenue by region (year-over-year)
• Dynamic France map: Revenue trends by region/department with color coding
• Scrollable detailed table: By sector, store, and city, including Margin vs N-1, YTD, Revenue trend, Margin
• Store map: Store locations with performance trends by point of sale
• Filters: Selection by Regional Management / Sales regions (DR/CSR)

Key results

• 10-second detection: Instantly spot underperforming regions
• Full drill-down: Zoom into a specific sector, state, or store
• Trend identification: Detect stores showing negative trends vs last year
• Near real-time responsiveness: Quickly adjust sales actions
• Zero training required: Intuitive interface adopted immediately
• High adoption rate: Widely used by regional managers

📋 Business Context

d2i (Data to Intelligence) is a company specialising in supporting healthcare organisations. Its mission is to accelerate the implementation of strategic performance improvement initiatives by enriching EHR (Electronic Health Record) data to make it usable. The company provides productivity and quality analyses to healthcare institutions, enabling them to measure physician performance and optimise their operations.

⚠️ Challenges

• d2i faced several major challenges:
• Inefficient distribution: Hundreds of PDFs sent by email each month for reports and analyses
• Lack of interactivity: Static PDFs did not allow users to explore their data
• Limited visualisations: Need to provide better visualisations to customers
• Budget constraints: Need to improve service without increasing SAP BusinessObjects licence costs

✅ Solution Deployed

• The transformation took place in several stages with N4V FOR WEBI:
• Solution evolution:
• ✅ Beta version: Use of N4V filters and scrollable tables
• ✅ Final version: Complete dashboard with N4V Widgets
• Key features of the new dashboard:
• ✅ Multi-hospital filters: Selection by institution (All Hospitals, General Hospital 1, 2, 3, 4, etc.)
• ✅ Selection by doctor: Dropdown filter by Physician ID
• ✅ Time series graphs: 6-month trends with integrated sparklines
• ✅ Distribution via HTML link: Replacing PDF emails with a simple link

Key Results

• The switch to N4V dashboards has generated measurable benefits:
• ✅ Controlled licence costs: SAP BusinessObjects costs kept at a fixed level
• ✅ Responsive HTML search and filtering: Users explore their data independently
• ✅ Simplified distribution: A simple email link replaces hundreds of monthly PDFs
• ✅ Significant time savings: Information obtained in seconds instead of minutes spent analysing static PDFs
• ✅ Commercial efficiency: The d2i solution has become more attractive to customers
• "Interactive data visualisation allows information to be obtained in seconds instead of spending minutes analysing static and cumbersome PDFs."

📋 Business Context

Building a cruise ship involves coordinating over 2,000 suppliers, managing 50+ million components, and tracking thousands of workers across multi-year projects. The BI team needed to provide real-time project status, resource allocation, and quality metrics to stakeholders at all levels.

⚠️ Challenges

• Complex Gantt charts impossible with standard WebI
• No geographic visualization for global supplier network
• Static reports couldn't show real-time project progress
• Executives needed mobile access to key project KPIs

✅ Solution Deployed

• N4V Widgets for interactive Gantt charts and project timelines
• N4V Maps for worldwide supplier and logistics visualization
• N4V Analysis for drill-down from ship-level to component-level
• N4V Publisher for automated stakeholder reporting

📋 Business Context

McKesson manages pharmaceutical distribution for over 40,000 pharmacies and healthcare institutions. Their BI team needed to deliver real-time inventory tracking, predictive analytics for drug demand, and compliance reporting across multiple regulatory frameworks.

⚠️ Challenges

• Standard WebI charts couldn't handle multi-dimensional pharmaceutical data
• No interactive drill-down capabilities for supply chain analysis
• Compliance reports required manual consolidation from multiple sources
• Mobile access was limited for field representatives

✅ Solution Deployed

• N4V Widgets for advanced visualizations, interactive drill-down and filters
• N4V Maps for geographic distribution network visualization
• N4V Publisher for automated compliance report distribution