deFacto Business Modeler

deFacto Global Business Modeler Logo

Every deFacto Power Planning xP&A solution addresses a specific customer need. The specifications for solutions are reflected in deFacto Models, essentially SQL Tabular Models. Building Tabular Models typically requires the use of complex, technical tools designed for developers, like Visual Studio Enhancing these models like adding hierarchies to any dimension, or adding financial intelligence to models, adds another layer of difficulty to the process.  

deFacto Business Modeler addresses all those challenges. Using its easy to use, drag and drop interface, non-technical users can quickly create any type of financial or operational tabular model, from simple to complex These models can even be used with Power BI, Power Apps and other applications. 

All The Features You Need. Simple, Easy To Use, Fast Results.

deFacto Business Modeler - Tabular Models for Power BI


Combined with custom account hierarchies, you can easily report and analyze data across multiple chart of accounts.   

Easy Integration

Reports can be created and deployed using Power BI, Power Apps, Pivot Tables, Excel or any tool that can consume SSAS tabular data. 

deFacto Business Modeler - Tabular Models for Power BI

How Does It Work?
It's Easy As 1-2-3!

Once deFacto Business Modeler is installed, a tabular model is built by using an easy to use, drag and drop dimension manager where dimensions can be combined into the tabular model.

Next, data can be loaded directly to the model through the Data Load interface via .xlsx or .csv files.

If further calculations are needed, Custom Measures can be created via deFacto Business Modeler’s interface using DAX.