20768 Developing SQL Data Models

Course Summary

Training levelMOC
Duration2 days / 16 Hours
Delivery methodIn Class
Level200
LanguageBulgarian/English
List price380 Euro VAT Excl.

Click Tabs for Detailed info

Microsoft Official Course – 20768

  • The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions. Primary responsibilities will include:
    • Implementing multidimensional databases by using SQL Server Analysis Services
    • Creating tabular semantic data models for analysis by using SQL Server Analysis Services
  • Describe the components, architecture, and nature of a BI solution
  • Create a multidimensional database with Analysis Services
  • Implement dimensions in a cube
  • Implement measures and measure groups in a cube
  • Use MDX syntax
  • Customize a cube
  • Implement a tabular database
  • Use DAX to query a tabular model
  • Use data mining for predictive analysis
  • Module 1: Introduction to Business Intelligence and Data Modeling
  • Module 2: Creating Multidimensional Databases
  • Module 3: Working with cubes and dimensions
  • Module 4: Working with measures and measure groups
  • Module 5: Introduction to MDX
  • Module 6: Customizing Cube Functionality
  • Module 7: Implementing a Tabular Data Model by Using Analysis Services
  • Module 8: Introduction to Data Analysis Expression (DAX)
  • Module 9: Performing Predictive Analysis with Data Mining

Next planned dates:

Trainer: Ivan Donev

Ivan-Donev

Reserve your seat





Subscribe me to your mailing list

Reserving a seat does not imply any obligations for payment

Next training starts in:
Stay tuned for the next training date
Days
Hours
Minutes
Seconds