Microsoft Business Intelligence Online Training - London - Education, training, lessons, London - 157105

Find
 


Classified ad details
 Back  Print

Microsoft Business Intelligence Online Training - Education, training, lessons

Ref. number: 157105 Updated: 08-03-2010 07:25

Price: 1 000 USD $

Offering: Education, training, lessons in United Kingdom, London

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

Advertising
Classified ad images
Contact information
Phone number: 09246541666
 
Ask about this ad
Email *
 
Retype E-mail Address *
 
Main personal information
First name:  
Last name:  
Phone number:  
Mobile number:  
Please enter your message below to send it to ad owner.
Your message: *



Our button:
FREEADS in UK

Button code