DWH ETL /
MSBI

MSBI

MSBI Online Training

What is MSBI

During this Microsoft Business Intelligence [MSBI] online training, you’ll dive into planning ETL solution architecture exploitation Microsoft SQL Server Integration Services and Implementing and Maintaining Microsoft SQL ServerIntegration Services[SSIS].
Additionally, we are going to extensively cover a way to design Analysis solution design exploitation Microsoft SQL ServerAnalysis Services [SSAS] and Implement and Maintain Microsoft SQL Server Analysis Services [SSAS].
You’ll expand your data on MDX Queries and learn the way to make advanced reports using expressions, global collections, and conditional data formatting using SQL Server Reporting Services [SSRS]

Who is Eligible:

Any Graduates/Post Graduates are eligible.
Anyone having knowledge in Data Warehousing technologies.
Any technical background consultants are eligible to learn MSBI Online Training.

  • 1

    Core concept BI is the cube or UDM

    20:56
  • 2

    Example cube as seen using Excel pivot table

    20:56
  • 3

    MS BI is comprehensive more than Analysis Services on SQL Server

    20:56
  • 1

    Demonstration of SQL Reporting Services with cube as data source

    20:56
  • 1

    Modeling source schemasstars and snowflakes

    20:56
  • 2

    Understanding dimensional modeling Dimensions (Type 1, 2, or 3) or rapidly
    changing

    20:56
  • 3

    Understanding fact (measures) and cube modeling

    20:56
  • 4

    Other types of modelingdata mining etc

    20:56
  • 2

    Understanding the development environment

    20:56
  • 3

    Creating Data Sources and Data Source Views

    20:56
  • 4

    Creating cubes using the UDM and the Cube Build Wizard

    20:56
  • 4

    Refining Dimensions and Measures in BIDS

    20:56
  • 3

    Translations cube metadata and currency localization

    20:56
  • 4

    Actions regular, drill-through and reporting

    20:56
  • 1

    Using multiple fact tables

    20:56
  • 2

    Modeling intermediate fact tables

    20:56
  • 3

    Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing
    dimensions, writeback dimensions

    20:56
  • 4

    Modeling changing dimensions Dimension Intelligence w/ Wizard

    20:56
  • 5

    Using the Add Business Intelligence Wizards write-back, semi-additive
    measures, time intelligence, account intelligence

    20:56
  • 1

    Storage topics basic aggregations, MOLAP

    20:56
  • 2

    Advanced Storage Design MOLAP, ROLAP, HOLAP

    20:56
  • 3

    Partitions relational and Analysis Services partitions

    20:56
  • 4

    Customizing Aggregation Design Processing Design

    20:56
  • 5

    Rapidly changing dimensions / ROLAP dimensions

    20:56
  • 6

    Welcome to the Real Time Proactive Caching

    20:56
  • 1

    Cube processing options

    20:56
  • 2

    Using the MDX query editor in SQL Server Management Studio

    20:56
  • 3

    Most-used Functions & Common tasks

    20:56
  • 4

    New MDX functions

    20:56
  • 1

    Adding calculated members

    20:56
  • 3

    Adding named sets

    20:56
  • 4

    .NET Assemblies

    20:56
  • 1

    Best practices health monitoring

    20:56
  • 2

    XMLA scripting (SQL Mgmt Studio)

    20:56
  • 3

    Other Documentation methods

    20:56
  • 4

    Security roles and permissions

    20:56
  • 5

    Disaster Recovery backup / restore

    20:56
  • 6

    Clustering high availability

    20:56
  • 2

    Examples of using each of the 9 algorithms (MS Clustering, MS Decision Trees,
    Nave Bayes, MS Sequence Clustering, MS Time Series, MS Association
    Rules, MS Neural Network)

    20:56
  • 3

    Data Mining dimensions

    20:56
  • 4

    Data Mining clients

    20:56
  • 5

    Processing mining models

    20:56
  • 1

    Excel 2003 Pivot Tables

    20:56
  • 2

    SQL RS & Report Builder

    20:56
  • 3

    SPS RS web parts & .NET 2.0 report viewer controls

    20:56
  • 4

    Business Scorecards 2005 & ProClarity

    20:56
  • 1

    SharePoint 12 and AS

    20:56
  • 2

    Report Center (type of dashboard) uses KPIs, Reports, Excel Web, Filter

    20:56
  • 3

    Excel Services 12 and AS (Web Services)

    20:56
  • 1

    Understanding SSIS

    20:56
  • 2

    Exploring and Executing an SSIS Package in BIDS

    20:56
  • 3

    Exploring and Executing a Package in BIDS

    20:56
  • 1

    Overview of Control Flow in SSIS

    20:56
  • 2

    Control Flow Tasks

    20:56
  • 4

    Other SQL Operations Tasks

    20:56
  • 5

    Precedence Constraints

    20:56
  • 6

    Data Processing Tasks

    20:56
  • 1

    Data Flow Overview

    20:56
  • 2

    Data Flow Pipeline

    20:56
  • 3

    Data Flow Sources

    20:56
  • 4

    Data Flow Destinations

    20:56
  • 6

    Data Flow Transformations

    20:56
  • 1

    Understanding Variables

    20:56
  • 2

    Using Variables in Control Flow

    20:56
  • 3

    Using Variables in Data Flow

    20:56
  • 4

    Understanding Property Expressions

    20:56
  • 5

    Understanding Configurations

    20:56
  • 6

    User Configurations

    20:56
  • 6

    Using Variables and Configurations between Packages

    20:56
  • 1

    Advanced Control Flow Overview

    20:56
  • 2

    Using Containers

    20:56
  • 3

    Transactions Support in SSIS

    20:56
  • 4

    Additional Control Flow Tasks

    20:56
  • 1

    Overview of Deploying Packages

    20:56
  • 2

    Deployment Challenges

    20:56
  • 3

    Create a Package Deployment Utility

    20:56
  • 4

    The Package Installation Wizard

    20:56
  • 5

    Deploy a Package to the File System

    20:56
  • 6

    Deploy a Package to SQL Server

    20:56
  • 6

    Redeploying Updated Packages

    20:56
  • 1

    Overview of Package Management

    20:56
  • 2

    Managing packages with DTUtil

    20:56
  • 3

    Managing packages with SQL Server Management Studio

    20:56
  • 4

    Executing Packages

    20:56
  • 5

    Scheduling packages with SQL Server Agent

    20:56
  • 1

    Extending SSIS Capabilities Through Code

    20:56
  • 2

    The SSIS scripting

    20:56
  • 3

    Scripting in Control Flows

    20:56
  • 4

    Scripting in Data Flows

    20:56
  • 5

    Custom SSIS Components

    20:56
  • 1

    Best Practices for Using SSIS

    20:56
  • 2

    Best Practices for Package Design

    20:56
  • 3

    Data Flow Best Practices

    20:56
  • 1

    Using SSIS Beyond ETL

    20:56
  • 2

    Migrating SQL Servers with SSIS

    20:56
  • 3

    SQL Server Maintenance Plans

    20:56
  • 4

    Working with Analysis Services

    20:56
  • 5

    Folder and File Management

    20:56
  • 6

    Working with Windows Event Log

    20:56
  • 1

    Investigate what SQL Server Reporting Services can do

    20:56
  • 2

    Explore the basic architecture of SQL Server Reporting Services

    20:56
  • 3

    Gain a basic understanding of the components behind SQL Server Reporting
    Services

    20:56
  • 4

    Learn how to create a basic report using the SQL Server Reporting Services
    Wizard

    20:56
  • 1

    Learn how to create a tabular report from scratch

    20:56
  • 2

    Learn about datasets and data regions

    20:56
  • 3

    Discover how to add textboxes and other controls to reports

    20:56
  • 4

    Investigate the list data region

    20:56
  • 5

    Learn how to work with rich text to produce mail merge style reports

    20:56
  • 1

    Explore how to create expressions in your reports using

    20:56
  • 2

    Learn how to create custom functions using the Code window

    20:56
  • 3

    Discover the various global collections that you can reference in your
    expressions

    20:56
  • 4

    Learn how to format report items using the formatting toolbars, the Properties
    window, and the Textbox Properties dialog box

    20:56
  • 5

    Find out how you can use conditional formatting to make your reports more
    dynamic

    20:56
  • 6

    Learn about report variables and when you might need to use them

    20:56
  • 1

    Explore creating groups

    20:56
  • 2

    Master the Reporting Services Grouping pane

    20:56
  • 3

    Learn how to calculate group totals and percentages

    20:56
  • 4

    Understand scope as it applies to aggregate functions

    20:56
  • 5

    Discover interactive sorting

    20:56
  • 6

    Find out how to create drill-down reports

    20:56
  • 1

    Understanding how Reporting Services parameters work with stored procedure
    parameters

    20:56
  • 2

    Learn how to create parameters in ad-hoc SQL

    20:56
  • 3

    Find out how to display parameter values in report headers

    20:56
  • 4

    Discover how to improve parameter prompts using drop-down list parameters

    20:56
  • 5

    Dig into the use of unbound, multivalued, and cascading parameters

    20:56
  • 6

    Learn how to solve common parameter issues

    20:56
  • 1

    Learn how to create matrix reports

    20:56
  • 2

    Investigate Reporting Services charts

    20:56
  • 3

    Explore the use of Reporting Services gauges

    20:56
  • 1

    Understand how to plan and configure for deployment

    20:56
  • 2

    Learn how to deploy Reporting Services projects and individual reports and data
    sources

    20:56
  • 3

    Explore exporting reports to a variety of formats and using the client-side
    printing feature of Reporting Services

    20:56
  • 4

    Investigate how to manage Reporting Services projects using Report Manager

    20:56
  • 5

    Explore creating linked reports

    20:56
  • 1

    Investigate how Reporting Services secures access to reports and other
    Reporting Services resources

    20:56
  • 2

    Find out how to use Report Manager to manage user accounts and roles

    20:56
  • 3

    Learn how to enable basic authentication for reports and how to require
    SSL for report operations

    20:56
  • 4

    Explore the storing of credentials within a data s

    20:56
  • 1

    Discover the many application programming interfaces of Reporting Services

    20:56
  • 2

    Learn how to use URL to integrate Reporting Services reports into your
    applications

    20:56
  • 3

    Explore the use of the Report Viewer controls to create Web pages and
    Windows Forms that render Reporting Services reports in place

    20:56
  • 4

    Investigate how to use the Report Views controls in local mode to display
    reports that don't involve Reporting Servicesource

    20:56
  • 1

    Discover the classes and methods exposed by the Reporting Services Web
    Service API

    20:56
  • 2

    Learn how to call the Report Server Web Service

    20:56
  • 3

    Investigate how to call a custom assembly from a report

    20:56
  • 4

    Explore the potential deployment and security issues that might arise when
    working with custom assemblies

    20:56
  • 1

    Learn how to enable and control report caching

    20:56
  • 2

    Investigate the scheduling of report snapshots

    20:56
  • 3

    Explore the maintenance of report history

    20:56
  • 4

    Discover how to create standard report subscriptions

    20:56
  • 5

    Learn how to create data-driven report subscriptions

    20:56
  • 1

    Learn the differences between Report Builder 1.0 and Report Builder 2.0

    20:56
  • 2

    Explore how to use Report Builder to build ad-hoc tabular, matrix
    and chart reports

    20:56
  • 3

    Discover how to create Report Builder reports without using the wizards

    20:56
  • 4

    Learn how to create Report Model projects using Visual Studio and deploy
    them to a Reporting Services server

    20:56
N/A