Microsoft Business Intelligence MSBI Realtime online training, job & interview support by corporate working Professionals

MSBI Training makes your expert in creating real world integration, Analytical and Reporting applications with MSBI. Microsoft BI tools cover a wide range of functionalities and they hold up to the competition very well.


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


MSBI Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews,Assignments (TESTS) Will be provided


MSBI: MicroSoft Business Intelligence Course Outline
(the course content can be modified as per your requirements):

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