What users are saying about

Adaptive Insights

Top Rated
204 Ratings

Microsoft BI

593 Ratings

Adaptive Insights

Top Rated
204 Ratings
Score 8.7 out of 101

Microsoft BI

593 Ratings
Score 7.8 out of 101

Add comparison

Likelihood to Recommend

Adaptive Insights

It is very helpful for budgeting and reporting. I love how easy it is to automate reports and presentations. It can be more difficult to plan specific activities. It feels more high-level than activity-level. It shows totals rather than individual transactions (either past or future transactions).
Mark McConkie profile photo

Microsoft BI

Visualization of business data: it's good, fast, and cheap. What more can you ask? With more specialized visualization needs, use Tableau or write code. For complex scientific visualizations, write code.It's also so much easier communicating about the tool and its visuals to other people who don't spend their lives analyzing complex data. "It's Excel for Big Data!" is really quite simple.
Alexander Lubyansky profile photo

Feature Rating Comparison

Budgeting, Planning, and Forecasting

Adaptive Insights
8.7
Microsoft BI
Long-term financial planning
Adaptive Insights
8.9
Microsoft BI
Financial budgeting
Adaptive Insights
8.9
Microsoft BI
Forecasting
Adaptive Insights
9.1
Microsoft BI
Scenario modeling
Adaptive Insights
8.3
Microsoft BI
Management reporting
Adaptive Insights
8.2
Microsoft BI

Consolidation and Close

Adaptive Insights
7.5
Microsoft BI
Financial data consolidation
Adaptive Insights
7.9
Microsoft BI
Journal entries and reports
Adaptive Insights
5.5
Microsoft BI
Multi-currency management
Adaptive Insights
7.7
Microsoft BI
Intercompany Eliminations
Adaptive Insights
7.5
Microsoft BI
Minority Ownership
Adaptive Insights
7.0
Microsoft BI
Local and consolidated reporting
Adaptive Insights
8.3
Microsoft BI
Detailed Audit Trails
Adaptive Insights
8.6
Microsoft BI

FInancial Reporting and Compliance

Adaptive Insights
8.3
Microsoft BI
Financial Statement Reporting
Adaptive Insights
9.0
Microsoft BI
Management Reporting
Adaptive Insights
8.6
Microsoft BI
Excel-based Reporting
Adaptive Insights
8.5
Microsoft BI
Automated board and financial reporting
Adaptive Insights
8.5
Microsoft BI
XBRL support for regulatory filing
Adaptive Insights
6.9
Microsoft BI

Analytics

Adaptive Insights
7.6
Microsoft BI
Personalized dashboards
Adaptive Insights
7.3
Microsoft BI
Color-coded scorecards
Adaptive Insights
6.8
Microsoft BI
KPIs
Adaptive Insights
8.0
Microsoft BI
Cost and profitability analysis
Adaptive Insights
8.1
Microsoft BI
Key Performance Indicator setting
Adaptive Insights
8.1
Microsoft BI
Benchmarking with external data
Adaptive Insights
7.3
Microsoft BI

Integration

Adaptive Insights
8.6
Microsoft BI
Flat file integration
Adaptive Insights
8.4
Microsoft BI
Excel data integration
Adaptive Insights
8.8
Microsoft BI
Direct links to 3rd-party data sources
Adaptive Insights
8.7
Microsoft BI

BI Standard Reporting

Adaptive Insights
Microsoft BI
8.2
Pixel Perfect reports
Adaptive Insights
Microsoft BI
8.2
Customizable dashboards
Adaptive Insights
Microsoft BI
8.1
Report Formatting Templates
Adaptive Insights
Microsoft BI
8.4

Ad-hoc Reporting

Adaptive Insights
Microsoft BI
8.5
Drill-down analysis
Adaptive Insights
Microsoft BI
8.6
Formatting capabilities
Adaptive Insights
Microsoft BI
8.3
Integration with R or other statistical packages
Adaptive Insights
Microsoft BI
8.3
Report sharing and collaboration
Adaptive Insights
Microsoft BI
8.8

