Data Analytics Graduate Certificate

A hands-on data analytics course for structured data using SAS Enterprise Miner. Covers the skills that are required to assemble analysis flow diagrams using the rich tool set of SAS Enterprise Miner for both pattern discovery (segmentation, association, and sequence analyses) and predictive modeling (decision tree, regression, and neural network models). Course includes defining a SAS Enterprise Miner project and explore data graphically, modifying data for better analysis results, building, and understanding predictive models such as decision trees and regression models, comparing and explaining complex models, generating, and using score code, applying association and sequence discovery to transaction data. Upon completion, students will have a set of practical data analytics skills and know how to apply these skills in a variety of business environment and with many types of structured data.

Practical survey course covering database and data warehouse fundamentals. Emphasizes SQL (simple and complex queries), the Extract-Transformation-Load (ETL) process, relational versus non-relational databases (and why relational databases can be a problem for analysis), an exploration of different database systems (Oracle, Microsoft SQL Server, etc.), data warehousing concepts, normalization/de-normalization, and cloud data warehousing. Course provides practical skills for database querying and allows provides a foundational knowledge of database concepts so that students can work better with the database administration staff.

A hands-on course emphasizing the importance of data visualization in understanding data. Designed for those who have never used data visualization software before, this course will utilize Microsoft Power BI to prepare students to create reports and dashboards at all levels of an organization. Students will learn exploratory and explanatory data analysis and learn how to ask the right questions about what is needed in a visualization. Students will assess how data and design work together and learn which visualization to use in various situations. Students will learn how to balance the goals of their stakeholders with the needs of their end-users and be able to structure and organize a digital story for maximum impact.

A survey and case study course emphasizing the importance of data privacy and security. We need to share data in organizations, but the more we share it, the more it becomes necessary to protect it. By the end of the course, students will understand the legal, social, and ethical ramifications of data security and privacy as well as the concepts behind data guardianship and custodianship and data permissions. Special attention will be given to industry-specific data privacy laws (HIPAA, FERPA, PCI DSS, etc.).

A hand-on data analytics course for structured data using the Python programming language. Covers the skills that are required to explore and prepare data prior to analysis, create several types of predictive models, and perform data clustering. It also covers skills that are required for model assessment and implementation. Models covered include decision trees, regressions, neural networks, K-means, market basket analysis, and others. Upon completion, students will have a set of practical data analytics skills and know how to apply these skills in a variety of business environments and with many types of structured data. 

This course provides students with an introduction to the SAS programming language. It is for students who want to learn how to write SAS programs to access, explore, prepare, and analyze data. The course will also cover some intermediate topics as time allows. Through a series of mini projects, students will gain a basic working knowledge of the SAS programming language.