Intuitive Business Intelligence tool to analyze Category performance
January 16, 2020

Intuitive Business Intelligence tool to analyze Category performance

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Software Version

Analytics Enterprise

Overall Satisfaction with MicroStrategy Analytics

MicroStrategy Analytics is used in my organization to analyze the sales performance of products by specific SKUs, categories, or customer segments. It is a business intelligence tool leveraged by merchandising and marketing departments. The business problem addressed by MicroStrategy tool is to understand if a particular product category is growing in revenue after more SKUs were added or after a marketing campaign was run targeting specific groups, sales division or segment of customers. It does an excellent job of creating a custom performance report by dragging and dropping a set of objects which are correlated to each other in a relational database. As well as enables analysts to create quick visualizations.
  • Dragging and dropping report objects to create quick reporting of marketing and merchandising success metrics such as cases sold, revenue, and margin.
  • Segmenting a specific product performance report by filters such as a fiscal period, a list of SKUs, product categories, sub-groups, types, or a segment of customers.
  • Not efficient when the volume of data sets increases to hundreds of thousands of rows, which results in timeout errors when exporting excel reports. So, often the analyst has to break large data sets into smaller subsets, which means more time to analyze.
  • Doesn't do a great job of correlating unstructured data sets such as marketing banner impressions and clicks to structured data sets such as transactions, customer engagement, or cases sold attributed to a specific marketing campaign.
I would rate MicroStrategy Analytics tool higher than Google BigQuery but lower than the Teradata Analytics Platform. Because I don't need advanced knowledge or experience running SQL Queries to use MicroStrategy Analytics since it allows me to run complex marketing and merchandising reports by simply dragging and dropping report objects into the reporting panel. But I find it cumbersome to use when running reports against large data sets stored in relational databases. Where Teradata Analytics Platform is more efficient and doesn't timeout when querying heavy data sets containing thousands of rows as long as the analyst has SQL coding experience.
I gave an above-average rating of 6 to MicroStrategy Analytics because its data source connectivity works well with most transactional data sources such as relational databases. But not that well with unstructured data sources dependent on website tagging such as Google Analytics, Adobe Analytics or Webtrends. Additionally, MicroStrategy Analytics tool enables analysis of historical data sets but not real time. Since customers interact with a mix of tactics which are online and offline, having poor connectivity with unstructured data sources is a key hurdle in an organization's digital transformation strategy. More expensive analytical platforms such as Hadoop help close the gap but need high budgets.
The sharing and collaboration capabilities of MicroStrategy Analytics tool are limited due to less of cloud-based features included in it. Typically, an analyst has to run the report and export it in excel format and then email to all the users across the departments. Hence, I gave it an average rating of 5. Once more cloud-based sharing is enabled where export to local drive is not needed, then MicroStrategy Analytic sharing and collaboration rating can be above average.
MicroStrategy Analytics tool is well suited when marketing campaign or merchandising category data sets are smaller in volume, are more transactional, and historically collected. So, if the goal of the analyst is to analyze success metrics as cases sold, revenue, and margin by specific product SKUs, category or customer segments of campaigns which were run in the past like a day, week, month, or year ago. This business intelligence tool should not be used to do real-time data analysis or to run reports against thousands of megabytes of data. Because in those complex scenarios, the tool will time out and show reporting errors. Instead, other digital marketing analytics or business intelligence tools such as Google Analytics or Teradata SQL Assistant would be more appropriate to use to meet the advanced analytics needs of an organization.

MicroStrategy Analytics Feature Ratings

Pixel Perfect reports
6
Customizable dashboards
6
Report Formatting Templates
6
Drill-down analysis
8
Formatting capabilities
7
Integration with R or other statistical packages
5
Report sharing and collaboration
6
Publish to Web
5
Report Versioning
5
Report Delivery Scheduling
5
Delivery to Remote Servers
5
Pre-built visualization formats (heatmaps, scatter plots etc.)
4
Predictive Analytics
5
Multi-User Support (named login)
7
Role-Based Security Model
7
Multiple Access Permission Levels (Create, Read, Delete)
7
Single Sign-On (SSO)
7
Responsive Design for Web Access
5
Dashboard / Report / Visualization Interactivity on Mobile
4
REST API
Not Rated
Javascript API
Not Rated
iFrames
Not Rated
Java API
Not Rated
Themeable User Interface (UI)
6
Customizable Platform (Open Source)
Not Rated