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

Autumn Quarter 2020:

The autumn session is now closed.

Meeting Pattern

Online: Sync Section

Days & Times:
Mondays, 5:45pm-9:00pm (Central Time)

These classes take place at a specific time on a specific day, with the instructor and all the students meeting online using a synchronous meeting tool like Zoom. Classes will be recorded, so any student who is not able to join at the specified time will be able to watch the recording of the class. Before selecting this option, please carefully consider your ability to actively participate in video and audio with a reliable internet connection.

What if I cannot make it to every online synchronous class meeting?
Joining the class meetings in real time is highly recommended, but is not required. You can still take this class by viewing the class recordings and keeping pace with the weekly topics and assignments.

Online: Async (Sync-Option) Section

These classes do not meet at a specific time on specific days. This class is paired with a class that takes place at a specific time on a specific day via Zoom (or similar tool). Students in this class may connect with the live classroom and instructor, if and when they are available, but they are not required to do so.

Students will have access to the recordings of the paired synchronous online classroom. They are expected to follow the same weekly agenda of topics and assignments as the class that meets synchronously, but can view the course material at a time of their own choosing.

Fees

Autumn Quarter 2020

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 September 28, 2020 (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.

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.