OMB Data Visualization Tool Requirements Analysis: MicroStrategy

1. OMB Data Visualization Tool Requirements Analysis: MicroStrategy Dr. Brand Niemann Director and Senior Data Scientist Semantic Community http://semanticommunity.info/ AOL Government Blogger http://breakinggov.com/author/brand-niemann/ July 29, 2013 http://semanticommunity.info/Data_Science/Free_Data_Visualization_and_Analysis_Tools/MicroStrategy

2. Background • DRAFT White Paper for OMB Pittsburgh, July 11, 2013. • Start With the End in Mind, Avoid Tool and Turf Wars, and Develop Well-designed Spreadsheets That Can be “Dragged and Dropped” Onto a Tool That Creates Statistics and Visualizations in the Public and Private Clouds. • Focus on Requirements Analysis by First Comparing Magic Quadrant Leaders and Challengers on Common Data Sets. • Spotfire Was Able to Reproduce Birst, IBM, Information Builders, Logi Analytics, Microsoft, QlikView, SAS, and Tableau Data Visualizations With Dynamically Linked Visualizations. • Broaden This Requirements Analysis to Include More Sample Data Sets and Tools. • MicroStrategy Is a Leader in the Gartner Magic Quadrant.

3. Gartner BI Magic Quadrant: MicroStrategyMicroStrategyAnalytics Strengths and Cautions Excerpts • MicroStrategy specializes in enterprise BI deployments running on top of large EDWs. It is typically deployed in larger enterprises that consider it to be their enterprise BI standard. Its deployments remain among the most complex in terms of functionality, large numbers of users, high data volume and wide deployment across an enterprise, although it is not as distinctive from competitors as in the past. • In 2012, it was recognized by Gartner as having the broadest and most advanced set of mobile capabilities in the BI market (see "Critical Capabilities for Mobile BI"), and it has continued to evolve the mobile tool, adding new visualizations, improving performance and delivering tight integration with the data discovery tool (Visual Insight) and the cloud offerings.  • There are two other forward-looking focus areas for the company: Hadoopintegration — for semistructured and unstructured data analysis, and for social data leveraging — through a connector that delivers Facebook profile data to a MicroStrategy analytic application. • While the MicroStrategy development environment is robust and flexible, there is a steep learning curve, even for seasoned report developers building any level of analytic complexity into parameterized reports that simulate ad hoc analysis and interactive dashboards for business users. • MicroStrategy has the lowest usage of predictive analytics of all vendors in the Magic Quadrant. Note: Bolding by the author to highlight key points. Source: http://www.gartner.com/technology/reprints.do?id=1-1DYKLUR&ct=130206&st=sb

4. MicroStrategy: Home Page http://www.microstrategy.com/

5. MicroStrategy: Free Software http://www.microstrategy.com/software/free

6. MicroStrategy: Download http://www.microstrategy.com/evaluation-edition

7. MicroStrategy: Registration Please note that MicroStrategy Version 9.3.1 Evaluation Edition Software is available for use with corporate email accounts only. You may create an account using a personal email address, but certain resources like this one require a corporate email address. https://resource.microstrategy.com/login/login.aspx?ReturnUrl=%2fResourceCenter%2f%3frid%3d28058%26CID%3d&rid=28058&CID=

8. MicroStrategy: Express http://www.microstrategy.com/express

9. MicroStrategy: Express Registration https://www.microstrategy.com/express/login/

10. MicroStrategy: Express Web Client https://cloud2.microstrategy.com/MicroStrategy/servlet/mstrWeb;jsessionid=FA1F34D00F14402F202E48E4E03DA5F6;uxts1375028588335

11. MicroStrategy:World Development Indicators Web URL http://semanticommunity.info/AOL_Government/2012_International_Open_Government_Data_Conference#World_Bank_World_Development_Indicators https://silverspotfire.tibco.com/us/library#/users/bniemann/Public?DataCatalogAnalytics-Spotfire

12. MicroStrategy: Select Data Source https://cloud2.microstrategy.com/MicroStrategy/servlet/mstrWeb;jsessionid=4DAB49F2A086A12DCA3B0D9ECFD15771;uxts1375044026505

13. PresidentsBudgetFY2012: Spreadsheet http://semanticommunity.info/@api/deki/files/15625/Presidents2012Budget.xlsx

14. MicroStrategy: Review Data https://cloud2.microstrategy.com/MicroStrategy/servlet/mstrWeb;jsessionid=4DAB49F2A086A12DCA3B0D9ECFD15771;uxts1375044026505

15. MicroStrategy: Knowledge Base http://semanticommunity.info/Data_Science/Free_Data_Visualization_and_Analysis_Tools/MicroStrategy

16. Historical Deficits: Spotfire https://silverspotfire.tibco.com/us/library#/users/bniemann/Public?PresidentsBudgetforFiscalYear2012-Spotfire

17. Presidents Budget FY2012: Spotfire https://silverspotfire.tibco.com/us/library#/users/bniemann/Public?PresidentsBudgetforFiscalYear2012-Spotfire

18. Some Conclusions and Recommendations • Semantic Community Was Able to Import An Excel File Into MicroStrategy Express But It Did not Automatically Generate (Intelligent Analytics) Dynamically Linked Graphics Like Spotfire Does. • Spotfire Provides Similar Features To MicroStrategy Express, But the Author Finds Spotfire Much Easier and Faster to Use. • MindTouch and Spotfire Are More Versatile Than MicroStrategy Express For Mashups. • Semantic Community Will Continue to Use The Gartner BI Magic Quadrant Leader Tools and Their Sample Data Sets and to Recreate Visualizations and Dashboards.