How to Create Value and Present Data to Business Executives in SharePoint
summary
Shows how to take PowerPivot workbooks and deliver them as dashboard‑style pages on SharePoint Enterprise using Excel Services: hide unused rows/columns, create a 100×100px sizing grid, upload a custom master page + branding.css, add an Excel Web Access web part (toolbar set to none, fixed height), and wire top navigation. Adds small JavaScript snippets for download snapshot and reset filters, recommends Atomic Browser for iPad and Power Update for scheduled refreshes; the setup produces faster, cleaner web reports and it works.
AI-written summary · about
chapters (14)
- 0:00Introduction
- 3:13Power Pivot sharing importance
- 8:07Generic vs enhanced reporting
- 13:56Enhanced reporting demo
- 20:19Preparing workbooks for upload
- 26:19SharePoint Enterprise settings
- 34:05Creating Excel web part pages
- 41:05Setting navigation menus
- 48:09JavaScript slicers and downloads
- 52:25Clickable dashboard links
- 55:15Finalizing reporting setup
- 57:41Mobile access optimization
- 58:22Managing data models and refreshes
- 1:00:09Q&A
related talks
01h 01mVisualization Choices: What, When, and How?
58mProductivity Revolution in Excel
59mPresent and Futures: Roadmap and Strategy
18mEmpowering Business Through Data
52mSelf-Service Business Analytics in 2013
01h 00mTaking BI to the Next Level: Collaboration
46mVisualizing Data for Non-Data Experts: Making Reports Accessible to All
55mOffice as Your BI Platform