Jet Analytics Case Study: How IKEA Kuwait Consolidated 7 Dynamics NAV Databases

This Jet Analytics case study shows how the finance team at IKEA Kuwait replaced monthly Excel stitching with one data warehouse built on Jet Analytics and Jet Reports. The result is a faster month-end close, self-service reporting for more than 300 users, and one version of the truth for financial reporting.

IKEA Kuwait case study

The challenge, solution and results on one page for you to review.

What IKEA Kuwait achieved with Jet Analytics

Six outcomes from consolidating seven Dynamics NAV databases into one governed data warehouse and cube layer.

Seven databases, one warehouse

Data from 7 Dynamics NAV databases consolidated in one place

Self-service reporting

Finance users build reports in Excel with Jet Reports

Comparisons in moments

Date-range comparisons that took weeks are now instant

Sub-second queries

Cubes support team’s different analysis needs

300+ users served

Fast query response for the whole user base

A day saved at month-end

Month-end reporting shortened by one day

From manual Excel stitching to a single version of the truth

The challenge. To produce financial and management reports, IKEA’s finance team in Kuwait had to combine data from seven Microsoft Dynamics NAV databases. They exported data from each system and stitched it together in Excel every month, repeating the work from scratch each time.

 

The solution. Global Data 365 deployed Jet Analytics and Jet Reports. Jet Analytics provided pre-built content, so IKEA could create a data warehouse quickly. It also provided multiple cubes with sub-second query response times. With Jet Reports, finance team members used their existing Excel skills to build the reports they need directly from the data warehouse.

jet analytics case study ikea

Solution coverage at a glance

Jet Analytics consolidates multiple companies and databases into a single data warehouse. Jet Reports lets finance users build and refresh Excel reports on top of it, without technical specialists. See the full Jet Analytics cubes for Dynamics 365 Business Central and NAV.

What was delivered?

Why clients choose Global Data 365?

See Jet Analytics running on your Dynamics data

Book a 30-minute session with our Jet Analytics team. We will show how Jet Analytics and Jet Reports would consolidate your Dynamics NAV or Business Central data.

The Results: Faster close and a single version of the truth

The finance team at IKEA Kuwait now works from one reliable data source instead of exporting and stitching data by hand.