Developing SQL Data Models (MS-20768)

Seminarbeschreibung:

• Introduction to Business Intelligence and Data Modeling
• Creating Multidimensional Databases
• Working with Cubes and Dimensions
• Working with Measures and Measure Groups
• Introduction to MDX
• Customizing Cube Functionality
• Implementing a Tabular Data Model by Using Analysis Services
• Introduction to Data Analysis Expression (DAX)
• Performing Predictive Analysis with Data Mining

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
• The secondary audiences for this course are ‘power’ information workers/data analysts.

Before attending this course, students must have:

• Experience of querying data using Transact-SQL