MSBI: Microsoft Business Intelligence online training

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: https://best-online-it-training-institute.blogspot.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

Copyright © 2018 Apex Online IT Trainings Inc. All Rights Reserved



Call us on : USA - +1 214 628 3894 | IND - +91 8500122107


for your course please follow the link : https://www.apex-online-it-trainings.com/it-trainings-at-apex/msbi-ssas-ssrs-ssis-online-training-by-handson-experts