XLCubed Blog ../ XLCubed Blog Thu, 11 Nov 2021 11:17:07 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png XLCubed Blog ../ 32 32 Updating SQL Tables from Excel: A New Approach (Part 2) ../2021/11/updating-sql-tables-from-excel-a-new-approach-part-2/ ../2021/11/updating-sql-tables-from-excel-a-new-approach-part-2/#respond Thu, 11 Nov 2021 11:16:15 +0000 https://blog.xlcubed.com/?p=6415 In part 1 of this article, we have prepared the table for the update. In this second part, we will learn how to update the SQL table with only the rows modified by the user. Part 2: Tracking Changes and Updating the SQL Table Tracking the changed rows We need a way to track what […]

The post Updating SQL Tables from Excel: A New Approach (Part 2) appeared first on XLCubed Blog.

]]> ../2021/11/updating-sql-tables-from-excel-a-new-approach-part-2/feed/ 0 Updating SQL Tables from Excel: A New Approach (Part 1) ../2021/11/updating-sql-tables-from-excel-a-new-approach-part-1/ ../2021/11/updating-sql-tables-from-excel-a-new-approach-part-1/#respond Thu, 11 Nov 2021 11:15:00 +0000 https://blog.xlcubed.com/?p=6399 In a previous blog article, Ambika presented a neat method to update an SQL table from Excel.  This proved to be useful for many of our customers but could somewhat be painful for those wishing to update many rows. Today, an increasing number of XLCubed customers use Excel as a planning sandbox and often want […]

The post Updating SQL Tables from Excel: A New Approach (Part 1) appeared first on XLCubed Blog.

]]> ../2021/11/updating-sql-tables-from-excel-a-new-approach-part-1/feed/ 0 Chart-driven Table Highlighting ../2021/10/chart-driven-table-highlighting/ ../2021/10/chart-driven-table-highlighting/#respond Thu, 21 Oct 2021 09:19:37 +0000 https://blog.xlcubed.com/?p=6376 Recently a customer raised a support issue asking if it was possible to highlight a row within a table based on a selection made in a chart. Interactive charting being a core XLCubed feature, of course it is! Here we can click on a country to highlight the relevant rows or we can go one […]

The post Chart-driven Table Highlighting appeared first on XLCubed Blog.

]]> ../2021/10/chart-driven-table-highlighting/feed/ 0 Dashboard Titles ../2021/08/dashboard-titles/ ../2021/08/dashboard-titles/#respond Wed, 11 Aug 2021 08:33:00 +0000 https://blog.xlcubed.com/?p=6343 Interactive and responsive dashboard sheets have been a core feature of XLCubed for a number of years. Version 10.0.81 introduced dashboard titles (with additional improvements added in 10.0.98) as a further way to simplify the dashboarding process. Titles can be added to any existing dashboard item. They can contain a text label as well as […]

The post Dashboard Titles appeared first on XLCubed Blog.

]]> ../2021/08/dashboard-titles/feed/ 0 Scenario Comparisons With Variance Charts ../2021/03/scenario-comparisons-with-variance-charts/ ../2021/03/scenario-comparisons-with-variance-charts/#respond Mon, 01 Mar 2021 13:59:03 +0000 https://blog.xlcubed.com/?p=6323 Business data is often better understood when viewed in the context of another scenario. We need to know if we are doing better than this time last year, or how close we are to meeting our budget. Variance charts are effective at displaying these differences between actual and comparative values. They can show absolute or […]

The post Scenario Comparisons With Variance Charts appeared first on XLCubed Blog.

]]> ../2021/03/scenario-comparisons-with-variance-charts/feed/ 0 Faster Excel Queries For Power BI & Azure Analysis Services ../2021/02/faster-excel-queries-for-power-bi-azure-analysis-services/ ../2021/02/faster-excel-queries-for-power-bi-azure-analysis-services/#respond Tue, 09 Feb 2021 09:57:30 +0000 https://blog.xlcubed.com/?p=6286 If you have slow queries when reporting table format data in Excel from PowerBI.com, Azure Analysis Services or Tabular SSAS, this could be just the performance boost you need. Excel Pivot Tables query Power BI and Analysis Services using MDX, and sometimes the MDX they generate is not ideal. XLCubed Grids also query using MDX, […]

The post Faster Excel Queries For Power BI & Azure Analysis Services appeared first on XLCubed Blog.

]]> ../2021/02/faster-excel-queries-for-power-bi-azure-analysis-services/feed/ 0 Waterfall Charts for Profit and Loss Statements ../2021/02/waterfall-charts-for-profit-and-loss-statements/ ../2021/02/waterfall-charts-for-profit-and-loss-statements/#respond Tue, 02 Feb 2021 09:37:11 +0000 https://blog.xlcubed.com/?p=6263 Income statements, or Profit and Loss statements, are an essential part of any business. However, when displayed as a large table of numbers, it can be difficult to draw out the information needed to answer simple questions such as “how has my revenue changed compared to last year?” or “which region has the largest contribution […]

The post Waterfall Charts for Profit and Loss Statements appeared first on XLCubed Blog.

]]> ../2021/02/waterfall-charts-for-profit-and-loss-statements/feed/ 0 Waterfall Charts in Excel – Time Analysis ../2021/01/waterfall-charts-in-excel-time-analysis/ ../2021/01/waterfall-charts-in-excel-time-analysis/#comments Fri, 08 Jan 2021 10:15:49 +0000 https://blog.xlcubed.com/?p=6246 Waterfall charts are a great way of visualising contributions to a total or a total variance. They allow you to analyse how a value is influenced by the cumulative effect of underlying positive or negative inputs. This can lead to quicker and more effective business insights. Waterfalls are available as a chart type with XLCubed, […]

The post Waterfall Charts in Excel – Time Analysis appeared first on XLCubed Blog.

]]> ../2021/01/waterfall-charts-in-excel-time-analysis/feed/ 1 Lessons from IBCS – Scenario Handling ../2020/10/lessons-from-ibcs-scenario-handling/ ../2020/10/lessons-from-ibcs-scenario-handling/#respond Mon, 05 Oct 2020 09:20:19 +0000 https://blog.xlcubed.com/?p=6218 In the previous blog, we looked at how consistency is important throughout a set of reports and dashboards. It helps users to understand the reports quickly and easily. Another important aspect to maintain is scenario handling; this forms the UNIFY part of IBCS’ SUCCESS formula. Scenarios are used to represent different types of business data […]

The post Lessons from IBCS – Scenario Handling appeared first on XLCubed Blog.

]]> ../2020/10/lessons-from-ibcs-scenario-handling/feed/ 0 Lessons from IBCS – Maintaining Visual Integrity ../2020/08/maintaining-visual-integrity/ ../2020/08/maintaining-visual-integrity/#respond Fri, 14 Aug 2020 07:46:24 +0000 https://blog.xlcubed.com/?p=6187 When reading reports and dashboards, we often find ourselves spending more time than we’d expect analysing the charts and tables tying to comprehend the data. In many cases that’s due to inconsistencies in the presentation, or poor design. Ideally a report should convey the message clearly and quickly. One of the underlying rules of IBCS […]

The post Lessons from IBCS – Maintaining Visual Integrity appeared first on XLCubed Blog.

]]> ../2020/08/maintaining-visual-integrity/feed/ 0