Signup as a Tutor

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

Enquire

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.

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 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

Share

course photo

MSBI Online Training

Online Instructor led Course

Platform:

20,000

No Reviews Yet
1 Interested

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
Introduction SQL Server 2012.
SQL-Architecture.
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?
?MS-BI (SSIS, SSAS, SSRS)
?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
?Services
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

Pre-requisites

Basic internet Knowledge

What you need to bring

Nothing Required High speed Internet should must be ther

Key Takeaways

MSBI ,SSIS,SSRS,SQL
Content
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

cash back100% Money Back Guarentee

About the Trainer

Surendra

B.Tech


MSBI Trainer with 8+years Experience
Seats Left-

Students Interested 1

Course Id: 21191