Background: One of the common scenarios we need to handle in the Data Integration process is to Pivot or UnPivot the input data received from external systems such as ERP or Finance systems. Microsoft SQL-Server provides two very good Transact-SQL commands Pivot and UnPivot to handle such transformations. In this part-1 series of this article […]
Business Intelligence & Business Analytics in Simple Terms
I had gone to Park Royal Industrial Area in London with my friend to meet one of his clients who runs an Import/Export Distribution business and his company was specializing in all types of tiles. This company has his office in one of his warehouses. He had three additional warehouses in the same premises. During […]