MSBI (SSAS,SSIS,SSRS) ONLINE TRAINING,INTERVIEW SUPPORT (TESTS) & JOB SUPPORT WITH REALTIME SCENARIOS, LIVE PROJECT

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
Website: http://www.apex-online-it-trainings.com/
Blog: http://apex-it-online-trainings..in

MSBI 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 Course Outline




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

 Jobs & Scheduling Packages
• Deploying SSIS packages
• Performance Tuning of SSIS packages & Optimizations Techniques
• Different Kinds of Data Loadings (Incremental Loading)
• Protection Levels in SSIS
• 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


 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


 How to browse cube from Excel