You searched "powerpivot"
       24 articles of 288 results
article –

Budget and Other Data at Different Granularities in PowerPivot

PowerPivot and BISM Tabular handle relationships between tables by using a single column that requires to be a unique column in the lookup table. In this article you will see how to handle relationships between tables that have different granularities,…  Read more

article –

Automate PowerPivot Data Refresh in Excel

In many workshops and sessions about PowerPivot the most frequently asked question has always been: how can I automate the PowerPivot Data Refresh in Excel? I talked about that a few weeks ago.  Read more

article –

Separate date and time in PowerPivot (and BISM tabular)

In PowerPivot you can import data from several sources and it is often the case that you import a DateTime column from a database. From an analytical point of view, you usually make analysis over dates (day/month/year/quarter/week) and over time…  Read more