Enhancing the pattern by keeping text in check
Text is an indispensable helper when we make data visualizations, but we need to be careful not to...
Network package size
We all know that network handling is very expensive, so when loading a large amount of data...
Leveraging comparison in a stacked bar chart
Remaking charts has become increasingly popular around the web lately.
Enrich your Data Warehouse dimensions
As a Data Warehouse Consultant, I´m often asked the following by customers: “Is it possible to...
Are you wasting storage space?
Do you see tables taking up much more space than expected? And when looking at the table design and...
SQL Server trace flags
Normally I’m not a big fan of using trace flags, my advice is only to use these when it is...
Backup On-Premises SQL Server Databases to Azure Storage
With the release of SQL Server 2012 SP1 CU2, an enhancement to the BACKUP command has been added....
Filegroup confusion
Where did I put my Sales table?
Tired of crowded bars? The dot plot hits a sweet spot!
Dots don't just look great on Tour de France jersies - they are also great for conveying...
Don't drown the data - show it!
Far too often, we seem overly worried that our audience will not find our data interesting and...
Tableau - Making the Date dimension ready for Tableau
This is a technical follow up on the previous post on designing and working with cubes in Tableau.
Tableau - Designing and working with cubes in Tableau
In this article we will look at how the cube is structured and how to setup a date dimension what...
Tableau – Working with cubes
This post is the first of a series on designing and working with Microsoft SQL Server Analysis...
A better alternative to long set analysis
When you work with QlikView, you have probably created tons of set analysis expressions, and many...
Yet another possibility with QlikView
I sometimes wonder, haven’t we seen all the possibilities for QlikView?
The answer is simple – NO!