DATA ANALYTICS AND VISUALIZATION

Our online classes are taught LIVE by an instructor. Students will need access to a computer and to the Internet. A desktop or laptop computer is preferred, but tablets and smartphones are also an option. CCM will provide access to any specialized software needed for the course.

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. Classes may be taken in any order, but the recommended sequence is:

  • Introduction to R Programming
  • Advanced R Programming for Data Science
  • Business Analytics with Excel
  • Visual Basic Applications in Excel
  • Tableau I
  • Tableau II

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, individuals will be prepared to take the Tableau Desktop Specialist certification exam. To obtain your Data Visualization certificate, you must take all of the following courses:

  • Tableau I
  • Tableau II
  • Tableau III
  • Tableau IV


INTRODUCTION TO R PROGRAMMING

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, bio science, 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.  Enrollment is limited to 20. CPC-631.

INSTRUCTOR: Kelly Fitzpatrick, MA, CFA, Tableau Desktop Specialist

3 sessions: 6 hours,  0.6 CEU

Time: 6:30-8:30 p.m., Tues and Thurs, Aug 13, 18, 20

or

88871.  2 sessions: 6 hours,  0.6 CEU

Time: 9:00 a.m.-12:00 p.m., Sat, Oct 3-10

Cost: $299

ADVANCED R PROGRAMMING FOR DATA SCIENCE

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. Also, 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. Enrollment is limited to 20. CPC-603

Instructor: Kelly Fitzpatrick, MA, CFA, Tableau Desktop Specialist

88872.  5 Sessions: 10 hours, CEU 1.0
Time: 6:30-8:30 p.m., Tues, Nov 10-Dec 8
Cost: $499


BUSINESS ANALYTICS WITH EXCEL

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 Go Seek features of Excel. Students will need to save their work to their local computer or a flash drive. CPC-635

Instructor: Rreze Zejnullahi-Berisha, MA

88873.  4 Sessions: 8 hours, CEU 0.8
Time: 6:30-8:30 p.m., Mon, Oct 5-26
Cost: $299


VISUAL BASIC APPLICATIONS IN EXCEL

PREREQUISITE: Proficient knowledge of MS Excel.

You will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. This course starts you out with learning how to record macros and the basics of VB programming. The course will teach you to read, write and debug VB code. You will also learn how to pass lists and floating variables though VB. The course will teach you to use conditional statements, 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. You will be able to apply this knowledge to make interactive and fully functional spreadsheets. CPC-624

INSTRUCTOR: Kelly Fitzpatrick, MA, CFA, Tableau Desktop Specialist

88874.  3 sessions: 6 hours, CEU 0.6
Time: 6:30-8:30 p.m., Tues and Thurs, Dec 10-17

Instructor will contact students with instructions for connecting online.

Cost: $299

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. Search https://tinyurl.com/Tableau-Certifications. Electronic textbook included with all classes.

The course includes: a 1-year student 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.

TABLEAU I 

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.  CPC-618

Instructor: Kelly Fitzpatrick, MA, CFA, Tableau Desktop Specialist

88875.  4 Sessions: 8 hours, CEU 0.8
Time: 6:30-8:30 p.m., Tues and Thurs, Sept 8-17

or

Instructor: Rreze Zejnullahi-Berisha, MA

88881.  3 Sessions: 8 hours, CEU 0.8
Time: 9-11:45 a.m., Mon, Wed and Fri, Nov 16-20

Cost: $499

TABLEAU II 

This course picks up where Tableau I leaves off, and includes saving and sharing, filtering data, custom visualizations and creating maps, dashboards and stories. CPC-619

Instructor: Kelly Fitzpatrick, MA, CFA, Tableau Desktop Specialist

88876.  4 Sessions: 8 hours, CEU 0.8
Time: 6:30-8:30 p.m., Tues and Thurs, Sept 22-Oct 1

or

Instructor: Rreze Zejnullahi-Berisha, MA

88882.  3 Sessions: 8 hours, CEU 0.8
Time: 9-11:45 a.m., Mon, Wed and Fri, Nov 30-Dec 4

Cost: $499


TABLEAU III 

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. CPC-632

Instructor: Kelly Fitzpatrick, MA, CFA, Tableau Desktop Specialist

88877. 4 Sessions: 8 hours, CEU 0.8
Time: 6:30-8:30 p.m., Tues and Thurs, Oct 6-15

or

Instructor: Rreze Zejnullahi-Berisha, MA

88883.  3 Sessions: 8 hours, CEU 0.8
Time: 9-11:45 a.m., Mon, Wed and Fri, Dec 7-11

Cost: $499

TABLEAU IV

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. CPC-633

Instructor: Kelly Fitzpatrick, MA, CFA, Tableau Desktop Specialist

88878.  4 Sessions: 8 hours, CEU 0.8
Time: 6:30-8:30 p.m., Tues and Thurs, Oct 20-29

or

Instructor: Rreze Zejnullahi-Berisha, MA

88884.  3 Sessions: 8 hours, CEU 0.8
Time: 9-11:45 a.m., Mon, Wed and Fri, Dec 14-18

Cost: $499