Solver
Enabling World-Class Decisions
Looking for BI360?
At the start of this year, BI360 became Solver.
All of the same content and features under a new name.
Reporting
Use the Excel-based reporting engine to design custom reports combined with the power of Excel. The best part? No code needed, everything is provided to you via a drag-and-drop interface. Connect to your data directly or to the built-in data warehouse.
Planning
Effortlessly create and manage budgeting, forecasting, and what-if scenarios. Store your data back into the Data Warehouse and report on it alongside other scenarios and your actuals.
Dashboards
Power BI connects natively to the Solver Data Warehouse and extends the platform with a best-in-class data visualization solution.
Data Warehouse
The Solver suite includes a native Data Warehouse with a pre-defined format optimized for reporting and with numerous additional insights to your users and also protect your data from prying eyes.
Reporting
Solver Reporting makes it easier than ever before to design reports and interact with your data. Design virtually any type of report imaginable and finally get the real insights into your data that you’ve been looking for.
Multiple Ways to Report!
- Report directly from your ERP solution live and in real-time! Take a look at some of Solver’s pre-built integrations here
- Prefer to house everything under one roof? Solver’s got you covered! House all your entities and solutions and report on all your data – everything under one roof with Solver’s data warehouse!
- Run your reports directly in Excel, in your Solver portal, publish them, or schedule them for delivery
Excel-based
- Solver’s reporting solution is provided as an Excel add-in – no need to learn other tools or software
- Report generation in Excel allows your finance and accounting team to work on a platform they already know
- Utilize Excel formulas, formatting, and other features alongside Solver reporting functionality to take your reports to the next level
Clicks, Not Code
- No coding required!
- Solver’s Excel add-in provides all of the necessary functionality in easy-to-use drag-and-drop menus
- Easily accessible which allows for users to self-serve ad-hoc reporting
- Design time from new report requests to validation and publishing reduced dramatically from typical analytics architectures Dramatically reduce design time for new reports – from request to validation and publishing – compared to other analytics architectures
Planning
There has never been a better time to have a budget.
Solver’s planning module expands your reporting capabilities, and allows your users to store input data, such as budgets, back into the data warehouse.
- Easily create an unlimited number of scenarios in which to store budgets or other data
- Compare this data side-by-side with your actuals or operational data
- Budget against general ledger, subledger, and operational figures
- Budget at any level of granularity, detail, or time period
- Automated budget spreading and line-item detail capabilities
- Built-in Review and Approval workflow engine
1. Set Budget Parameters
2. Enter Forecast
3. Review & Comment
4. Forecast Or Compare
Dashboards
Getting an overview of your data is quick and easy with Solver’s Power BI Integration. Using Power BI’s intuitive, drag-and-drop simplicity, you can customize your data and create dashboards on the fly with pre-defined widgets and modules.
Data Modeling made Simple
- Removes one of the most difficult steps in utilizing Power BI – building a data model
- Connects directly to the Solver data warehouse and inherits the data structures
- The same data structure means making dashboards in Power BI uses the same configuration as your data warehouse for simplicity and ease-of-use
- Connect Power BI to your data warehouse with just a few clicks
- Embed your dashboards and tiles directly in the Solver reports
Drag, Drop, Done
- Dashboards are created specifically for business users and do not require advanced levels of technical expertise
- Users can quickly learn how to build their own custom dashboards using Power BI
- Drag and drop controls mean there is no coding required. Simply select the data needed and drag and drop the control onto the dashboard
Insight, not Hindsight
- Power BI dashboards offer insights into your business that are comprehensive and easy to understand
- Visualize trends, identify issues, and analyze your data
- Set up sliders as inputs to your models and simulate cashflow, sales, and more in real time
- Display your organization’s metrics and KPIs in bold, interactive ways such as charts, scorecards, flow diagrams, maps, and more!
No-Coding needed, Fast, Drop & Drag report builder.
Data Warehouse
Curious about Solver’s Data Warehouse?
- Cloud and On-Premise Versions
- Hybrid Cloud Reporting for users of Dynamics GP
- Bespoke Data Warehouse deploys in days or weeks instead of traditional data warehouse deployments of months to years
- Combine your financial and operational data
- Great for multi-entity consolidation
- Load your data from each of your solutions into one location- create reports as if they were a single solution
- Easy clicks-not-code data warehouse administration
- Create and use unlimited reporting trees
- Configurable to your custom general ledger, business terminology, fiscal periods, currency rules, business rules, and more!
See some of our Pre-Configured Connectors
FAQs
What is a data warehouse?
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.
What happened to BI360?
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.
What is a fact or fact table in data structures?
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.
I’ve also heard the term “module”, what’s that?
In Solver, module and fact are interchangeable terminology. See the above.
What are dimension tables?
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.
Can dimension tables be shared across multiple fact tables?
Yes, Solver allows dimension tables to be shared across multiple fact tables.
Does Solver integrate with Microsoft Power BI?
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)
Will we have to create our own data structures?
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.
Can we connect to or get data from other data sources?
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.
Is this a cloud or on-premise solution?
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 I get the cloud version, will it talk with my on-premise ERP solution?
What Our Clients
Are Saying
“It's been a great blessing to have UniverseIT handle all our IT needs. Their technical know-how coupled with their excellent customer service is unparalleled.”
Kenneth Omoruyi
CPA
“UniverseIT guided the implementation of our Student Information System. We had tried to implement a different SIS on our own with poor results. UniverseIT were truly expert guides. They are what you expect from an IT resource, competent and responsive. But more than that, they are genuinely good folks who care about their customers. They let us know from the beginning that they were there to help us with any of our IT concerns and they have! I would highly recommend them and give them six stars if I could.”
Bob Stephens
The Opened Bible Academy
“We have worked on several projects over the last 3yrs with the team at UniverseIT. Working in marketing, we often need to collaborate with the IT teams to make sure things work together the way they are supposed to. The UniverseIT team has been the most knowledgeable IT team I have worked with. I recommend them to all my clients that need IT/ Business Intelligence solution in place for their business that really work.”
Scott Cole
Lovewell
“UniverseIT did a great job in getting our back office infrastructure up and running and allowed us to focus on our core priorities. When we needed engineering help that wasn’t in there area of expertise, they referred us to a partner that turned out to be an ideal fit. It’s unique to see a company help in this way. They are responsive, supportive and understand how to help you manage your IT cost. Highly recommend them!”
Stephen Chaney
Forbie
“We are lucky to have UniverseIT as a partner in growing our business! It's such a pleasure working with them. Aside from the quality of service they provide, they offer great solutions for working out customer needs and requirements. We value the inputs they give as well for improving our product. All I can say is we're happy to be working with these guys and we highly recommend being in business with UniverseIT!”
Patricia Esmaquel
Classe365
“I initially contacted UniverseIT over two years ago to get an idea on the type of services they offer. From that time to a few months ago, I have contacted Joe and met with him on many occasions to get his feedback on my startup company's needs and services that his company provides. What I gather from these meetings is that he is truly looking out for the best interest of my business and IT needs. Furthermore, his staffs are great to work with. These are the reasons why I sign up with Universal IT a few months ago as my IT partner moving forward with my startup business.”
Benito Aguilar
Atilar Pharma
“Joe is the CEO and for such a huge company I can really appreciate that he is still hands on! My company has been a loyal client for over 3 years now!”
Alex Miller
Alex Miller Credit Repair
“Been a customer of UniverseIT for a few years. Amazing customer service. Recommend their services 100%!”
Vicky di Colloredo-Mels
EdSaber
Contact Us Today!
WANT TO SKIP ALL THE TECH TALK?
Schedule a Call