DATA ANALYTICS AND VISUALIZATION
Fall/Winter Courses at a Glance:
| Course | Dates |
| Business Analytics with Excel | March 7-14 |
| Tableau I | March 19-28 |
| Tableau II | April 9-18 |
| Tableau III | April 23-May 2 |
| Tableau IV | May 7-16 |
| Visual Basic Applications in Excel | Feb 22-29 |
| Intro to R Programming | Jan 23 – 30 |
| Advanced R Programming | Feb 6 – 20 |
Veterans
If you are a veteran, you may qualify for funding to help pay for this program. If this applies to you, click here to fill out the interest form.
DATA ANALYTICS CERTIFICATE PROGRAM
Prerequisite: A solid foundation in Microsoft Excel.
The CCM ‘Certificate in Data Analytics’ offered through Workforce Development provides participants with data acumen in the areas of data manipulation, visualization and interpretation. To obtain your certificate, you must take all of the following courses:
- Introduction to R Programming
- Advanced R Programming for Data Science
- Business Analytics with Excel
- Visual Basic Applications in Excel
- Tableau I
- Tableau II
INSTRUCTORS:
Kelly Fitzpatrick, MA, CFA, Tableau Desktop Specialist
Weiwen Li, MA
Shehroz Malik, BS
Lorie Pezzutti, BA
Rreze Zejnullahi-Berisha, MA
BUSINESS ANALYTICS WITH EXCEL (CPC-635E)
PREREQUISITE: Proficient/intermediate knowledge of MS Excel.
Learn how data science is applied in business. Explore concepts in correlation, regression analysis, hypothesis testing and multivariate analysis. Learn how correlation helps to understand portfolio diversification and design. ‘What If’ analysis will be covered utilizing the Solver and Goal Seek features of Excel. Students will need to save their work to their local computer or a flash drive.
INSTRUCTOR: CCM Staff
Tues and Thurs, March 7-14, 6:30-8:30 p.m.
Remote-Live
3 sessions: 6 hrs, CEU 0.6
Course: 28874
Cost: $299
VISUAL BASIC APPLICATIONS IN EXCEL (CPC-624E)
PREREQUISITE: Proficient knowledge of MS Excel.
Make your Excel spreadsheets much more powerful. Learn to record macros and about the basics of VB programming. The course will teach you to read, write and debug VB code, how to pass lists and floating variables though VB, to use conditional statements, and create input and message boxes. At the end of this course, you will be familiar with the VBA programming language as it applies to Microsoft Excel and will apply this knowledge to make interactive and fully functional spreadsheets. Students will need to save their work to their local computer or a flash drive.
INSTRUCTOR: Lorie Pezzuti, BA
Tues and Thurs, Feb 22-29, 6:30-8:30 p.m.
Remote-Live
3 sessions: 6 hrs, CEU 0.6
Course: 28873
Cost: $299
INTRODUCTION TO R PROGRAMMING (CPC-631E)
PREREQUISITE: Proficient knowledge of MS Excel.
R’s widespread popularity in today’s data driven business world makes R a must-know data analysis tool in almost every field of business: finance, bioscience, supply chain, sports, retail, marketing, social media, manufacturing and even journalism. R is a software program used to analyze large data sets. Students will complete projects analyzing large data sets related to environmental and business issues. The course will cover exploratory data analysis techniques, visualization methods, modeling and ideas in reproducible research using packages from base R. Students will learn the basic syntax for R and how functions and packages work. Students will need to save their work to their local computer or a flash drive.
INSTRUCTOR: Weiwen Li, MA
Tues and Thurs, Jan 23-30, 2024, 6:30-8:30 p.m.
Remote-live
Course: 28871
3 sessions: 6 hrs, CEU 0.6
Cost: $299
ADVANCED R PROGRAMMING FOR DATA SCIENCE (CPC-603E)
PREREQUISITE: Proficient knowledge of MS Excel and the Introduction to R Programming course or some programming knowledge.
The course will expand on the topics covered in the Introduction to R Programming course. Advanced topics include the use of the Tidyverse and learning the ggplot2, dplyr and tidyr packages. In addition, advanced data science methods such as k-means, clustering and dendrograms will be covered. Students will need to save their work to their local computer or a flash drive.
INSTRUCTOR: Weiwen Li, MA
Tues and Thurs, Feb 6-20, 2024, 6:30-8:30 p.m.
Remote-live
Course: 28872
5 sessions: 10 hrs, CEU 1.0
Cost: $499
DATA VISUALIZATION CERTIFICATE PROGRAM
The CCM ‘Certificate in Data Visualization’ provides participants with an understanding of a visualization tool which presents large amounts of complex data in an easy to understand format. Visual context such as charts and graphs make it easy to identify correlations, patterns, trends or areas needing improvement. By taking all four courses, Tableau I-IV, individuals will obtain a Data Visualization certificate, AND be prepared to take the Tableau Desktop Specialist certification exam.
TABLEAU
Tableau has advanced capability to analyze large datasets easily. Tableau allows users to analyze data using multiple dimensions and creates tables and visualizations ready for the boardroom. Start your journey to the CCM Data Visualization Certificate with Tableau I and take all four classes. Following the CCM courses, if you are interested in demonstrating your mastery of Tableau, there are multiple levels of certification available through Tableau. Visit Tableau-Certifications at Tableau Certified.
An electronic textbook is included with all classes. The course includes a 1-year subscription to Tableau Desktop, an e-textbook from Logical Operations, homework, projects, and practice questions. This course covers all topics for the Tableau Desktop Specialization Exam, an industry credential. Students will need to save their work to their local computer or a flash drive.
*Additional textbook required. Click here for textbook information.
TABLEAU I (CPC-618E)
The first session in CCM’s four-part series introduces Tableau. Learn basic Tableau fundamentals as well as connecting and preparing data, exploring data and managing, sorting and grouping data.
Tues and Thurs, March 19-28, 6:30-8:30 p.m.
Remote-Live
4 sessions: 8 hrs, CEU 0.8
Course: 28875
Cost: $499
TABLEAU III (CPC-632E)
Students will move beyond fundamentals to perform advanced data visualization. Blend data to visualize relationships, join data, access data in PDFs and refine your visualizations with sets and parameters.
Tues and Thurs, April 23-May 2, 6:30-8:30 p.m.
Remote-live
4 sessions: 8 hrs, CEU 0.8
Course: 28877
Cost: $499
TABLEAU II (CPC-619E)
This course picks up where Tableau I leaves off. It includes saving and sharing, filtering data, custom visualizations and creating maps, dashboards and stories.
Tues and Thurs, April 9-18, 6:30-8:30 p.m.
Remote-live
4 sessions: 8 hrs, CEU 0.8
Course: 28876
Cost: $499
TABLEAU IV (CPC-633E)
Complete the CCM Tableau series and earn your Data Visualization Certificate as you conclude with manipulating data with calculations, visualizing data with advanced calculations, performing statistical analysis and forecasting and learning to enrich visualizations, dashboards and maps.
Tues and Thurs, May 7-16, 6:30-8:30 p.m.
Remote-live
4 sessions: 8 hrs, CEU 0.8
Course: 28878
Cost: $499