ICC Teleservices Ltd
Your Trusted ICT Partner

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

OUR PARTNER