Topic: Excel

        Page 5 of 60 posts
blog post –

Stock Analysis and Moving Average with PowerPivot

One week ago Alberto Ferrari wrote a post about how to do working days calculation in PowerPivot . You might think this is necessary only for accounting department or something like that… but in reality the same techniques are really useful to implement  Read more

blog post –

BonaVista Dimensions used as a report service

Recently I have seen a long demo of BonaVista Dimensions . It is a product that is able to create reports and, most important dashboards. You can use it also without SQL Server and Analysis Services, just by importing data in a local cube file that you  Read more

blog post –

A new Excel 2010 book for Data Analysis

Microsoft Press just announced the printing of Microsoft Excel 2010: Data Analysis and Business Modeling , which is the third edition of the book written by Wayne L. Winston covering many data analysis and modeling techniques using a very clear problem-solution  Read more

blog post –

The Microsoft BI Roadmap: BISM, UDM and Beyond

Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it  Read more

blog post –

PowerPivot ebook – 50% discount offer of the day

Yesterday I delivered my Inside DAX session at PASS 2010. Someone might have missed the link to buy the PowerPivot for Excel 2010 book with a 50% discount that is valid just today. The link is http://oreil.ly/sqlpass2010 !  Read more

blog post –

PowerPivot book sample chapters available in PDF

You can download these two sample chapters of the PowerPivot for Excel 2010: Give Your Data Meaning book: Chapter 2 – PowerPivot at Work This is introductive and suggested to read to anyone who is new to PowerPivot Chapter 7 – Date Calculations in DAX  Read more

blog post –

Banding with PowerPivot

Banding is one of the most common requirements when you have the need to analyze continuous values, like the retail price of a product which may change over time, due to discounts and price variations. I have already spoken about banding with regards  Read more

blog post –

Using SSAS 2005/2008 as PowerPivot Data Source: Direct MDX

If you write direct MDX queries using SSAS 2005/2008 as a PowerPivot data source, it is better if you prepare your MDX query by using another editor. For example, write and test your MDX query by using SQL Server Management Studio and then copy &  Read more