What users are saying about
13 Ratings

Microsoft BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
628 Ratings
13 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 6.6 out of 101

Microsoft BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
628 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.9 out of 101

Add comparison

Likelihood to Recommend

Apptio

If you are trying to understand your IT costs and have cost pools and services defined then you are in a good position to move forward. If you are missing one of those items, spend the time getting that figured out before trying to implement the system. You can do that in parallel and use the ATUM model but it will not be an quick implementation. Ask what services Apptio can help with during the implementation process. They have some very good resources that can help provide best practice details from other customers.
Rick Eckoff profile photo

Microsoft BI

Microsoft has pulled a great trick. The trick is getting you into the pricing for only $20 to $50 dollars a month. They then made it very easy to push to the SharePoint site and keep it updated with free gateway product that will keep your reports live and consistently updated. Now here is a gotcha....IF you use the Data modeling tool (Power Query) for example that is then connected to a large database, you will have no issues. The issues begin at publishing information to SharePoint. There is a size limitation to how large the excel sheet can be. I would point out that we are not making large spread sheets with Pivot tables and millions of rows of data. We are simply connecting through Power Query. The sheet is still very small but the issue is the data model size. This is tapped at a gig on SharePoint. To be considered a true enterprise product, this size limitation will have to be overcome. There is a (not sure if beta or not) version of some of the power views that can be done in Power BI. These views when rendered locally are wonderful. When they are rendered from the web, they can take a little longer. The part that can be agonizing is the showing views through HTML5. This is almost unworkable when using power maps or maps through power view. The response is so jittery that it is almost unusable
Sean Warren profile photo

Feature Rating Comparison

BI Standard Reporting

Apptio
Microsoft BI
8.0
Pixel Perfect reports
Apptio
Microsoft BI
7.9
Customizable dashboards
Apptio
Microsoft BI
7.9
Report Formatting Templates
Apptio
Microsoft BI
8.2

Ad-hoc Reporting

Apptio
Microsoft BI
8.4
Drill-down analysis
Apptio
Microsoft BI
8.2
Formatting capabilities
Apptio
Microsoft BI
8.4
Integration with R or other statistical packages
Apptio
Microsoft BI
8.2
Report sharing and collaboration
Apptio
Microsoft BI
8.9

Report Output and Scheduling

Apptio
Microsoft BI
8.2
Publish to Web
Apptio
Microsoft BI
8.3
Publish to PDF
Apptio
Microsoft BI
8.8
Report Versioning
Apptio
Microsoft BI
8.2
Report Delivery Scheduling
Apptio
Microsoft BI
7.6
Delivery to Remote Servers
Apptio
Microsoft BI
8.2

Data Discovery and Visualization

Apptio
Microsoft BI
8.2
Pre-built visualization formats (heatmaps, scatter plots etc.)
Apptio
Microsoft BI
8.5
Location Analytics / Geographic Visualization
Apptio
Microsoft BI
8.0
Predictive Analytics
Apptio
Microsoft BI
8.1

Access Control and Security

Apptio
Microsoft BI
8.4
Multi-User Support (named login)
Apptio
Microsoft BI
8.4
Role-Based Security Model
Apptio
Microsoft BI
8.2
Multiple Access Permission Levels (Create, Read, Delete)
Apptio
Microsoft BI
8.6
Single Sign-On (SSO)
Apptio
Microsoft BI
8.4

Mobile Capabilities

Apptio
Microsoft BI
8.3
Responsive Design for Web Access
Apptio
Microsoft BI
8.2
Dedicated iOS Application
Apptio
Microsoft BI
8.4
Dedicated Android Application
Apptio
Microsoft BI
8.1
Dashboard / Report / Visualization Interactivity on Mobile
Apptio
Microsoft BI
8.2

Application Program Interfaces (APIs) / Embedding

Apptio
Microsoft BI
7.9
REST API
Apptio
Microsoft BI
7.9
Javascript API
Apptio
Microsoft BI
8.3
iFrames
Apptio
Microsoft BI
7.8
Java API
Apptio
Microsoft BI
7.6
Themeable User Interface (UI)
Apptio
Microsoft BI
7.9
Customizable Platform (Open Source)
Apptio
Microsoft BI
7.6

Pros

  • Proprietary, standardized IT data model built into the system. Enables very rapid deployment. Also, by having defined data, it makes it easier to know what to ask for and find it within the organization. Also enables "like for like" benchmarking.
  • The standardized IT data model allows Apptio to deliver a robust set of reports out of the box.
  • Customer support is well beyond expectations. Outstanding. Apptio is a true business partner.
  • Technology Business Management Council is a leading group of CIOs developing the practice and driving new features into Apptio.
No photo available
  • One Stop Shopping: Single solution provider provides tight integration between data storage, data manipulation, data processing and presentation. Instead of buying an RDBMS from one provider, data processing tools from another vendor, and presentation tools from yet another, the entire application stack is provided by Microsoft.
  • Value: Compared to other RDBMS vendors, Microsoft BI tools are more cost-effective because all the tools needed are included in the purchase of Microsoft SQL Server, SharePoint and Office. SQL Server even has a Business Intelligence Edition!
  • Performance: The SQL Server RDBMS is a top-tier data management solution. Ancillary tools like Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), PerformancePoint are mature, full featured and include lots of performance monitoring and high availability options. The newer Power BI tools have made tremendous strides in stability and usability since their introduction last year.
  • HDInsight and Azure BLOB storage offer a new paradigm for storing and querying data sets of all sizes. Flat files are stored in inexpensive storage, and HDInsight Hive allows "schema over file" table structures and near-ANSI SQL queries. This provides an inexpensive, very fast way to process data from web logs, large call center logs, and other large data volume data sets without importing into a database. Once the processing is complete, the HDInsight cluster (up to 64 nodes) is dropped, leaving the data intact.
  • Azure Hybrid Scenarios: Microsoft is rapidly migrating their business offerings to Azure. Business Intelligence is no exception.
  • Many new features in SQL Server 2012 R2 and SQL Server 2014 are designed to allow seamless management of both on-premise and cloud-based data,From Infrastructure As a Service (IaaS) options like virtual servers for development and test to Power BI for Office 365 sites that revolutionize how data is shared and accessed, Microsoft is making significant investments in the next generation of cloud-based solutions.
