Learn your way! Get started

Microsoft SQL Server BI 2019, Part 3 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	Beginner
	Runtime	3h 23m
	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: Reporting, Matrix Tabular Parameters, Data Profiling, Hierarchical Dimensions, Drill downs and Sub reports, KPIS as well as Pivot, Aggregation and Calculations.

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 Three Part One

SSRS: Simple Reporting (29:52)

Introduction (00:08)
Introduction to Reporting (08:31)
Customer Report (05:42)
Sorting (05:44)
Build Dropdown (04:39)
Connect Dropdown Data Sets (04:58)
Summary (00:08)

SSRS: Matrix Tabular Parameters (30:07)

Introduction (00:08)
Expressions and Table Properties (05:23)
Matrix Reports (08:50)
Report Sorting (03:15)
SQL Dropdowns (12:21)
Summary (00:08)

SSIS: Data Profiling (20:05)

Introduction (00:08)
Introduction to Data Profiling (06:14)
Data profile Destination (04:57)
Format Output (08:38)
Summary (00:08)

SSAS: Hierarchical Dimensions (24:51)

Introduction (00:08)
Introduction to Hierarchical Dimensions (03:51)
Hierachy (06:14)
Query input to Cube (01:53)
Create Hierarchical Dimension (07:18)
Hierarchical Dimension in Action (05:17)
Summary (00:08)

Course Three Part Two

SSIS: Web Services and XML Tasks (16:24)

Introduction (00:08)
Introduction to Web Services (02:38)
WCF Test Client (04:01)
WSDL (03:49)
Result (05:38)
Summary (00:08)

SSRS: Drilldowns and Subreports (19:12)

Introduction (00:08)
Drilldown reports (03:42)
Add Row Group (07:26)
Group By (07:47)
Summary (00:08)

SSAS: KPIs (13:24)

Introduction (00:08)
KPIs (03:47)
Status Indicator (02:14)
Trend (03:14)
Color Coding (03:52)
Summary (00:08)

SSIS: Pivot, Unpivot, and Aggregation (18:22)

Introduction (00:08)
Pivoting (02:25)
Pivot Key (04:40)
Sort Transformation (03:20)
Aggregation Transformation (07:40)
Summary (00:08)

SSAS: Calculations (31:06)

Introduction (00:08)
Introduction to Calculations (13:05)
Calculator Member (08:49)
Visibility to False (07:58)
Measure vs. Calculation (00:57)
Summary (00:08)