Topic: DAX

        Page 36 of 369 posts
blog post –

PowerPivot Course European Roadshow – first stop London #ppws

After the successful first edition in Amsterdam of the PowerPivot Workshop in December, we are planning to repeat this 2-day intensive course on PowerPivot in several other European countries (we are also evaluating one or two possible dates in US – please  Read more

blog post –

PowerPivot Sessions from TechEd OnLine

If you have not been at Microsoft Business Intelligence Conference this year, which was co-located with TechEd 2010, you probably missed the sessions I and Alberto made there. Well, now you can watch them online on Microsoft TechEd Online site: DAX Patterns  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 –

Many-to-many relationships in PowerPivot – more samples!

Alberto wrote a really fine post that should help you to better understand how many-to-many relationships can work in PowerPivot, using a lot of images that explain some concepts better than a thousand words. The example shown by Alberto is really interesting  Read more

blog post –

Inside DAX session at PASS

I will be a speaker this year at PASS Summit 2010 in Seattle, and I will present two sessions. The one I’d like to talk about in this post is the Inside DAX one. I chose to do this session (instead of another one that was initially planned) because when  Read more

blog post –

Define groups of values using PowerPivot

Alberto Ferrari posted an interesting article that show how you can use a continuous value in a group of values in PowerPivot. I think this is a feature that many users would like to get in a standard Analysis Services cube, but that unfortunately requires  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 –

PowerPivot book RTM! And some DAX thoughts…

Yesterday I had a nice time delivering the SQLBI Methodology session at 24 Hours of PASS . A few hours later, I had the news about the official RTM of the PowerPivot book I wrote with Alberto. The complete title is Microsoft® PowerPivot for Excel® 2010:  Read more

blog post –

Rounding functions in DAX

Today I prepared a table of the many rounding functions available in DAX (yes, it’s part of the book we’re writing), so that I have a complete schema of the better function to use, depending on the round operation I need to do. Here is the list of functions  Read more

blog post –

TechEd NorthAmerica 2010 (and MS BI Conference 2010) Sessions

I just read the Dave Wickert post about his sessions about PowerPivot from Microsoft at TechEd 2010 in New Orleans (June 7-10, 2010) and there are at least two things I’d like to add. First of all, there is also another conference! In fact, this time  Read more