Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.


MSBI Online Training

No Reviews Yet

Course ID: 21191

You can not pay for your own class.

About the Course

An impeccable course carefully designed for starters and experienced. Includes basic through advanced business intelligence and data warehouse concepts on SQL Server Integration Services, Analysis Services and Reporting Services.

Topics Covered

Introduction SQL Server 2012.
GAM, SGAM, Pages, Extents.
Database engine,
Multiple instances,
Sql server2012 editions,
SQL Server 2012 databases and Objects,
Sql Server Physical Structure.
MSBI studio.
What is new for MSBI in SQL Server 2012?
?SSIS Objectives
Plan data transfer and staging solutions for an ETL operation
Plan an SSIS Solution
Design and implement data flows
Incorporate logging, error handling and reliability into a package
Optimize an SSIS Solution
Deploy an SSIS Solution
?Contents: Planning for ETL
Identifying Data Sources and Destinations
Evaluating Source Data
Identifying Staging Requirements
?Planning an SSIS Solution
Planning Packages
Planning Package Development
Designing Package Control Flow
?Designing Data Flow
Understanding Data Flow
Designing Data Flow Operations
Handling Data Changes
?Logging, Error Handling and Reliability
Logging ETL Operations
Handling Errors in SSIS
Implementing Reliable ETL Processes with SSIS
?Optimizing an SSIS Solution
Monitoring SSIS Performance
Optimizing SSIS Packages
Scaling Out SSIS Packages
?Deploying and Operating an SSIS Solution
Deploying SSIS Packages
Operating an SSIS Solution
?SSAS Objectives:
Describe how SQL Server Analysis Services can be used to implement Analytical solutions
Create multidimensional analysis solutions with SQL Server Analysis Services
Implement dimensions in an Analysis Services solution
Implement measures and measure groups in an Analysis Services solution
Query a multidimensional Analysis Services solution
Customize an Analysis Services cube
Deploy and secure an Analysis Services database
Maintain a multidimensional Analysis Services solution
Implement Data Mining solution
?Contents: Introduction to Microsoft SQL Server 2012 Analysis
Overview of Data Analysis Solutions
Over of SQL Server 2012 Analysis Services
Installing SQL Server 2012 Analysis Services
?Creating Multidimensional Analysis Solution
Developing Analysis Services Solutions
Data Sources and Data Source Views
Creating a Cube
?Working with Dimensions
Configuring Dimensions
Defining Hierarchies
Sorting and Grouping Attributes
?Working with Measures and Measure Groups
Working with Measures
Working with Measure Groups
?Querying Multidimensional Analysis Solutions
MDX Fundamentals
Adding Calculations to a Cube
?Customizing Cube Functionality
Implementing Key Performance Indicators
Implementing Actions
Implementing Perspectives
Implementing Translations
?Deploying and Securing an Analysis Services Database
Deploying an Analysis Services Database
Securing an Analysis Services Database
?Maintaining a Multidimensional Solution
Configuring Processing Settings
Logging, Monitoring and Optimizing an Analysis Services Solution
Backing Up and Restoring an Analysis Services Database
?Introduction to Data Mining
Overview of Data Mining
Creating a Data Mining Solution

Who should attend

Any Graduates Btech ,B.com .BSC.MSC.MBA ,Mtech


Basic internet Knowledge

What you need to bring

Nothing Required High speed Internet should must be ther

Key Takeaways



Date and Time

Not decided yet.

About the Trainer

5 Avg Rating

1 Reviews

2 Students

15 Courses

MSBI Trainer with 8+years Experience


No reviews currently Be the First to Review


Surendra picture

Sridhar Reddy

No Reviews Yet

Students Interested 1 (Seats Left 0)

₹ 20,000


Post your requirement and let us connect you with best possible matches for MSBI-SQL SERVER Training Post your requirement now


Submit your enquiry for MSBI Online Training

Please enter valid question or comment

Please select a category

No matching category found.

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Sreekar Global IT Solutions

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Register for Free Master Class

tickYou have successfully registered

Class Scheduled at


To join, click

Add to Google Calendar

Share this Master class

Message copied

How to join a Class?
  • For Mobile phone, download the UrbanPro app for Learners

    The UrbanPro Learner app is your study app for this course. You can attend the Demo Class on the app and also get access to the course material, course schedule and ability to communicate with the Tutor. To learn more, watch this video.

    Play Store App Store
  • For Laptop, download the Zoom app

    Download the Zoom app for your laptop. The link to join the class will launch the meeting with the tutor on this Zoom app. To learn more, watch this video.

Verify you Mobile Number

Please verify your Mobile Number to continue and book a FREE Demo class.


Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.


Please enter OTP.

Or, give a missed call and get your number verified


UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more