Service Manager includes predefined Microsoft Online Analytical Processing (OLAP) data cubes that connect to the data warehouse to retrieve data so that you can manipulate it by using Microsoft Excel ...

In the first post in this series I showed a simple example of how you can use the FORECAST.ETS function in Excel in combination with the Excel cube functions to do forecasting with Power BI data. In ...

After my post on tuning Excel cube functions last week there was some (justified) moaning on Twitter about their performance. This got me thinking about other things you could do with cube functions ...

Dynamic array formulas automatically spill results into multiple cells, allowing for more efficient data handling and the creation of scalable templates that adapt to varying data sizes without manual ...

Despite being considered advanced, array formulas are easy to use and powerful if you can recognize when to best use them. Here's my best explanation on how they work. One of the most time consuming ...

As one of the most popular productivity tools in the modern world, it’s no secret that Microsoft Excel is an incredibly versatile and useful piece of software. With a wide range of features and ...

Excel's basic formulas work fine for simple calculations, but they quickly become cumbersome when you're dealing with complex data analysis. You end up with nested functions that are hard to read, ...