eBECS Power BI Accelerator for Microsoft Dynamics AX 2012 (Old)

The eBECS Power BI Accelerator is a ‘quick-start’ solution that sits within Microsoft Power BI.

It provides eBECS customers with instant and user-friendly access to the data that resides within Microsoft Dynamics AX2012. It can be easily extended to include a wide selection of data sources, including NAV, CRM Online, Excel as well as Big Data Sources including the Internet of Things.

The eBECS Power BI Accelerator speeds up the process of creating Power BI content for Microsoft Dynamics because it includes pre-designed management dashboards that display detailed, accurate and insightful business information on one single-page.

Manage your data effectively

Many Business Intelligence solutions have proved to be complicated to implement, heavy on manpower and therefore expensive. They often require specialist ‘middleman’ skills to extract and deposit data into data warehouses, which is then presented to Business Intelligence tools to dissect and display on corporate dashboards. The whole process can be very time-consuming and the results are not always satisfactory or helpful. 

The eBECS Power BI Accelerator is different. The data modelling tool gives users the ability to create data structures directly within Microsoft Dynamics AX. The models are then used to provide real-time, direct access to the live data that actually sits on-premise. It works out-of-the-box with easy-to-understand content created by eBECS to optimise its customers’ experience. Users can instantly build and view their own reports and make business decisions with complete confidence the data is accurate, current and uncorrupted.

The eBECS Power BI Quick Starter is designed to work out-of-the-box. However, if it does not deliver precisely what is required, then every element of the solution can be extended and built-out to meet the users’ needs in a simple, easy-to-use toolset.

The business benefit

With the eBECS Power BI Accelerator you can:

• Visualise and analyse all your data in one place, with complete confidence of its accuracy
• Stop searching for data, and instead explore its potential through a drag-and-drop canvas
• Transform ROI by discovering and acting quickly upon real-time data
• Publish reports and financial packs by role and function
• Build and share interactive dashboards
• Combine multiple data sources
• Build custom data models from on-premise and cloud data.

eBECS Rapid Return Dynamics Dashboard

The eBECS Power BI Accelerator dashboards are designed for nine distinct management roles and each dashboard sits on one compact page, effectively providing all the information a manager needs in one “just one pane of glass”. 

The out-of-the-box dashboards comprise:  

• CEO Dashboard
• CFO Dashboard
• Account Receivable Manager Dashboard
• Account Payable Manager Dashboard
• Purchasing Manager Dashboard
• Production Manager Dashboard
• Sales Manager Dashboard
• Sales Rep Dashboard
• Delivery Performance Dashboard.

Examples of the CEO and CFO dashboards are shown below. The solution can of course be adjusted and updated at a later date to complement the business requirements according to role and responsibility.

The eBECS Design and Modelling tool (eDM)

The eBECS design and modelling tools have been developed specifically for the eBECS Power BI Accelerator. They provide a simple GUI-based design tool that can produce Data Marts, which in turn are used by the Power BI visualisation tools to transfer information to the dashboards. This aspect of the solution provides the greatest value because it takes away the complexity of provisioning data so that the data can be accessed directly via eBECS Power BI Accelerator.

Getting started

To progress there are three prerequisites:

• Access to a Power BI Pro License – this is required to allow users access to up-to-date data from an on-premise application
• A SQL Server BI or Enterprise Instance – this is required because the Rapid Return Dynamics Dashboards are refreshed from an On-premise SQL Server Analysis Services Tabular model
• Access to the eBECS Design and Modelling tool – this is a required element of the solution as it provides the Dynamics AX data, which is ultimately presented in Power BI.

To purchase this solution or to request a personal demonstration of the product please contact your account manager or click on the Contact Us section at the top of this page.