MSBI course content
MSR Trainings offers MSBI online training through worldwide, Learn Microsoft Business Intelligence Training Institute in Hyderabad from the Experts at MSR Trainings
Who Can Learn Microsoft Business Intelligence Training
- Professionals from ETL background
- Software Developers
- Big Data professionals
- Professionals from Analytics background
- SQL Server Development
- SQL Server database Overview
- What is DDL, DML
- Data Types
- What are Constraints (Identity, Unique, Check, NULL, Default)
- Operators
- Aggregates
- Where
- Group by
- Having
- Distinct, Top
- Date functions
- Temp tables
- Table Variables
- Usage of While loop & if conditions
- Case Statement
- Ranking Functions
- Scalar Functions
- Exception handling
- Transactions
- Joins
- Sub Queries
- Views
- CTE
- Cursor
- Stored Procedures
- User Defined Functions (String, Table value: inline Functions and multi value)
- Triggers
- SSIS (SQL Server Integration Services)
- SSIS Introductions
- Control Flow
- Data Flow
- Precedence constraint & Expressions
- Sequence Container
- Annotation
- Data Flow Components
- Data viewer
- Copy
- OLEDB Source
- OLDB Destination
- Audit
- Character Map
- Conditional Split
- Row sampling
- Percentage sampling
- Multicast
- Data conversion / Type Cast
- Sort
- Merge
- Union all
- Aggregate
- Derived
- RowCount
- BreakPoints
- Merge join
- Flat File Destination
- Excel Destination
- OLEDB Command
- Cache transformation (target is cashed)
- Lookup
- SCD (type 1, type 2)
- Excel Source
- Flat File Source
- Control Flow Components
- Sequence Containers
- For loop
- For each loop
- Variables with default values
- Variables with dynamic values through Expressions
- Dynamic loading of Excel files into SQL target
- FTP Task
- Execute SQL Task – Basic
- Execute SQL task with parameter and with result
- Breakpoints
- Script task
- Bulk Insert Task ( sending FF – SQL)
- Execute package
- Execute process
- ERROR Output in DF
- File system Task
- Send Mail Task
- Logging
- Checkpoints (restart ability)
- Jobs (Scheduling)
- Deployment
- Configurations
- SSRS (SQL Server Reporting Services)
- Introduction to SSRS
- Architecture of SSRS
- What is Report Server
- What is Report Manager
- Creating reports using BIDS
- What are Data sources
- What are Shared Data sources
- Types of Reports (Table and Matrix)
- FOTTER
- HEADERS AND EXPRESSIONS.
- Parameterized report
- Multi-valued Parameterized Reports
- Page break concept
- Drill Down report
- Report Wizard / Adhock Report /Ad-Hock Report / Wizards
- Cascading report — Parameter Dependency
- Drill through Report / hyperlink report / jump report / navigation report / go to report/ Action report
- Chart report and its properties & expressions
- Sub report
- List Report with Image
- Rectangle Report
- Indicators
- Gauge
- Deployment
- Report Subscription (Email and Windows File Share) and Scheduling
- Report Manager Operations
- Edit Report
- Move / Delete Report
- Linked Report
- Cashed / Execution Report
- Snap short and History comes under this report
- SSAS (SQL Server Analysis Server)
- Introduction to SSAS
- Schemas
- Star Schema
- Snowflake Schema
- Data source
- Data source views
- Options in DSV
- Dimension
- Measures
- Cube Creation
- Build
- Deploy
- Process
- How to Brows the CUBE
- Types Of Relationships inside CUBE
- No relationship
- Regular Relationship
- Fact Relation
- Referenced Relationship
- Many to Many
- None
- Hierarchies
- What are KPI’s and How to Create KPI’s in SSAS
- What are Perspective and how to create
- What are Partitions
- What are Translations
- What are Actions
- What are Calculations
- Aggregations
- Storage design – ROLAP, MOLAP , HOLAP
- How to use Cube in Excel
- MDX in Report
Learning Objectives
Course Features:
- Course Duration -30 Hours
- Levels-All Levels
- Language -English
- 1000+ Students
- Full lifetime access
- Job Assistance
- Mentor Support
- Guaranteed job support for freshers and professionals to start a great career in cloud technologies
- Get authorized and industry-recognized Devops certification after course completion
- A Portfolio of Real-world Projects
Choose The Best
Benefits of MSR Training Classes
100% Placement Support
Weekdays/Weekend LIVE classes
One-on-One with Mentors
Free Demo Classes
Industry Oriented Projects
Instructors are from MNC’s
Lab Sessions
Doubt Clearance Sessions
Designed by Industry experts
Recognized Certification
REQUEST A CALL BACK
Explore the trending and niche courses and learning maps. Learn about tuition fees, payment plans, and curriculum