How WonderChef Unified Historical Dynamics NAV and Business Central Data into a Single Power BI Reporting Suite

LocationIndia

SolutionUnified Power BI Analytics Consolidating Dynamics NAV & Business Central

1 Single

Unified Reporting Pane (Zero Dual Logins)

100%

Historical NAV & Live BC Data Blended

35%

Inventory Turnover & Run-Rate Optimization

At-a-Glance

WonderChef - India’s leading premium cookware and kitchen appliance brand founded by Chef Sanjeev Kapoor, selling through omnichannel retail and e-commerce.

Case Study

CHALLENGE:

Following migration from on-premise Microsoft Dynamics NAV to cloud Dynamics 365 Business Central, staff still required continuous access to multi-year historical NAV records. Dual logins caused workflow friction, and fragmented datasets hindered executive decision-making.

SOLUTION:

Intelegain developed an automated Power BI reporting architecture consolidating historical NAV SQL databases with live Business Central cloud data, delivering unified Sales Register and Inventory Run-Rate dashboards without dual logins.

RESULTS:

Eliminated dual ERP logins, unified multi-year sales and SKU performance metrics, accelerated executive reporting from days to real-time, and optimized inventory holding across retail channels.

The Challenge: Post-ERP Migration Reporting Friction and Data Silos

WonderChef is one of India’s most celebrated consumer appliance brands, distributing premium cookware, air fryers, and kitchen electronics across thousands of retail outlets, direct-to-consumer (D2C) web stores, and major marketplaces like Amazon and Flipkart.

To support rapid national expansion, WonderChef migrated its core operations from on-premise Microsoft Dynamics NAV to Microsoft Dynamics 365 Business Central in the cloud. However, post-migration reporting presented a severe operational challenge: years of historical sales transactions, customer buying trends, and supplier ledgers remained locked inside the legacy NAV SQL database.

Management, sales directors, and supply chain planners were forced to maintain dual logins - constantly switching between legacy NAV and modern Business Central to compare year-over-year revenue, category growth, and distributor performance. Manually extracting and stitching together CSV exports took days, introducing calculation discrepancies and paralyzing strategic decisions.

Operations and finance teams forced into dual logins across legacy NAV and modern Business Central.

Inability to conduct seamless multi-year comparative sales analysis without manual spreadsheet reconciliation.

Lack of real-time inventory run-rate visibility, risking stockouts in high-velocity retail channels.

Delayed monthly executive reporting hindering rapid procurement and promotional campaign planning.

Why Intelegain Was Chosen

WonderChef selected Intelegain due to our dual expertise in legacy Microsoft Dynamics NAV, modern Business Central cloud architecture, and enterprise Power BI data modeling.

Automated Cross-Platform ETL Pipelines:

Building automated data pipelines that extract, transform, and merge on-premise NAV SQL records with cloud Business Central telemetry into unified semantic models.

Specialized Sales Register Reporting:

Engineering comprehensive analytical models dissecting sales performance across retail channels, regional distributor tiers, product categories, and individual SKUs.

Predictive Inventory & Run-Rate Analytics:

Constructing real-time inventory dashboards that evaluate monthly sales velocity against current warehouse stock to prescribe optimal reorder points.

Zero Dual-Login Friction:

Providing a single, role-based Power BI workspace accessible from desktop, web, and mobile without requiring legacy NAV credentials.

Implementation: The Intelegain Approach

Intelegain engineered and deployed the unified reporting platform over 10 weeks:

Phase 1: Database Extraction & Schema Harmonization

Intelegain extracted and cleansed 5+ years of historical transactional data from the legacy Dynamics NAV SQL database. We mapped legacy charts of accounts and item master codes to the new Business Central schema.

Phase 2: Power BI Semantic Modeling & Sales Register Reports

We constructed the unified Power BI semantic model using DAX. We built the comprehensive Sales Register report - enabling leadership to analyze multi-year sales trends, channel margins, regional distributor performance, and seasonal peaks in real time.

Phase 3: Inventory Run-Rate Dashboards & Executive Deployment

We developed dynamic Inventory Reports visualizing stock levels across central and regional distribution centers. Automated alerts highlight slow-moving inventory and predict stockout risks based on historical velocity.

Microsoft Power BIDynamics 365 Business CentralMicrosoft Dynamics NAV (SQL Server)Power BI DataflowsDAX Data ModelingAzure Data Gateway

Measurable Results & Business Impact

1 Pane

Unified single-pane reporting workspace replacing dual ERP system logins

100%

Seamless blending of multi-year historical NAV and live Business Central data

35%

Optimization in inventory holding efficiency and regional warehouse turnover

3 Days → 0

Reduction in monthly sales consolidation time (now instantaneous)

The Power BI reporting platform completely resolved WonderChef’s post-migration data fragmentation. Executive leadership, sales heads, and procurement directors now operate from a single, authoritative source of truth. With multi-year trend analysis and real-time inventory run-rate visibility, WonderChef optimizes production schedules, executes targeted retail promotions, and accelerates omnichannel revenue growth.

Struggling with fragmented reporting across legacy systems and new ERP deployments?

Discover how Intelegain can build unified Power BI reporting models that blend legacy and modern data seamlessly.

Start A Conversation