Category Archives: Business Intelligence

Vantana Research: Who’s Hot in Analytics and Business Intelligence

Ventana Research recently completed a comprehensive evaluation of analytics and business intelligence products and vendors. Such research is necessary and timely as analytics and business intelligence is now a fast-changing market. Vantana’s Value Index for Analytics and Business Intelligence in 2015 scrutinizes 15 top vendors and their product offerings in seven keyvr_VI_BI_2015_Weighted_Overall categories: Usability, Manageability, Reliability, Capability, Adaptability, Vendor Validation and TCO/ROI. The analysis shows that the top supplier is Information Builders, which qualifies as a Hot vendor and is followed by 10 other Hot vendors: SAP, IBM, MicroStrategy, Oracle, SAS, Qlik, Actuate (now part of OpenText) and Pentaho.

The evaluations drew on Vantana’s research and analysis of vendors’ and products along with their responses to their detailed RFI or questionnaire, their own hands-on experience and the buyer-related findings from their benchmark research on next-generation business intelligence, information optimization and big data analytics. The benchmark research examines analytics and business intelligence from various perspectives to determine organizations’ current and planned use of these technologies and the capabilities they require for successful deployments.

Vantana found that the processes that comprise business intelligence today have expanded beyond standard query, reporting, analysis and publishing capabilities. They now include sourcing and integration of data and at later stages the use of analytics for planning and forecasting and of capabilities utilizing analytics and metrics for collaborative interaction and performance management. Their research on big data analytics finds that new technologies collectively known as big data vr_Big_Data_Analytics_15_new_technologies_enhance_analyticsare influencing the evolution of business intelligence as well; here in-memory systems (used by 50% of participating organizations), Hadoop (42%) and data warehouse appliances (33%) are the most important innovations. In-memory computing in particular has changed BI because it enables rapid processing of even complex models with very large data sets. In-memory computing also can change how users access data through data visualization and incorporate data mining, simulation and predictive analytics into business intelligence systems. Thus the ability of products to work with big data tools figured in their assessments.

In addition, the 2015 Vantana Research Value Index includes assessments of their self-service tools and cloud deployment options. New self-service approaches can enable business users to reduce their reliance on IT to access and use data and analysis. However, their information optimization research shows that this change is slow to proliferate. In four out of five organizations, IT currently is involved in making information available to end users vr_Info_Optimization_01_whos_responsible_for_information_availabilityand remains entrenched in the operations of business intelligence systems.

Similarly, their research, as well as the lack of maturity of the cloud-based products evaluated, shows that organizations are still in the early stages of cloud adoption for analytics and business intelligence; deployments are mostly departmental in scope. Vantana is still exploring these issues further in their benchmark research into data and analytics in the cloud, which will be released in the second quarter of 2015.

The products offered by the five top-rated com­pa­nies in the Value Index provide exceptional functionality and a superior user experi­ence. However, Information Builders stands out, providing an excep­tional user experience and a completely integrated portfolio of data management, predictive analytics, visual discovery and operational intelligence capabilities in a single platform. SAP, in second place, is not far behind, having made significant prog­ress by integrating its Lumira platform into its BusinessObjects Suite; it added pre­dictive analytics capabilities, which led to higher Usability and Capability scores. IBM, MicroStrategy and Oracle, the next three, each provide a ro­bust integrated platform of capabilities. The key differentiator between them and the top two top is that they do not have superior scores in all of the seven categories.

In evaluating products for this Value Index Vantana found some noteworthy innovations in business intelligence. One is Qlik Sense, which has a modern architecture that is cloud-ready and supports responsive design on mobile devices. Another is SAS Visual Analytics, which combines predictive analytics with visual discovery in ways that are a step ahead of others currently in the market. Pentaho’s Automated Data Refinery concept adds its unique Pentaho Data Integration platform to business intelligence for a flexible, well-managed user experience. IBM Watson Analytics uses advanced analytics and VR_AnalyticsandBI_VI_2015natural language processing for an interactive experience beyond the traditional paradigm of business intelligence. Tableau, which led the field in the category of Usability, continues to innovate in the area of user experience and aligning technology with people and process. MicroStrategy’s innovative Usher technology addresses the need for identity management and security, especially in an evolving era in which individuals utilize multiple devices to access information.

