Another assignment given in my BI training was to design and build a warehouse for an order processing system, which included transferring data from excel sheets to a fact table. As I have done most of the tasks in previous projects related to BI, like designing a star schema, creating the relevant packages, this was Continue reading

One of the tasks we were given during the BI training is to compare and contrast two different date dimension generators. Given the complexity of what this code looks like, my preferred method would have been to write up a date generator from scrap, so that I know what is in it than going through Continue reading

In my 8 years as a software engineer, I have not been in a lot of projects. 4 years in a single telecommunication project reduces that by half, and then a financial, 1 airline, 1 manufacturing and 2 healthcare projects that adds up to 6 projects total. Out of which the airline and 1 healthcare Continue reading

Following example demonstrates dimensional modelling for the following requirement of an invoicing application Requirement: A dashboard to display the following: Invoices against delivery method Number of Invoices by month Total dry Items against delivery method Total Chiller Items against delivery method Total Number of Invoices by Sales Person Following dimensions have to be used for Continue reading

There are different types of dimensional modelling, facts and dimensions. Most of the terms are quite similar and the definitions are overlapping across them.Star Schema and Fact Constellation is one such example which is explained below: 1. Star Schema Traditional dimensional modelling that has a large fact table that relates to multiple dimensions. Simple design Continue reading

Decrypt data in a column in a table residing in a MS SQL database. 1. Create a class library project 2. Write the code with a SQL Function annotation as below. namespace DecryptionProject{     public class ScriptMain    {              [SqlFunction(DataAccess = DataAccessKind.Read)]        public static String Continue reading