Connect Dear Inventory to Power BI for Unparalleled Analytics & Planning

Modernize Your Planning & Analytics with our Free Trial Now

Make actionable decisions with Acterys and fast-track your plans and budgets. Changes in data can be modeled in minutes and viewed in real-time, informing you of possible risks and allowing you to simulate what-if scenarios quickly. 

(choose a time)

  • Cloud based data warehouse with your Dear Inventory data
  • Ready made, interactive dashboards & reports in Power BI Desktop and Excel
  • Immediately usable with latest analytics tools like Power BI, Tableau and others
  • Visualizing DEAR Inventory Data in Power BI – The Standard Integration Approach

    Want to harness DEAR Inventory reporting and planning in Power BI? Feeling flustered at the lack of write-back features for modifying inventory and financial data?

    DEAR Inventory lacks an integration interface for Power BI. This means that – aside from incurring annual licensing costs for multiple users – obtaining any transfer of data lies at the discretion of DEAR Inventory’s ‘connector’ to ensure it is configured for migration, integration, and management with Power BI.

    While it’s possible to develop native connectivity in-house, considerable development knowledge and domain expertise is needed to ensure DEAR Inventory, Xero and other integrations for Power BI are fully configured and optimized – making it expensive and time-consuming.

    Problems with Dear Inventory & Power BI Standard Integration Approach

    The limitations of loading DEAR Inventory data into Power BI tables extends beyond a lack of seamless configuration. Instead, data analysts face a host of issues that can impact their time-to-value and insight. These include:

    1. Lack of write-back features to append DEAR Inventory data on-the-go

    Employing data write-back to make changes to Dear Inventory data to effect visualizations in Power BI tables to examine historical data, anticipate future trends, and adjust accordingly is not a possibility. Thus, data analysts and BI professionals face limits in creating what-if scenarios, rolling forecasts, or when making any iterations to reports as needed.

    2. Significant time and costs spent in moving DEAR Inventory Data to Power BI

    Loading any changes in Power BI reports means spending considerable man-hours integrating and transforming DEAR Inventory, Xero, and other siloed data into a central data repository.  The source data would have to be modified using transformations and optimized for the database destination for querying before it can be loaded into Power BI to analyze reports.

    3. Inability to leverage Power BI’s planning, forecasting, and budgeting capabilities.

    Power BI isn’t well suited for visualizing reports for budgeting and financial planning purposes. Dedicated planning and discovery features such as ratios, formulas, KPIs are not prebuilt into Power BI, preventing users from visualizing interactive reports for use-cases such as rolling forecasts, analyzing before and after performance metrics, and much more.


    Integrate Your DEAR Inventory Reports with Power BI in One-Click Using Acterys

    Acterys offers a virtual data warehouse approach to DEAR Inventory-Power BI integration to automate data warehouse generation and build stunning dashboards with built-in planning templates and write-back solutions – all in one.

    1. One-Click Data Visualization Without Moving Disparate, Siloed Data

    Instead of moving disparate, siloed data systems into a central repository, Acterys offers a cloud or on-premises SQL database for out-of-the-box MYOB, DEAR Inventory, and Xero integrations via a virtualized platform, eliminating the need for connector interfaces. The result? No connector and end-user licensing costs.

    2. Ready-to-Use Prebuilt Templates For Planning and Analysis

    DEAR Inventory data financial planning and forecasting in Power BI just got easier; Acterys offers Acterys Apps for DEAR Inventory, Xero and more sources to supercharge your reporting analyses with prebuilt, fully customizable dashboards in Power BI or Excel. You can customize and extend the model exactly to your needs (account mappings, KPI’s, etc). and add nearly any other data source (CRM, POS, Inventory, etc.) on the fly.

    3. A Holistic Data Model for Short Time to Value and Insight

    Reduce build and cycle times by centralizing disparate datasets and applications through various consolidation features such as multi-currency handling and inter company elimination.  This lets you unify multiple disconnected sources without having to integrate and visualize all accounting and financial data in Power BI or Excel under one roof.

    Gain Better Insights of Dear Inventory Reports with Power BI

    Play Video

    ACTERYS is an integrated platform that adds professional financial reporting, planning & consolidation functionality to DEAR Inventory and other solutions. All your requirements in one solution integrated with Power BI & Excel:


    Serious Analytics For Dear

    Acterys Apps for Xero provide you with a professional data model and ready made, fully editable interactive dashboards and reports in Power BI or Excel. You can customize and extend the model exactly to your needs (account mappings, KPI’s, etc). and add nearly any other data source (CRM, POS, Inventory, etc.).


    Stunning Dear Reports & Dashboards

    The Acterys Apps enable you to design interactive dashboards using the market leading data discovery tools (Power BI, Tableau). The Acterys Excel Add-in is the easiest way to build reports, planning and forecasting forms exactly as needed with every detail from your Xero data.

    Gear icon

    Versatile Planning & Forecasting

    Planning and budgeting have never been easier: use extensive options for top/down bottom data entry on any level of the model. Profit from fully editable best practice templates for budgeting, cash flow forecasting, and many other planning aspects.


    Effective Dear Company Consolidation

    Acterys offers the quickest and most flexible way to implement management and statutory consolidation for unlimited Xero companies. Advanced requirements like multi-currency handling, inter company elimination and other consolidation features can be configured exactly as required.

    Customer Testimonials about Dear Inventory & Power BI Integration


    Effective Planning and Modelling with DEAR Inventory Power BI Integration

    Planning and budgeting have never been easier: use extensive options for top/down bottom data entry on any level of the model. Modify structures as required e.g. simulating the introduction of a new product, organizational changes or acquisitions.


    Add Any Source

    In addition to Acterys Connectors to other accounting and SaaS sources the Premium Edition enables you to add any data source the easiest way with the unique Cube Wizard.

    acterys modeller

    Build Your Own Models

    Acterys Apps come with ready made models for reporting, consolidation and planning. For those that have requirements beyond that, the Premium Edition enables you to build your own data models exactly as needed.

    How To Connect DEAR Inventory to Power BI using Acterys?

    After your onboarding session when you have registered at the ACTERYS site, you will see this screen:

    model connector

    Click on “Add Model” to link your Dear Inventory company file with ACTERYS. This process will create cloud-based relational (based on MS SQL Server) and a multi-dimensional data model with your data.

    Linking the accounts should only take a few minutes. For larger models, this can take longer. Once it is finished you will receive a notification at the email address you have specified with your account.

    Blogs related to Power BI Planning & Analytics