The Value Index analysis uncovered notable differences in how well products satisfy the business intelligence needs of employees working in a range of IT and business roles. Vantana’s analysis also found substantial variation in how products provide development, security and collaboration capabilities and role-based support for users. Thus, they caution that similar vendor scores should not be taken to imply that the packages evaluated are functionally identical or equally well suited for use by every organization or for a specific process.

To learn more about this research and to download a free executive summary, click here.

Source: Tony Cosentino, VP and Research Director, Ventana Research, April 22, 2015,

2015 Gartner Magic Quadrant for Business Intelligence and Analytics Platforms – Tableau Wins Again

2015 Gartner Magic Quadrant BI & Analytics


Click on Image to Read the Report

Tableau’s intuitive, visual-based data discovery capabilities have transformed business users’ expectations about what they can discover in data and share without extensive skills or training with a BI platform. Tableau’s revenue growth during the past few years has very rapidly passed through the $100 million, $200 million and $300 million revenue thresholds at an extraordinary rate compared with other software and technology companies.

Tableau has a strong position on the Ability to Execute axis of the Leaders quadrant, because of the company’s successful “land and expand” strategy that has driven much of its growth momentum. Many of Gartner’s BI and analytics clients are seeing Tableau usage expand in their organizations and have had to adapt their strategy. They have had to adjust to incorporate the requirements that new users/usage of Tableau bring into the existing deployment and information governance models and information infrastructures. Despite its exceptional growth, which can cause growing pains, Tableau has continued to deliver stellar customer experience and business value. We expect that Tableau will continue to rapidly expand its partner network and to improve international presence during the coming years.

Wisdom of Crowds 2014: Success with Business Intelligence and Technology Priorities


Howard DresnerLast week, Howard Dresner released the 2014 Edition of his Wisdom of Crowds Business Intelligence Market Study.

Mr. Dresner is Chief Research Officer of Dresner Advisory Services, LLC, an independent advisory firm and a well-known authority and author in the areas of Business Intelligence and Performance Management.

Howard has 32 years of IT industry experience with 24 years in the Business Intelligence market.

He spent 13 years at Gartner, where he was a Research Fellow and Lead Analyst for BI. He also served as Chief Strategy Officer at Hyperion Solutions prior to forming Dresner Advisory Services in 2007.

Howard is a frequent speaker around the globe and has published two books on the subject – including: Profiles in Performance – Business Intelligence Journeys and the Roadmap for Change (John Wiley & Sons, November 2009) and The Performance Management Revolution: Business Results through Insight and Action (John Wiley & Sons, November 2007).

Through the Wisdom of Crowds Business Intelligence market research reports, Howard engages with a global community to redefine how research is created and shared.

I thought I would share a peek into his report with you on the topic of Success with Business Intelligence and Technology Priorities.

Mr. Dresner notes that with a few exceptions, reports of success with BI deviate little based on specific technology priorities. Those claiming success are slightly more likely to favor in-memory analysis and data mining and advanced algorithms. Those that are less successful were more likely to favor big data, analytical applications, software-as-a-service / cloud and location intelligence.

As part of his survey, when asked for reasons why business intelligence fails, respondents point to shortfalls and constraints surrounding data that include “tools” and “time,” but also “business,” “organization” and “management”.

Primary reasons for failure include: a lack of management understanding or appreciation of BI, a predominant focus upon technology vs. solving business problems and a lack of skills and resources to deliver solutions.

To visualize the data associated with success and not being successful, Mr. Dresner uses a radar chart (see chart below). A radar chart is a graphical method of displaying multivariate data in the form of a two-dimensional chart of three or more quantitative variables represented on axes starting from the same point. The relative position and angle of the axes is typically uninformative.

The radar chart is also known as web chart, spider chart, star chart, star plot, cobweb chart, irregular polygon, polar chart, or kiviat diagram.

As I delve deeper into the report, I will share other insights with you.

