Developing SQL Data Models Training from ICC Teleservices
Duration 40(Hrs)
Buy Now
COURSE OUTLINE
1 - INTRODUCTION TO BUSINESS INTELLIGENCE AND DATA MODELING
- Define the Basics of Business Intelligence
- Get to Know the Microsoft Business Intelligence Platform
- Lab: Explore a BI Solution
2 - CREATING MULTIDIMENSIONAL DATABASES
- Apply Multidimensional Analysis
- Create Data Sources and Data Source Views
- Deploy a Cube
- Learn About Cube Security
- Lab: Create a Multidimensional Database
3 - WORKING WITH CUBES AND DIMENSIONS
- Configure Dimensions
- Define Attribute Hierarchies
- Sort and Group Attributes
- Lab: Work with Cubes and Dimensions
4 - WORKING WITH MEASURES AND MEASURE GROUPS
- Work with Measures
- Practice Using Measure Groups
- Lab: Configure Measures and Groups
5 - INTRODUCTION TO MDX
- Navigate the Fundamentals of MDX
- Add Calculations to a Cube
- Query a Cube Using MDX
- Lab: Work with MDX
6 - CUSTOMIZING CUBE FUNCTIONALITY
- Implement Key Performance Indicators
- Apply Actions, Perspectives and Translations
- Lab: Customize a Cube
7 - IMPLEMENTING A TABULAR DATA MODEL BY USING ANALYSIS SERVICES
- Define and Create Tabular Data Models
- Work with an Analysis Services Tabular Model in an Enterprise BI Solution
- Lab: Work with an Analysis Services Tabular Data Model
8 - INTRODUCTION TO DATA ANALYSIS EXPRESSION (DAX)
- Master the Basics of DAX
- Use DAX to Create Calculated Columns and Measures in a Tabular Data Model
- Lab: Create Calculated Columns and Measures using DAX
9 - PERFORMING PREDICTIVE ANALYSIS WITH DATA MINING
- Gain an Introduction to Data Mining
- Navigate the Data Mining Add-In for Excel
- Create a Custom Data Mining Solution
- Validate a Data Mining Model
- Connect to and Consume a Data Mining Solution
- Lab: Practice Data Mining