List Price: $281.99
Our price: $225.59
You save $56.40!
(20% OFF)
Product Type: 
Qty
* Please select required options above
SQL Server 70-768: Developing SQL Data Models LiveLessons (Video Training)
Qty
* Please select required options above
SQL Server Analysis Services (SSAS) provides a robust semantic environment for modeling data in support of analytic and ad hoc reporting needs. With each release of SQL Server, SSAS functionality is enhanced, with tabular models in particular becoming more capable and fully featured.
In this video, Scot Reagin couples discussion with demonstration to give you not just an understanding of the functional differences between multidimensional and tabular models, but also the context to understand where and why each should be implemented.
In addition to a comprehensive discussion of design and implementation topics, Scot covers techniques for developing queries using multidimensional and data analysis expressions, optimizing processing and query performance, and configuring and maintaining SSAS.
Skill Level
Intermediate
Learn How To
Design a multidimensional semantic model
Design a tabular semantic model
Develop queries using MDX and DAX
Configure and maintain SSAS
Who Should Take This Course
IT professionals responsible for designing, developing, maintaining, or administering SQL Server Analysis Services (SSAS)
BI developers pursuing Microsoft Certification
Course Requirements
Basic understanding of relational databases and SQL queries
Familiarity with Microsoft SQL Server client tools
Lesson Descriptions
Lesson 1: Designing a Multidimensional Semantic Model, covers building a multidimensional semantic model - a Cube. Create the fundamental components for the model, dimensions, and measures as a project and deploy this to Analysis Service.
Lesson 2: Designing a Tabular Semantic Model, demonstrates how to build and deploy tabular models while exploring security and refresh options.
Lesson 3: Developing Queries Using MDX and DAX, covers developing queries and expressions using MDX and DAX. Understanding these query languages is essential to optimizing Analysis Services models - whether multidimensional or tabular.
Lesson 4: Configuring and Maintaining SSAS, looks at ways to monitor and configure Analysis Services for best performance.
In this video, Scot Reagin couples discussion with demonstration to give you not just an understanding of the functional differences between multidimensional and tabular models, but also the context to understand where and why each should be implemented.
In addition to a comprehensive discussion of design and implementation topics, Scot covers techniques for developing queries using multidimensional and data analysis expressions, optimizing processing and query performance, and configuring and maintaining SSAS.
Skill Level
Intermediate
Learn How To
Design a multidimensional semantic model
Design a tabular semantic model
Develop queries using MDX and DAX
Configure and maintain SSAS
Who Should Take This Course
IT professionals responsible for designing, developing, maintaining, or administering SQL Server Analysis Services (SSAS)
BI developers pursuing Microsoft Certification
Course Requirements
Basic understanding of relational databases and SQL queries
Familiarity with Microsoft SQL Server client tools
Lesson Descriptions
Lesson 1: Designing a Multidimensional Semantic Model, covers building a multidimensional semantic model - a Cube. Create the fundamental components for the model, dimensions, and measures as a project and deploy this to Analysis Service.
Lesson 2: Designing a Tabular Semantic Model, demonstrates how to build and deploy tabular models while exploring security and refresh options.
Lesson 3: Developing Queries Using MDX and DAX, covers developing queries and expressions using MDX and DAX. Understanding these query languages is essential to optimizing Analysis Services models - whether multidimensional or tabular.
Lesson 4: Configuring and Maintaining SSAS, looks at ways to monitor and configure Analysis Services for best performance.
SQL Server Analysis Services (SSAS) provides a robust semantic environment for modeling data in support of analytic and ad hoc reporting needs. With each release of SQL Server, SSAS functionality is enhanced, with tabular models in particular becoming more capable and fully featured.
In this video, Scot Reagin couples discussion with demonstration to give you not just an understanding of the functional differences between multidimensional and tabular models, but also the context to understand where and why each should be implemented.
In addition to a comprehensive discussion of design and implementation topics, Scot covers techniques for developing queries using multidimensional and data analysis expressions, optimizing processing and query performance, and configuring and maintaining SSAS.
Skill Level
Intermediate
Learn How To
Design a multidimensional semantic model
Design a tabular semantic model
Develop queries using MDX and DAX
Configure and maintain SSAS
Who Should Take This Course
IT professionals responsible for designing, developing, maintaining, or administering SQL Server Analysis Services (SSAS)
BI developers pursuing Microsoft Certification
Course Requirements
Basic understanding of relational databases and SQL queries
Familiarity with Microsoft SQL Server client tools
Lesson Descriptions
Lesson 1: Designing a Multidimensional Semantic Model, covers building a multidimensional semantic model - a Cube. Create the fundamental components for the model, dimensions, and measures as a project and deploy this to Analysis Service.
Lesson 2: Designing a Tabular Semantic Model, demonstrates how to build and deploy tabular models while exploring security and refresh options.
Lesson 3: Developing Queries Using MDX and DAX, covers developing queries and expressions using MDX and DAX. Understanding these query languages is essential to optimizing Analysis Services models - whether multidimensional or tabular.
Lesson 4: Configuring and Maintaining SSAS, looks at ways to monitor and configure Analysis Services for best performance.
In this video, Scot Reagin couples discussion with demonstration to give you not just an understanding of the functional differences between multidimensional and tabular models, but also the context to understand where and why each should be implemented.
In addition to a comprehensive discussion of design and implementation topics, Scot covers techniques for developing queries using multidimensional and data analysis expressions, optimizing processing and query performance, and configuring and maintaining SSAS.
Skill Level
Intermediate
Learn How To
Design a multidimensional semantic model
Design a tabular semantic model
Develop queries using MDX and DAX
Configure and maintain SSAS
Who Should Take This Course
IT professionals responsible for designing, developing, maintaining, or administering SQL Server Analysis Services (SSAS)
BI developers pursuing Microsoft Certification
Course Requirements
Basic understanding of relational databases and SQL queries
Familiarity with Microsoft SQL Server client tools
Lesson Descriptions
Lesson 1: Designing a Multidimensional Semantic Model, covers building a multidimensional semantic model - a Cube. Create the fundamental components for the model, dimensions, and measures as a project and deploy this to Analysis Service.
Lesson 2: Designing a Tabular Semantic Model, demonstrates how to build and deploy tabular models while exploring security and refresh options.
Lesson 3: Developing Queries Using MDX and DAX, covers developing queries and expressions using MDX and DAX. Understanding these query languages is essential to optimizing Analysis Services models - whether multidimensional or tabular.
Lesson 4: Configuring and Maintaining SSAS, looks at ways to monitor and configure Analysis Services for best performance.
