Testing in SQL Server – Count all rows from multiple tables

The power of a friendly work place challenge

How to install Qlik Sense in AWS.

How to install Qlik Sense in AWS.

Working at OptimalBI, I am asked to install and configure a number of products be it for production workloads or internal evaluations. Some of these products require days of configuration (according to the vendor) or at the other end of the spectrum require a single...

Use Trifacta to Wrangle your data

Use Trifacta to Wrangle your data

As mentioned in Shane Gibson’s blog, Trifacta = I can code! (and free data wrangling on your desktop), some of us at OptimalBI have had the pleasure of using Trifacta’s Desktop Data Wrangling tool. A little something from their website Data Wrangling to Simplify the...

Don't start your project with code

Cool, I found that date field I was looking for on line 8! But also on line 9...damn...what now? Source: author's collection. A natural way for data people to start our projects is to "just get in to the data and see what's there." Almost every week, in fact, I tell a...

QlikSense Menus – They are all greek to me

QlikSense Menus – They are all greek to me

We found an interesting issue with QlikSense 2.0 the other day, where the menu options all looked like Hieroglyphics or Greek characters rather than the english characters. A close up of the right hand menu shows the problem:     The problem ended up being...