Wij slaan cookies op om onze website te verbeteren. Is dat akkoord? Ja Nee Meer over cookies »
72158648 SKU 72158648

70-466 Implementing Data Models and Reports with Microsoft SQL Server Training

72158648 SKU 72158648

70-466 Implementing Data Models and Reports with Microsoft SQL Server Training

299,00 361,79 Incl. btw

Het examen voor deze training wordt door Microsoft vanaf 31 Januari 2021 niet meer ondersteund. U kunt de training nog wel volgen.

Lees meer
Kortingen:
  • Koop 2 voor €293,02 per stuk en bespaar 2%
  • Koop 3 voor €290,03 per stuk en bespaar 3%
  • Koop 5 voor €278,07 per stuk en bespaar 7%
  • Koop 10 voor €269,10 per stuk en bespaar 10%
  • Koop 25 voor €254,15 per stuk en bespaar 15%
  • Koop 50 voor €233,22 per stuk en bespaar 22%
  • Koop 100 voor €209,30 per stuk en bespaar 30%
  • Koop 200 voor €149,50 per stuk en bespaar 50%
Beschikbaarheid:
Op voorraad
Levertijd:
Bestel voor 16:00 uur en start vandaag.
  • Award Winning E-learning
  • De laagste prijs garantie
  • Persoonlijke service van ons deskundige team
  • Betaal veilig online of op factuur
  • Bestel en start binnen 24 uur

70-466 Implementing Data Models and Reports with Microsoft SQL Server Training - OEM Certkit

De Training 70-466 Implementing Data Models and Reports with Microsoft SQL Server 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).

Cursusinhoud

Microsoft SQL Server 2014: Design and Install Analysis Services and Tools

Course: 1 Hour, 57 Minutes

  • Course Introduction
  • Overview of the Multidimensional and Data Mining Mode
  • Overview of Tabular Mode
  • Overview of BI Features with SharePoint
  • SQL Server BI Scenarios and SharePoint
  • Identify the Correct Model for Data Analysis
  • Identify the Development and Production Considerations

Microsoft SQL Server 2014: Designing Multidimensional Models and Data Sources

Course: 2 Hours, 3 Minutes

  • Course Introduction
  • Understanding the Logical Architecture
  • Understanding the Cube Architecture
  • Designing a Schema for a Cube Architecture
  • Understanding the Different Data Sources
  • Creating a Data Source
  • Creating a Data Source View

Microsoft SQL Server: Implement and Configure Cubes

Course: 1 Hour, 47 Minutes

  • Course Introduction
  • Creating a Cube Using Existing Tables
  • Creating an Empty Cube
  • Creating a Cube Using a Template
  • Viewing the Cube Schema in Cube Designer
  • Viewing Cube Data and Metadata in Cube Designer
  • Checking Cube Data Through the Browser
  • Creating Actions on a Cube

Microsoft SQL Server 2014: Design and Implement Dimensions 

Course: 2 Hours, 8 Minutes

  • Course Introduction
  • Creating a Dimension Using the Dimension Wizard
  • Configuring a Dimension Structure Using the Designer
  • Configuring Dimension Attribute Relationships
  • Developing New Custom Attributes on Dimensions
  • Creating User-Defined Hierarchies
  • Defining Translations for Dimension Metadata
  • Creating a Time Dimension Using the Dimension Wizard
  • Modifying a Time Dimension Using the Designer
  • Managing Parent-Child Dimensions
  • Creating Linked Dimensions

Microsoft SQL Server: Implement Partitions and Custom Logic

Course: 2 Hours, 26 Minutes

  • Course Introduction
  • Designing a Partition Strategy
  • Understanding the Storage Modes for Partitioning
  • Understanding Proactive Caching for Partitions

Microsoft SQL Server 2014: MDX Queries, Process Models, and Deploy Databases

Course: 2 Hours, 32 Minutes

  • Course Introduction
  • Understanding MDX Queries on Multidimensional Models
  • Understanding the MDX SELECT Statement Syntax: Part I
  • Understanding the MDX SELECT Statement Syntax: Part II
  • Identifying Tuples in an MDX SELECT Statement
  • Returning Tuples from an MDX SELECT Statement
  • Using Number Functions in an MDX SELECT Statement
  • Using Set Functions in an MDX SELECT Statement
  • Using the TopCount Function in an MDX SELECT Statement
  • Restricting Queries with Query Axis
  • Restricting Queries with Slicer Axis
  • Using the scope MDX Statement
  • Using the CASE MDX Statement

