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




1) SSIS
a) Introduction to SSIS
b) Control Flow, Data Flow and Containers
c) Transformations -- Includes All Transformations inside Dataflow
d) Slowly Changing Dimensions(SCD)
e) Tasks used inside Control Flow
f) Check Points
g) Logging
h) Configurations
I) Jobs & Scheduling Packages
j) Deploying SSIS packages
k) 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
a) Introduction to SSRS
b) Core Components - Data Tab, Layout Tab & Preview Tabs
c) Designing Reports - Header, Footer, Details, Query Designer
d) Creating parameters in reports, Types of parameters, Cascading Parameter
e) Drilldown Reports
f) Matrix Reports
g) Image, Rectangular, Chart and List Reports
h) Sub report
I) Report Deployment and Security
j) Drill through Reports
k) Report Caching
l) Subscriptions
m) Adhoc Reports
N) Linked Report
o) Report Manager and Report Server
p) Report Snapshot
q) Gauge, Data Bars, Spark Lines, Indicators


3) SSAS
a) Introduction to Data Ware Housing, SSAS, DataMart’s
b) Dimension and Fact tables
c) Types of Dimensions
d) Schema - Star & Snowflake
e) Cube-Advantages, Creation, Processing
f) Options inside Data Source View - Named Query, Add/Remove tables, New Relationship
g) Levels, Members, Hierarchy
h) Measures - Additive, Semi Additive, Non Additive
j) Fact less Fact tables
k) Storage Modes
l) Cube Securities
m) Partitions, Calculations, Perspectives
n) 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