+1 (201) 720-5410 (USA)

My Cart


Microsoft BI

Training Mode: Class Room / Live Online

Need Help? please call us on +919019191856 or Click Here to send us an Enquiry


Microsoft BI Training in Bangalore - Live Online & Classroom

myTectra the Market Leader in Microsoft BI Training in Bangalore

myTectra offers Microsoft BI training in Bangalore using Class Room. myTectra offers Live Online Microsoft BI Training Globally.


Introduction To MS - BI:
What is MS-BI
BI/DWH life cycle
ETL and OLAP Tools
Features of MS-BI
Introduction To SSIS:Package
SSIS installation
SSIS Architecture
SSIS Wizard
Control Flow Tasks
Data Flow Task
Variables and Expressions
Errors and Debugging SSIS
Data viewers
Manually Executing SSIS Package
Scheduling SSIS Package
Importing and Exporting Packages
Monitoring and Optimizing Packages
Introduction To SQL Server Reporting Services
Reporting Services Architecture
Reporting Services Terminology
Creating Reports
Deconstructing Reporting Services
Shared Data Sources
Creating Reports from Scratch
Calculations And Formatting
Creating Expressions
Using the Global Collection
Grouping And Sorting
Creating Groups and Calculating Totals and Percentage
Interactive Sorting, Creating Drill-Down Reports
Report Parameters Creating Report Parameters
Creating Drop-Down Parameters
Multi-Valued Parameters
Debugging Parameter Issues
Creating Matrix Reports And Charts
Creating a Basic Matrix Report
Matrix Subtotals
Creating a Basic Chart
Exploring the Charting Possibilities
Reporting Services Security
Two Parts to Reporting Services Security
Securing Access to Reports
Data Source Security
OLAP Modeling
Modeling source schemas—stars and snowflakes
Understanding dimensional modeling— Dimensions (Type 1, 2, or 3) or rapidly changing
Understanding fact (measures) and cube modeling
Intermediate SSAS
Translations – cube metadata and currency localization
Actions – regular, drill-through and reporting
Advanced SSAS
Using multiple fact tables
Modeling intermediate fact tables
Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, write back dimensions
Modeling changing dimensions – Dimension Intelligence w/ Wizard
Using the Add Business Intelligence Wizards – write-back, semi-additive measures, time intelligence, account intelligence
Cube Storage And Aggregation
Storage topics – basic aggregations, MOLAP
Advanced Storage Design – MOLAP, ROLAP, HOLAP
Partitions – relational and Analysis Services partitions
Customizing Aggregation Design - Processing Design
Rapidly changing dimensions / ROLAP dimensions
Welcome to the Real Time – Proactive Caching
Cube processing options
Beginning MDX:Basic Syntax
Using the MDX query editor in SQL Server Management Studio
Most-used Functions & Common tasks
New MDX functions

To Learn Live Online Microsoft BI Training Globally and Microsoft BI Training in Bangalore using Class Room, ENROLL TODAY at myTectra.

Customer Reviews

1 Item(s)

per page
Mytectra is the grasping solution for the Learners. Review by Akshaya.V
The classes were good.It helped us understand many new concepts.The teacher was good in explaining the doubts and helped us a lot with new programs.We will look forward to join my tectra for other courses.

1 Item(s)

per page

Only registered users can write reviews. Please, log in or register

myTectra Stands for Quality Training and provides training using Experienced professionals on the Respective Technologies and who has a good teaching expertise.


myTectra flexible batch schedules enables you to start your class at your convenient date and time.

1. All the enrolled candidates must start the class by any date within 30 days from the date of enrollment.
2. Maximum of 3 Days will be taken by myTectra to schedule the batches from the date of schedule request from the candidate.
3. Individual Focus - Maximum 5 candidates allowed per batches
4. The candidate can request any one of the batch time slot from the below list
Batch Type Time Slab Hours/Day Time Zone Days
Regular Morning 6.30 AM - 9.30 AM Anytime Maximum 2 Hrs IST Monday-to-Friday
Regular Evening 6.30 PM - 9.30 PM Anytime Maximum 2 Hrs IST Monday-to-Friday
Week End 6.30 AM - 9.30 PM Anytime Maximum 3 Hrs IST Saturday,Sunday
Fast Track-Morning 6.30 AM - 9.30 AM Anytime Maximum 2 Hrs IST Monday-to-Saturday
Fast Track-Evening 6.30 PM - 9.30 PM Anytime Maximum 2 Hrs IST Monday-to-Saturday
Customized Batch Customized Timing Customized Hrs IST Customized Days

Note : We can schedule your batch anytime on Saturday and Sunday between 6.30 AM 9.30 PM at your convenient time

Do you have any questions ? please call us on +919019191856 or email to [email protected]