SSAS Training Overview
This Designing and Implementing SQL Server Analysis Services (SSAS) Multidimensional Databases training class teaches participants how to administer, design, and build multidimensional databases using SQL Server Analysis Services (SSAS).
This class can be combined with Accelebrate's Introduction to SQL Server MDX as a customized five-day class to add a greater depth of knowledge of MDX queries and expressions.
Note: This course is appropriate for SQL Server 2016 and 2017.
Location and Pricing
Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.
In addition, we offer some courses as live, instructor-led online classes for individuals.
Objectives
- Describe the components, architecture, and nature of a BI solution
- Implement a logical design for a data warehouse
- 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
- Use data mining for predictive analysis
Prerequisites
All students should have the following experience:
- At least 2 years’ experience of working with relational databases
- Designing a normalized database
- Querying with Transact-SQL is helpful but is not required
Outline
Expand All | Collapse All
Introduction to Business Intelligence and Data Modeling
- Introduction to Business Intelligence
- The Microsoft business intelligence platform
Designing and Implementing a Data Warehouse
- Logical Design for a Data Warehouse
- Physical Design for a Data Warehouse
Creating Multidimensional Databases
- Introduction to multidimensional analysis
- Creating data sources and data source views
- Creating a cube
- Overview of cube security
- Configure SSAS
- Monitoring SSAS
Working with Cubes and Dimensions
- Configuring dimensions
- Define attribute hierarchies
- Sorting and grouping attributes
- Slowly Changing Dimensions
Working with Measures and Measure Groups
- Working with measures
- Working with measure groups
Introduction to MDX
- MDX fundamentals
- Adding calculations to a cube
- Using MDX to query a cube
Customizing Cube Functionality
- Introduction to Business Intelligence
- Implementing key performance indicators
- Implementing actions
- Implementing perspectives
- Implementing translations
Performing Predictive Analysis with Data Mining
- Overview of Data Mining
- Creating a Custom Data Mining Solution
- Validating a Data Mining Model
- Connecting to and Consuming a Data-Mining Model
- Using the Data Mining add-in for Excel
Conclusion
Training Materials
All Microsoft training students receive customized Microsoft official courseware.
Software Requirements
Attendees will not need to install any software on their computer for this class. The class will be conducted in a remote environment that Accelebrate will provide; students will only need a local computer with a web browser and a stable Internet connection. Any recent version of Microsoft Edge, Mozilla Firefox, or Google Chrome will be fine.