Best regards,


Wisdom of Crowds - Success

A Must Read: Bryan Brandow’s BI Blog on Evolving BI


I have some good news to share with you.

Bryan BrandowBryan Brandow, a Data Engineering Manager, has started (or perhaps restarted) blogging again. His new blog is called Bryan’s BI Blog and the first post is a must read. It is titled Evolving BI and Bryan shares his latest adventures, his thoughts on the current state of BI as he has observed and experienced it, and where he feels we collectively need to go.

Bryan has also migrated all of his old MicroStrategy Blog posts to this blog site and I encourage you to read these as well.

Here is a link to the Evolving BI post.

Best Regards,



Infographic: A History of Business Intelligence

A History of Business Intelligence

MicroStrategy “Data Science to Business Value” – Arpit Agrawal

Note: I received this blog posting in an e-mail. I generally and in principle agree with Arpit in his assessment of MicroStrategy. I thought I would share his thoughts and, if time permits, offer my thoughts in a future blog.

Best Regards,


MicroStrategy “Data Science to Business Value” by Arpit Agrawal (blogged on IT Central Station on August 14, 2013)

When a customer wants to implement BI, there are lots of options available in the market to choose from. The decision depends on various parameters such as  scale of implementation, costing and  performance. They can either go with the open source options, or they can plan towards a paid BI tool. The decision can  also be driven based on strategic factors of the company. I personally don’t believe in tool agnostic approach, I feel every customer has his own BI needs and has some specific requirements. No tool in this world can meet each one of these requirements, but in my experience MicroStrategy provides a complete product, which meets most of the customer requirements. This would be my first product review on a Business intelligence tool “MicroStrategy”

MicroStrategy is a solution provider for enterprise software platform on business intelligence. When we talk about MicroStrategy the first thought that comes into my mind is the core focus of the company, which is to deliver Business intelligence solutions, unlike other companies, which have their focus on different horizons. This, in my opinion, is the core strength of MicroStrategy as a company. Mike Saylor (CEO) gave similar insights in the MicroStrategy World conference. According to him the biggest advantage of MicroStrategy as a company is that they are the largest independently owned BI platform. There are a lot of companies in the market who acquire small firms to improve their technology and product, but MicroStrategy is not one of them. The fact that MicroStrategy has resisted the temptation to build a technology portfolio through acquisitions has become their core strength. They always believed in their core framework and everything was developed by their own team. According to the BI Survey 12, conducted by German-based Business Application Research Center (BARC), MicroStrategy has received the highest ranking in numerous KPIs (Key Performance Indicator) such as  total Performance, user Recommendation, mobile, query performance, data volumes and  big data.

