Developing SQL Data Models Video Course

70-768: Developing SQL Data Models

Your Microsoft 70-768 exam is just around the corner, right? So, it's high time to find an effective preparation tool! Our training course is what you really need! This is a series of videos led by the experienced IT instructors who will provide you with a detailed overview of the 70-768 certification test. Ace your Microsoft 70-768 at the first attempt and obtain the Developing SQL Data Models credential with ease.

# of Students
122
# of Lectures
57
Course Length
7 h
Course Rating
4.6
Price $32.99
Today $29.99

Curriculum for 70-768 Video Course

Fundamentals and Technology Overview

  Video Name Time
  1. Business Intelligence Solution Components Overview 07:42
  2. Analyzing Dimensional Model 14:21
  3. Business Intelligence Semantic Model Overview 07:43
  4. SSAS Overview 14:07
  5. Multidimensional Expressions Overview 10:59
  Video Name Time
  1. Installing SQL Server and SSAS 07:24
  2. Configuring SSAS 06:00
  Video Name Time
  1. Attaching Data Warehouse 04:11
  2. Data Source and Data Source Views 07:59
  3. Developing Cube using Cube wizard 04:48
  4. Cube Design 07:38
  5. Dimension Design 11:45
  6. Hierarchy Design 03:15
  7. SSAS Deployment 08:00
  Video Name Time
  1. Installing OLAP database 05:22
  2. Fundamentals of MDX Query 10:29
  3. Querying Object hiearchy - Dimensions, Attributes and Members 09:48
  4. Navigating and Sorting data 11:32
  5. Filtering Data 11:31
  6. Named Sets and Subcubes 06:45
  7. Calculated Measures and KPIs 10:20
  8. SSRS with MDX 08:02
  Video Name Time
  1. Processing Dimensions, Measurses and Cubes 09:43
  2. Backup and Restore 04:11
  3. Query Logging, Exception Logging and Flight Recorder 07:15
  4. Scripting and Synchronizing Databases 03:39
  5. SSAS Security 08:23
  Video Name Time
  1. Fine tuning and Multi-lingual Support 11:45
  2. Aggregation Design 11:13
  3. Partitioning and Storage Modes 11:54
  Video Name Time
  1. Query interception and analysis 06:15
  2. Usage based performance optimization 05:13
  3. Performance Counters 05:50
  Video Name Time
  1. Applications of Data Mining 06:02
  2. Problem Definition for Data Mining with SSAS 04:10
  3. Data Preparation for Data Mining with SSAS 02:07
  4. Data Exploration for Data Mining with SSAS 03:25
  5. Building and Training Models for Data Mining with SSAS 04:02
  6. Validating model for Data Mining with SSAS 04:22
  7. Deploying models for Data Mining with SSAS 02:59
  8. Data Mining Algorithms 08:38
  Video Name Time
  1. Building a Relational Data Mining Model and Data Mining Structure 12:48
  2. Analyzing and Testing a Relational Data Mining Model 14:14
  3. Applying a Data Mining Model for Prediction 04:11
  4. Reusing a Data Mining Structure 06:29
  5. Building an OLAP Data Mining Model 09:39
  6. Analyzing Cube with Data Mining Dimension 07:36
  7. Developing Data Mining Reports using Microsoft Office 06:32
  Video Name Time
  1. Installing Tabular SSAS 04:47
  2. Setting up a sample SSAS Tabular database, data warehouse & SSAS Tabular Project 06:55
  Video Name Time
  1. Developing Tables, Relationships, and Hierarchies 14:04
  2. Developing Calculated Columns and Measures using DAX 06:56
  3. Developing Key Performance Indicators using DAX 05:38
  4. Configuring Perspectives in Tabular SSAS 03:54
  5. Querying SSAS Tabular Data Model using DAX 13:57
  6. Developing PowerView Reports from SSAS Tabular Data Model using Microsoft Office 05:24
  Video Name Time
  1. Course Wrapup 02:53

Student Feedback

5 Stars
4 Stars
3 Stars
2 Stars
1 Star
4.6
Rating: 4.6
Overall Rating: Good.

Similar Courses

Only Registered Members can View Training Courses

Please fill out your email address below in order to view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.

  • Trusted by 1.2M IT Certification Candidates Every Month
  • Hundreds Hours of Videos
  • Instant download After Registration

Already Member? Click here to Login

A confirmation link will be sent to this email address to verify your login

1200+ IT Certification Exams available: Get a free sample of any exam right now!
Try Free Demo

Try Free Demo

  • ABA
  • ACAMS
  • ACFE
  • ACI
  • ACSM
  • Adobe
  • AHIMA
  • AHIP
  • AHLEI
  • AICPA
  • AIWMI
  • Alfresco
  • AMA
  • Amazon
  • AndroidATC
  • APBM
  • API
  • APICS
  • Apple
  • Arista
  • Aruba
  • ASIS
  • ASQ
  • Atlassian
  • Autodesk
  • Avaya
  • Axis Communications
  • BACB
  • BCS
  • BICSI
  • Blockchain
  • Blue Coat
  • Blue Prism
  • Brocade
  • C++ Institute
  • CA Technologies
  • Checkpoint
  • CIMA
  • Cisco
  • Citrix
  • CIW
  • Cloudera
  • CompTIA
  • CSA
  • CWNP
  • CyberArc
  • Dell
  • DMI
  • DSCI
  • ECCouncil
  • EMC
  • Esri
  • Exin
  • Extreme Networks
  • F5
  • FileMaker
  • FINRA
  • Fortinet
  • GAQM
  • GARP
  • Genesys
  • GIAC
  • Google
  • Guidance Software
  • H3C
  • HFMA
  • HIPAA
  • Hitachi
  • HP
  • HRCI
  • Huawei
  • IAPP
  • IBM
  • IFPUG
  • IIA
  • IIBA
  • Informatica
  • Isaca
  • iSAQB
  • ISC
  • iSQI
  • ISTQB
  • ITIL
  • Juniper
  • Linux Foundation
  • Logical Operations
  • LPI
  • Magento
  • Marketo
  • McAfee
  • Microsoft
  • Mulesoft
  • NACVA
  • NCMA
  • Network Appliance
  • NI
  • Nokia
  • Novell
  • Nuage Networks
  • OMG
  • Palo Alto Networks
  • Pegasystems
  • PEOPLECERT
  • PMI
  • PRINCE2
  • Python Institute
  • QlikView
  • RedHat
  • Riverbed
  • RSA
  • Salesforce
  • SANS
  • SAP
  • SAS Institute
  • Scrum
  • SDI
  • ServiceNow
  • Six Sigma
  • SNIA
  • SOA
  • Software Certifications
  • SolarWinds
  • Splunk
  • SpringSource
  • Symantec
  • The Open Group
  • Tibco
  • VCE
  • Veeam
  • Veritas
  • Vmedu
  • VMware
  • WatchGuard
  • WorldatWork
  • Zend
Next Step
Next Step

Try Free Demo

  • Microsoft
Next Step
Next Step

Summer Sale! Get 25% Discount on All Your Purchases!

Passguide Products

Enter Your Email Address to Receive Your 25%
OFF
Discount Code Plus... Our Exclusive Weekly Deals

* We value your privacy. We will not rent or sell your email address