70-467 Designing Business Intelligence Solutions with Microsoft SQL Server 2012 Ausbildung - OEM Certkit

Das Ausbildung 70-467 Entwerfen von Business Intelligence-Lösungen mit Microsoft SQL Server 2012 über ein spezielles Zertifizierungspaket. 1 Jahr Zugang zu revolutionärem E-Learning, um die Prüfung problemlos zu bestehen. Machen Sie sich mit dem Lernen über 1 Learning Portal (LMS) mit zertifizierten Lehrern vertraut. Exklusive Online-Mentoren rund um die Uhr und anspruchsvolle Kurstests und hinter den Kulissen Alle Tipps und Tricks anzeigen.
Garantiert immer die offizielle Testprüfung und eine offizielle Teilnahmebescheinigung nach dem Training. Optionale Livelabs (zusätzliche Kosten).

Kursinhalt

Microsoft SQL Server 2014 - Designing BI Solutions: BI Infrastructure Design

Course: 3 Hours, 12 Minutes

• Course Introduction
• The BI Infrastructure Data Sources
• Data Warehouse and ETL Solution for a BI Infrastructure
• Analytical Data Models and Reporting
• Microsoft Product Roles in the BI Infrastructure
• BI Infrastructure Upgrade Considerations

Microsoft SQL Server 2014 - Designing BI Solutions: Extract, Transform, and Load

Course: 2 Hours, 55 Minutes

• Course Introduction
• ETL Data Flow Architectures
• Examining the Source Data for the ETL Solution
• Reducing Load Times and Plan Extraction Windows
• Transformations in an ETL Solution
• Implementing Slowly Changing Dimensions
• Implementing Change Data Capture
• Handling Invalid Rows
• Using the Balanced Data Distributor Transformation
• Planning for Incremental Loads and Full Loads
• Aggregation Performance Design
• Loading Partitioned Fact Tables
• Handling Errors and Audit Information

Microsoft SQL Server 2014 - Designing BI Solutions: Data Models

Course: 2 Hours, 48 Minutes

• Course Introduction
• Business Intelligence Semantic Models
• Choosing the Appropriate BISM
• Choosing the Appropriate Schema for a Data Model
• Designing a Relational Model for a Data Mart
• Designing Proactive Caching within SSAS

Microsoft SQL Server 2014 - Designing BI Solutions: Reporting Services

Course: 2 Hours, 49 Minutes

• Course Introduction
• Reporting and Analysis Design in a BI Solution
• Common Reporting Scenarios for BI Solutions
• Tools Used for Report Creation and Delivery Part
• Tools Used for Report Creation and Delivery Part

Microsoft SQL Server 2014 - Designing BI Solutions: SharePoint Integration

Course: 2 Hours, 28 Minutes

• Course Introduction
• SharePoint Infrastructure Design in a BI Solution
• Overview of SharePoint Integration Mode Features
• Understanding the SharePoint Server Integration Steps

Microsoft SQL Server 2014 - Designing BI Solutions: MDX Queries and Performance

Course: 3 Hours, 1 Minute

• Course Introduction
• Designing MDX Calculations
• The MDX Query Structure
• Identifying Common MDX Functions
• Using MDX Set Functions (Part 1)
• Using MDX Set Functions (Part 2)
• Using MDX Tuple Functions
• Managing Scope and Context
• Creating Query-Scoped Calculated Members
• Creating Session-Scoped Calculated Members
• Performing a Simple Case Statement
• Performing a Searched Case Statement

Microsoft SQL Server 2014 - Designing BI Solutions: Availability and Recovery

Course: 2 Hours, 23 Minutes

• Course Introduction
• Authentication Mechanisms
• Configuring SSAS to Allow for Impersonation
• Configure SSAS for Trusted Delegation
• Testing for Impersonated or Delegated Identity
• Configuring External Access to SSAS (Part 1)
• Configuring External Access to SSAS (Part 2)
• Configuring External Access to SSAS (Part 3)
• Implementing Dynamic Dimension Security
• Creating Roles for Access at Different Levels Microsoft SQL Server 2014: Process Report and
• Create Subscriptions and Schedules