MicroStrategy has a deep market penetration and is regularly used for industry level solutions in different domains such as  Retail, Healthcare, Banking, Manufacturing, Social Media etc. There are lots of key advantages of using MicroStrategy which I will elaborate verbosely.

  • Core functionality and Ease for Development – Having worked on different reporting platforms, I feel that most of the functionality is directly available out of the box in MicroStrategy. MicroStrategy platform supports distributed development so many developers can work on the project at a given time. Most of objects are reusable and their definition can be reused across other business areas. It also has extensive control on formatting of reports / dashboard. It supports as many number of databases and next generation database along with multi sourcing. The security architecture of MicroStrategy makes designing and implementation very powerful. You can have row level, object level, application level, and all different forms of security. Any developer with a fair amount of development experience in MicroStrategy would be able to list down product features and limitations. Although limitations of the tool are not much but there are functionalities which can be handled using SDK.
  • Visual Data discovery – For any BI tool, the ease-of-use is very important along with the sophisticated analytics which can be presented using the best visualization framework. As the size of data is increasing day by day, this is not going to decrease in the near future as well. It has become very important for a BI to analyze these enormous data volumes in a best representable format. Data visualization is driving demand in the business intelligence (BI) market because it’s intuitive and accessible to business users who aren’t schooled in query languages or statistical analysis. MicroStrategy has a strong stand in these areas due to large number of visualizations in their library. This separates MicroStrategy, as a tool, for visual exploration from other competitors. Features like flash widgets and interactive flash PDF export make it very versatile tool. The advance dashboards visualizations make the dashboard appealing and are best way to represent data in a more intuitive format.
  • Impromptu BI – There are customers in the market who look for Impromptu BI as a solution for their BI needs. MicroStrategy provides a solution called as visual insights which meets this purpose and is best suited for such cases. MicroStrategy Visual Insight empowers you to discover insights from your data using compelling visualizations. Users can use any of the out of the box Visualizations or they can create their own custom Visualizations using SDK. Once the base cube is developed it hardly takes 10-20 minutes to create visualizations for the analysis and this is what most business users want these days. They are the people who understand their data and want to play around with the data. Other than visual insights there are solutions developed using Object prompt where user has an option to select what they want to view in a report. This makes MicroStrategy stand out in front of other competitors.
  • Mentoring and support offering – For any business intelligence tool the level and depth of customer support is becoming increasingly critical as BI becomes more integrated into organizations’ operations. Better product support results in higher application success rates and helps to ensure customers get full value from their Investments. MicroStrategy on that note has one of the best customer support offering in the industry. This helps you to report your issues and business cases enhancements to MicroStrategy which can be taken into consideration for the subsequent release/hotfix/patch depending on your business impact. The support offering also helps in providing solutions to MicroStrategy developers and Administrators for the issues they face during the development. Striving to maximize the business benefits of a MicroStrategy one should prioritize customer support strategy. Apart from the excellent customer offering MicroStrategy hosts customer trainings events at different Geographic locations as it is important to keep decision makers across the company educated on the tool. End user training and mentoring is very important for success of any BI tool. MicroStrategy also hosts their annual user conference called as “MicroStrategy world” which consists of lot of sessions; it is also a good opportunity for individuals looking for more networking opportunities in MicroStrategy.
  • Performance and stability – MicroStrategy provides unmatched Performance and Stability on a Consolidated BI Platform
  • Social media and big data – MicroStrategy is one of the first vendors to certify integration with Amazon Redshift. MicroStrategy constantly demonstrates leadership and innovation in both major dimensions of Big Data analytics. They are one of the leading innovators in big data space. When we talk about BI, social media analytics cannot be neglected. Many market research firms rely on data from social media like Facebook, Twitter and LinkedIn to get some insights. MicroStrategy’s social intelligence platform includes a number of applications that help enterprises harness the power of social networks for marketing and e-commerce.
  • MicroStrategy Mobile – Michael Saylor, who is the founder of MicroStrategy, has also written a book called “The Mobile Wave: How Mobile Intelligence Will Change Everything” and I believe that its Saylor’s vision on the Mobile technology that has made MicroStrategy to grow on the Mobile Side. The Mobile App Platform transforms business intelligence reporting from paper or the desktop, to the mobile device.  Workers are no longer chained to their desk, or reliant on paper-based documents that are obsolete by the time they reach their target audience.  Mobile applications provide functionality that is unmatched by paper or a web browser. MicroStrategy has created some really amazing apps for IOS and Android users. They also have a program called Mobile Quick strike for 10 days where they would come up with a fully functional app. It gives customers the confidence in the overall strength of the tool. MicroStrategy’s mobile intelligence platform helps companies and organizations build, deploy, and maintain mobile apps across a range of solutions by embedding intelligence, transactions, and multimedia into apps.
  • Integration and certification with other platforms – MicroStrategy tool is certified with various reporting databases and platforms which makes it easily usable across the organizations. MicroStrategy team adds new certification and support with every release of the product.

