You need to give special attention when you plan to work on SQL BI (SSIS, SSAS, SSRS). There are lot of concepts need to clear before start working on SQL BI for example,
What is BIDS – Business Intelligence Development Studio? It is an interface based on Microsoft Visual Studio to develop all BI projects.
SSIS – SQL Server Integration Services involves different kinds of flow such as Control Flow, Data Flow, etc.
SSAS – SQL Server Analysis Service involves Cube, Dimension, Fact, and Measure etc.
SSRS – SQL Server Reporting Services involves Report Builder, Report Manager, Report Server.
I have created small presentations that will walk-through some important concepts & introduce you SQL BI. This is an introductory presentation contains some common concepts used while working on BI. Please note this article is meant for SQL BI beginners, who would like to work on SQL BI.
As we all know SQL BI is a big world, but I hope this presentation will help you to understand this big world… 🙂