Report Output and Scheduling

Adaptive Insights
Microsoft BI
8.7
Publish to Web
Adaptive Insights
Microsoft BI
8.7
Publish to PDF
Adaptive Insights
Microsoft BI
8.5
Report Versioning
Adaptive Insights
Microsoft BI
8.8
Report Delivery Scheduling
Adaptive Insights
Microsoft BI
8.8
Delivery to Remote Servers
Adaptive Insights
Microsoft BI
8.5

Data Discovery and Visualization

Adaptive Insights
Microsoft BI
8.8
Pre-built visualization formats (heatmaps, scatter plots etc.)
Adaptive Insights
Microsoft BI
9.0
Location Analytics / Geographic Visualization
Adaptive Insights
Microsoft BI
8.8
Predictive Analytics
Adaptive Insights
Microsoft BI
8.5

Access Control and Security

Adaptive Insights
Microsoft BI
8.7
Multi-User Support (named login)
Adaptive Insights
Microsoft BI
8.8
Role-Based Security Model
Adaptive Insights
Microsoft BI
8.6
Multiple Access Permission Levels (Create, Read, Delete)
Adaptive Insights
Microsoft BI
9.0
Single Sign-On (SSO)
Adaptive Insights
Microsoft BI
8.5

Mobile Capabilities

Adaptive Insights
Microsoft BI
8.5
Responsive Design for Web Access
Adaptive Insights
Microsoft BI
8.4
Dedicated iOS Application
Adaptive Insights
Microsoft BI
8.7
Dedicated Android Application
Adaptive Insights
Microsoft BI
8.5
Dashboard / Report / Visualization Interactivity on Mobile
Adaptive Insights
Microsoft BI
8.5

Application Program Interfaces (APIs) / Embedding

Adaptive Insights
Microsoft BI
8.4
REST API
Adaptive Insights
Microsoft BI
8.6
Javascript API
Adaptive Insights
Microsoft BI
8.4
iFrames
Adaptive Insights
Microsoft BI
8.4
Java API
Adaptive Insights
Microsoft BI
8.3
Themeable User Interface (UI)
Adaptive Insights
Microsoft BI
8.7
Customizable Platform (Open Source)
Adaptive Insights
Microsoft BI
8.0

Pros

  • Web-based system which eliminates the need to purchase new software. System is accessible anywhere as long as there is internet access.
  • Its features provide for good planning, budgeting, and forecasting.
  • The ability to create customized reports is a very nice touch - we are able to share this across our organization.
Jessalyn Ka profile photo
  • EASY visualization of business data. Excel is the killer app so anybody remotely good at basic office tools knows how to make PivotTables and PivotCharts. If you don't, it's really easy to learn; give it a try... People think big data visualization is hard but it's not for most business use cases.
  • FAST visualization of business data. There are BI/Analytics tools out there, some of them beginning with the letter S, that are slooow. I do my taxes waiting for them to run basic queries/filters/charts. Microsoft BI (and Tableau, etc.) create compact data models to allow for pretty fast data loading and slicery.
  • FREE or at least REALLY CHEAP visualization of business data. Who has MS Office on their business computer? Oh, everybody. If you don't have Office Pro, pony up for that or get the monthly license. The bigness of data you can run on your own machine is fairly big; don't use cloud if you don't need it. By comparison, who enjoys throwing thousands of dollars away on bloated legacy BI software? Well, too many companies, apparently.
Alexander Lubyansky profile photo

Cons

  • The in-house consultants who originally set up Adaptive were poor listeners - and as a result built a model that didn't work for my organization. I had to hire an outside consulting firm with more experience with nonprofits to redo my model. I lost about 1 year of usefulness as a result.
  • Mastering attributes for reporting takes time. The system can do many things, but not without lots of time and effort. I ended up hiring a consultant to build initial reports I needed. I'm comfortable enough now to edit and update, but still have some hesitancy building new reports. One difficulty I have is not knowing the impact a single change, such as the name of a field, can have on everything else associated with that named field or dimension or attribute. It would be nice to have a map showing the links between everything.
