• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
START DATE END DATE CLASS TIMINGS MODE LOCATION ACTION
11/19/2018 11/21/2018
  • VLT
Live Online
12/17/2018 12/19/2018
  • VLT
Live Online

20768: Developing SQL Data Models Course Overview

The concentration of this 3-day educator drove course is on making oversaw endeavor BI arrangements. It depicts how to execute both multidimensional and unthinkable information models and how to make solid shapes, measurements, measures, and measure gatherings. 20768: Developing SQL Data Models course causes you get ready for the Exam 70-768. 

20768: Developing SQL Data Models Audience Profile 

The essential gathering of people for this course are database experts who need to satisfy BI Developer part to make undertaking BI arrangements. 

Essential duties will include: 

  •  Implementing multidimensional databases by utilizing SQL Server Analysis Services 
  •  Creating unthinkable semantic information models for examination by utilizing SQL Server Analysis Services 

20768: Developing SQL Data Models At Course Completion

Subsequent to finishing this course, understudies will have the capacity to: 

  • Depict the parts, design, and nature of a BI arrangement 
  • Make a multidimensional database with Analysis Services 
  • Execute measurements in a 3D shape 
  • Actualize measures and measure bunches in a block 
  • Utilize MDX punctuation 
  • Alter a block 
  • Actualize an unthinkable database 
  • Utilize DAX to inquiry an unthinkable model 
  • Utilize information digging for prescient examination

20768: Developing SQL Data Models Course Outline 

Module 1: Introduction to Business Intelligence and Data Modeling 

20768: Developing SQL Data Models module presents key BI ideas and the Microsoft BI item suite. 

Lessons 

  • Prologue to Business Intelligence 
  • The Microsoft business knowledge stage 

Lab : Exploring a BI Solution 

  • Investigating a Data Warehouse 
  • Investigating an information show 

In the wake of finishing this module, understudies will have the capacity to: 

  • Portray BI situations, patterns, and venture parts. 
  • Portray the items that make up the Microsoft BI stage. 

Module 2: Creating Multidimensional Databases 

20768: Developing SQL Data Models module portrays how to make multidimensional databases utilizing SQL Server Analysis Services. 

Lessons 

  • Prologue to Multidimensional Analysis 
  • Making Data Sources and Data Source Views 
  • Making a Cube 
  • Outline of Cube Security 
  • Arrange SSAS 
  • Checking SSAS 

Lab : Creating a multidimensional database 

  • Making a Data Source 
  • Making and Modifying an information Source View 
  • Making and Modifying a Cube 

In the wake of finishing this module, you will have the capacity to: 

  • Portray contemplations for a multidimensional database. 
  • Make information sources and information source sees. 
  • Make a 3D square 
  • Actualize security in a multidimensional database. 
  • Arrange SSAS to meet necessities including memory points of confinement, NUMA and circle format. 
  • Screen SSAS execution. 

Module 3: Working with Cubes and Dimensions 

20768: Developing SQL Data Models module depicts how to execute measurements in a 3D square. 

Lessons 

  • Designing Dimensions 
  • Characterizing Attribute Hierarchies 
  • Arranging and Grouping Attributes 
  • Gradually Changing Dimensions 

Lab : Working with Cubes and Dimensions 

  • Designing Dimensions 
  • Characterizing Relationships and Hierarchies 
  • Arranging and Grouping Dimension Attributes 
  • Subsequent to finishing this module, you will have the capacity to: 
  • Design measurements. 
  • Characterize quality progressions. 
  • Actualize arranging and gathering for properties. 
  • Actualize gradually evolving measurements. 

Module 4: Working with Measures and Measure Groups 

20768: Developing SQL Data Models module portrays how to execute measures and measure bunches in a 3D shape. 

Lessons 

  • Working with Measures 
  • Working with Measure Groups 

Lab : Configuring Measures and Measure Groups 

  • Arranging Measures 
  • Characterizing Dimension Usage and Relationships 
  • Arranging Measure Group Storage 

