MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Server Business Intelligence Overview

Course Summary

This course introduces you to some of the Business Integration tools available in SQL Server, including SSIS, SSRS, and SSAS.


  • +

    Course Syllabus

    ● SQL Server Integration Services
        ◦ Introduction
        ◦ Overview
        ◦ Package
        ◦ Package Example
        ◦ Control Flow
        ◦ Control Flow Example
        ◦ Parallel Control Flow example
        ◦ Loop example
        ◦ Data Flow
        ◦ Data Flow Source
        ◦ Data Flow Source example
        ◦ Data Flow Transform
        ◦ Transform Example
        ◦ Package Deployment
        ◦ Deploy and Run example
        ◦ Summary
    ● SQL Server Reporting Services
        ◦ Introduction
        ◦ What is SSRS?
        ◦ Sample Reports
        ◦ Features
        ◦ Server Components
        ◦ Client Components
        ◦ Report Wizard
        ◦ Control Properties
        ◦ Report Data Window
        ◦ The Toolbox
        ◦ TextBox Controls and Expressions
        ◦ Tables and Grouping
        ◦ Using Parameters
        ◦ Summary
    ● SQL Server Analysis Services
        ◦ Introduction
        ◦ Defining OLTP
        ◦ Defining OLAP
        ◦ The Data Warehouse
        ◦ Star Schema
        ◦ Multi-Dimension Concepts
        ◦ Understanding Dimensions
        ◦ Members, Levels and Hierarchies
        ◦ Measures and Aggregates
        ◦ SQL Server Analysis Services
        ◦ System Roles and Workflow
        ◦ Creating an Analysis Services Project
        ◦ Creating a Data Source
        ◦ Creating a Data Source View
        ◦ Customizing the Data Source View
        ◦ Creating Name Queries
        ◦ Creating the Customer Dimension
        ◦ The Product and Date Dimensions
        ◦ Creating the Cube
        ◦ Deployment and Processing
        ◦ Verifying Deployment
        ◦ Browsing the Cube
        ◦ SSAS Clients
        ◦ Querying from Excel
        ◦ Querying from SSRS
        ◦ Querying with ADOMD.NET
        ◦ SUmmary
    ● SQL Server Integration Services Precedence Constraints
        ◦ SSIS Precedence Constraints
        ◦   14
     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top