Likelihood to Recommend MSTR is great for any organization that is looking for a way to deliver complicated data in an uncomplicated way. From business teams to marketing and finance, several departments benefit from using MSTR to keep track of KPIs enabling teams to make optimizations along the way. MSTR provides great visual representations of data enabling team members to distill thousands of data points into easily digestible charts and graphs
Read full review I am over our HR data, and we use Workday for our HR management system. I have a script in place that runs reports on Workday and saves the results as CSVs. I can then use stages in Snowflake to insert these CSVs into Snowflake, then I can insert or truncate and replace these staged tables into a final schema. Then once these are in a schema I can reference them and build out my data models. In addition to ingesting CSVs, Snowflake has the ability to write a CSV file to our Amazon S3 bucket. Ingesting these CSVs, transforming the data, then delivering it to a destination would've involved so much more coding than my current process if we were on any other platform.
Read full review Pros They sell the product well, and make promises you will actually believe "checks the box" for most features a company would need. Doesn't actually deliver them though They answer the phone in a timely manner. Can't answer your questions or provide support, but the queue time isn't bad They have online documentation. It's not up to date, and likely doesn't reflect the version of software you are using, but hey... they can point to it. Read full review Snowflake scales appropriately allowing you to manage expense for peak and off peak times for pulling and data retrieval and data centric processing jobs Snowflake offers a marketplace solution that allows you to sell and subscribe to different data sources Snowflake manages concurrency better in our trials than other premium competitors Snowflake has little to no setup and ramp up time Snowflake offers online training for various employee types Read full review Cons The graph options are not as robust as an Excel user might want. The metadata layer can sometimes be slower, and it takes a long time for reports to run. Viewing the data feed entered can be cumbersome at times, in terms of validation with reports. Read full review This tool is very much technical and proper knowledge is required, so mostly you have to hire an IT team. I wish if various videos could be available for basic quires like its initiation, then I think it would act as a guideline and would help the beginners a lot. Read full review Likelihood to Renew I would always choose to renew MicroStrategy as long as they lead the market in features, functionality and price. The support of MicroStrategy is timely and professional, I frequently get answers to my questions within 24 hours and normally have solutions within 48 hours. Training available for MicroStrategy completely covers everything required to be able to expertly use MicroStrategy and understand data warehousing.
Read full review SnowFlake is very cost effective and we also like the fact we can stop, start and spin up additional processing engines as we need to. We also like the fact that it's easy to connect our SQL IDEs to Snowflake and write our queries in the environment that we are used to
Read full review Usability The standard grid reporting could look more like the styling and object used for the Import and Visual Insight products. In addition, object properties almost seem to be hidden when first using the product. It's as if they are asking the engineers to only use the presets we make available...and, these presets are 10+ years old. On the positive side, Microstrategy seems to be the only product, not named
Cognos , which can scale to Big Data. The product is "hackable" via the SDK or tricking the Intelligence Server to do uncommon things. The Microstrategy development team also seems to be very involved with their OEM partners; especially when it comes to features and enhancements. A large majority of the improvements we suggested have made it into the product or on the roadmap for future enhancements. Only suckas fall for the shiny objects from most other vendors; Microstrategy is really the only choice for Enterprise BI.
Read full review The interface is similar to other SQL query systems I've used and is fairly easy to use. My only complaint is the syntax issues. Another thing is that the error messages are not always the easiest thing to understand, especially when you incorporate temp tables. Some of that is to be expected with any new database.
Read full review Reliability and Availability I've never had an issue with MicroStrategy not being available due to MicroStrategy application malfunction. It is very robust and only failures I've seen were due to user error or the platform the machine running the service failed some how.
Read full review Performance Being able to customize the performance based on the business need is extremely powerful. Proper configuration and understanding of the usage pattern is key, if the technical ability of the architect is not at top level, then the product will not be configured correctly which will lead to poor performance.
Read full review Support Rating Good user community. Support team is available if you are under AMC. You get decent support after raising the support ticket. If it is product bug they will inform you and let you know which patch will resolve the same.
Read full review We have had terrific experiences with Snowflake support. They have drilled into queries and given us tremendous detail and helpful answers. In one case they even figured out how a particular product was interacting with Snowflake, via its queries, and gave us detail to go back to that product's vendor because the Snowflake support team identified a fault in its operation. We got it solved without lots of back-and-forth or finger-pointing because the Snowflake team gave such detailed information.
Read full review Online Training I have attended many trainings offered by MicroStrategy; both distance and in-person training. I earned my CRD (Certified Report Developer) certification via the online training. I found the training to be well organized and concise. Overall I will definitely continue to increase my knowledge with MicroStrategy via the online training offering.
Read full review Implementation Rating We measured following KPI for the success
Increase in Business Feeds Loads
Reduction in Controllers Manual Work.
Conversion of Manual Work into Systematic Workflows.
Increase in Customer Spend
Reduction in Service costs
Reduction in time-to-market for new campaigns
Increase in cross sell and Up sell
Error reduction in customer Identification
Existing client retained
Read full review Alternatives Considered Tableau is probably MicroStrategy Analytic's biggest competitor I've noticed over time, and I'm not sure why.
Tableau only covers visualizations independently for each business user, which then creates the issues of every employee creating their own version of the data, and then you have 20 versions of the truth. A enterprise data warehouse and MicroStrategy's Visual Insight is a better method.
Read full review I have had the experience of using one more database management system at my previous workplace. What Snowflake provides is better user-friendly consoles, suggestions while writing a query, ease of access to connect to various BI platforms to analyze, [and a] more robust system to store a large amount of data. All these functionalities give the better edge to Snowflake.
Read full review Scalability This software is extremely scaleable, one can add more core servers which performs as a load balancing. The configurations available to manage usage patterns and daily activity are as high a caliber as any other enterprise level software. This product can be installed on both a windows and unix platform allow for integration on a budget.
Read full review Return on Investment MicroStrategy was helpful for reducing the amount of time we needed to spend number crunching large data sets, and in doing so, allowed me as the primary users to spend more time gleaning insights from the data that in turn informed our leadership team to make strategic decisions. By creating numerous canned reports available to all members of the team through email distribution or basic access to the platform, we were able to reduce the time I spent showing people how to pull the data in Microsoft Excel by nearly 40% . We ended up needing to make many changes to the way our DMP was feeding data into MicroStrategy due to incorrect reporting that caused complications in accounting and finance. Read full review Positive impact: we use Snowflake to track our subscription and payment charges, which we use for internal and investor reporting Positive impact: 3 times faster query speed compared to Treasure Data means that answers to stakeholders can be delivered quicker by analysts Positive impact: recommender systems now source their data from Snowflake rather than Spark clusters, improving development speed, and no longer require maintainence of Spark clusters. Read full review ScreenShots