Daniel Killpack profile photo
  • Parallel Sequential job Processing within the SSIS GUI, not using DTS
  • More Options for non-SharePoint portal Integration
  • Reporting Services performance browser rendering time for reports
Lee Cullom profile photo

Likelihood to Renew

Adaptive Insights8.5
Based on 32 answers
We have renewed this a number of times. It fits our business model and it is now an integral part of our organization.
Harry Vasels profile photo
Microsoft BI8.0
Based on 25 answers
I will renew because the pain to change, rip out and buy new is simply too much to live through. I am under the assumption that this is still 1.0. Microsoft will better my concerns and I still see them adding features from time to time. They have released new versions of the Power Query, and the Gateway over the past couple of months. They have single evenhandedly turned Excel from the preferred tool of presentation to making Excel Middle ware. Middle Ware? Don't hang up and close the browser yet. Yup, its middle ware. Excel connects to the data, SQL database or the data model, Excel is the tool that passes the information to the real presentation layer. Excel is just a middleware tool that has become more powerful than ever and the platform that Microsoft BI resides upon. While my review may seem at times critical its the familiarity of the tools (Excel), ease of use, and price that make Microsoft BI the recommended tool for the small to medium size company looking for BI
Sean Warren profile photo

Usability

Adaptive Insights7.7
Based on 75 answers
Building complex reports is still difficult to do when using dimension or level attributes. Formulas are still a challenge.
Daniel Killpack profile photo
Microsoft BI7.0
Based on 5 answers
Easy to use. Good User Interface and visualizations
No photo available

Reliability and Availability

Adaptive Insights9.1
Based on 9 answers
Cloud-based allows for access anywhere. Very little downtime.
Andrew Rosenberg profile photo
Microsoft BI9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo

Performance

Adaptive Insights9.1
Based on 4 answers
Product performs well when making and saving changes and navigating between pages within the application
Andrew Rosenberg profile photo
Microsoft BI7.0
Based on 2 answers
SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.
Robert Goodman profile photo

Support

Adaptive Insights6.8
Based on 11 answers
Support requests are always handled promptly and resolved favourably.Many user support requests arise during initial deployment and use and often represent questions relating to best methods or how to approach their particular situation, which we gladly assist with as we provide the appropriate skills transfer training and assistance.As clients become more knowledgeable in working with the product suite then they tend not to ask many questions.
Greg Clarke profile photo
Microsoft BI7.1
Based on 6 answers
We are not currently utilizing Microsoft's technical support.
Robert Goodman profile photo

In-Person Training

No score
No answers yet
No answers on this topic
Microsoft BI6.9
Based on 3 answers
This training was more directed toward what the product was capable of rather than actual programming.
Stephanie Grice profile photo

Online Training

Adaptive Insights8.2
Based on 6 answers
Training receives the highest rating due to the availability of Webex training from an expert at Adaptive, with several sessions tailored to specific features including personnel, capital, formulas, reporting, etc
Andrew Rosenberg profile photo
Microsoft BI8.5
Based on 2 answers
I have used on-line training from Microsoft and from Pragmatic Works. I would recommend Pragmatic Works as the best way to get up to speed quickly, and then use the Microsoft on-line training to deep dive into specific features that you need to get depth with.
Sean Brady profile photo

Implementation

Adaptive Insights8.2
Based on 13 answers
In our experience the Adaptive Suite is quick and easy to deploy. Most implementations are facilitated in just a few weeks but may range depending on organisation complexity from say 2 to 12 weeks with only the very largest and most complex taking a little longer. When key stakeholders are properly engaged and the opportunities for skills transfer are exercised, we find that implementations proceed well and are delivered on time and to project budget
Greg Clarke profile photo
Microsoft BI9.6
Based on 7 answers
Thorough project planning and requirements gathering ensured project's success.
Boris Skylar profile photo

