Related: Business Intelligence Market Shifts
Back in October 2012, I built my own treemap after a passionate appeal to Excel's program management team was denied. Sometimes you just need to keep on moving forward and fill the voids yourself. Other BI vendors are doing the exact same thing right now—showcasing APIs that serve as wrappers around d3.js to extend base data visualization offerings.
Apps for Office run inside Excel desktop clients and within Office 365 Excel documents online. Theoretically, these web-friendly, modern Excel add-ins should work with most mobile web browsers including Windows, iPad, iPod, and Androids devices. I tested my Excel treemap from Office 365 with an iPad and indeed, it worked for me. However, I have heard reports that the new native Office Mobile Apps do not support the Apps of Office framework at this time due to limitations in the way Apple allows external communications.
If you want to get started building an Office App data visualization, check out the Office Developer tutorial. You'll need to install the Office 365 Development Tools app on your Office 365 site. You can code Office Apps directly within a web browser, no Visual Studio installation is necessary. You might need a low cost Office 365 Developer account and Office 2013 Professional Plus to test your visualization masterpiece. If you have an MSDN subscription, an Office 365 Developer account should already be included in your subscription.
If you aren’t quite ready to take the Office App developer programming plunge, you can still enjoy publicly available data visualizations in the Office Store. On the Excel 2013 INSERT menu, choose Store, perform a search for data visualization, and select an app to install. A few of the more popular apps include:
- People Graph
- Geographic Heatmap
- Radial Chart
- Smart Charts
- XLMiner Data Visualization
New applications get added to the Office Store fairly often, so it's worth checking out monthly. If you get easily distracted, be prepared to spend a few hours or more exploring and playing with all the really cool Excel Office Apps that are available.