Business Intelligence

Many business users require similar report content with minor formatting differences.  Rather than create individual, customized reports for each business user the report writer can leverage input controls and conditional formatting to put the power of customization back into the hands of the business users. Below is a sample of ...

I have always been a huge fan of Ancient Egypt and the inside of my house has been likened to the Cairo Museum. I had been thinking for a while if there was a way to marry my passion for Ancient Egypt with my passion for Business Intelligence and about ...

With news, social media and conversation completely dominated by the COVID-19 pandemic, I was hesitant to write a blog that even mentions it. At the same time because I am so passionate about Business Intelligence and can see how it is being both used and abused in this situation, I ...

Wow – here we are in a brand-new decade and it’s the 2020’s. Now if this decade turns out anything like its predecessor 100 years ago – the 1920’s – then we are in for a fun time! The “roaring 20’s”, as they were known, was a time in Western ...

This blog is aimed at Xcelsius users who want to migrate their .xlfs into Squirrel. To everyone else — don’t let this put you off, it’s still an interesting read and you might pick up a few hints and tips along the way. The first thing to know is Our ...

In just the last three days I received three fascinating dashboards. The first was from Microsoft, called MyAnalytics, showing my work habits for the last week based on my Microsoft Outlook usage. It showed I had spent almost 80% of my time in email activities and 20% in meetings (not ...

Sometimes just because you can, doesn’t mean you should.  Although sometimes it pays to break that rule, in many cases it is the one rule that we pass on to our kids that we most hope they follow.  And so, it follows that maybe it was the one rule our ...

You might have noticed that since Chrome’s last update you are now unable to use Adobe Flash. However, there is a way to unblock Flash on Chrome. To unblock Flash from Google Chrome, follow these steps: Open the menu in chrome, select Settings, scroll to the bottom of the page and ...

Have you been forced to buy a new cell phone because there are no new app updates available? And whenever you see someone else’s phones, they operate faster than yours does and have all the latest features? The average life of a handset in the U.S. is about 21 months, ...

In Design mode of Web Intelligence, you can change the sort order of columns in a block.  However, this option is not available in Reading mode.  We can accomplish some basic sorting tasks using an input control and the steps below will detail how this is done. We’ll start off ...