Jet Reports vs. MicroStrategy Analytics vs. TARGIT

Jet Reports is better suited if you have a specific population set you are looking at and less suited when querying or summing large pools or data, records, etc. I use a combination of Jet & SQL syntax when performing the latter because it allows me to harness the speed of our SQL server. Jet allows more for more customization when bodes better for users.

Incentivized

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

Incentivized

Targit is very strong when the data is presented to the system. Because of this, we are able to report on almost all of the information that is valuable to us. When we have questions or ideas on how to better leverage Targit, they are great to work with. We track our sales progress/process in Targit and AP tracks things such as outstanding invoices, open invoices, etc

• Integrated reporting
• Customizable reports
• Easy to use

Incentivized

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

• Quick start-up and report turnaround time.
• Easy drag and drop capabilities as well as user friendly command options.
• Ability to share reports among other users making it easy to use an already created report and simply changing the criteria to suit your own needs.
• Ability to save a base report that can be modified as needed repeatedly, instead of recreating from scratch.
• Easy visual for final layout.
• Ability to run multiple reports within one screen without jumping around.

Incentivized

• Tips and tricks
• Sharing best practices from other companies
• Online user forum

Incentivized

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

Incentivized

• Probably one of our biggest complaints from the user community is the inability for the user to see the details behind the data. I know with the tool you can write reporting services reports that would allow users to see the detail by right clicking on a measure and selecting Actions, but for a very lean IT shop there simply has not been time to build these Actions for every possible scenario a user might want to see detailed reporting on.
• Another complaint I've heard is the inability for the user to know exactly what the data represents from the source. If Targit had maybe some type of capability to hover over a measure or dimension and see a pop up of a more detailed description this might help resolve that issue.
• The most difficult concepts to teach our users is how and when to use comparisons and the syntax for calculations. Creating comparisons has become much simpler with the 2k11 release but it is still difficult for my users.

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.

Incentivized

It is very easy to use and I am proficient at this point to be able to figure out how to run most of the reports I need. I have had the time to "play around" in TARGIT and really teach myself about the visibility settings and other aspects - though other users have needed help with some of these aspects - but once you conceptually understand how to build the reports, it is very simple from a power user perspective.

Incentivized

Because it is not the costliest tool in this category but it serves the purpose. It is easy to use, cost effective, and works really well with the data stored on cloud. It has wide range of dashboard templates which go really well with different types of data sets. I would love to use it agains and again

Incentivized

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.

Everything on the back end needs to be correct, which sometimes it may not be set up or missing some variables. Some of the more difficult parts of Targit require a lot more attention and object creation to work properly

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.

Incentivized

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.

Incentivized

I hinestly have not used the support a lot but i have always had to way for longer durations to get a response on my emails. I have tried calling them a few times and the wait time was a little more than what i expected. They were able to answer my queries nonetheless

Incentivized

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.

Incentivized

Everyone I've dealt with at Targit genuinely cares about me and my success, and they respond to questions quickly and accurately. There is literally nothing more I could ask for from their support.

Incentivized

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.

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

Incentivized

Make sure all of the back end work is done prior to getting Targit set up. Every variable you may need for calculations needs to be correct and every item needs to be uniform so it is read properly.

Jet Reports is light weight and has a minimal barrier to entry for new users. Tableau has a higher learning curve and is more cost prohibitive

Incentivized

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.

Incentivized

It really met our business requirements when we were searching for a reporting/Bi tool and the flexible business model of being able to introduce additional functionally as your organization grows and requires it made the investment decision the right one for us. The functionality available in comparison to the investment is well worth it.

Incentivized

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.

Incentivized

• Prediction analysis has helped the business to make future plans
• Report scheduling has eliminated a lot of manual work

Incentivized

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

• We have been looking at our Product Hit Rate by Customer instead of just looking into Customer hit rate and adjusted our offerings accordingly.
• Giving people the ability to run their own ad-hoc reports rather than to request them from IT is a great benefit to my department.