Brainmatics

Microsoft SQL Server 2008, Business Intelligence Development and Maintenance (70-448) Exam Preparation

Popularity : author-post-ratingauthor-post-ratingauthor-post-ratingauthor-post-ratingauthor-post-rating

Training ini berfokus untuk developer dan administrator Business Intelligent (BI) yang berencana mengambil ujian sertifikasi Microsoft Certified Technology Specialist (MCTS) 70-448, Microsoft SQL Server 2008 Business Intelligence Development and Maintenance.

Pada training ini, peserta akan belajar bagaimana mengembangkan dan mengelola Microsoft SQL Server 2008 BI platform yang meliputi SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).

 

CONTENT

1. Developing SSIS Packages

    1.1. Creating SSIS Packages and Data Sources
    1.2. Creating and Editing Control Flow Objects
    1.3. Using Data Flow Adapters and Transformations

2. Debugging and Error Handling in SSIS

    2.1. Configuring Package Transactions and Checkpoints
    2.2. Identifying Package Status, Enabling Logging, and Handling Task Errors
    2.3. Handling Data Flow Errors and Debugging

3. Deploying and Configuring SSIS Packages

    3.1. Using Package Configurations and Expressions
    3.2. Deploying SSIS Packages

4. Administering, securing, and Executing SSIS Packages

    4.1. Managing the SSIS Service and Configuring Package Security
    4.2. Executing and Scheduling Packages

5. Developing SSAS Cubes

    5.1. Creating Data Sources and Data Source Views
    5.2. Creating and Modifying SSAS Cubes
    5.3. Creating and Modifying Dimensions
    5.4. Creating Measure Groups and Measures

6. Extending SSAS Cubes

    6.1. Defining User Hierarchies and Dimension Relationships
    6.2. Creating KPIs, Actions, Translations, and Perspectives
    6.3. Creating Calculations and Queries by Using MDX

7. Managing SSAS Storage, Processing, and Deployment

    7.1. Defining Measure Group Partitions and Aggregations
    7.2. Deploying SSAS Objects
    7.3. Processing SSAS Objects

8. Securing and Administering SSAS

    8.1. Setting Up SSAS Server Security
    8.2. Managing SSAS High Availability, Backups, and Object Scripting
    8.3. Managing SSAS Tuning and Logging
    8.4. Tracing and Monitoring SSAS Instances

9. Working with SSAS Data Mining

    9.1. Preparing and Creating Data Mining Structures
    9.2. Creating Models and Applying Algorithms
    9.3. Validating Models, Using DMX Queries, and Using Prediction Queries in Reports
    9.4. Securing and Processing Data Mining Models

10. Developing SSRS Reports

    10.1. Creating SSRS Projects and Reports in BIDS
    10.2. Creating a Dataset from a Data Source
    10.3. Working with Advanced Report Object Properties
    10.4. Applying Dataset Filters and Groups

11. Extending and Deploying SSRS Reports

    11.1. Assigning Parameters Within Reports
    11.2. Using Expressions to Perform Advanced Report Item Formatting
    11.3. Deploying New Reports and Changes
    11.4. Using Reports in Your Code

12. Scheduling and Securing Deployed Reports and Data Sources

    12.1. Administering SSRS Item-Level Permissions and Site Security Roles
    12.2. Creating Report Schedules and Subscriptions
    12.3. Managing Report Caching and Execution Properties in Report Manager

13. Configuring and Administering the SSRS Server

    13.1. Installing and Configuring Initial Instances of SSRS
    13.2. Configuring Advanced SSRS Settings and Scale-Out Deployment

 

INSTRUCTOR

Rudolf Gumansalangi. Menyelesaikan S1 Jurusan Ilmu Komputer di Universitas Gunadarma. Telah memiliki Sertifikasi MCT (Microsoft Certified Trainer),Microsoft Certified Application Developer (MCAD) untuk ASP.Net,Microsoft Certified Professional Developer (MCPD) di bidang Web Development,Microsoft Certified Professional (MCPS),Microsoft Certified Technology Specialist (MCTS) Sharepoint 2010 Development. Memiliki expertise dalam bidang Datawarehouse, Business Intelligence,Sharepoint serta menguasai bahasa pemrograman VB.NET, ASP.NET, C#, Javascript dan RDBMS (Microsoft SQL Server,MySQL dan Oracle Database). Sekarang aktif sebagai Freelance Developer dan Trainer/Pengajar baik di perusahaan swasta maupun instansi pemerintahan.