Administering Business Intelligence

$95.00

What Will You Learn?

  • How to write queries that involve multiple tables and summary queries
  • How to modify data and understand the logical programming aspects of T-SQL

Description

Administration of SQL Server can often be as simple as query tuning a T-SQL statement or configuring a server properly. When a Business Intelligence developer gets a hold of other ‘cool’ features provided in Standard or Enterprise Edition of SQL Server, then the range of knowledge a DBA has needs to keep up with developers. The administrator does not need to know how to develop an integration service (SSIS) package or create a calculated measure in analysis services (SSAS), but it is good to understand what is needed to help debug and maintain the features used in their enterprise IT systems. Most shops do not use all these components, but most do use more than one.

Instructor

THOMAS LEBLANCTHOMAS LEBLANC

BI Consultant and Trainer
Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Warehouse Architect in Baton Rouge, LA. Today, he designs Dimensional Models in the financial industry while using Integration (SSIS) and Analysis Services (SSAS) for development along with Reporting Services (SSRS) and Power BI for reporting. Starting as a developer in COBOL while at LSU, he has been a developer, tester, project manager, and team lead, as well as a software trainer for writing documentation. His involvement in the SQL Server community includes speaking at SQLPASS.org Summits, SQLSaturday events since 2011, IT/Dev Connections and Live! 360. He is the past Chair of the PASS Data Architecture and Excel Business Intelligence Virtual Chapters and worked on the nomination committee for the PASS Board of Directors in 2016 and 2017.

 

What to Know Before the Class

Basic DBA skills that can be obtained by watching our DBA Fundamentals course.


Duration: 9:33:40
Administration of SQL Server can often be as simple as query tuning a T-SQL statement or configuring a server properly. When a Business Intelligence developer gets a hold of other ‘cool’ features provided in Standard or Enterprise Edition of SQL Server, then the range of knowledge a DBA has needs to keep up with developers. The Administrator does not need to know how to develop an integration Service (SSIS) package or create a calculated measure in Analysis services (SSAS), but it is good to understand what is needed to help debug and maintain the features used in their enterprise IT systems. Most shops do not use all these components, but most do use more than one.
Administering Business Intelligence - What you need to get started
Module 01 - Class Introduction
22:10
Module 02A - Installation and Configuration (Installation)
48:27
Module 02B - Installation and Configuration (Service Configuration)
15:08
Module 02C - Installation and Configuration (SSRS, DQS, and MDS Configuration)
32:58
Module 03A - Administering SSIS (Introduction to SSIS)
12:13
Module 03B - Administering SSIS (SSIS Catalog)
13:43
Module 03C - Administering SSIS (Catalog Configuration)
08:49
Module 03D - Administering SSIS (Executing a Package - SQL Server Agent)
21:28
Module 03E - Administering SSIS (Executing a Package - T-SQL)
10:14
Module 03F - Administering SSIS (Executing a Package - Other Execution Options)
04:13
Module 03G - Administering SSIS (Environments)
07:46
Module 03H - Administering SSIS (Best Practices)
07:10
Module 03I - Administering SSIS (Security)
03:24
Module 03J - Administering SSIS (Monitoring)
07:28
Module 04A - Data Quality Services (Introduction)
20:10
Module 04B - Data Quality Services (Administration)
20:50
Module 05A - Master Data Services (Overview)
24:34
Module 05B - Master Data Services (Administrative Tasks)
31:01
Module 06A - Administering SSAS (Introduction to SSAS)
17:01
Module 06B - Administering SSAS (SSAS Design Basics)
18:22
Module 06C - Administering SSAS (Projects and Databases)
17:12
Module 06D - Administering SSAS (Real Time Analytics)
09:50
Module 06E - Administering SSAS (Partitions)
14:57
Module 06F - Administering SSAS (Processing Data)
21:30
Module 06G - Administering SSAS (Configuration)
14:56
Module 06H - Administering SSAS (Maintenance)
12:57
Module 06I - Administering SSAS (Monitoring)
23:09
Module 06J - Administering SSAS (Security)
08:30
Module 07A - Administering SSRS (Overview)
16:05
Module 07B - Administering SSRS (Configuration Manager)
12:05
Module 07C- Administering SSRS (Reporting Services Tools)
16:00
Module 07D - Administering SSRS (Deployment)
11:20
Module 07E - Administering SSRS (Data Sources)
12:42
Module 07F - Administering SSRS (Security)
09:35
Module 07G - Administering SSRS (Administrative Tasks)
17:08
Module 07H - Administering SSRS (Subscriptions and Power BI Integration)
08:35
Class Survey

System Requirements

Your computer should meet the following minimum requirements: https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server