Continuing Education Center

» SPSU Home / Continuing Education Center / Courses / Business Intelligence and Analytics

Business Intelligence and Analytics

Course Description:

This is a prerequisite for any other BI course.  You are NOT required to take this course if you have already worked SQL Server and know T-SQL.

Contents BI 101:SQL 101—Introduction to SQL Server

    1. A tour of SQL Server
    2. Designing and creating a database
    3. Data selection queries (Transact-SQL)
    4. Modifying Data
    5. Working with SQL Server Management Studio
    6. Transact-SQL programming
    7. Creating views
    8. Creating stored procedures, triggers and Functions

BIRS-1 - Implement & Maintaining SQL Server 2012 Reporting Services

    1. Intro to Microsoft SQL Server Reporting Services
    2. Installing Reporting Services
    3. Creating Basic Reports using Report Wizard
    4. Authoring Basic Reports
    5. Enhancing Basic Reports with Graphics
    6. Creating Advance Reports
    7. Publishing & Executing Reports
    8. Using Subscriptions and Managing Reports Delivery
    9. Using Report Models
    10. Customizing Reporting Services

 ----------------------------------------------------------------------------------

BI Tracks

BI 101: SQL Server Reports Developer—This includes the following courses:

SQL 101—Introduction to SQL Server
BIRS-1—Implementing and Maintaining SQL Server 2012 Reporting Services

Click here to register 14SB2701 - Jun 14 - Jul 26, 2014 (Sa 9:00AM - 5:00 PM) $1,800

Click here to register 15FB2702 - Sep 13 - Oct 25, 2014 (Sa 9:00AM - 5:00 PM) $1,800

Click here to register 15FB2703 - Nov 1 - Dec 13, 2014 (Sa 9:00AM - 5:00 PM) $1,800

——————————

BI 102: SQL Server Business Intelligence Developer (32 hours) $1,500

Implementing and Maintaining SQL Server 2012 Analysis Services - Call for dates

——————————-

BI 103: SQL Server Business Intelligence & ETL Developer (32 hours) $1,500

Implementing and maintaining SQL Server 2012 Integration Services - Call for dates

                                                                                                                                                                                                                                                                                                                                         

SPSU Continuing Education Center 
1100 South Marietta Parkway
Atrium Building (J)
Room J-211 (unless otherwise posted)
Marietta, GA 30060
678.915.7240

 ©