A Faster Track to Careers in Demanding Industries

Business Intelligence

You will learn how to equip your organization for informed, timely decision making using the expert tips and best practices. This course explains how to effectively develop, customize, and distribute meaningful information to users enterprise-wide. Learn how to build data marts and create BI Semantic Models.

BI 101: SQL Server Reports Developer

This course will cover the following topics: 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

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

You, as a graduate of this program, could apply for entry level jobs requiring BI reporting knowledge. You could also proceed to the following more specialized programs:

Prerequisite: A two- or four-year degree, or 2 years of professional work experience.

Tuition: $2,195 Date: January 27, 2016 (Saturdays 8:30 AM-5:00 PM) for six weeks

BI 201: SQL Server Business Intelligence Developer

This course will cover the following topics:
  • Introduction to Data Warehousing and Business Intelligence
  • Accessing Source Data and Building your First Cube using template
  • Designing and Creating Dimensions
  • Designing and Creating a Cube
  • Designing Advanced Measure Groups and Calculations
  • Advanced Dimension Design
  • Working with Account Intelligence
  • Currency Conversion with Multiple Languages
  • Interacting with Cubes
  • Retrieving Data from Analysis Services using SSRS and Excel
  • Implementing Security
  • Designing Aggregations & Hierarchies
  • Managing Partitions & Database Processing
  • Managing Deployment
  • Advanced Monitoring and Management Tools
  • Data Mining using SQL Server 2008
Prerequisite: BI 101: SQL Server Reports Developer Tuition: $1,500 Date: Spring 2016 (Saturdays 8:30 AM-5:00 PM) for four weeks

BI 301: SQL Server Business Intelligence & ETL Developer

This course will cover the following topics:
    • Introduction to SQL Server 2008 Integration Services
    • Developing Integration Services Solutions
    • Implementing Control Flow
    • Implementing Data Flow
    • Implementing Logging
    • Debugging and Error Handling
    • Implementing Checkpoints and Transactions
    • Deploying Packages
    • Managing and Securing Packages
Prerequisite: BI 101: SQL Server Reports Developer Tuition: $1,500 Date: Summer 2016 (Saturdays 8:30 AM-5:00 PM) for four weeks