Microsoft SQL Server 2014: Manage, Maintain, and Troubleshoot SSAS

Course: 2 Hours, 3 Minutes

  • Course Introduction
  • Optimizing Performance of Cubes and Dimensions
  • Monitoring SSAS Using Performance Counters
  • Using DMVs to Monitor SSAS
  • Optimizing MDX Queries
  • Optimizing MDX in Calculations
  • Monitoring and Clearing the SSAS Cache

Microsoft SQL Server 2014: Create and Manage Tabular Data Models

Course: 2 Hours, 46 Minutes

  • Course Introduction
  • Creating a Tabular Model Using SSDT
  • Importing Data into a Tabular Model
  • Defining Relationships Between Tables
  • Creating Hierarchies
  • Managing the Visibility of Columns
  • Sorting and Filtering Columns
  • Creating Perspectives

Microsoft SQL Server 2014: Design Reports and Create Data Sources and Datasets

Course: 2 Hours, 4 Minutes

  • Course Introduction
  • Reporting Services Topologies and Configurations
  • Planning a Report
  • Identifying Report Components
  • Creating a Reporting Services Project
  • Installing Reporting Services
  • Configuring Reporting Services

Microsoft SQL Server 2014: Report Formatting and Interactivity

Course: 2 Hours, 34 Minutes

  • Course Introduction
  • Creating a Tablix Report
  • Creating a Matrix Report
  • Formatting Fields and Column Headers
  • Adding Images, Maps, Charts, and Indicators
  • Adding Lists, Text Boxes, and Other Visuals
  • Grouping Data and Adding Line Totals and Grand Totals
  • Implementing Group and Report Variables
  • Defining Expressions
  • Using the Report Wizard to Create a Report

Microsoft SQL Server 2014: Manage Reporting Services

Course: 1 Hour, 37 Minutes

  • Course Introduction
  • Understanding Report Server Security Architecture
  • Configuring Report Server Level Security
  • Configuring Item-level Security
  • Securing Reports Using Roles
  • Securing Shared Data Source Items
  • Configuring Stored Credentials
  • Configuring SharePoint Groups and Permissions
  • Managing Encryption Keys

Microsoft SQL Server 2014: Process Report and Create Subscriptions and Schedules

Course: 1 Hour, 19 Minutes

  • Course Introduction
  • Publishing Reports to a Report Server
  • Publishing Reports to a SharePoint Library
  • Deploying Custom Assemblies with Reports
  • Saving Reports Using Report Builder
  • Viewing Reports in Report Manager and a Browser
Levertijd Binnen 1 werkdag
Online toegang 365 dagen
Lesduur 24:50 uur
Studiebelasting Variabel i.v.m. praktijkopdrachten.
Leermethoden Instructie video, Demonstratie video, Knowledge Base
Besturingssystemen Microsoft Windows, Google Chrome OS, Apple MacOS
Inbegrepen dienstverlening Contact met docent per mail en chat, Voortgangsrapportage, 24/7 online toegang
Ondersteunde browsers Internet Explorer, Edge, Firefox, Safari en Chrome
MOS Examen Mogelijk voor bijbehorend examennummer
Toegang tot docent Per mail en chat
Extra Opties Virtual Labs (indien beschikbaar)

Er zijn nog geen reviews geschreven over dit product.

70-466 Implementing Data Models and Reports with Microsoft SQL Server OEM Certkit + Live Labs

  • Normaal: 415,-
  • Je bespaart: (2% korting) 10,-
  • Totaal: 405,-
In winkelwagen

Beoordelingen

Er zijn nog geen reviews geschreven over dit product.

Microsoft Office SCORM e-Learning

Wilt u Microsoft Office e-Learning SCORM hosten in het LMS van uw organisatie? Neem contact met ons op.

Combideals

Pak een bundel en ontvang korting

70-466 Implementing Data Models and Reports with Microsoft SQL Server OEM Certkit + Live Labs

  • Normaal: 415,-
  • Je bespaart: (2% korting) 10,-
  • Totaal: 405,-
In winkelwagen

Cursisten beoordeling

Springest: 8.9, Edubookers: 8.5

Kwaliteitsgarantie

Award Winning E-learning & Gecertificeerde Docenten

Microsoft Partner

én Certiport Partner

Niet Goed Geld Terug

én Startgarantie

Nóg meer kennis

Lees onze meest recente blogartikelen

Bekijk alles