Business Intelligence Essentials

SQL Server Business Intelligence Essentials

Course Code: BIE

Course Duration: 1 Day

Overview

In this one-day hands on course, you are introduced to the Microsoft Business Intelligence suite of software technologies. It is designed to show participants how Microsoft SQL Server 2008 and 2008 R2 can be used to solve different types of business intelligence problems, from data warehousing to real-time operational reporting and analytics.

Participants will learn how to use the SQL Server BI toolset to collect data from heterogeneous data sources and then display the data in a meaningful format to assist in making business decisions and then measure and monitor the results. This course provides an end-to-end overview of the entire SQL Server BI stack from extracting data using Integration Services to building cubes with Analysis Services and then displaying the results using SQL Server Reporting Services.

Book SQL Server Training Course Outline

Who Should Attend

The course is designed for all types of BI users that are looking to expose real-time, powerful Business Intelligence with Microsoft SQL Server including Database Administrators, Developers and Analysts.

Course Objectives

After completing this course, students will be able to:

  • How to design, build, implement and maintain Business Intelligence projects built using SQL Server 2008 or 2008 R2.

Course Prerequisites

Before attending this course, participants should have:

  • An understanding of basic database concepts
  • Working knowledge of the Windows environment
  • An understanding of business fundamentals