MS-Data Tools (formerly BIDS) has 3 parts: 1. SSIS,
2. SSAS, and 3. SSRS
MS-BIDS Overview
(15 minutes) -
By Craig
Utley at
LearnMicrosoftBI.com
1. SSIS (SQL Server Integration Services) - MS ETL Tool
SSIS - Part 1 (5 minutes)
SSIS - Part 2 (4.5 minutes)
SSIS - Part 3 (5 minutes)
SSIS
- Part 4 (5 minutes)
2. SSAS (SQL Server
Analysis Services) - MS OLAP Tool
SSAS - Part 1 (3.5 minutes) SSAS - Part 2
(2.25 minutes)
SSAS - Part 3
(2 minutes)
SSAS - Part 4
(2 minutes)
3. SSRS (SQL Server Reporting Services) - MS Reporting/Dashboard
Tool
SSRS - Part 1 (6 minutes)
SSRS - Part 2 (3.5
minutes)
SSRS - Part 3
(4.5
minutes)
SSRS - Part
4
(3
minutes)
SSRS - Part 5
(4
minutes)
SSRS - Part 6
(3
minutes)
MS-Power BI
(In-Memory Reporting/Dashboard Tool)
Get Started |
Create Visualization |
Publish to BI Service |
Publish to Web
Connecting to MS-SQL Server Data Sources (Detailed
Documentation)
Connect to a Remote Cube
Connect to a Data Warehouse
Connect to Tables in SSIS
Connect to Sources in Power BI