Microsoft Business Intelligence [ssis,ssas,ssrs] Certification Level Online Corporate Training,job Support And Interview Support
Offer
Illinois » Chicago » chicago
Published by: Sri Raja
200
USD
MSBI (SSAS,SSIS,SSRS) ONLINE TRAINING WITH REALTIME TOPICS,COURSE OUTLINE FROM INDIA | PH: 8500122107
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.blogspot.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 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
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.blogspot.in
Views: 10