Curriculumestimated time

Data Warehousing

• Overview of Data ware housing and BI

• Introduction to SQL BI

• Dimensional Modelling Concepts

SSIS

• Introduction to SSIS Services

• Developing SSIS Packages

• Implementing Control Flow

  • Control Flow Tasks

  • Precedence Constraints

  • Control Flow Containers

  • Control Flow Tasks

  • Precedence Constraints

  • Control Flow Containers

• Implementing Data Flow

  • Data Flow Sources & Destinations

  • Data Flow Transformations

  • Data Flow Pipeline

  • Data Flow Sources & Destinations

  • Data Flow Transformations

  • Data Flow Pipeline

• Implementing Logging

  • Overview of Integration Services Logging

  • Implementing Logging

  • Overview of Integration Services Logging

  • Implementing Logging

• Debugging and Error Handling

  • Debugging a Package

  • Implementing Error Handling

• Implementing Checkpoints and Transactions

• Implementing Transactions

• SSIS Administration

  • Deploying Packages

  • Managing Packages

  • Securing Packages

  • Scheduling a Package

SSAS

• Introduction to Analysis Services

  • OLTP, DWH

  • OLAP TYPES

• SSAS Architecture

  • Dimension Tables

  • Fact tables

• Analysis Services Tools

• Cube Design process and Concepts

  • Dimensions

  • Measure Groups

  • Creating simple calculations

  • Aggregations and Hierarchies

  • Dimension Relationships

  • Translations

  • Perspectives

• Advanced Cube Design Process

• MDX introduction and Queries

  • Implementing KPI

  • Implementing Actions

• SSAS Administration

  • Applying Security Roles

  • Levels of Security

  • Partitioning

  • Deployment and Scheduling

SSRS

• Introduction to SSRS

• Overview of SSRS

• Authoring Reports

• Publishing and Executing Reports

• Creating Snapshots and Report History

• Using Subscriptions to Distribute Reports

• SSRS Administration

Power BI

• Introduction to Power BI Concepts

• Power Pivot

• Power Query

• Power View

• Power Map