ONYX REPORTING LTD.
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
Search

Inventory Analysis using Jet Professional and Jet Enterprise

15/8/2017

0 Comments

 
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!
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Profile Picture Jae Wilson
    View my profile on LinkedIn

    Stay Informed.

    * indicates required

    RSS Feed

    Categories

    All
    Automation
    Basic Training Series
    Business Intelligence
    Connect
    Dashboard
    Data Pipeline
    Data Science
    Domo
    Excel Tricks
    Executive Training & Leadership
    Extract
    Jet Enterprise
    Jet Essentials
    New Release
    NP Function
    Onyx Reporting
    Planning
    Power Pivot
    Python
    Report Writing
    Statistics And Analytics
    TimeXtender
    Visualization

London, UK
jae@OnyxReporting.com
+44 747.426.1224
Jet Reports Certified Trainer Logo
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters