SQL Server Business Intelligence Overview

تاریخ: 1399/11/07 23:09
توسط: MotoMan
امتیاز: ۰
تعداد بازدید: ۳۰۶۸
دیدگاه ها: ۰
دوره ویدیویی SQL Server Business Intelligence Overview
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

کانال تلگرام سایت

گروه تلگرام سایت

like می پسندم
dislike به درد نمی خوره
مطالب مشابه
دیدگاه ها
  • اولین نفری باشید که نظری می دهید!
loading...

لطفا منتظر بمانید...