Extending PowerPivot into a Scalable Component for Enterprise BI
summary
Shows how a PowerPivot workbook becomes a server-hosted BI component by uploading an Excel PowerPivot into SQL Server 2012 Tabular, applying role security, and serving it through Pyramid’s web apps (BioExcel, BioPoint). Demo uses a 360–400K row transactional set — 360,000 customers and ~400,000 facts — and produces a real-time Market Basket without data mining via parameterized sets and MDX, all built, secured and dashboarded live; product scales to hundreds of users and the demo executes successfully.
AI-written summary · about
chapters (12)
- 0:00Enterprise PowerPivot scaling
- 2:50PowerPivot frontend limits
- 8:27Pyramid Analytics for BI
- 11:15Market Basket setup
- 15:34PowerPivot model from Excel
- 22:53Deploying to Pyramid
- 27:08Cube analysis with Excel
- 33:06Advanced Market Basket
- 42:19Dashboard from results
- 44:46Dashboard design in bio Point
- 49:42Summary and scalability
- 53:56Q&A
related talks
18mEmpowering Business Through Data
45mRebooting your SME Data Analysis Strategy
50mPower BI + Azure Synapse Analytics: Beginning your journey
51mPower BI Composite and Hybrid Models
01h 13mDiscover, Acquire, and Transform Your Data with Power Query
48mDon't be scared with Hybrid, they are only tables…
51mSupercharge Power BI with Azure Synapse Analytics
49mNew ways to optimize shared datasets in the Power BI Service