| Budgeting Solution Built with PowerPivot |
| Written by Alberto Ferrari |
| Friday, 25 June 2010 21:16 |
|
How will users work with Microsoft PowerPivot for Microsoft Excel 2010? Will they find problems during their everyday work? We tried to answer this apparently simple question creating a complete PowerPivot application that will manage the budgeting needs of a company. Join us in “that guy’s" shoes as we take the sales data of AdventureWorks from an OLAP cube, collect Excel sheets from departments, some information about how the market will change in the future and integrate all this information into a PowerPivot data model that will let "that guy" build reports and handle the budget of the company. In this session we describe all the tools used and choices made during the building process, showing some insights of a real case of use of PowerPivot. We try to analyze problems even before the market will need to handle them, in order to bring our users good advice from the beginning with the introduction of PowerPivot.
|
Author articles
- Understanding Circular Dependencies in Tabular and PowerPivot
- Video - Many-to-Many Relationships in DAX
- KEEPFILTERS: a new DAX feature to correctly compute over arbitrary shaped sets
- Tabular Parent/Child Dimensions: SumOfLeaves and the CALCULATE wall
- Video - PowerPivot Advanced Data Modeling
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?



