MSBI Training at @ elegant it services – Bangalore

Introduction to MSBI:
1. What is MS-BI
2. Advantages of MS-BI
3. DWH Concepts
a. -->What is DWH?
b. -->Definition of DWH (Ralph Kimball, Bill Inmon Definitions)
c. -->OLTP Vs OLAP
d. -->DWH Architecture
e. -->Data Acquisition Process (ETL)
f. -->Data Analysis Process (OLAP)
g. -->DWH Design Guidelines (Star, Snowflake Schemas)
h. -->Tools used in DWH
i. -->Data Mart
Introduction to SSIS:
4. SSIS installation
5. SSIS Architecture
6. Package
7. Tasks ,Control Flow , Data Flow
Developing SSIS Packages:
8. SSIS Wizard
9. SSIS Designer (BIDS Environment)
10. Variables and Expressions
11. Breakpoints
12. Data viewers
13. Configuring Error Output
Errors and Debugging SSIS
14. Events Handling
15. Execution Logging
16. Control Flow Tasks
17. Data Flow Tasks(ETL)
18. .Net Scripting Task
Thanks&Regards

Elegant IT Services,
#352, 2nd Floor,Aswath Nagar
Varthur main road,Near Railway Fly Over
Maratha halli,Land mark : Chemmunar Jewellers,
Bangalore - 560037.Ph:-9886541264/87