TrustRadius: an HG Insights company

Microsoft BI (MSBI) vs. Pentaho

Save this comparison

Save this comparison

Microsoft BI (MSBI)

934 Reviews and Ratings

Pentaho

132 Reviews and Ratings

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Microsoft BI (MSBI)

    Score7.1 out of 10
    		N/AMicrosoft BI is a business intelligence product used for data analysis and generating reports on server-based data. It features unlimited data analysis capacity with its reporting engine, SQL Server Reporting Services alongside ETL, master data management, and data cleansing.

    $14

    per month per user

    Pentaho

    Score5.1 out of 10
    		N/APentaho is a suite of open source business intelligence and analytics products, now offered and supported by Hitachi Data Systems since the June 2015 acquisition.N/A
    Pricing
    Microsoft BI (MSBI)Pentaho
    Editions & Modules
    Power BI Pro
    $14
    per month per user
    Power BI Premium
    $24
    per month per user
    No answers on this topic
    Offerings
    Pricing Offerings
    Microsoft BI (MSBI)Pentaho
    Free Trial
    NoNo
    Free/Freemium Version
    YesNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    Microsoft BI (MSBI)Pentaho
    Considered Both Products
    Microsoft
    Julia Gusman
    BI Consultant at Altis Consulting (Information Technology and Services, 51-200 employees)
    Chose Microsoft BI (MSBI)
    I have been using the open source open standards BI tool 'Pentaho' before moving into the Microsoft space and I must admit I was surprised how much more difficult it is to do development in Microsoft. Having said that the cubes (SSAS) and reporting (SSRS) side does seem more …
    Incentivized
    Al Mubassir Muin
    Software Engineer in Information Technology at Prime Tech Solutions Ltd. (Information Technology & Services, 51-200 employees)
    Chose Microsoft BI (MSBI)
    Better integration with Microsoft products is one of the advantages of using Business Intelligence (BI). It's simple to understand, and plenty of resources are available to outsource it. Many of our existing clients have Microsoft licensing agreements. It's an obvious path when …
    Incentivized
    Aononna Tazin
    Customer Relationship Management Specialist in Information Technology at Green Light Ltd (Information Technology & Services, 51-200 employees)
    Chose Microsoft BI (MSBI)
    Outsourcing work is easy to understand, and there are plenty of resources available in the marketplace. It is expensive, but it is still significantly less costly than the alternatives. Results from Microsoft BI (MSBI) are dependable; therefore, there is no problem with trust. …
    Incentivized
    Lakhan Suri
    SQL AND BI Developer in Information Technology at Carmen Solutions (Information Technology and Services, 51-200 employees)
    Chose Microsoft BI (MSBI)
    Easy to understand, resources easily available in market to outsource the work.
    Incentivized
    Hitachi Vantara
    Ilham AB
    Senior Solution Architect in Information Technology at Three. (Telecommunications, 501-1000 employees)
    Chose Pentaho
    Since the Pentaho platform offers a range of broad functionality across data preparation and advanced analytics, it also can be easily integrated to support many data sources and machine-learning frameworks. Based on that fact, we selected Pentaho to be used in our internal …
    Incentivized
    Ivan Miller
    Business Intelligence Engineer in Engineering at Experticity (Marketing and Advertising, 51-200 employees)
    Chose Pentaho
    In terms of price, pentaho seems to be the clear winner for functionality that you get--especially with the community edition. If you don't need to license anything out, even the enterprise edition is fairly reasonably priced. With this in mind, it's a winner in the sense that …
    Incentivized
    Key User Insights
    Would buy again
    No answers on this topic
    No answers on this topic
    Delivers good value for the price
    No answers on this topic
    No answers on this topic
    Happy with the feature set
    No answers on this topic
    No answers on this topic
    Lived up to sales and marketing promises
    No answers on this topic
    No answers on this topic
    Implementation went as expected
    No answers on this topic
    No answers on this topic
    Features
    Microsoft BI (MSBI)Pentaho
    BI Standard Reporting
    Comparison of BI Standard Reporting features of Microsoft BI (MSBI) and Pentaho
    Feature
    Microsoft BI (MSBI)
    8.7
    48 Ratings
    Pentaho
    9.0
    20 Ratings
    Pixel Perfect reports9.041 Ratings8.618 Ratings
    Customizable dashboards8.048 Ratings9.918 Ratings
    Report Formatting Templates9.046 Ratings8.718 Ratings
    Ad-hoc Reporting
    Comparison of Ad-hoc Reporting features of Microsoft BI (MSBI) and Pentaho
    Feature
    Microsoft BI (MSBI)
    8.8
    48 Ratings
    Pentaho
    8.7
    19 Ratings
    Drill-down analysis9.043 Ratings7.618 Ratings
    Formatting capabilities8.048 Ratings8.319 Ratings
    Integration with R or other statistical packages9.038 Ratings9.312 Ratings
    Report sharing and collaboration9.048 Ratings9.717 Ratings
    Report Output and Scheduling
    Comparison of Report Output and Scheduling features of Microsoft BI (MSBI) and Pentaho
    Feature
    Microsoft BI (MSBI)
    9.0
    47 Ratings
    Pentaho
    9.7
    20 Ratings
    Publish to Web9.043 Ratings9.618 Ratings
    Publish to PDF9.043 Ratings9.819 Ratings
    Report Versioning9.039 Ratings9.713 Ratings
    Report Delivery Scheduling9.042 Ratings9.917 Ratings
    Delivery to Remote Servers9.023 Ratings9.310 Ratings
    Data Discovery and Visualization
    Comparison of Data Discovery and Visualization features of Microsoft BI (MSBI) and Pentaho
    Feature
    Microsoft BI (MSBI)
    9.0
    47 Ratings
    Pentaho
    8.1
    17 Ratings
    Pre-built visualization formats (heatmaps, scatter plots etc.)9.046 Ratings7.916 Ratings
    Location Analytics / Geographic Visualization9.043 Ratings8.216 Ratings
    Predictive Analytics9.041 Ratings8.314 Ratings
    Pattern Recognition and Data Mining9.01 Ratings00 Ratings
    Access Control and Security
    Comparison of Access Control and Security features of Microsoft BI (MSBI) and Pentaho
    Feature
    Microsoft BI (MSBI)
    9.0
    48 Ratings
    Pentaho
    9.1
    20 Ratings
    Multi-User Support (named login)9.045 Ratings9.320 Ratings
    Role-Based Security Model9.042 Ratings9.619 Ratings
    Multiple Access Permission Levels (Create, Read, Delete)9.045 Ratings9.918 Ratings
    Report-Level Access Control9.01 Ratings00 Ratings
    Single Sign-On (SSO)9.027 Ratings7.610 Ratings
    Mobile Capabilities
    Comparison of Mobile Capabilities features of Microsoft BI (MSBI) and Pentaho
    Feature
    Microsoft BI (MSBI)
    8.5
    38 Ratings
    Pentaho
    8.3
    11 Ratings
    Responsive Design for Web Access8.035 Ratings9.710 Ratings
    Mobile Application8.026 Ratings6.97 Ratings
    Dashboard / Report / Visualization Interactivity on Mobile10.035 Ratings8.711 Ratings
    Application Program Interfaces (APIs) / Embedding
    Comparison of Application Program Interfaces (APIs) / Embedding features of Microsoft BI (MSBI) and Pentaho
    Feature
    Microsoft BI (MSBI)
    8.8
    20 Ratings
    Pentaho
    8.6
    10 Ratings
    REST API9.018 Ratings8.310 Ratings
    Javascript API9.018 Ratings9.09 Ratings
    iFrames9.017 Ratings7.39 Ratings
    Java API9.016 Ratings8.79 Ratings
    Themeable User Interface (UI)9.017 Ratings8.910 Ratings
    Customizable Platform (Open Source)8.016 Ratings9.610 Ratings
    User Ratings
    Microsoft BI (MSBI)Pentaho
    Likelihood to Recommend
    9.0
    (72 ratings)
    9.1
    (31 ratings)
    Likelihood to Renew
    8.0
    (25 ratings)
    8.8
    (11 ratings)
    Usability
    8.9
    (14 ratings)
    9.3
    (6 ratings)
    Availability
    9.5
    (2 ratings)
    -
    (0 ratings)
    Performance
    7.0
    (2 ratings)
    -
    (0 ratings)
    Support Rating
    8.9
    (15 ratings)
    9.3
    (7 ratings)
    In-Person Training
    6.9
    (3 ratings)
    -
    (0 ratings)
    Online Training
    8.5
    (2 ratings)
    9.5
    (2 ratings)
    Implementation Rating
    9.6
    (7 ratings)
    5.0
    (1 ratings)
    Configurability
    10.0
    (2 ratings)
    -
    (0 ratings)
    Data Sharing and Collaboration
    8.5
    (42 ratings)
    8.4
    (16 ratings)
    Data Sources
    8.4
    (41 ratings)
    8.6
    (16 ratings)