Overview
Developing SQL Data Models course imparts core skills to implement multidimensional databases using SSAS (SQL Server Analysis Services), and create tabular semantic data models for analysis. This SSAS training is meant for database professionals who create enterprise BI solutions in order to fulfil the role of a BI Developer. This SQL Data Model Development course is also suitable for power users, information workers and data analysts.
This course prepares you for Exam 70-768. Download Course Contents Test your current knowledge Qubits
Course Prerequisites
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases.
Upon Completion of this Course, you will accomplish following:
- Understand the architecture, components and features of BI solution
- Use analytics of SSAS to create a multidimensional database
- Deploy dimensions into a cube
- Deploy measures and measure groups into a cube
- Implement MDX syntax
- Perform customizations on a cube
- Create a tabular database
- Query tables using DAX
- Conduct predictive analysis using data mining