In the wake of finishing this module, you will have the capacity to: 

  • Arrange measures. 
  • Arrange measure gatherings. 

Module 5: Introduction to MDX 

20768: Developing SQL Data Models module portrays the MDX sentence structure and how to utilize MDX. 

Lessons 

  • MDX basics 
  • Adding Calculations to a Cube 
  • Utilizing MDX to Query a Cube 

Lab : Using MDX 

  • Questioning a 3D shape utilizing MDX 
  • Making a Calculated Member 

In the wake of finishing this module, you will have the capacity to: 

  • Utilize essential MDX capacities. 
  • Utilize MDX to add computations to a solid shape. 
  • Utilize MDX to inquiry a solid shape. 

Module 6: Customizing Cube Functionality 

20768: Developing SQL Data Models module portrays how to tweak a block. 

Lessons 

  • Prologue to Business Intelligence 
  • The Implementing Key Performance Indicators 
  • Actualizing Actions 
  • Actualizing Perspectives 
  • Actualizing Translations 

Lab : Customizing a Cube 

  • Actualizing a KPI 
  • Actualizing an activity 
  • Actualizing a point of view 
  • Actualizing an interpretation 

In the wake of finishing this module, you will have the capacity to: 

  • Execute KPIs in a Multidimensional database 
  • Execute Actions in a Multidimensional database 
  • Execute points of view in a Multidimensional database 
  • Execute interpretations in a Multidimensional database 

Module 7: Implementing a Tabular Data Model by Using Analysis Services 

20768: Developing SQL Data Models module depicts how to actualize a forbidden information show in Power Pivot. 

Lessons 

  • Prologue to Tabular Data Models 
  • Making a Tabular Data Model 
  • Utilizing an Analysis Services Tabular Data Model in an Enterprise BI Solution 

Lab : Working with an Analysis Services Tabular Data Model 

  • Making an Analysis Services Tabular Data Model 
  • Design Relationships and Attributes 
  • Designing Data Model for an Enterprise BI Solution. 

Subsequent to finishing this module, understudies will have the capacity to: 

  • Depict forbidden information models 
  • Depict how to make a forbidden information demonstrate 
  • Utilize an Analysis Services Tabular Model in an endeavor BI arrangement 

Module 8: Introduction to Data Analysis Expression (DAX) 

20768: Developing SQL Data Models module depicts how to utilize DAX to make measures and ascertained segments in an unthinkable information show. 

Lessons 

  • DAX Fundamentals 
  • Utilizing DAX to Create Calculated Columns and Measures in a Tabular Data Model 

Lab : Creating Calculated Columns and Measures by utilizing DAX 

  • Making Calculated Columns 
  • Making Measures 
  • Making a KPI 
  • Making a Parent – Child Hierarchy 
  • Subsequent to finishing this module, understudies will have the capacity to: 
  • Depict the key components of DAX 
  • Make figured sections and measures by utilizing DAX 

Module 9: Performing Predictive Analysis with Data Mining 

20768: Developing SQL Data Models module portrays how to utilize information digging for prescient examination. 

Lessons 

  • Outline of Data Mining 
  • Making a Custom Data Mining Solution 
  • Approving a Data Mining Model 
  • Interfacing with and Consuming a Data-Mining Model 
  • Utilizing the Data Mining include for Excel 

Lab : Using Data Mining 

  • Making a Data Mining Structure and Model 
  • Investigating Data Mining Models 
  • Approving Data Mining Models 
  • Devouring a Data Mining Model 
  • Utilizing the Excel Data Mining include 

In the wake of finishing this module, understudies will have the capacity to: 

  • Portray contemplations for information mining 
  • Make an information mining model 
  • Approve an information mining model 
  • Interface with an information mining model 
  • Utilize the information digging include for Excel

Before going to this course, understudies must have: 

  • Experience of questioning information utilizing Transact-SQL

Awards