#DWH #BI #Automotive
The vehicle identification number (VIN) is the central identifier for vehicles in the automotive industry. When running an automotive project, you will have to deal with these 17 digit long numbers.
Continue reading
When creating entities in Microsoft SQL Server Master Data Manager, it is not possible to set a member attribute to store only unique values.
Continue reading
Just a question. Does anybody need a SSRS client for Android?
Please leave a comment!
For Microsoft SQL Server Analysis Services, there is a neat Android client available on Google Play.
Continue reading
Reading a book on Microsoft SQL Server administration, I came upon a topic that I didn’t cared about so far, mainly because I’m usually not responsible for administrating the data warehouse.
Just found an interesting white paper from Microsoft on a reference configuration for high performance data warehousing using Microsoft SQL Server.
Continue reading
Just uploaded a template for a data warehouse business case to the templates section of the DWH Wiki.
Continue reading
Berthold just told me that it is of advantage to have a date dimension per date attribute in the fact table. At first I didn’t like the idea, but he is right:
Having one date dimension table for each date attribute in the fact table has the advantage that when end-users want to select a specific date from a drop-down box, they only see those date where the attribute has data for.
Continue reading
Just found this interesting document on naming conventions for Microsoft SQL Server.
Due to some project requirements, I’m reading a lot about the Data Vault model by Dan Linsted. It is totally different to the star schema or snowflake schema introduced by Ralph Kimball or Bill Inmon.
