Data – XLCubed Blog ../../../ XLCubed Blog Tue, 09 Feb 2021 09:57:33 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png Data – XLCubed Blog ../../../ 32 32 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 Updating SQL Tables from Excel ../../../2020/03/updating-sql-tables-from-excel/ ../../../2020/03/updating-sql-tables-from-excel/#comments Thu, 05 Mar 2020 15:55:02 +0000 https://blog.xlcubed.com/?p=5896 Most of our customers use XLCubed for reporting, analysis and data visualisation, but an increasing number use it for data updates, either within budgeting and forecasting solutions or in niche applications. XL3RunSQL is a neat method for running SQL updates from Excel, and allows users to build input forms (which can ultimately be web-enabled) quickly […]

The post Updating SQL Tables from Excel appeared first on XLCubed Blog.

]]> ../../../2020/03/updating-sql-tables-from-excel/feed/ 2 Member Searching ../../../2019/03/member-searching/ ../../../2019/03/member-searching/#respond Thu, 21 Mar 2019 09:37:36 +0000 https://blog.xlcubed.com/?p=4934 Did you know how easy it is to search for members within XLCubed? Here’s a simple grid – let’s search for members within the Geography hierarchy. First of all, let’s open the Geography member selector by just double-clicking the Geography header. XLCubed offers a number of options when searching. Firstly, you can simply enter a […]

The post Member Searching appeared first on XLCubed Blog.

]]> ../../../2019/03/member-searching/feed/ 0 Data Mashups 101 ../../../2019/01/data-mashups-101/ ../../../2019/01/data-mashups-101/#respond Fri, 04 Jan 2019 09:25:37 +0000 https://blog.xlcubed.com/?p=4724 In an ideal world for report designers, all the data required for a report is available in one data source, and the structure and hierarchies perfectly match the reporting needs. Sadly, the world isn’t always ideal (just ask Theresa May…). We often see scenarios where users are reporting numerical data from Analysis Services but want […]

The post Data Mashups 101 appeared first on XLCubed Blog.

]]> ../../../2019/01/data-mashups-101/feed/ 0 Auto refresh in XLCubed Pivot-views and Power BI ../../../2017/02/auto-refresh-xlcubed-and-powerbi/ ../../../2017/02/auto-refresh-xlcubed-and-powerbi/#respond Mon, 20 Feb 2017 11:01:15 +0000 https://blog.xlcubed.com/?p=4332 Version 9 of XLCubed introduced Pivot-views, which allow our powerful grids, small multiples and slicers to be driven directly from lots of different relational sources. We also added support for Power BI as a data source, and many of our customers are now using XLCubed on Power BI data for a better in-Excel experience and slice and […]

The post Auto refresh in XLCubed Pivot-views and Power BI appeared first on XLCubed Blog.

]]> ../../../2017/02/auto-refresh-xlcubed-and-powerbi/feed/ 0 DAX Performance tips– lessons from the field ../../../2016/06/dax-performance-tips-lessons-from-the-field/ ../../../2016/06/dax-performance-tips-lessons-from-the-field/#respond Fri, 10 Jun 2016 15:56:58 +0000 http://blog.xlcubed.com/?p=4239 XLCubed has supported a drag/drop interface for creating reports against Tabular Analysis Services since the first release of the new engine. It lets users easily create reports which run DAX queries on the cube, and we’ve often seen very good performance at customers when MDX against Tabular was a cause of long running reports. So […]

The post DAX Performance tips– lessons from the field appeared first on XLCubed Blog.

]]> ../../../2016/06/dax-performance-tips-lessons-from-the-field/feed/ 0 Some Excel BI myths debunked – #5 Real-time data exploration ../../../2013/09/some-excel-bi-myths-debunked-5-real-time-data-exploration/ ../../../2013/09/some-excel-bi-myths-debunked-5-real-time-data-exploration/#comments Wed, 11 Sep 2013 07:33:39 +0000 http://blog.xlcubed.com/?p=4056 #5: Lack of Real-time data exploration The argument is often made that Excel is too inflexible to answer spur of the moment questions quickly and effectively. The scenario given is that you’re in a meeting with your Excel workbook, and someone asks a related question not currently accounted for. How embarrassing to have to look […]

The post Some Excel BI myths debunked – #5 Real-time data exploration appeared first on XLCubed Blog.

]]> ../../../2013/09/some-excel-bi-myths-debunked-5-real-time-data-exploration/feed/ 1 Some Excel BI myths debunked ../../../2013/08/some-excel-bi-myths-debunked/ ../../../2013/08/some-excel-bi-myths-debunked/#comments Thu, 08 Aug 2013 08:27:46 +0000 http://blog.xlcubed.com/?p=3940 “Excel: Great hammer, lousy screwdriver’” When evaluating BI tools, many of our customers are hit by marketing messages about the limitations and woes of Excel. One white paper we were pointed to is Tableau’s ‘Excel: Great hammer, lousy screwdriver’. It contains 5 key points concerning Excel limitations for BI which we’ll take a look at […]

The post Some Excel BI myths debunked appeared first on XLCubed Blog.

]]> ../../../2013/08/some-excel-bi-myths-debunked/feed/ 2 XLCubed as an alternative to ProClarity ../../../2012/11/xlcubed-as-an-alternative-to-proclarity/ ../../../2012/11/xlcubed-as-an-alternative-to-proclarity/#respond Mon, 12 Nov 2012 11:18:08 +0000 http://blog.xlcubed.com/?p=3716 With the launch of 7.1 of XLCubed Excel Edition we introduced the ability to import ProClarity Briefing Books – with support for ProClarity ending this year and many customers looking for a replacement, now is a great time for us to show you how the import works to help move users from ProClarity to an alternate solution. Importing […]

The post XLCubed as an alternative to ProClarity appeared first on XLCubed Blog.

]]> ../../../2012/11/xlcubed-as-an-alternative-to-proclarity/feed/ 0 Easy pivoting of SQL queries in Excel ../../../2012/05/easy-pivoting-of-sql-queries-in-excel/ ../../../2012/05/easy-pivoting-of-sql-queries-in-excel/#respond Tue, 22 May 2012 08:01:31 +0000 http://blog.xlcubed.com/?p=3355 So today’s blog is all about pivoting SQL query data columns. Here we have a small sample of a SQL query report that shows us actual revenue across different products over a number of quarters.  There’s nothing wrong with the data being returned but it is pretty difficult to do any comparison analysis. So what […]

The post Easy pivoting of SQL queries in Excel appeared first on XLCubed Blog.

]]> ../../../2012/05/easy-pivoting-of-sql-queries-in-excel/feed/ 0