O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing Business Intelligence with SQL Server 2019

Video Description

A one-stop guide to help database developers build Business Intelligence applications from scratch!

About This Video

  • Understand basic Data Warehousing, OLTP, and OLAP.
  • Use SSDT (SQL Server Data Tools) to develop SSIS packages and design reports.
  • Learn about SSIS, SSAS, and SSRS architectures and their components.

In Detail

In the course, you will cover topics including Business Intelligence fundamentals, data warehousing and ETL, data governance, data visualization, Power BI, data mining, SSAS, SSIS, and Azure Data Analysis Services, with each covering a section of the Microsoft BI with SQL Server 2017. You will get more hands-on with reporting and making sense out of your business intelligence data with SQL Server.

The course will not only help you implement BI Data warehousing solutions, but will also enable you to provide data solutions with SQL Server Integration Services covering Enterprise Suite for data governance, improving data quality, and master data management. By the end of this course, you will be confident enough to create your own Microsoft BI solutions with components such as SSIS for ETL, SQL Server for Data Warehouse, SSAS for OLAP modeling and data mining, and SSRS for reporting.

The course will not only help you in implementing BI; Data warehousing solutions, but will also enable you to provide data solutions with SQL Server Integration Services covering Enterprise suit for data governance, improving data quality, and master data management. By the end of this course, you will be able confident in creating your own Microsoft BI solutions with components such as SSIS for ETL, SQL Server for Data Warehouse, SSAS for OLAP modeling and data mining, and SSRS for reporting.

Downloading the example code for this course: You can download the example code files for all Packt video courses you have purchased from your account at http://www.PacktPub.com. If you purchased this course elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.

Table of Contents

  1. Chapter 1 : Setup and Installation of SQL Server Environment
    1. The Course Overview 00:01:47
    2. Preparing Your Computer for SQL Server 00:04:28
    3. Step by Step Procedure on Properly Installing SQL Server 00:06:33
    4. Setting Up Your Report Server for SQL Server Reporting Services 00:08:14
    5. Installation of SSDT 00:02:56
  2. Chapter 2 : Get Familiarized and Create SSIS
    1. SSIS Introduction 00:08:36
    2. Familiarization of SSIS Environment 00:14:12
  3. Chapter 3 : Implement and Execute SSIS
    1. How to Implement the Use of Control Flow and Looping 00:12:44
    2. How to Implement Data Flow and Data Flow Transform 00:11:23
    3. How to Implement Functions 00:06:32
    4. How to Execute SSIS Package with SQL Server Agent 00:10:25
  4. Chapter 4 : Get Familiarized and Create SSAS
    1. SSAS Introduction 00:09:30
    2. MDX 00:02:22
  5. Chapter 5 : Implement and Execute SSAS
    1. Calculations, Dimension, and Cube Designs 00:26:50
    2. Perspective, Actions and Security Implementation 00:07:55
  6. Chapter 6 : Get Familiarized and Create SSRS
    1. Planning a Report and Design Tips(Data Source, Data Sets and Report) 00:09:30
    2. Creating a Basic Report with Header, Footer, Matrix, Charts, and Data Bars 00:13:18
    3. Creating a Basic Report with Gauge, Indicators, and Maps 00:10:38
    4. Creating Sub Reports with Report Parameters 00:16:40
  7. Chapter 7 : Implement and Execute SSRS
    1. Implementation of Custom Code and Calculated Fields 00:10:05
    2. Implementation of Drilldown Matrix Reports and Lookup 00:13:32
    3. Executing Report using Report Manager to Deploy Reports Using BIDS and Subscriptions 00:15:29