Microsoft Power BI

Direction also provides BI solutions using Jet Enterprise, Jet Enterprise is a complete Business Intelligence and Reporting solution based on the Microsoft BI Framework.

In Jet Enterprise, data is pulled from your Microsoft Dynamics GP, NAV or AX ERP system to the Jet Data Warehouse. The Data Warehouse is tuned for Reporting performance, and key information is brought together to make it easy to retrieve information required.

Jet Enterprise out-of-the-box OLAP cubes designed specifically for the Microsoft Dynamics GP, Dynamics NAV, and Dynamics AX databases.

The cube derives necessary data from the Data Warehouse by collecting multiple pieces of data and combining it into several reports that are critical to run your business.

Data is organized for top-level analysis by role or area, combining related data into meaningful metrics.

Direction - Jet Enterprise Features

Each cube includes a comprehensive set of dimensions and measures to provide lightning fast and flexible views of:

  • Finance
  • Sales
  • Purchases
  • Accounts Payable
  • Accounts Receivable
  • Inventory

The Jet Data Manager is a user friendly drag and drop interface that makes updating the data warehouse and OLAP cubes easy, with very limited need for writing lines of SQL code.

The Data Manager works seamlessly with Microsoft SQL Server, MS Analysis Services and Microsoft BI offerings. The key features of the Jet Enterprise Data Manager are:

  • Enhanced SQL Server Analysis Services Feature Support
  • Data Warehouse Types Synchronization
  • Custom Data Import
  • Cube Perspectives
  • Offline Cube Processing
  • Writeback for SSAS Multidimensional
  • Language Control for SSAS Multidimensional
  • Data Compressions
  • Multithreaded Execution
  • Team Development
  • Template Data Sources
  • Multiple Projects
  • Export / Import Projects
  • Data Warehousing
  • Data Staging
  • Data Lineage Diagrams
  • Documentation – Full Printable
  • Multiple Environment Deployment
  • Trace
  • Version Control
  • Data Quality
  • Reverse Engineer Data Warehouse
  • Automated Performance Optimization
  • Data Warehouse Hierarchy Builder
  • Index Creation
  • Lookups
  • Multithreading
  • Table Partitions
  • Time Dimensions
  • Incremental Load
  • Slowly Changing Dimensions
  • Business Functions


5, Brady Gladys Plaza,
1/447 Senapati Bapat Marg,
Lower Parel, Mumbai - 400 013, India

Get in Touch

Email: info@direction.biz
Phone: 91 (22) 6152 5000
Fax: 91 (22) 2491 1046