70-768: Developing SQL Data Models Exam - Certification Training Course

Curriculum For This Course

Fundamentals and Technology Overview

5Lectures

Time 00:55:42

SQL Server Analysis Services (SSAS) Installation

2Lectures

Time 00:13:33

Cube Design and Development

7Lectures

Time 00:48:01

Multidimensional Expressions - Practical code development

8Lectures

Time 01:14:21

Administration

5Lectures

Time 00:33:30

Advance Techniques

3Lectures

Time 00:35:03

Performance Tuning

3Lectures

Time 00:17:29

Basics of Data Mining Concepts and Data Mining Algorithms

8Lectures

Time 00:36:16

Developing Data Mining Models using SQL Server and SSAS

7Lectures

Time 01:01:55

Tabular SSAS - Installation and Setup

2Lectures

Time 00:11:49

SSAS Tabular Data Model - Design and Development

6Lectures

Time 00:50:16

Conclusion

1Lectures

Time 00:03:30

Fundamentals and Technology Overview
	1. Business Intelligence Solution Components Overview	7:49
	2. Analyzing Dimensional Model	14:26
	3. Business Intelligence Semantic Model Overview	7:51
	4. SSAS Overview	14:17
	5. Multidimensional Expressions Overview	11:19

SQL Server Analysis Services (SSAS) Installation
	1. Installing SQL Server and SSAS	7:27
	2. Configuring SSAS	6:06

Cube Design and Development
	1. Attaching Data Warehouse	04:11
	2. Data Source and Data Source Views	8:03
	3. Developing Cube using Cube wizard	4:53
	4. Cube Design	7:42
	5. Dimension Design	11:49
	6. Hierarchy Design	3:18
	7. SSAS Deployment	8:05

Multidimensional Expressions - Practical code development
	1. Installing OLAP database	5:26
	2. Fundamentals of MDX Query	10:33
	3. Querying Object hiearchy - Dimensions, Attributes and Members	9:52
	4. Navigating and Sorting data	11:36
	5. Filtering Data	11:35
	6. Named Sets and Subcubes	6:49
	7. Calculated Measures and KPIs	10:24
	8. SSRS with MDX	8:06

Administration
	1. Processing Dimensions, Measurses and Cubes	9:47
	2. Backup and Restore	4:15
	3. Query Logging, Exception Logging and Flight Recorder	7:19
	4. Scripting and Synchronizing Databases	3:43
	5. SSAS Security	8:26

Advance Techniques
	1. Fine tuning and Multi-lingual Support	11:49
	2. Aggregation Design	11:17
	3. Partitioning and Storage Modes	11:57

Performance Tuning
	1. Query interception and analysis	6:19
	2. Usage based performance optimization	5:17
	3. Performance Counters	5:53

Basics of Data Mining Concepts and Data Mining Algorithms
	1. Applications of Data Mining	6:05
	2. Problem Definition for Data Mining with SSAS	4:14
	3. Data Preparation for Data Mining with SSAS	2:11
	4. Data Exploration for Data Mining with SSAS	3:29
	5. Building and Training Models for Data Mining with SSAS	4:06
	6. Validating model for Data Mining with SSAS	4:26
	7. Deploying models for Data Mining with SSAS	3:03
	8. Data Mining Algorithms	8:42

Developing Data Mining Models using SQL Server and SSAS
	1. Building a Relational Data Mining Model and Data Mining Structure	12:53
	2. Analyzing and Testing a Relational Data Mining Model	14:17
	3. Applying a Data Mining Model for Prediction	4:14
	4. Reusing a Data Mining Structure	6:33
	5. Building an OLAP Data Mining Model	9:43
	6. Analyzing Cube with Data Mining Dimension	7:39
	7. Developing Data Mining Reports using Microsoft Office	6:36

Tabular SSAS - Installation and Setup
	1. Installing Tabular SSAS	4:50
	2. Setting up a sample SSAS Tabular database, data warehouse & SSAS Tabular Project	6:59

SSAS Tabular Data Model - Design and Development
	1. Developing Tables, Relationships, and Hierarchies	14:07
	2. Developing Calculated Columns and Measures using DAX	7:00
	3. Developing Key Performance Indicators using DAX	5:42
	4. Configuring Perspectives in Tabular SSAS	3:58
	5. Querying SSAS Tabular Data Model using DAX	14:01
	6. Developing PowerView Reports from SSAS Tabular Data Model using Microsoft Office	5:28

Conclusion
	1. Course Wrapup	3:30

Free 70-768 Exam Questions & Microsoft 70-768 Dumps
Microsoft.Prep4sure.70-768.v2017-12-07.by.wangyan.23qs.ete	Views: 322 Downloads: 427	Size: 1.13 MB Votes: 7

Student Feedback

4.6

Excellent

65%

25 %

10%

Comments * The most recent comment are at the top

Julia

Germany

May 08, 2018

It is great software and (I hope ) exam questions content . It was nice, when we could use more than one ete file for preparation. I have an exam next week, So, I'll write, how it works. Any case - thanks a lot for your work here.