Learn your way! Get started

Microsoft SQL Server BI 2019, Part 6 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	Advanced
	Runtime	3h 14m
	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 Tabular model, MDX, Data Mining, Page Splits and Aggregation.

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

SSAS: Tabular Model and PowerPivot (39:32)

Introduction (00:08)
Introduction to Tabular Model (06:15)
Install PowerPivot (05:23)
PowerPivot Views (06:15)
Add PowerPivot Columns (04:25)
Explicit Calculations (06:19)
Multidimensional PowerPivot (10:35)
Summary (00:08)

SSAS: MDX Queries (28:50)

Introduction (00:08)
Introduction to MDX (05:13)
Facts and Dimensions (04:50)
Where Clauses (05:37)
Sorting with MDX (04:56)
Axes (07:54)
Summary (00:08)

SSAS: MDX Continued (23:56)

Introduction (00:08)
Reporting with MDX (05:06)
Select Multiple Facts (05:12)
CurrentMember and PrevMember (04:44)
Functions in MDX Queries (08:37)
Summary (00:08)

Course Six Part Two

Data Mining (28:26)

Introduction (00:08)
Introduction to Data Mining (07:38)
Data Mining Project (04:36)
Data Mining Wizard (04:53)
Data Mining Results (04:56)
Data Mining Views (06:04)
Summary (00:08)

SSIS: Page Splits (24:42)

Introduction (00:08)
SQL Server Pages (04:38)
Page Splits (04:16)
Page Split Issues (06:47)
Page Splits per Second (03:03)
Indexing Without Page Splits (05:40)
Summary (00:08)

SSAS: Aggregation (49:29)

Introduction (00:08)
Introduction to Aggregation (05:19)
Queries Without Aggregations (11:28)
Design an Aggregation (08:16)
Aggregation Usage (07:50)
Queries with Aggregations (05:01)
Workloads and Aggregations (11:16)
Summary (00:08)