Microsoft Training - April-September 2009 - (Page 39) SQL Server 2005 for Business Intelligence Use SQL 2005 to build Business Intelligence applications. Course 6064 Enhanced Course OMLP-based & Global Knowledge enhanced Course Description In this instructor-led course, you’ll learn to implement an Analysis Services solution in an organization. Learn to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and learn to use the Analysis Services management and administrative tools to manage an Analysis Services solution. Supplemental content and our enhanced labs add additional hands-on experience. This course incorporates material from the Official Microsoft Learning Product (OMLP): • ourse 2791: Implementing and Maintaining Microsoft SQL Server C 2005 Analysis Services Lab 1: Installing Analysis Services and Designing a Multidimensional Analysis Solution • Installing Analysis Services • Data Warehouse Databases • Dimension and Fact Tables • Star and Snowflake Schemas Lab 2: Creating a Multidimensional Analysis Solution • Creating a Data Source • Creating and Modifying a Data Source View • Creating and Modifying a Cube Lab 3: Defining Dimensions • Configuring Dimensions • Defining Relationships and Hierarchies • Sorting and Grouping Dimension Attributes Lab 4: Configuring Measures and Measure Groups • Configuring Measures • Defining Dimension Usage and Relationships • Configuring Measure Group Storage Lab 5: Querying a Cube • Querying a Cube by Using MDX • Creating a Calculated Member • Defining a Named Set Lab 6: Customizing a Cube • Implementing a KPI • Implementing an Action • Implementing a Perspective • Implementing a Translation Lab 7: Deploying and Securing an Analysis Services Database • Deploying an Analysis Services Database • Securing an Analysis Services Database Lab 8: Maintaining an Analysis Services Database • Configuring Processing • Implementing Logging and Monitoring • Backing Up and Restoring an Analysis Services Database Hands-On Labs Lab 9: Implementing Data Mining • Creating a Data Mining Structure • Adding a Data Mining Model • Exploring Data Mining Models • Validating Data Mining Models • DMX Predictive Queries Lab 10: Performance, Indexes, and Proactive Caching • Creating Clustered and Non-Clustered Indexes • Index Creation Fill Factors • Database Engine Tuning Advisor • SQL Profiler • Implementation of Proactive Caching Lab 11: Use Analysis Services with Microsoft Office System • Integration with Microsoft Office • Example application Lab 12: SSIS/Populating a Data Warehouse • SSIS Designer • Running SSIS Packages • Running DTS packages in SQL Server 2005 • Migration Wizard – Upgrade DTS packages to SSIS • Extract, Transform, and Load a Data Warehouse Lab 13: Set Up and Use Reporting Services (SSRS) • Setting Up Reporting Services • Using Report Manager • Sample Reports • Report Wizard • Report Designer • Reports Using Cubes What You’ll Learn in Class • ow SQL Server Analysis Services can be used to implement analytical H solutions • Create Analysis Services cubes • reate multidimensional analysis solutions with SQL Server Analysis C Services • Implement dimensions in an Analysis Services solution • mplement measures and measure groups in an Analysis Services I 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 a data mining solution • Utilize Key Performance Indicators (KPIs) • Populate cubes using SSIS • Create reports using Reporting Services and cubes • Integration of Microsoft Office and Analysis Services • Strategies for migrating from 2000 to 2005 Who Needs To Attend Information technology (IT) professionals and developers who need to implement analysis solutions by using Microsoft SQL Server 2005 Analysis Services. Prerequisites • • • • • Course Content Conceptual understanding of OLAP solutions Experience navigating the Microsoft Windows Server environment Experience with Windows services (starting and stopping) Experience creating service accounts and permissions Experience with Microsoft SQL Server, including: - SQL Server Agent - SQL Server query language (SELECT, UPDATE, INSERT, and DELETE) - SQL Server System tables - SQL Server accounts (users and permissions) 1. Introduction to Microsoft SQL Server 2005 Analysis Services 2. Creating Multidimensional Analysis Solutions 3. Working with Dimensions 4. Working with Measures and Measure Groups 5. Querying Multidimensional Analysis Solutions 6. Customizing Cube Functionality 7. Deploying and Securing an Analysis Services Database 8. Maintaining a Multidimensional Solution 9. Introduction to Data Mining 10. Implementing Proactive Caching 11. Analysis Services with Microsoft Office System 12. SQL Server Integration Services (SSIS) 13. Set Up and Use Reporting Services Classroom Learning 5 days $2,995 Classroom Learning CA San Jose Apr 6-10 CA San Jose Aug 10-14 DC Washington Apr 27-May 1 DC Washington Aug 3-7 GA Atlanta May 18-22 GA IL IL NC NC NJ Atlanta Chicago Chicago Raleigh Raleigh Morristown Virtual Classroom e-Learning 5, 8-hour sessions, $2,495 Sep 21-25 Jun 1-5 Aug 31-Sep 4 May 11-15 Sep 14-18 Jun 1-5 NY NY ON ON ON TX New York New York Ottawa Toronto Toronto Dallas On-Site Learning Call for info. May 4-8 Jul 27-31 Apr 27-May 1 Apr 13-17 Aug 10-14 Jul 13-17 Classroom Learning Apr 20-24 Jun 15-19 Aug 10-14 REGISTER NOW 1-800-COURSES www.globalknowledge.com/microsoft 39 http://www.globalknowledge.com/training/olm/go.asp?find=MIC6064&country=United+States http://www.globalknowledge.com/microsoft
For optimal viewing of this digital publication, please enable JavaScript and then refresh the page. If you would like to try to load the digital publication without using Flash Player detection, please click here.