XLCubed - Updates
News from XLCubed!
XLCubed is an amazing frontend tool that luckily only gets better and better. This February and March, the developers of XLCubed have made improvements making the tool both faster and better to work with.
You can read much more about exactly what this implies below.
Faster Excel Queries for Power BI & Azure Analysis Services
One of the reasons why many users choose XLCubed above many other frontend tools is the short load times in relation to data queries. However, XLCubed has experienced dissatisfying load times when it comes to data queries from Power BI and Azure Analysis Services to Excel, especially regarding great data volumes. This has now been solved by using DAX queries instead of MDX queries, which has shortened the load times with 3,5 to 4 times depending on the data volume.
If you want to know more about the new update and the reason for it, you can do just that right here: https://blog.xlcubed.com/2021/02/faster-excel-queries-for-power-bi-azure-analysis-services/
Scenario Comparisons with Variance Charts
It is often easiest to comprehend and analyze business data when it is assessed in a context measured against another scenario. This can for example be in relation to this year’s accounts measured against last year’s accounts, or it can be an assessment of how close you are to achieving a budget. For this purpose, variance charts are very applicable as they give a very clear picture of the difference between actuals and the comparative values. Below is shown examples of how both absolute and relative variance charts can look like.
These charts are available in XLCubed 10, where you can choose the chart type from the task panel and define both the active values as well as the comparative values (typically two scenarios or the current year measured against last year).
If you want to read more about the variance charts and how to use them, you can do just that right here:
News from XLCubed!
Reporting options are many with XLCubed but luckily, the developers constantly keep innovating new improvements making the opportunities within visualizations numerous. This January, XLCubed has launched waterfall charts for time analysis, which is a great way of visualizing individual contributions to a total or a total variance.
Read more about the new update here:
Waterfall Charts for Time Analysis
This new update allows you to analyze how a value is influenced by the cumulative effect of underlying positive or negative inputs, which can help you effectively interpreting for example where in a time series that your individual departments are performing as illustrated below.
The new chart type is accessible as every other chart type in XLCubed, and they connect directly to your data source, are fully interactive, and are easily inserted into an Excel sheet as you already know it from XLCubed.
You can read much more about the new waterfall charts and access a detailed review of how to use all the features included in the new chart type below.