Chris Utter profile photo

Cons

  • TBM is such a new practice, finding resources that either know it or can learn it is challenging. This is no fault of Apptio's, but we rely on them heavily to show us best practice and deliver value proposition. Thankfully their field support engineer is very dedicated to helping us.
No photo available
  • Power BI maturity: Power BI is a combination of add-ons for Microsoft Excel and a special Office365 hosting site. However, the primary presentation tool, Power View, has a long way to go to catch up with such competitors as Tableau and even Microsoft's current analytics platform, PerformancePoint. To address these concerns, Power BI releases are being scheduled out-of-band from normal version upgrades in order to address requirements of the user community.
  • Office 365: There are currently size limitations, like a 250GB max for PowerPivot worksheets, which might cause issues with organizations who want to utilize very large data sets with Power BI.
  • Messaging: Some of the marketing and best practices around the new cloud-based solutions are unclear, making it difficult for someone who doesn't work in the BI world to understand the benefits and the architecture for such solutions.
  • Multiple data manipulation languages: Currently there are four or five distinct query languages in the Microsoft BI stack: T-SQL for SQL Server, MDX and DAX for Analysis Services, and the Power Query Formula Language for Power Query. In Integration Services, there is yet another language used in some of the tasks. That seems to be a lot to keep abreast of!
Chris Utter profile photo

Likelihood to Renew

Apptio10.0
Based on 4 answers
I don't believe there is a product on the market as mature in its practice and purpose-built as Apptio is for IT Cost Transparency. It even made the CNBC "Top 50 Disruptor" list for innovative technologies. Its is way ahead of its competition.
No photo available
Microsoft BI8.0
Based on 25 answers
It is the best fit BI solution for a Microsoft shop - nobody else is even close on integration capabilities, feature set, and price at this point.
Sean Brady profile photo

Usability

Apptio9.0
Based on 1 answer
Apptio is proving to be a relatively user-friendly product, assuming proper skill sets and training. Enterprise Analytical abilities to support the proper data readiness and implementation are key.
No photo available
Microsoft BI7.0
Based on 5 answers
The product is very usable compared to competitive solutions. I didn't give it a full 10 because Microsoft needs to improve their Report Builder module.
Robert Goodman profile photo

Reliability and Availability

Apptio10.0
Based on 1 answer
Excellent, so far. SaaS-based...assuming effective data links and connectivity
No photo available
Microsoft BI9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo

Performance

Apptio10.0
Based on 1 answer
Excellent, so far.
No photo available
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

Apptio9.0
Based on 1 answer
Solid support so far, primarily focused on implementation
No photo available
Microsoft BI7.1
Based on 6 answers
I am basing this rating not on Microsoft's paid premium support, but rather on the resources available (both from Microsoft and 3rd parties) to BI consumers. There is such a huge community working with and building solutions with the Microsoft BI stack (SQL Server) that I have always been able to find a solution (or at least a workaround) to any problems that have come up.
Sean Brady profile photo

In-Person Training

Apptio10.0
Based on 1 answer
Excellent. We were able to coordinate an onsite course for several vs flying everyone to Apptio Training in Seattle.
No photo available
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

Apptio9.0
Based on 1 answer
Was simply used to get familiar with the tool. Good introduction to the in-person course.
No photo available
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

Apptio9.0
Based on 1 answer
Well, so far. Apptio Consulting covered specific model architecting areas particularly. Most of the heavy lifting is being done in-house with support from Apptio as it relates to tool impacts and needs. Some administrative tasks were redundant
No photo available
Microsoft BI9.6
Based on 7 answers
Thorough project planning and requirements gathering ensured project's success.
Boris Skylar profile photo

Alternatives Considered

There is no true competitor that is even comparable to allowing the same capabilities and benefits Apptio provides. It is ground breaking in every sense of the word and will make a huge difference for each and every customer. It can be very complex at times, but like everything in life anything worth implementing takes time, effort, and some growing pains.
No photo available
Microsoft BI is definitely catching up, especially with monthly updates.
Ivan Leung profile photo

Return on Investment

  • Apptio Technology Business Management has greatly improved our chargeback transparency to the lines of business.
  • Apptio Technology Business Management has reduced our internal processing time for transfer pricing and various monthly reports.
  • We have yet to apply the IT expenses to a business metric within Apptio Technology Business Management but that is on the roadmap.
  • Apptio Technology Business Management has provided valuable cost level reports but we are still struggling to create the high level dashboards within the tool.
Rick Eckoff profile photo
  • Greatly reduced reporting project development time (and associated costs).
  • Significantly larger pool of experts to assist on large / ad-hoc projects.
  • Faster availability of critical business data to our users (due to decreased development time as well as performance of overall system - we are able to keep the data very fresh).
  • Significantly increased ETL / data integration capabilities means that more legacy and external system data is making it into the data warehouse.
Sean Brady profile photo

Pricing Details

Apptio

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Apptio Editions & Modules
Apptio
Additional Pricing Details

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