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

• Connecting andJoining Multiple Data Sources Together - Multi-Dimensional SSAS
• Usability in Report Creation for Business Analysts (Excel via Analysis Services specifically), Executives (Performance Point and Power BI) and Power Users (Report Builder)
• Collaboration (via SharePoint only, before the release of Power BI Designer)
• Speed of Analysis - Specifically when leveraging SSAS on databases up to 5 TB
• Speed of ETL processing - Multiple Parallel Sequential Jobs with SSIS/DTS

Read full review

• Improved forecasting and planning tools, currently Aprimo does not enable teams to easily delineate starting budgets, actual spend, planned spend, and remaining budget.
• Better filtering mechanisms - we rely on text lookups that can easily create problems if employees input misspellings.
• Needs a capability to show snapshots of given points in time, for example, what the budget and plan looks like at the outset of the year vs. halfway through vs. end of year.

Read full review

• SQL Server Data Integration (also knows as SSIS) seems to provide most functionality you would expect from an ETL tool. However, when you start using it you quickly find out that most transformations perform slower than equivalent functionality when coded directly in SQL. So you go ahead with creating joins, using case statements and data type conversions directly in SQL input statements and potentially end up with a huge piece of code that performs nicely but is hardly maintainable in the future.
• The development environment takes quite a while to get used to. Once you are all set up and doing your development work it is all fine but if you accidentally close some window or 'pane' just figuring out how to get it back can take quite some time.

Read full review

• We are early users of the tool so it's hard to quantify actual benefits yet, but the following metrics have been established per business function:
• Brand & Creative - Cycle time from creative brief intake to delivering the final design; Number of reviews/re-works per creative request
• Field Marketing - Time to consolidate a field marketing forecast
• Digital Engagement - Cycle time to complete a website request
• PHSS - Time to complete a marketing plan for a specific PHSS campaign
• CEOP - # of emails and phone calls required to get a CEOP request through the cycle; Time to develop a consolidate quarterly report on CEOP requests/status
• Email Marketing - End-to-end email production process, through to launch date (# of launches that don't stay on schedule; # of email launches that have mistakes - audience, sender line, grammar; # of email launches that involve internal complaints, miscommunications)
• On-boarding/CDRP - Time to generate a quarterly client status regionalization report; Errors in data capture and missed deadlines; Capacity to handle on-boarding requests
• Direct Mail - % of mail campaign requests that miss 15-day approval service level, Involvement of LOB/ Stakeholders in the review process while maintaining response time.

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