| Creating useful PowerPivot data models for public consumption via Reporting Services |
| Written by Russell Christopher |
| Thursday, 26 November 2009 12:15 |
|
If you’ve played with PowerPivot at all, it’s pretty obvious how flexible the tool is in terms of creating data models. After you initially create a model, you may want to spend some additional time with it to make sure users can easily leverage what you’ve created in other tools. If you don’t, the PowerPivot model you publish probably won’t see lots of re-use outside of the PowerPivot gallery and Excel because users won’t be able to get at the values they want to. What am I talking about? Here’s an example:
|
Author articles
- PowerPivot on the iPad: Best Practices
- Re-creating the PowerPivot Management Dashboard’s “Sliding Bubble Chart”
- Business Intelligence Indexing Connector “breaks” PowerPivot Gallery on “All in One” machine
- PowerPivot, DAX and Semi-additive measures
- SQL Server Reporting Services Reports in the PowerPivot Gallery
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
