SQL Server Business Intelligence Overview
برچسب ها:
SQL |SQL Server |Database |Business Intelligence |Data Mining |Video |
Pluralsight
Scott Allen, Dan Sullivan, Bret Stateham
2010
3h 47m
English
دوره ویدیویی SQL Server Business Intelligence Overview (مروری بر هوش تجاری در SQL Server) موسسه Pluralsight که توسط Scott Allen، Dan Sullivan و Bret Stateham تدریس شده است، تعدادی از ابزارهای Business Integration در دسترس در SQL Server را از جمله (SQL Server Integration Services (SSIS)، SQL Server Reporting Services (SSRS و (SQL Server Analysis Services (SSAS به شما معرفی خواهد کرد.
Table of Contents:
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
می پسندم
به درد نمی خوره
