Developing SQL Data Models (M20768)
Course ID
Course Description
In this course, you will learn about business intelligence (BI) solutions that implement multidimensional databases and create tabular semantic data models for analysis using SQL Server Analysis Services (SSAS).
This course uses Microsoft SQL Server 2016 and incorporates material from the Official Microsoft Learning Product 20768: Developing SQL Data Models.
Prerequisites
- Basic knowledge of the Microsoft Windows operating system and its core functionality
- Working knowledge of Transact-SQL
- Working knowledge of relational databases
Audience
- Data analysts and power information workers
- Database professionals who fulfill a BI developer role and create enterprise BI solutions and whose primary responsibilities include:
- Implementing multidimensional databases by using SSAS
- Creating tabular semantic data models for analysis by using SSAS
Course Content
- 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
For More Information
For training inquiries, call 850-308-1376
or email us at eramos@gbsi.com
Course Details
Duration - 3 days
Price - $2295.00 USD
(Discounts may apply. Call for more information.)
Course Actions
Acceletrain Collaborative Learning Environment (formerly know as VILT) places industry certified and expert instructors, peers, learners and multi-media components into a "borderless classroom", and interactive learning environment that can span multiple physical locations. VILT combines the benefits of the traditional brick-and-mortar classroom with innovative learning techniques and the cost savings of internet-based training.