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