MSBI online training
MicroSoft – BI
(SSIS, SSAS, SSRS)
SSIS–Objectives:
1. Plan data transfer and staging solutions for an ETL operation.
2. Plan an SSIS Solution
3. Design and implement data flows
4. Incorporate logging, error handling, and reliability into a package.
5. Optimize an SSIS solution
6. Deploy and operate an SSIS solution.
Contents:
Planning for ETL:
• Source Identify Data Sources and Destinations
• Evaluating Data
• Identify Staging Requirements
Lab: Planning an ETL Solutions
Planning an SSIS Solutions:
• Planning Packages
• Planning Package development
• Designing Package Control Flow
Lab: Implementing SSIS Packages
Designing Data Flow:
• Understanding Data Flow
• Designing Data Flow Operations
• Handling Data Changes
Lab: Implementing Data Flow
Logging Error Handling and Reliability:
• Logging ETL Operations
• Handling Errors in SSIS
• Implementing Reliable ETL Process with SSIS
Lab: Implementing Reliable Packages
Optimizing an SSIS Solution:
• Monitoring SSIS Performance
• Optimizing SSIS Packages
• Scaling out SSIS Packages
Lab: Optimizing Packages
Deploying and Operating an SSIS Solution
• Deploying SSIS Packages
• Operating an SSIS Solution
Lab: Optimizing Packages
SSAS – Objectives:
1. Describe how SQL Sever Analysis Service can be used to implement Analytical Solutions.
2. Create multidimensional analysis solutions with SQL Server Analysis Services.
3. Implement dimensions in an Analysis Services Solution.
4. Implement measure and measure group in an Analysis Services Solution.
5. Query a multidimensional Analysis Service Solution.
6. Customize an Analysis Service cube.
7. Deploy and Secure an Analysis Service database.
8. Maintain a multidimensional Analysis Service Solution.
9. Implement a Data Mining Solution.
Contents:
Introduction to Microsoft SQL Server 2005 Analysis Services
• Overview of Data Analysis Solutions.
• Over of SQL Server 2005 Analysis Services.
• Installing SQL Server 2005 Analysis Services.
Creating Multidimensional Analysis Solution
• Developing Analysis Service Solutions.
• Data Sources and Data Sources Views.
• Creating a Cube.
Lab: Creating a multidimensional Analysis Solution
Working with Dimensions
• Configuring Dimensions.
• Defining Hierarchies.
• Sorting and Grouping Attributes.
Lab: Defining Dimensions
Working with Measure and Measure Groups
• Working with Measure.
• Working with Measure Groups.
Lab: Configuring Measure and Measure Groups
Querying Multidimensional Analysis Solutions
• MDX Fundamentals.
• Adding Calculations to a Cube.
Lab: Querying a Cube
Customizing Cube Functionality
• Implementing Key Performance Indicators.
• Implementing Actions.
• Implementing Perspectives.
• Implementing Translations.
Lab: Customizing a Cube
Deploying and Securing an Analysis Services Database
• Deploying an Analysis Services Database.
• Securing an Analysis Services Database.
Lab: Deploying and 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 Service Database.
Lab: Maintaining an Analysis Services Database
Introduction to Data Mining
• Overview of Data Mining.
• Creating a Data Mining Solution.
• Validating Data Mining Models
Lab: Implementing Data Mining
SSRS – Objectives:
1. Describe SQL Server Reporting Services and its Components.
2. Create a Reporting Services report.
3. Enhance a Reporting Service report.
4. Create and manipulate data sets.
5. Use report models to implement reporting for business users.
6. Configure report publishing and execution settings.
7. Implementing subscription for reports.
8. Implement custom Reporting Services applications.
Contents:
Introduction to Microsoft SQL Server Reporting Services
• Overview of SQL Server Reporting Services.
• Reporting Services Tools.
Lab: Using Reporting Services Tools
Authoring Basic Reports
• Creating a Basic table Report.
• Formatting Report Pages.
• Calculating Values.
Lab: Creating a Simple Report
Enhancing Basic Reports
• Interactive Navigation.
• Displaying Data.
Lab: Enhancing a Report
Manipulating Data Sets
• Defining Report Data.
• Using Parameters and Filters.
• Using Parameter lists
Lab: Manipulating Data Sets
Publishing and Executing Reports
• Executing Reports.
• Creating Cached Instance.
• Creating Snapshots and Report History.
Lab: Publishing and Executing Reports
Using Subscriptions to Distribute reports
• Introduction to Report Subscriptions.
• Creating Report Subscriptions.
• Managing Report Subscriptions
Lab: Implementing Subscriptions
ANNEX IT SOLUTIONS
(Training&Consultancy)
G1, 1st Floor, Siri Towers, Beside Mythri Hospital (Prime)Ameepet, Hyderabad.
Ph: 9246541666, 040-64541666.
E-mail:msbi.annex@gmail.com
www.annexit.com
City | hyderabad |
---|---|
Price | $1000 |
Phone | 09246541666 |
msbi.annex@gmail.com | |
Category | Services: Tutoring |
Latest classifieds
Enjoy the sweetest moment of your life by choosing a Vietnam tour with kids
If you have kids and are unable to make any trips for the betterment of your kids, then if you are r
Cost-effective Bulk Messaging Solutions for Business Expansion in Pan India
Xclusive Desk is one of India's best bulk messaging services provider that allows you cost-effective
Design Build Custom Homes
Design Build Custom Homes is a Luxury Home Builder in Queen Creek, AZ. We are dedicated to crafting
Vape Street Parksville BC
At our Vape shop in Parksville BC we love helping educate new vaping users. We have the largest sele
A Civil and Structural Engineering Service - Imperiumengineering.co.uk
Are you looking for a business that offers both domestic and commercial civil and structural enginee
Ocean Hills Recovery
Welcome to Ocean Hills Recovery! Your freedom from addiction begins here. Call us now to enroll in o
Two Aspens Builders
Two Aspens Builders home renovation team of experienced professionals will work with you to create a
Strongheart Trauma Recovery
Here at STRONGHEART TRAUMA RECOVERY, I understand the effects of trauma, I understand the urge to es
Ross Appliance and Mattress
At Ross Appliance and Mattress Store, we're committed to providing the best shopping experience for
Solar 360
Solar 360 offer the best 25-year service and installation warranty, and we have a wide range of paym