Connect with Southern Poly

Facebook link Twitter link YouTube link

Apply to Southern Polytechnic State University

Visit Southern Polytechnic State University

Request information about Southern Polytechnic State University

SPSU Continuing Education Center
1100 South Marietta Parkway
Atrium Building (J)
Room J-354
Marietta, GA 30060
678.915.7240
----------------------------------------
SPSU Testing Center
1100 South Marietta Parkway
Atrium Building (J)
Room J-160
Marietta, GA 30060
678.915.3982

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

  • A tour of SQL Server
  • Designing and creating a database
  • Data selection queries (Transact-SQL)
  • Modifying Data
  • Working with SQL Server Management Studio
  • Transact-SQL programming
  • Creating views
  • Creating stored procedures, triggers and Functions

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

  • Intro to Microsoft SQL Server Reporting Services
  • Installing Reporting Services
  • Creating Basic Reports using Report Wizard
  • Authoring Basic Reports
  • Enhancing Basic Reports with Graphics
  • Creating Advance Reports
  • Publishing & Executing Reports
  • Using Subscriptions and Managing Reports Delivery
  • Using Report Models
  • 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 - May 31 - July 12, 2014  (Sa 9:00AM - 5:00 PM) $1,800

——————————

BI 102: SQL Server Business Intelligence Developer

Implementing and Maintaining SQL Server 2012 Analysis Services

Click here to register 15SB2702 - Sep 6 - Sep 27, 2014 $1,500

——————————-

BI 103: SQL Server Business Intelligence & ETL Developer

Implementing and maintaining SQL Server 2012 Integration Services

Click here to register 15FB2703 - Nov 1 - Nov 22, 2014 $1,500