Microsoft

Last modified

Story

OMB Data Visualization Tool Requirements Analysis: Microsoft

Slides

Background

  • DRAFT White Paper for OMB Pittsburgh, July 11, 2013.
  • Start With the End in Mind, Avoid Tool 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 on Common Data Sets.
  • Spotfire Was Able to Reproduce Birst, Tableau, and QlikView Data Visualizations With Dynamically Linked Visualizations.
  • Broaden This Requirements Analysis to Include More Sample Data Sets and Tools.
  • Microsoft Is a Leader in the Gartner Magic Quadrant.


Gartner BI Magic Quadrant: Microsoft
Microsoft Strenghts and Cautions Excerpts

  • The company's strategy has been to enhance the BI capabilities in three of its core offerings with each release — including Microsoft Office (specifically Excel), Microsoft SQL Server and Microsoft SharePoint — to increase their value and drive upgrades.
  • Office 2013, Excel is no longer the former 1997, 64K row-limited, tab-limited spreadsheet. It finally begins to deliver on Microsoft's long-awaited strategic road map and vision to make Excel not only the most widely deployed BI tool, but also the most functional business-user-oriented BI capability for reporting, dashboards and visual-based data discovery analysis. Over the next year, Microsoft plans to introduce a number of high-value and competitive enhancements to Excel, including geospatial and 3D analysis, and self-service ETL with search across internal and external data sources. These enhancements, along with planned support for analyzing large and diverse data (PolyBase, Microsoft's platform to enable a single query across relational and Hadoop data sources, is due in the first half of 2013).
  • Building on the in-memory capabilities of PowerPivot in SQL Server 2012, Microsoft introduced a fully in-memory version of Microsoft Analysis Services cubes, based on the same data structure as PowerPivot, to address the needs of organizations that are turning to newer in-memory OLAP architectures over traditional, multidimensional OLAP architectures to support dynamic and interactive analysis of large datasets.
  • Multiproduct complexity is a challenge. Because Microsoft's BI platform capabilities exist across three different tools (Office, SQL Server and SharePoint) that also perform non-BI functions, integrating the necessary components and building the applications is left to the organization. Microsoft's do-it-yourself approach puts more of the BI solution's development and integration onus for the platform components on customers, compared with the all-in-one purpose-built BI platforms offered by most other vendors in the BI market.
  • Microsoft lags behind most other BI vendors in delivering mobile BI capabilities. It has been slow to deliver BI on mobile devices.

Note: Bolding by the author to highlight key points.
Source: http://www.gartner.com/technology/re...t=130206&st=sb

Semantic Community

Some Conclusions and Recommendations

  • Semantic Community Was Able to Build the Complete Scotland Environmental Statistics 2012 in Spotfire Using MindTouch and Excel.
  • Some Modifications to Excel Tables Are Necessary to Effectively Use Them in Spotfire.
  • MindTouch and Spotfire Are More Versatile Than SharePoint and Excel 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.

Slides

Slides

Slide 1 OMB Data Visualization Tool Requirements Analysis: Microsoft

http://semanticommunity.info/
http://breakinggov.com/author/brand-niemann/
http://semanticommunity.info/Data_Science/Free_Data_Visualization_and_Analysis_Tools/Microsoft

BrandNiemann07192013Slide1.PNG

Slide 2 Background

BrandNiemann07192013Slide2.PNG

Slide 3 Gartner BI Magic Quadrant: Microsoft

http://www.gartner.com/technology/re...t=130206&st=sb

BrandNiemann07192013Slide3.PNG

Slide 5 Principles and Practices for a Federal Statistical Agency: Knowledge Base

http://semanticommunity.info/CNSTAT/Principles_and_Practices_for_a_Federal_Statistical_Agency

BrandNiemann07192013Slide5.PNG

Slide 6 National Statistics for Scotland: Web Page

http://www.scotland.gov.uk/Publicati...2012/08/2023/0

BrandNiemann07192013Slide6.PNG

Slide 7 National Statistics for Scotland: Excel Graphic 1

http://www.scotland.gov.uk/Publicati...012/08/2023/27

BrandNiemann07192013Slide7.PNG

Slide 9 National Statistics for Scotland: Excel Graphic 2

http://semanticommunity.info/@api/deki/files/24898/ScotlandEnvironmentalStats2012.xls

BrandNiemann07192013Slide9.PNG

Slide 10 Spotfire – a new, innovative way to display water quality information

http://www.sepaview.com/2013/06/spot...y-information/

BrandNiemann07192013Slide10.PNG

Slide 11 National Statistics for Scotland: Excel Table for Spotfire

http://semanticommunity.info/@api/deki/files/24898/ScotlandEnvironmentalStats2012.xls

BrandNiemann07192013Slide11.PNG

Slide 12 Scotland Environmental Statistics 2012: Spotfire Cover Page

https://silverspotfire.tibco.com/us/...s2012-Spotfire

BrandNiemann07192013Slide12.PNG

Slide 13 Scotland Environmental Statistics 2012: Spotfire Drinking Water Quality: 1991-2011

https://silverspotfire.tibco.com/us/...s2012-Spotfire

BrandNiemann07192013Slide13.PNG

Slide 14 Some Conclusions and Recomendations

BrandNiemann07192013Slide14.PNG

Spotfire Dashboard

For Internet Explorer Users and Those Wanting Full Screen Display Use:  Web Player Get Spotfire for iPad App

Research Notes

Source: http://www.gartner.com/technology/reprints.do?id=1-1DYKLUR&ct=130206&st=sb

Miicrosoft Strenghts and Cautions Excerpts

The company's strategy has been to enhance the BI capabilities in three of its core offerings with each release — including Microsoft Office (specifically Excel), Microsoft SQL Server and Microsoft SharePoint — to increase their value and drive upgrades.

Office 2013, Excel is no longer the former 1997, 64K row-limited, tab-limited spreadsheet. It finally begins to deliver on Microsoft's long-awaited strategic road map and vision to make Excel not only the most widely deployed BI tool, but also the most functional business-user-oriented BI capability for reporting, dashboards and visual-based data discovery analysis. Over the next year, Microsoft plans to introduce a number of high-value and competitive enhancements to Excel, including geospatial and 3D analysis, and self-service ETL with search across internal and external data sources. These enhancements, along with planned support for analyzing large and diverse data (PolyBase, Microsoft's platform to enable a single query across relational and Hadoop data sources, is due in the first half of 2013).

Building on the in-memory capabilities of PowerPivot in SQL Server 2012, Microsoft introduced a fully in-memory version of Microsoft Analysis Services cubes, based on the same data structure as PowerPivot, to address the needs of organizations that are turning to newer in-memory OLAP architectures over traditional, multidimensional OLAP architectures to support dynamic and interactive analysis of large datasets.

Multiproduct complexity is a challenge. Because Microsoft's BI platform capabilities exist across three different tools (Office, SQL Server and SharePoint) that also perform non-BI functions, integrating the necessary components and building the applications is left to the organization. Microsoft's do-it-yourself approach puts more of the BI solution's development and integration onus for the platform components on customers, compared with the all-in-one purpose-built BI platforms offered by most other vendors in the BI market.

Microsoft lags behind most other BI vendors in delivering mobile BI capabilities. It has been slow to deliver BI on mobile devices.

Page statistics
1505 view(s) and 11 edit(s)
Social share
Share this page?

Tags

This page has no custom tags.
This page has no classifications.

Comments

You must to post a comment.

Attachments