Breadth of Deployment

It is used throughout the company in different divisions and at our corporate level. When used in a division recently the personnel from different departments directly inputted data and monitored their budget against actual. It is very user friendly and flexible.
Harry Vasels profile photo
Number of users = 500. Company Wide.
Asif Paracha profile photo

Alternatives Considered

My decision came down to Adaptive vs Host Analytics. Host made the claim that because their sheets were just like excel, you wouldn't need to learn any new commands. Rather, I thought that was a downside. I didn't want another glorified version of excel, I was looking for something different, something new. Adaptive had that. They were also far more willing to work with a nonprofit and become a partner, rather than just a vendor.
Daniel Killpack profile photo
For analysis and visualization, Power BI is aiming to take a large chunk of Tableau's market share. The rhythm of iterations at this time has in my opinion given the momentum to Power BI. The added functionalities in Excel also make it possible for intermediate users to get familiar with data modeling.
Charles Saulnier profile photo

Collaboration and Sharing

Adaptive Insights7.5
Based on 17 answers
With workflow I am able to track progress on budget and forecast projects in a timely manner. There is also an organiser to track and assign tasks to users. Security is very flexible.
Robin Webber profile photo
Microsoft BI8.2
Based on 27 answers
You can publish dashboards or reports from the web or desktop versions in many ways. From the web side, you can distribute dashboards or reports over roll based, user based or user group. From the desktop side, you can distribute dashboards or reports by file (MS BI report file, MS Excel, MS Access, and other formats).
Celil ÇİYNEKLİ profile photo

Data Integration

Adaptive Insights7.6
Based on 17 answers
We have used Adaptive for years and it works well as we adapt to changing business scenarios. We can make changes and see potential impacts to our business before they occur.
Harry Vasels profile photo
Microsoft BI8.7
Based on 26 answers
Microsoft BI supports a variety of different data sources such as SQL Server, Oracle DB, DB2, Sybase, Excel, Access, Text files, MySQL, Teradata, Amazon Redshift, Azure SQL Database, Azure SQL Data Warehouse, Impala, SAP Business Warehouse, SAP Hana.
Gonzalo Angeleri profile photo

Scalability

Adaptive Insights9.1
Based on 7 answers
Adaptive is the leader and is very progressive with the product improvements that they provide.
Gary Sabulski profile photo
No score
No answers yet
No answers on this topic

Return on Investment

  • The most positive impact has been on time. While it took some time to get things set up correctly, once we did, we were able to report results very quickly.
  • The budgeting process has gone much more quickly.
  • What-if scenarios are a little trickier. There are multiple ways you can do it. We have chosen to use assumptions for percentages and then copy the original version to a "what-if" version and change the assumption it is pointing to. However, this is a bit clunky.
  • Month-end reporting is getting faster and faster the more we automate through Adaptive.
Amy Kee, CPA profile photo
  • At the moment, the lack of use of Power BI has indered our market progression IMO
  • A large majority of customers keeps the solution once implemented, very few have switched platform
  • Once organizations implement Office 365, the potential for added business with Microsoft BI will really manifest. At this time, the slow adoption of Office 2013 or more recent is limiting the analysis and visualizations capabilities of our average client.
Charles Saulnier profile photo

Pricing Details

Adaptive Insights

General
Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Optional
1.  per seat, per installation
Adaptive Insights Editions & Modules
Adaptive Insights
Additional Pricing Details

Adaptive Insights More Information

Microsoft BI

General
Free Trial
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Entry-level set up fee?
No
Microsoft BI Editions & Modules
Microsoft BI
Edition
Power BI
$0
Power BI Pro
$102
2. per user per month
Additional Pricing Details

Microsoft BI More Information