20768 Developing SQL Data Models
Course Summary
Training level | MOC |
Duration | 3 days / 24 Hours |
Delivery method | In Class |
Level | 300 |
Language | Bulgarian/English |
List price | 600 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

Reserve your seat
Reserving a seat does not imply any obligations for payment