Data Analytics

For the past four years, Glassdoor.com has rated Data Scientist as the ‘Best Job in America.’ Data science allows companies to make data driven decisions to improve the performance of the organization. Companies are adopting a culture where data drives decisions in marketing, sales, finance and purchasing. Through a progression of courses at CCM, you can earn a Certificate in Data Analytics.

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:

Course CodeCourse TitleCEUs
CPC-603Introduction to R Programming and Data Science1
CPC-629Business Analytics With Excel0.6
CPC-624Visual Basic: Applications in Excel0.6
CPC-625Tableau I0.6
CPC-626Tableau II0.6

Through hands on projects, students will gain a working knowledge of data science and develop a working toolkit of software applications.

To register, go to https://webadvisor.ccm.edu/ and click on "Continuing Education (Non-Credit)." Have your credit card, social security number, and 5-digit Course Code number ready.

Course usage information

Introduction to R Programming and Data Science

Prerequisite: Working knowledge of personal computers. This ten-hour course introduces students to R, a free, open source, statistical 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. 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. High school statistics teachers will benefit from this course as well, by incorporating technology, an element of the common core curriculum. At the completion of this introductory class, students will be able to produce their own R-based report in their own business or school environment. Enrollment is limited to 20. CPC-603.


Course usage information

Business Analytics With Excel

Prerequisite: Proficient/Intermediate knowledge of MS Excel. The Business Analytics course is designed to teach students how data science is applied in business. Students will utilize the Analysis ToolPak built into Excel to explore concepts in correlation, regression analysis and hypothesis testing. Students will learn the theory behind these statistical methods as they master the practical application. Students will explore multivariate analysis and how correlation can help them understand portfolio diversificand design. 'What If' analysis will be covered utilizing the Solver and Go Seek features of Excel. CPC-629.


Course usage information

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.


Course usage information

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


Course usage information

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