BI stands for Enterprise Intelligence. It’s a methodology of convert knowledge in to data. BI is an ordinary time period, it’s miles an idea. To enforce this idea various group like oracle, Microsoft has provide you with varied instruments. This text will deal with Microsoft method of doing BI. So that phrase MSBI stands for (Microsoft Enterprise Intelligence). As we have now understood about MSBI so now allow us to strive to have a look at the small print of MSBI. It’s miles a composite of three separate entities. SSIS (SQL Server Integration providers) SSAS (SQL Server Evaluation providers) and SSRS (SQL Server Reporting providers) On this textual content we’re capable of be concentrating on SSIS (SQL Server Integration providers) and can create a straightforward problem with SSIS. Earlier than we proceed with creation of SSIS, permit us to first fast bear roughly precept of SSIS. SSIS (SQL Server Integration Service): Beneath SSIS, uncooked data or uncooked knowledge is taken from CSV kind, excel or Microsoft entry and saved in knowledge ware home. SSIS takes care of uncooked data (knowledge supply) and shops it in knowledge ware home which isn’t at all times very straightforward it has to undergo ETL (Extraction, Transformation and Loading) system. Similtaneously going by the journey of process known as ETL: – Extraction from uncooked knowledge is carried out it first identifies whether or not or not uncooked data is CSV file, binary, SQL file or Microsoft entry. As soon as the id of uncooked data provide is achieved then its transformation is achieved. Contained in the Transformation methodology varied information data utilized in uncooked knowledge are added into commonplace knowledge kind with a objective to keep away from confusion. As soon as the Extraction and Transformation method is achieved then loading of that data provide is achieved into statistics ware home. What is the existence cycle of BI? BI coaching changing knowledge in to data. Changing knowledge in to data is a fancy approach. It consists of lot of steps allow us to acknowledge the an identical. Beneath are the very important steps in BI life cycle: – It takes uncooked knowledge then it would do extraction to have the ability to perceive which sort of uncooked evaluation it’s whether or not CSV, binary format, SQL Doc and Microsoft entry file. As soon as type of the information is acknowledged then it’s far reworked into frequent evaluation from extraction course of. After profitable transformation then loading of the data into knowledge ware home. Information after attaining statistics ware home knowledge’s analysis is accomplished after which saved in data construction known as dice. Finally massaged saved statistics is ready for displaying to the consumer as helpful data by reporting.