Start Date Batch Name Timings Days Duration Mode Amount Slots Available Cart
Nov 19,2018 Nov 2018 07:00 PM - 08:00 PM (PST) Monday - Friday 6 Weeks Online (Instructor Led) $499 ($399.00) 25

MS BI

In this Course, you'll be introduced to features and technologies for implementing a database beyond the basics. You will learn about the Microsoft SQL server, which is a relational database management system developed to store and retrieve data requested by other software applications.

You will learn about database development basics, programmatic database objects, in-memory databases, and transactions. 

  • 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