Welcome To Eazygurus

Microsoft Business Intelligence

Course Name         :   Microsoft Business Intelligence (MSBI)
Duration                 :  35 hrs

STUDENTS ENROLLED

    • Introduction to Microsoft Business Intelligence (MSBI)
      • Need of Business Intelligence
      • Failures of the Existing Systems
      • Data Warehouse Models
      • Building Stages of Data Warehouse
      • DWH Life Cycle- DWH Architecture
      • ETL and OLAP Tools
      • BI Products Availability
      • Microsoft BI in the Market
    • SQL Server Integration Services (SSIS) Development
      • Introduction to SSIS
      • Introduction to ETL Concepts
      • Packages Development using SSIS Wizard
      • SSIS Designer Introduction
      • Control flow Items
      • Tasks
      • Containers
      • Data Flow Items
      • Sources
      • Transformations
      • Destinations
      • Usage of Built-in Functions
      • Parameters & Variables in SSIS
      • Transaction with Data Quality Services
    • Error and Debugging SSIS
      • Events Handlers
      • Configure Error Output
      • Data Viewers
      • Break Points
      • Log Providers
      • Check Point Usage
    • SSIS Administrations
      • Deployment
      • Configuration
      • Security
      • Executing of Packages Manually
      • Scheduling SSIS Packages
      • Importing and Exporting Packages
      • Monitoring and Tuning Techniques in SSIS
    • DWH With SSIS
      • Dimension Tables Data Loading
      • Fact Tables Data Loading
    • SQL Server Reporting Services (SSRS)
      • Introduction to SSRS
      • Need of Reporting Services
      • Reporting Life Cycle
      • Types of Reports
      • Data Sources
      • Datasets
      • Designing of Report using Report Wizard
      • Introduction to Report Designer
    • Report Authoring
      • Report Items
      • Expressions in SSRS
      • Report Layout Sections
      • Designing of Reusable Templates
      • Working with Data Regions
    • Advanced Authoring
      • Use of Parameters in Reports
      • Drill Down Reports
      • Sub Reports
      • Filters in SSRS
      • Actions in SSRS
      • .NET Scripting in SSRS
      • Embedded Scripting
      • External Scripting
      • Variables in SSRS
      • Working with Different Report Items
      • Tables
      • List
      • Image
      • Matrix
      • Chart
      • Guage
      • Indicators
    • SSRS Administration
      • Configuration of Reporting Services
      • Deployment Methods
      • Security in SSRS
      • Subscriptions
      • Windows File Share
      • Email
      • Processing Options
      • Snapshots
      • Caching
      • Working with Shared Schedules
    • Adhoc Reports Development
      • Using Report Builder
      • Report Model Designing
    • SQL Server Analysis Services (SSAS)
      • Need of Analysis Services
      • Multi Dimension Analysis
      • Designing of Cubes
    • Developing CUBES
      • Cube Designer
      • Dimension Usage
      • Aggregations and Partitions
      • Calculations and Kpi’s
      • Actions
      • Perspectives & Translations
      • Write- Back Features
      • Reporting in Excel and SSRS by using Cubes
    • MDX Language
      • Introduction to MDX language
      • Tuple and sets
      • MDX Queries
      • MDX expressions
      • MDX Scripts
      • Built-in Functions
    • Reporting Using Analysis Service
      • Using SSRS with Analysis Services
      • Excel Reports
      • Power View
    • SSAS Administration
      • Deployment
      • Processing
      • Security
      • Backup and Restore
      • With Real Time Scenarios

    Key Benefits:

    • Exposure to real time scenarios.
    • Job oriented training program.
    • Training in an enterprise highly focused in recruitment.
    • Resume Preparation and Interview Tips
    • Q & A
    • Mock Interview.

    Course Curriculum

    Course Reviews

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 2 weeks, 4 days

    Advanced Course Search

    Total It Training Portal © Eazygurus. All rights reserved.