Microsoft Business Intelligence [SSIS,SSAS,SSRS] CERTIFICATION LEVEL ONLINE & CORPORATE TRAINING,JOB SUPPORT AND INTERVIEW SUPPORT BY REALTIME HANDS-ON FACULTY


FOR FREE DEMO contact us :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 1+214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in

Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided


MSBI -SSIS,SSAS,SSRS COURSE CONTENT (we can customize the Course Agenda as per your requirement)



MICROSOFT BUSINESS INTELLIGRNCE MSBI TOPICS




1) SSIS
• Introduction to SSIS
• Control Flow, Data Flow and Containers
• Transformations -- Includes All Transformations inside Dataflow
• Slowly Changing Dimensions(SCD)
• Tasks used inside Control Flow
• Check Points
• Logging
• Configurations
o Jobs & Scheduling Packages
• Deploying SSIS packages
• Performance Tuning of SSIS packages & Optimizations Techniques
• L) Different Kinds of Data Loadings (Incremental Loading)
• M) Protection Levels in SSIS
• N) Precedence constraints

2) SSRS
• Introduction to SSRS
• Core Components - Data Tab, Layout Tab & Preview Tabs
• Designing Reports - Header, Footer, Details, Query Designer
• Creating parameters in reports, Types of parameters, Cascading Parameter
• Drilldown Reports
• Matrix Reports
• Image, Rectangular, Chart and List Reports
• Sub report
o Report Deployment and Security
• Drill through Reports
• Report Caching
• Subscriptions
• Adhoc Reports
• N) Linked Report
• o) Report Manager and Report Server
• p) Report Snapshot
• q) Gauge, Data Bars, Spark Lines, Indicators


3) SSAS
• Introduction to Data Ware Housing, SSAS, DataMart’s
• Dimension and Fact tables
• Types of Dimensions
• Schema - Star & Snowflake
• Cube-Advantages, Creation, Processing
• Options inside Data Source View - Named Query, Add/Remove tables, New Relationship
• Levels, Members, Hierarchy
• Measures - Additive, Semi Additive, Non Additive
• Fact less Fact tables
• Storage Modes
• Cube Securities
• Partitions, Calculations, Perspectives
• Create Reports in ssrs using cube
• o)How to browse cube from Excel



FOR More Details contact us :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 1+214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in