70-467 Designing SQL Business Intelligence Solutions
E-Learning Training OEM Certkit

De Training 70-467 Designing SQL Business Intelligence Solutions via een Speciale Certificeringspakket. 1 Jaar toegang tot revolutionaire E-Learning om het examen Gemakkelijk te halen. Laat je Introduceren door te Leren via 1 Leerportaal (LMS) met Gecertificeerde Docenten. Exclusief 24/7 Online Mentor en Uitdagende Cursus Testen en Bekijk Achter de schermen alle Tips & Tricks.
Gegarandeerd altijd het Officieel Proefexamen en na de Training een Officieel Certificaat van Deelname. Optioneel Livelabs (meerprijs).

Microsoft SQL Server 2014 biedt meerdere functies ter ondersteuning van business intelligence-oplossingen. Dit leertraject behandelt het ontwerpen van een business intelligence-oplossing die data-analyse biedt via datamodellen en rapportlevering met behulp van Reporting Services en SharePoint-server. Het bevat informatie over het ontwerpen en bouwen van het datawarehouse, het uitvoeren van ETL op de data en het ontwerpen van datamodellen voor rapportagelevering via Reporting Services in Native en SharePoint-modus. Dit leertraject van Skillsoft helpt individuen zich voor te bereiden op de 70-467 Designing Business Intelligence Solutions met Microsoft SQL Server. Dit examen is het laatste examen in het MCSE Solutions Expert: Business Intelligence certificeringstraject.

Cursusinhoud

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