Inventory Analysis using Jet Professional and Jet Enterprise

If you're using the [Inventory Turnover] report from the Jet Reports, Report Player you may be drawing the wrong conclusions because THE REPORT HAS AN ERROR IN IT.

If you use the [Location Code] slicer, you may assume that you're looking at the inventory from THAT location; however, due to the design of the report, you're actually looking at inventory across ALL locations.

Easy solution?  Recreate the report in Jet Enterprise.  

At 40+ minutes, the tutorial is a mini-consulting session!  But if you're strapped for time, I've included hyperlinks that function as chapter markers.

Use Excel's GetPivotData function: https://youtu.be/h2Si6xHmWbw?t=262

Show Calculated Fields in Pivot Tables:  https://youtu.be/h2Si6xHmWbw?t=604

The Inventory Turnover Report IS WRONG:  https://youtu.be/h2Si6xHmWbw?t=781

Building KPIs in Jet Data Manager:  https://youtu.be/h2Si6xHmWbw?t=1107

Visualizing your cubes in Excel #PivotTables:  https://youtu.be/h2Si6xHmWbw?t=1712

When Rollups make your KPIs 'wrong':  https://youtu.be/h2Si6xHmWbw?t=1798

Visualizing your data in PowerBI:  https://youtu.be/h2Si6xHmWbw?t=2293

If this is all greek to you and you want someone to review your existing Jet Enterprise implementation (there's a new update to Jet Data Manager) , give me a holler at jae@onyxreporting.com or shoot us a message through the website.  Our team is available for training, development services and support remotely as well as onsite!