An 11–week in-depth program designed to provide a comprehensive introduction to the Microsoft Business Intelligence platform using Microsoft SQL Server.
The program focuses on teaching data professionals how to use SQL Server 2016 product features and tools to build business intelligence solutions. These features include analysis services, integration services, data mining, reporting services, and Power BI. The tools to develop and manage the solutions are SQL Server Management Studio (SSMS) and SQL Server Data Tools (SSDT). Students learn advanced product knowledge and skills needed to support business users by using the current Microsoft SQL Server business intelligence platform.
Classroom lectures and demonstrations will be complemented by reading, assignments, and hands-on exercises. In addition, students will be provided with a copy of Microsoft SQL Server 2016 for installation on their personal computers. This computer must be running Windows 10 and the student should have administrator privileges.
Topics covered in the program include SQL Server Data Tools (SSDT); SQL server Management Studio (SSMS); SQL Server Integration Services (SSIS) - Data Extraction, Transformation and Loading (ETL); SQL Server Analysis Services (SSAS); Unified Dimensional Modeling - cube and dimensions development; Key Performance Indicators (KPI) and calculations; developing and utilizing different data mining algorithms; SQL Server Reporting Services (SSRS); report management; Power View and PowerPivot; Power BI; designing reports with the Report Builder tool; publishing and accessing reports with SSRS and Microsoft Office; new features of SQL Server 2016 for the business intelligence developer.
For a complete program description,
download the program's brochure.
Dates & Location
Autumn Quarter 2019:
Application Deadline:Late Aug. 2019
Tuition Deadline:Late Aug. 2019
Classes Begin:Week of Sept. 9th (Dates TBA)
Classes End:Week of Nov. 18th (Dates TBA)
On-campus section: Classes meet one evening per week (5:45pm to 9:00pm; weeknight to be announced) at DePaul University's Loop Campus.
hybrid mode will be conducted this quarter. About half of the program content will be delivered by on-campus class meetings; the remaining program content will be delivered via online lectures that the student will be required to view.
Online section: Students may elect to register in an online section of this program. For more information about the online section, click
Autumn Quarter 2019
$2,665.00if registering for the undergraduate-level section (IPD 360)
$3,485.00if registering for the graduate-level section (IPD 460)
Regular DePaul University students are charged the above rates based on their degree program. The tuition fee for this program is not included in the university's tuition package for full-time undergraduate students.
Full payment of tuition must be received before the start of the program. Students who elect to pay tuition using a credit or debit card will be assessed a non-redundable 2.75% convenience fee.
Refund/Cancellation Policy: DePaul reserves the right to cancel any program before that program’s first scheduled meeting, in which case tuition fees (but not convenience fees) will be refunded. The university's refund policy allows a return of 100% of tuition if the student drops the SQL Server Business Intelligence Program within two weeks of the first day of the program (convenience fees will not be refunded).
Each program requires a $40.00 (non-refundable) application fee that can be paid online (via credit card) during the online application process. If you need to pay this fee by check or money order, please make the check or money order payable to DePaul University and send it to:
DePaul University Institute for Professional Development
243 S. Wabash Avenue
Chicago, IL 60604
Textbooks are a separate purchase to be made by students.
Reading materials for certificate programs consist of textbooks and supplementary handouts. Textbook readings are considered preparatory in nature and are typically assigned prior to lectures; supplementary handouts are frequently distributed in class to provide additional information.
There are no required textbooks for this session.
CTA U-Pass Fee: Beginning Autumn Quarter 2016, any IPD certificate program student who enrolls in a full-time course load (8 graduate or 12 undergraduate credit hours) and where at least one course is taught at an on-campus location will be automatically enrolled in the University’s CTA U-Pass program. The CTA U-Pass program provides unlimited rides on CTA transport and it requires that all eligible students participate in the program. The cost of the CTA U-Pass is $105.00 per quarter. Students who meet the eligibility criteria will have this fee added to their student accounts. Students are responsible for this fee regardless of benefit use or card pick-up. Students who are taking courses exclusively online do not qualify for this program. Further information about the U-Pass program is found at
Fees are payable by check made out to DePaul University, or by credit card. Students who elect to pay tuition using a credit or debit card will be assessed a non-redundable 2.75% convenience fee.
Applicants who are eligible for a tuition reimbursement program offered by their employer and are interested in deferring their tuition payment using the university's Employer Tuition Deferral Plan must return the Employer Tuition Deferral Plan application to the Institute for Professional Development Office. Submitting this application to any other DePaul office may delay the student's registration process. Information about this plan, along with an application form, is found
Applicants who wish to use the university's Single Term Payment Plan or a third-party billing arrangement should contact the Institute for Professional Development office at (312) 362-6282 for details.
Applicants should have knowledge of data analysis concepts and tools, of relational database concepts, and of data modeling. In addition, applicants should have basic Microsoft SQL Server skills.
The SQL Server Business Intelligence Program is an accredited course of DePaul University, which follows the quarter system (as opposed to the semester system). Credit hours are awarded to those who successfully complete the program's academic requirements. Academic requirements may include reading and homework assignments, written assignments, labs, projects, and other assignments. No midterm or final exams are conducted.
- Course #: IPD 360; 4 undergraduate credit hours
- Course #: IPD 460; 4 graduate credit hours
Applicants select to register in either IPD 360 (undergraduate level) or IPD 460 (graduate level), unless they are currently degree-seeking students of the university. In that case, they are required to select the level that corresponds with their degree program. Additionally, students interested in enrolling in the graduate section must have completed a bachelor's degree.
IPD 360 and IPD 460 are combined courses, with students attending the same lectures or viewing the same lectures (for those completing the program online). However, students in the graduate section are required to perform additional coursework than those in the undergraduate section.
Once the program begins, a student cannot switch from undergraduate level to graduate level or vice-versa and must remain in the level chosen or withdraw from the program. Please contact the Institute office for advice on which academic level to select.
The ability to apply these credit hours to a degree program is always determined by the college granting the degree. To view course transfer guidelines for DePaul's College of Computing and Digital Media (CDM), click
Application & Registration Procedure
All interested parties should apply for admission using the Institute for Professional Development's
online application; or, to apply via fax, mail, or in person, print out and complete the
Application Form. Upon admission, the Institute office will contact the prospective student with information and instructions about the registration process.
Registration is restricted to admitted students. IPD staff will register students upon receipt of payment and registration form. Regular DePaul students cannot register themselves via the university's registration system.