Bliv klogere med Inspari

På bloggen finder du inspiration og gode råd til at gøre data til et aktiv i din organisation.

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!

QlikView - Loading images into memory

Images in a QlikView application can be power full in many ways. Most of the time I see solutions...

Using table variables in a SSIS data source

Every now and then standard queries just aren’t sufficient as data sources and therefore it might...

QlikView tape recorder functionality

Try to visualize your old tape recorder. If you are old enough, you might remember the forward...

Special characters in SSAS Name properties

Have you ever got the request to use special characters, like ( ) / & %, in the names of your...

Throw your server off balance

…Balanced Power Plan that is

Caring about nature is most certainly a likable trait. But did you...

Output row values effected by an update

Have you ever thought about logging the before and after value for an update or delete? It’s...

Updateable views

By default view are updateable. It means you can write a TSQL update statement against a view just...

Avoid schema changes corrupting your views

Maybe you are using views as a layer between your tables and your users. If you have a lot of views...

dbcc checkdb

Almost every one of my customers is running a backup of their databases (you would be surprised if...