Tag Archives: Business Intelligence

Date continued

When you have the DateID as an int that represents a real date it can be good to be able to use SSIS to convert datetime to int in an easy way. In this blog post by Mike Davis shows … Continue reading

Posted in BI, SSIS | Tagged , , , , , | Leave a comment

Creating and populating a date dimension with Swedish or Norwegian weeks

Quite often when you work with analyzing data you need to be able to see your KPI’s per day, week or some other time-frame. Both Sweden and Norway has a fairly unusual way to handle week numbers which might make … Continue reading

Posted in BI, IT | Tagged , , , , , , , | Leave a comment