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
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
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.
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?
- Jet Analytics data warehouse across seven NAV databases
- Cubes for the team's different analysis needs
- Jet Reports for Excel-based reporting
- Drag-and-drop pivot analysis on OLAP cubes
- Fast query response for more than 300 users
Why clients choose Global Data 365?
- Authorized insightsoftware distributor and Microsoft Partner
- Pre-built content for a fast data warehouse start
- Reporting that finance users own, in Excel
- Implementation without reliance on technical specialists
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.
- A day saved at month-end. The team has already shaved one day off its month-end reporting process.
- Self-service reporting. Users who could not previously produce reports now build what they need in Jet Reports without technical expertise.
- Comparative reports in moments. Reports across date ranges are produced instantly with a drag-and-drop pivot table on the OLAP cubes. This used to take weeks.