You searched "dax"
        Page 53 of 532 results
blog post –

Vizubi: the first competitor of PowerPivot

A couple of weeks ago the first version of Vizubi has been released. It is an Excel AddIn with many of the features of PowerPivot, but also with a few important differences. I made some tests and in this post I give my first impression of the product.  Read more

blog post –

Microsoft BI Conference 2010 Recap & books promo

Last week I’ve been at Microsoft BI Conference and I presented an interactive session about PowerPivot DAX Patterns. Unfortunately only the breakout session were recorded and available on TechEd Online . The room was full and there were probably many  Read more

blog post –

How to start with PowerPivot for Excel

Now that Office 2010 has been released, many people will start looking for resources to start learning PowerPivot. Of course, the book I’m writing will be helpful when it will be published (September 2010), but you can also start with some online content  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

video –

PowerPivot Advanced Data Modeling

During this session we are going to analyze common business problems that require and advanced usage of DAX functions and data modeling. Examples include banding of price in ranges, advanced simulation with the usage of many-to-many relationships, usage of dynamic…  Watch now

video –

BISM Introduction

BISM (BI Semantic Model) is the new engine that will be available in Analysis Services “Denali”. Explore the capabilities of this new model, that will be an alternative to UDM in Analysis Services and will use the new Vertipaq engine…  Watch now

blog post –

Memory Considerations about PowerPivot for Excel

PowerPivot for Excel is an Add-In which uses a local version of Analysis Services (SSAS) to process data and make calculation to respond to user queries made using Excel 2010. The SSAS engine is loaded in-memory in the process of Excel. Especially with  Read more

blog post –

ABC Analysis in PowerPivot

The calculation for ABC analysis can be made in PowerPivot using calculated columns. In this way each row can have an attribute with the appropriate ABC class. The ABC calculation has to be made considering a particular grouping and sort order. For example,  Read more