A data warehouse, or DW, is a database in which we store data from multiple solutions side-by-side. In addition, all data entering the warehouse is transformed into a format that is optimized for reporting. For more detail on what a data warehouse is and what it allows us to do, please check out [link to article] this article.

BI360 simply rebranded the product suite to match the company name. BI360 is now Solver, and has all of the same features and value, just under a new name.

A fact is a value or measurement that represents a meaningful data point regarding a specific activity within the organization. Facts can include individual transactions such as sales or payments, or aggregated data such as account balances or inventory stock levels. Typically, your transactional data or “what happened” is answered by facts.

In Solver, module and fact are interchangeable terminology. See the above.

Dimension tables store lists of objects or things like customer, natural GL account, projects, etc. Often, instead of storing all of the details of a transaction with a customer in a single table, the customer’s details are kept in a separate table. When a transaction occurs with that customer, the transactional or fact data simply just notes down for which customer that transaction occurred instead of entering all of their data again.

Yes, Solver allows dimension tables to be shared across multiple fact tables

Solver uses an API and a Power BI connector to extend your data warehouse and bring your data to Power BI reports and dashboards seamlessly. See more here (link to the dashboard detail section of this page)

No, Solver’s data warehouse has a pre-defined data format and if you are connecting to one of the many systems that have native integrations, this will be done for you. If not, it’s simple to just add new fields to your fact and dimension tables.

Absolutely! The Solver data warehouse can be extended to encompass data from many other sources. The best part is that all of the data in your data warehouse can be reported on as if it were from one system.

Currently both! Solver v5 is primarily geared towards being a cloud solution but does offer an on-premise installation for those who need it. We don’t recommend it unless you have a good reason though!

If you use Microsoft Dynamics GP or NAV then yes! Solver has a new hybrid-cloud reporting solution that allows it to interface with your on-premise GP or NAV installation.