Data Analytics with Excel

stats 

Data Analytics with Excel and Tableau Program Details

About

An 11-week program covering advanced Microsoft Excel® and Tableau® for statistical modeling and data analytics

Note: As of spring quarter, IPD 239 Data Analytics with Excel Program is replaced with IPD 243 Data Analytics with Excel and Tableau Program.

In our data-centric world, professionals who have the skills to use advanced analytics to help solve business problems and inform decision-making will position themselves ahead of others. DePaul’s Data Analytics with Excel and Tableau Program will teach you to prepare data for analysis, use various data analysis techniques, and present data in a visually-compelling way using two of the most popular tools for business intelligence and data analytics. The program will begin with an introduction to regression, analysis of variance, and probability theory using tools available in Excel followed by working with data and understanding visualizations in Tableau as well as some advanced analytics and integration with other tools. Mathematical and statistical concepts will be covered in a straightforward and practical manner. The program is designed for information technology and business professionals who have basic skills in Excel. No prior Tableau experience is needed.

Program content includes lectures, demos and hands-on exercises. Students are required bring a laptop with current versions of Microsoft Excel and Tableau to every class (either Mac OS or Windows). Students will be instructed to download a copy of the software for educational use, but they must have full administrator rights to their laptop in order to install software.

Students in this program will be able to:

  • Learn the foundations of data analysis like regression analysis and analysis of variance using Excel
  • Comprehend the foundations of probability theory
  • Learn the essentials of Tableau concepts
  • Explore how to work with data in Tableau
  • Learn core visualizations in Tableau and how to use Tableau for presentations
  • Gain competency in some advanced analytics using Tableau

For a complete program description, download the program's brochure.

The terms "Microsoft Excel" and "Tableau" are registered trademarks of their respective owners. The Data Analytics with Excel and Tableau Program at DePaul University is an independent program of study and is not affiliated with, nor has it been authorized, sponsored, or otherwise approved by external entities.

Dates

Spring Quarter 2021:

The spring session is now closed.

Fees

Spring Quarter 2021

Tuition

  • $2,665.00

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 Data Analytics with Excel and Tableau Program by April 14, 2021 (convenience fees will not be refunded).

Notice for Current DePaul Students

  • Undergraduates: Please be aware that the tuition fee for this program is not included in the university’s full-time term package pricing.

Application Fee

  • $40.00non-refundable

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
Room 301
Chicago, IL 60604

Textbooks

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.

Required Textbook
Title: Mastering Tableau 2019.1: An expert guide to implementing advanced business intelligence and analytics with Tableau 2019.1 (2nd edition)
Author: Marleen Meier and David Baldwin
ISBN: 978-1789533880
Publisher: Packt Publishing
List Price: $44.99

Payment Options

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 here .

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.

Financial Assistance

The Institute for Professional Development is pleased to announce a new need-based financial award, the Chou Family IPD Scholarship, to provide funding for students interested in our certificate programs in Spring Quarter 2021. Applications will be accepted through March 12, 2021 for this scholarship.  

Admissions

Admission Requirements

Applicants should have basic Excel skills. No prior experience with Tableau is expected. Basic experience with a personal computer (running either Windows or Mac OS) is assumed.

Course Credit

The Data Analytics with Excel and Tableau Program is catalogued as a non-credit course of DePaul University. A certificate of completion from DePaul University is awarded to those who successfully complete the program's requirements. Program requirements include reading, homework assignments, and projects. No midterm or final exams are conducted.

  • Course #: IPD 243

The Data Analytics with Excel and Tableau Program is a graded course. A final grade letter as well as DePaul transcript (upon request) will be available upon program conclusion.

Application & Registration Procedure

All interested parties should apply for admission using the Institute for Professional Development's online application; or, download and complete the Application Form (PDF) and email to ipd@cdm.depaul.edu. Upon admission, the Institute office will contact the prospective student with registration information and instructions.

You do not have to be an existing DePaul student to take this certificate program. Registration is restricted to individuals who apply for admission to the program and receive an acceptance letter. IPD staff will register applicants upon receipt of payment and registration form.

Regular DePaul students cannot register themselves via the university's registration system. If interested in enrollment, regular DePaul students should begin by submitting an application for admission. Students must meet the program's admission criteria.