Although every tool has some limitations, MicroStrategy is no exception. I will list down a few:

  • Sometimes it can be hard to quantify the ROI (return on investment) on software as the returns come indirectly through the better informed workers and decision makers across the company. The tool can be of limited use for some companies. MicroStrategy system still cannot be afforded by most of the companies. When they plan to buy this product they have various purchase options wherein the cost would be around some hundred dollars per user if they plan to go for a user based license or it can go as high as a million dollars for a CPU based license depending on the performance they want from their system. Although, in the past few years MicroStrategy has started modifying their services towards medium and small-sized industries, but the fact is that many of such firms do not consider them to be highly essential as its hard to quantify the ROI.This stands true for other paid tools as well and that is the reason open source tools are getting some market share these days
  • Having worked as a developer on MicroStrategy, I see Impact Analysis as a pain point area in MicroStrategy. MicroStrategy is an object-oriented tool and in this world of business, change is something which is inevitable, so in case there is a request for change and you need to find the impact of the object in MSTR, it does a recursive search and doesn’t give the list of objects in one view which makes very difficult for any developer to know the overall impact of the object inside a big project implementation. Unlike other BI tools which list down all the objects dependent on a particular object in a single view which can be exported into excel for tracking the change and validation of test cases.
  • Version control is not a strong point for MicroStrategy and I feel there is a scope of improvement in this area.
  • Development in MicroStrategy is done mostly using desktop though they have included lot of features with their latest release in web but I feel full support of web-based development is important and would improve with  the future release.
  • A pain point for some organizations these days is to find a good MicroStrategy resource. Getting a Cognos/BO/OBIEE expert from the IT market is comparatively easier than finding a good MicroStrategy resource.

These are some advantages and disadvantages of the tool. Compared to the advantages the disadvantages are some minor improvements which i feel would be taken care in future releases. I haven’t listed granular details as I wanted to keep this review at a high level for product understanding. There are lots of features which one can explore. When you do the contemplate MicroStrategy is a great product over all. To conclude you should never forget “Owning a supercomputer gives you a special feeling but the question is, Are you really using it for what it is intended to?”

Hope this review helps customers who are preparing their BI strategy. In case you need more insights, or you are planning for a BI implementation and have some questions do write to me on my e-mail. I would be more than happy to help.

Disclosure: The company I (Arpit) work for is partners with several vendors.

The review is based on my professional experience and in case you feel that any information is inaccurate please do point it out so that i can rectify the same.

MicroStrategy World Europe 2013 – CEO Michael J. Saylor Keynote Video

This past week, MicroStrategy World Europe 2013 was held in Barcelona, Spain. As usual, Michael Saylor, Founder and CEO of MicroStrategy, Inc. provided the keynote address of the conference.

I have listened to Michael’s presentation today and want to think about it a bit before I post some commentary.

In the meantime, here is a link to the video of his presentation. Just click on the image below.



[Click image to watch video presentation]

[Click image to watch video presentation]

Stephen Few’s Review of Tableau 8: Tableau Veers from the Path

The first person who exposed me to best practices in data visualization was Stephen Few. I had the good fortune to take a one day Data Visualization class from him in 2007 at TDWI in San Diego. Stephen’s company is called Stephen Few, Perceptual EdgePerceptual Edge.

Stephen founded Perceptual Edge as a consultancy that was established to help organizations learn to design simple information displays for effective analysis and communication. With 25 years of experience as an innovator, consultant, and educator in the fields of business intelligence and information design, Stephen is now a leading expert in data visualization for data sense-making and communication.

He writes a quarterly Visual Business Intelligence Newsletter, speaks and teaches internationally, and provides design consulting.  In 2004, he wrote the first comprehensive and practical guide to business graphics entitled Show Me the Numbers, in 2006, he wrote the first and only guide to the visual design of dashboards, entitled Information Dashboard Design, and in 2009 he wrote the first introduction for non-statisticians to visual data analysis, entitled Now You See It.

With that introduction to Stephen Few, I wanted to provide you a link to his web site and his review of Tableau 8. Here is a brief snippet of Stephen’s review.

“I’ve seen it happen many times, but it never ceases to sadden me. An organization starts off with a clear vision and an impervious commitment to excellence, but as it grows, the vision blurs and excellence gets diluted through a series of compromises. Software companies are often founded by a few people with a great idea, and their beginnings are magical. They shine as beacons, lighting the way, but as they grow, what was once clear becomes clouded, what was once firm becomes flaccid, and what was once promising becomes just one more example of business as usual.”




Get every new post delivered to your Inbox.

Join 474 other followers