Wisdom Axis Suggests WISDOM TRAININGS for Best MSBI Online, Corporate and Classroom Trainings.
MSBI Training Details - Locations, Course Content, Fee, Duration, Faculty, Material, Projects, Lab, Hands On, Realtime examples and more.
MSBI COURSE DETAILS
COURSE DURATION : 40 HOURS
30 Hours for Actual Course + 10 HOURS PROJECT WORK + Interview Questions and Answers
MSBI PROJECT WORK
INSURANCE DOMAIN PROJECT
BANKING DOMAIN PROJECT
RETAIL PROJECT
MSBI ONLINE TRAINING
" Schedule a demo then DECIDE ! "
For Demo send an email to:
support@wisdomtrainings.com
(or)
Call us at : (91) 9000197175
Course Fee in INR : Rs.30000/- per person
Course Fee in USD : $500 per person
MSBI CLASSROOM TRAINING
WISDOM TRAININGS (Ameerpet)
Flat 303, Annapurna Block,
Aditya Enclave,
Satyam Theatre Road,
Ameerpet, Hyderabad-500 016.
Phone: (91) 9000197175
eMail: support@wisdomtrainings.com
WWW.WISDOMTRAININGS.COM
MSBI FACULTY
USA Experience as SOLUTION ARCHITECT
15+ Years Global IT Experience
Microsoft BI ( MSBI ) COURSE CONTENT
Business Domains and Information Technology
- Introduction to Business Domains
- Information Technology and Business
- Data and Business
The Data
- Introduction to Data
- Introduction to Tables
- Introduction to Database
- Introduction to SQL
- The importance of the Data
Data Warehouse Concepts
- Introduction to Data Warehouse
- Characteristics of Data Warehouse
- Difference between OLTP and OLAP
- Facts and Dimensions
- Architecture of Data Warehouse
- Various Data Warehouse tools
Business Intelligence (BI) Concepts
- Introduction to Business Intelligence
- The importance of Business Intelligence
- The relation betweenBusiness Intelligence and Data Warehouse
- Tools and Technologies in Business Intelligence area
MSBI introduction
- MSBI Architecture
- MSBI introduction and overview
- Import and Export wizard
- Overview of SSIS Package Designer & Environment
- Installation of SQL Server and SSDT- BI
SSIS
- SSIS Architecture.
- Control Flow & its Components.
- Data Flow & its Components.
- Parameters, Expressions, Event Handling.
- Transaction Options, CheckPoints, Logging options.
- Custom code using Script Task, Script Component.
- Package Configurations, Debugging & Troubleshooting.
- Package Performance Tuning.
SSAS
- Tabular Model and Multidimensional Model.
- Data Sources, Data Source Views
- Identify the Fact and Dimensions
- Named Calculation and Named Queries.
- Dimension Hierarchies, Designing Measure Groups.
- Storage Modes: MOLAP, ROLAP, HOLAP.
- Partitions, Aggregations.
- KPIs, Actions, Translations and Perspectives.
- SSAS Deployment and Cube ProcessingP.
- Loading Data into DW using SSIS, MDX queries, DAX Queries.
- Performance Optimization of cube and Dimension.
- Schedule the Cube processing.
SSRS
- Reporting Services Architecture & Lifecycle.
- Report Parameters and MultiValued.
- Cascading Drop down Parameters.
- Types of Reports:Table, Matrix, Sub Report, Chart Report (Bar, Pie, Line), Drill-Down Report, Drill Through Report.
- Creating Groups, Filters, Expressions Sort.
- Exporting Reports.
- Report Manager.
- Security for Reports and Data.
- Report Subscriptions.
- Ad-Hoc Reporting.
- Performance Tuning.
MSBI PROJECTS and CASE STUDIES
Live Project 1: MSBI as BI reporting tool in Insurance Domain
- Overview of Insurance Business
- Insurance and Information Technology
- Insurance dependency on Business Intelligence and Data Warehouse
- MSBI as BI reportingtool in Insurance Domain
Live Project 2: MSBI as BI reporting tool in Banking Domain
- Overview of Banking Business
- Banking and Information Technology
- Banking dependency on Business Intelligence and Data Warehouse
- MSBI as BI reporting tool in Banking Domain
Live Project 3: MSBI as BI reporting tool in Retail Domain
- Overview of Retail Business
- Retail Industry and Information Technology
- Retail Industry dependency on Business Intelligence and Data Warehouse
- MSBI as BI reportingtool in Retail Domain