Aprimo vs Microsoft BI

• Enables the allocation across brands of various marketing activities, essential for multi-brand executions that we do freuently.
• Connects seamlessly to IBM Cognos to create comprehensive reports that allow analysts and managers to see their budgets at any given point in time.
• Interface is easy to navigate, with an ability to customize based on your usage needs.

Read full review

• Ease of use: For end user Microsoft Power BI is incredibly easy to use. Excel is simple for most people. The presentation through SharePoint gives users with any medium the ability to instantly use the dashboards. End users are able to use mobile, local and just about anyway they would choose.
• High Adoption Rate: We had a very high adoption rate causing many of our users to be incredibly engaged. The adoption of is due to many users already familiar with the tools they grew up on. If you grew up on Excel, then you will instantly feel at home in the tools. The new add ons are rarely a challenge even for novice users.
• Mapping functions: The mapping functions are one of the cooler features. Power Maps automatically recognizes zip codes and other addresses much like other packages. The one item I really liked was the ability to create a movie file that would play over time showing the growth across a map through the different areas. Saved as a MP4 then blended with music made this function particularly delicious for many of our end users.
• The Gateway: MS has provided a really cool little trick. The Gateway. I will explain this part later in my review.

Read full review

• Compatibility - I had some problems with my corporate firewall, internet browser configuration and the fact that Aprimo runs only on Microsoft Internet Explorer.
• The online performance has a lot to improve. The user interface response time sometimes is bigger than we'd like.
• Aprimo does not have native integration interface, so we had to buy another tool to integrate it with our CRM and ERP systems.

Read full review

• Power Pivot is a very good tool to do self service BI but there is no direct way to implement row based security to the model. There has to be a mechanism where the owner of the book can lock the model within the book to be read only or hide the model so that other users will only see the reports and not the underlying data model
• Many to many functionality is simple in multi dimensional cubes but there is no direct and efficient way available in SSAS Tabular model and Power Pivot
• Even though Power Pivot is a easy to use and fast to implement BI solution, without proper training, end users can't utilize all the functionality of Power Pivot and common mistakes and misunderstandings will be expensive in long run

Read full review

• Internal tool once implemented so save on external design fees

Read full review

• 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.

Read full review