Learn your way! Get started

Microsoft SQL Server BI 2019, Part 4 of 7

with expert Shivprasad Koirala

Watch trailer

Course at a glance

Included in these subscriptions:

Dev & IT Pro Video
Dev & IT Pro Power Pack

	Release date	2/9/2021
	Level	Intermediate
	Runtime	3h 34m
	Closed captioning	N/A
	Transcript	N/A
	eBooks / courseware	N/A
	Hands-on labs	N/A
	Sample code	Included
	Exams	Included

Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

Course description

Microsoft SQL Server BI transforms raw data into information businesses can use to make decisions. This course combines SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services in one course with a project. This course covers: Executing SQL Tasks, Relationships, Script tasks and components, Graphical Reports, Partitions and Additive Measures.

Prerequisites

knowledge of SQL, coding experience and knowledge of Microsoft tools.

Meet the expert

Shiv is a seasoned Corporate Instructor and a Microsoft certified professional with 17 years of working and training experience on various Microsoft technologies like HTML5, CSS3, ASP.NET MVC, SQL Server, MSBI, WPF, VSTS, TFS, Design pattern, UML, BizTalk, SharePoint and Microsoft dynamics. He is ASP.NET MVP for 6 years, speaks at seminars and conducts training.

Course outline

Course Four Part One

Execute SQL Task (29:10)

Introduction (00:08)
Introduction to Execute SQL Task (05:10)
Map Parameters (07:36)
SQL Query (05:17)
Foreach and Execute SQL (10:49)
Summary (00:08)

SSAS: Reference and Many-to-Many Relationships (34:07)

Introduction (00:08)
Regular Relationships (07:00)
Reference Relationship (04:33)
Many-to-Many Relationships (10:44)
Creating Many-to-Many Relationships (11:31)
Summary (00:08)

SSIS: Script Task and Send Mail Task (15:09)

Introduction (00:08)
Introduction to Script Task (01:03)
Send Mail Task (05:33)
Script Task (08:16)
Summary (00:08)

SSIS: Script Component (43:21)

Introduction (00:08)
Introduction to Script Component (04:59)
Edit Script for Source (10:35)
Data Transformation (05:39)
Split Data (05:15)
Script Component as Destination (06:51)
Debugging Script Component (09:43)
Summary (00:08)

Course Four Part Two

SSRS: Graphical Reports (17:58)

Introduction (00:08)
Bar Chart Gauge and Indicators (01:56)
Chart Component (06:42)
Chart Areas (03:22)
Gauges and Indicators (05:41)
Summary (00:08)

SSAS: Partitions (24:32)

Introduction (00:08)
Creating a Partition (06:19)
Partitioning for Efficiency (04:05)
Multiple Partitions (05:01)
Restrict Rows (01:59)
Processing Partitions (06:50)
Summary (00:08)

SSIS: Changed Data Capture (36:02)

Introduction (00:08)
Introduction to CDC (07:19)
CDC Configuration Process (05:04)
CDC Phase 1 (04:25)
CDC Phase 2 (08:06)
Update and Delete Syntax (03:21)
CDC Results (07:28)
Summary (00:08)

SSAS: Additive Measures (14:29)

Introduction (00:08)
Additive Measures (02:54)
Semi-Additive Measures (04:46)
Non-Additive Measures (06:32)
Summary (00:08)