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.Continue reading “Faster Excel Queries For Power BI & Azure Analysis Services”
Author: Gary Crawford
Lessons from IBCS – Scenario Handling
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.Continue reading “Lessons from IBCS – Scenario Handling”
Lessons from IBCS – Eliminating Chart Clutter
The core job of a chart is to convey information to the viewer as clearly, concisely, and quickly as possible. One thing that can detract from this is chart clutter – distracting or unnecessary additional elements which can mask the overall message.Continue reading “Lessons from IBCS – Eliminating Chart Clutter”
XLCubed and IBCS
In the last few months we have significantly extended the charting elements within XLCubed. We wanted to get the product formally certified by IBCS, and I’m delighted to say we achieved that in early June. We’ve been aware of IBCS for several years now through some of our customers and partners, but it was really only at the beginning of this year that we started to look in detail, and it really resonated with us.Continue reading “XLCubed and IBCS”
Monitoring Data Comments
Many BI and reporting tools now allow users to collaborate directly with a report. This avoids the cumbersome backwards and forwards of email chains or the need to meet in person.
As useful as this is, some organisations have concerns about the ability to monitor comments made. We will discuss this aspect in more depth after a brief introduction to comments and collaboration.Continue reading “Monitoring Data Comments”
Data Mashups 101
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 to include descriptive or textual information held elsewhere. People have approached this in different ways, but XLCubed’s mashup capability can make it a much more streamlined and maintainable process.