HomeOn-Demand LearningSQL ServerAdministering Business Intelligence

Administering Business Intelligence


What Will You Learn?

  • Understand what is needed to help debug and maintain the features used in your enterprise IT systems
  • Administering SSIS, SSAS and SSRS
  • Administration of Data Quality and Master Data Services


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.



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.

Curriculum For This Course

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

You may also like…