Using SQL Server 2014 Analysis Services
This course is currently not scheduled on the open calendar, but can be organized on request.Request Course
This course is intended for database professionals who need to fulfill a Business Intelligence Developer role to create analysis and reporting solutions. Primary responsibilities include: Implementing multidimensional databases by using SQL Server Analysis Services; Creating tabular semantic data models for analysis by using SQL Server Analysis Services; Create visualizations of data by using PowerView; Create data mining solutions by using SQL Server Analysis Services.
Before attending this course, the student should have at least 2 years experience of working with relational databases, including: Designing a normalized database; Creating tables and relationships; Querying with Transact-SQL; Some basic knowledge of data warehouse schema topology (including star and snowflake schemas); Some exposure to basic programming constructs (such as looping and branching). An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
This course teaches students how to empower information workers through self-service analytics. Students will learn how to implement multidimensional analysis solutions, create PowerPivot and tabular data models, deliver rich data visualizations with PowerView, and discover business insights by using data mining. This course helps people prepare for exam 70-466.
Instructor led training alternated with demos and exercises. Each student disposes of a workstation. All the labs for this course can be performed using the provided virtual machines.
After completing this course, students will be able to: 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 Data Model in PowerPivot; Use DAX to query a tabular model; Implement a Tabular Database; Use PowerView to create interactive data visualizations; Use Data Mining for Predictive Analysis.
- Module 1: Creating Multidimensional Databases
- Introduction to Multidimensional Analysis
- Creating Data Sources and Data Source Views
- Creating a Cube
- Overview of Cube Security
- Module 2: Working with Cubes and Dimensions
- Configuring Dimensions
- Defining Attribute Hierarchies
- Sorting and Grouping Attributes
- Module 3: Working with Measures and Measure Groups
- Working with Measures
- Working with Measure Groups
- Module 4: Introduction to MDX
- MDX Fundamentals
- Adding Calculations to a Cube
- Using MDX to Query a Cube
- Module 5: Customizing Cube Functionality
- Working with Key Performance Indicators
- Working with Actions
- Working with Perspectives
- Working with Translations
- Module 6: Implementing an Analysis Services Tabular Data Model
- Introduction to Analysis Services Tabular Data Models
- Creating a Tabular Data Model
- Using an Analysis Services Tabular Data Model in the Enterprise
- Module 7: Introduction to DAX
- DAX Fundamentals
- Enhancing a Tabular Data Model with DAX
- Module 8: Performing Predictive Analysis with Data Mining
- Overview of Data Mining
- Creating a Data Mining Solution
- Validating Data Mining Model
- Consuming a Data Mining Data