Office as Your BI Platform

on YouTube ↗55m

" summary

Office 365 provisions a SharePoint site in minutes and streams Office 2013 to a PC via click-to-run streaming so Excel 2013 runs side-by-side with older Office versions; PowerPivot built into Excel and Power View authoring create data models and visual reports that publish to SharePoint and the browser (pivot field list, timeline slicer, Flash Fill, Quick Analysis all work). Audit/Inquire flags hidden sheets and formula issues. Current limits: 10 MB file limit on Office 365 workbooks and external data refresh is not yet supported; most demos run live, Silverlight powers some visuals.

AI-written summary · about

" chapters (5)

1. 0:00Office as BI platform
2. 13:14Excel 2013 BI overview
3. 21:50Interactive BI reports in Excel
4. 39:46Limitations and roadmap
5. 47:07Q&A

" related talks

• 01h 01mHow to Create Value and Present Data to Business Executives in SharePointMatt Allington · PASS Business Analytics Conference 2015
• 52mPower Up with the Power PlatformHeidi Hasting · SQLBits 2023
• 58mProductivity Revolution in ExcelAvi Singh, Purna Duggirala · PASS BA Marathon 2015
• 49mSharePoint Online and Power Apps : Better TogetherAroh Shukla · Power Platform Virtual Conference 2021
• 08mOffice Extensibility OverviewRob Lefferts · Connect(); // 2015
• 01h 04mBeyond the site: Building intelligent apps with SharePoint EmbeddedDavid Warner II, Vesa Juvonen, Steve Pucelik · SharePoint Hackathon 2026
• 08mHow and Where to Acquire AppsRussell Palmer · Connect(); // 2015
• 01h 03mPower BI for the DeveloperPeter Myers · NDC Sydney 2016