Data Analytics COA

The data analytics and certificate enables both students looking to transfer and existing working professionals the ability to enhance their skills with state of the art training in the rapidly evolving information technology areas of data analytics (the analysis and presentation of data) and database (collection organization of data). The certificate core requirements introduce students to the critical evolving data technologies, including relational databases, SQL (universal standard language for communicating to relational databases), data visualization, data modeling, data warehousing, database reporting using Tableau, big data, NoSQL, cloud, and business intelligence using Microsoft Power BI and Excel.

10-20

Upon completion of the Certificate Students will be able:

1.     Identify basics of data management and manipulation including SQL, Cloud Storage Services, Relational Database Vendors and Relational Database Interfaces.

2.     Perform various Data Analytics skills, of analyzing, manipulating, and reporting data.

Develop data visualizations for business decision making using applications like Tableau and Power BI.

Students will be awarded a Certificate of Achievement upon completion of the required coursework listed.

Course Number	Title	Units
Required
CIMA105	Microsoft Excel for Data Analytics	3
CIMA288	Database Reporting	3.5
CIMW105	Web Development and DB: Intro SQL and MySQL	3
CIMP7A or CIMP8A	Business Programming – Java -- Beginning or Programming with Python	3
Restrictive Electives
CIM1 or CIM10 or CIM112	Computer Information Systems or Introduction to Information Systems or Microsoft Office	4 or 3 or 3
CIMA 104	Spreadsheets - Excel	3
CIMA 204	Advance Spreadsheets - Excel	3
CIMA 106	Database - Access	3
CIMP7A or CIMP8A	Business Programming – Java -- Beginning or Programming with Python	3
CIMP608 (CiMP8B)	Advanced Python Programming	3
CIMP241	Cloud Competing for Developers	3.5

Computer Information Management

All OC colleges

40