Learn your way! Get started

Microsoft SQL Server BI 2019, Part 1 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 2h 59m
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: a discussion on BI Fundamentals, Data Conversion and Error Handling, Loops, Variables and Parameters, Packaging and Deployment as well as 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 One Part One

MSBI Fundamentals (25:00)
  • Introduction (00:08)
  • Introduction to BI (05:55)
  • Create MSBI Solution (02:15)
  • Install SQL Server (06:41)
  • SQL Server and Data Tools (04:55)
  • Create Database (04:56)
  • Summary (00:08)
MSBI Fundamentals Continued (27:53)
  • Introduction (00:08)
  • Control and Data Flows (04:25)
  • Using the Data Flow (06:24)
  • Mapping from Database (03:52)
  • Data Conversion (05:51)
  • Transform Data (07:03)
  • Summary (00:08)
SSIS: Data Conversion and Error Handling (31:29)
  • Introduction (00:08)
  • Introduction to Lab 2 (03:18)
  • Functions (05:44)
  • Data Conversion (09:38)
  • Errors (12:31)
  • Summary (00:08)

Course One Part Two

SSIS: Loops, Variables, Parameters, and Debugging (31:46)
  • Introduction (00:08)
  • Introduction to Lab 3 (05:38)
  • Loop (05:51)
  • Connection String (10:24)
  • Deploy Project (09:35)
  • Summary (00:08)
SSIS: Packaging and Deployment (35:23)
  • Introduction (00:08)
  • Packaging (13:06)
  • Deploy (11:49)
  • Create Parameter (10:11)
  • Summary (00:08)
SSIS: Measures, Connection Managers, and Tasks (28:10)
  • Introduction (00:08)
  • Measures and Dimensions (08:30)
  • Dimension Tables (10:44)
  • Load Country Master (08:38)
  • Summary (00:08)