microsoft

  MSBI is an abbreviated form of Microsoft Business Intelligence. To understand MSBI, it is important to understand BI (Business Intelligence) first. Here we discussed different Business Intelligence tools including SSIS, SSRS, SSAS & many more. Similarly, What is MSBI? and its benefits. know more  msbi online course Data & Information Data is a technical term. A layman would not understand the data in a technical format, he would be able to gain information from that data only if it is in an understandable format. Business Intelligence When the raw data is converted into meaningful information by using tools and techniques or by performing analysis, cleansing, modeling, etc. is termed as BI. Business Intelligence includes the following: Data Cleansing – Data comes to any organization in a lot of formats. As per industry-wise, it is important to collect the data which is important and discard the unnecessary data. Sometimes a data may even contain some errors. So, the ...

  Transformations are defined as a core component in the Data flow of a package in SSIS. It is that part of the data flow to which we apply our business logic to manipulate and modify the input data into the required format before loading it to the destination. Different types of Transformations available in SSIS. 1. AGGREGATE : The Aggregate transformation applies aggregate functions to column values and copies the results to the transformation output. Besides aggregate functions, the transformation provides the GROUP BY clause, which you can use to specify groups to aggregate across. KNOW MORE msbi online training The Aggregate Transformation supports following operations: GROUP BY, SUM, AVERAGE, COUNT, COUNT DISTINCT, MINIMUM, MAXIMUM Example of Aggregate Transformation 2. AUDIT : Adds Package and Task level Metadata - such as Machine Name, Execution Instance, Package Name, Package ID, etc.. 3. CHARACTER MAP : When it comes to string formatting in SSIS, Chara...