Data Analytics (DAT)

Courses

DAT 7711. Database Fundamentals. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

CPCC login required. Understanding how relational databases are designed for maximum data manipulation is the first step in the field of data management and analytics. You will learn core database concepts, and how to create database objects and manipulate data. Maps to Microsoft Technology Associate exam #98-364.

DAT 7712. Business Intelligence Fundamentals. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

Discover the best practices to access and analyze data while gaining the confidence to dive right into your processes to improve and optimize business decisions and performance. This course provides the foundation that will allow you to understand data warehousing, BI processes and techniques and how to develop skills to consume and analyze data. The class will use available tools such as Power BI and Tableau Public.

DAT 7713. Introduction to Statistics and Analytics. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

CPCC login required. Advanced Excel skills required. Understanding the various statistical techniques to analyze data is the foundation to any business intelligence solution. When statistical principles are correctly applied, statistical analyses tend to produce accurate results. In this class, you will use Excel with practice files, templates, data sets, and sample models to apply statistical techniques used in finance, marketing, quality, science and any other industry that uses data.

DAT 7714. Excel VBA Programming. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

Excel VBA is commonly used in high finance and frequency trading applications for creating and validating financial models. In this class, you will learn how to make user-centric, intuitive and interactive analytic dashboards and reports using Visual Basic. Also learn implementation of statistical models, and impactful presentation of results.

DAT 7720. SAS Programming. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

Advancing your analytical skills with SAS, provides you the opportunity of learning a tool that is both versatile and powerful enough to meet your needs in data analyses. Today, there are many job listings that require a variety of SAS expertise and is easy to learn with its GUI interface and versatility. Whether you are new to analytics or not; SAS allows data files created by SPSS, Excel, Minitab, Stata, Systat, and others to be incorporated directly or through file conversion. This class, will help advance your career in analytics by adding a new tool to your "toolbox" of skills.

DAT 7721. SAS Base Programming. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

SAS is the leader in analytics helping you turn your data into better decisions. In this class, you will learn the tools to be able to navigate the SAS Studio programming environment, import various types of data sets and begin with analysis of the data imported.

DAT 7722. SAS Advanced Programming. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

Advancing your analytical skills in SAS better prepares you in the dynamic field of big data and statistics. This course looks at the components of Macros and SQL. It will highlight the components of the SAS macro facility and how to design, write, and debug macro systems and introduces you how to process SAS data using Structured Query Language (SQL).

DAT 7723. Querying SQL. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

Learning SQL can be one of the greatest career decisions you make. Between the potential salary, no longer relying on others to give you information, and being able to ask any question about your business, learning SQL enables you to do so much more than you have done previously. Simply put, SQL is the language you use to interact with a database and is the most sought after skill set regardless of your role.

Corequisites: Take DAT 7711 with a minimum grade of S

DAT 7724. Developing SQL. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

This class is intended for individuals who have completed Querying SQL and who are ready to move beyond the fundamentals of querying and advance their skills in programmability, data definition (DDL) and performance tuning.

Corequisites: Take DAT 7723 minimum grade S

DAT 7726. Hadoop Base Programming. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

Hadoop has emerged as the most popular framework in the Big Data Platform. Learning to program and develop in Hadoop can lead to lucrative career opportunities in the Big Data realm. For the enterprise, Hadoop allows businesses to find answers to questions they don't even know to ask, providing insights into operational aspects, driving new product ideas, and in generating targeted ads for consumers. Enterprises are finding that adopting Big Data concepts with Hadoop has a very positive influence to their bottom line.

DAT 7727. SQL Server Integration Services (SSIS). 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

The complexity and importance of the data integration system, or ETL, in a data warehouse project is often underestimated, and the consequences of poorly implemented ETL processes inevitably lead to high maintenance cost, low reliability and even failure of the project. In this class, you will learn data integration concepts in the context of a data warehouse.

DAT 7728. Sql Server Database Administration Basic. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

DAT 7730. Data Visualization and Storytelling. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

CPCC login and textbook required. Required: DAT-7713 and DAT-7711 In today's world, data is omnipresent and most organizations are presented with billions of data points every morning. Good analysis parses these numerical outputs into an understanding of the organization or process and turns the raw numbers into a story about the performance. The challenge is to interpret and communicate these stories correctly. This course provides the fundamentals on how to design visualizations properly as well as provide techniques on how to communicate the analysis effectively. With data visualization you can help your business partners, peers, and managers make informed decisions with a blend of dimensions, color, and visual masterpieces. The class will use available tools such as Excel, Power BI, and Tableau.

Corequisites: Take DAT 7713 DAT 7711

DAT 7731. SQL Server Reporting Services (SSRS). 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

All types of users across the company need to have easy access to informative and intuitive reports that combine data from many sources throughout the organization. In this class, you will learn how to make effective business decision using Microsoft SQL Server Reporting Services (SSRS), in conjunction with SQL server database. If you are a current Dynamics ERP user, you can also use SSRS to your advantage combining the benefits of a centrally-managed reporting system.

DAT 7732. Tableau Basic. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

Learn to create new data analysis and reporting with a product that makes databases and spreadsheets understandable. This class is designed as an introduction to Tableau that can help you see and understand your data in order to solve problems. Enjoy analyzing data faster and easier with the Tableau Software. Strong Excel skills are preferred; SQL recommended.

DAT 7733. Analyzing Data with Tableau. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

Gain a competitive advantage by learning how to produce interactive data visualization reports to support business decision making. This class is designed for the professional who has a solid working experience and wants to take it to the next level.

DAT 7734. Power BI Basic. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

If you are working on Six Sigma projects or analyzing data, then you are ready to create stunning reports and visualization with Microsoft's NEW Power BI Desktop! This course will provide an overview of Power BI, a popular cloud based Business Intelligence platform for performing sophisticated data integration, modeling and reporting.

DAT 7735. Analyzing Data with Power BI. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

Vastly improve your ability to effectively derive business insights from data through Power BI. This class is intended for data scientists, Excel pros or data analysts, who are tasked with creating analytical or reporting solutions that are impactful, relevant and can effectively support business decision making.

Corequisites: Take DAT 7730 with a minimum grade of S

DAT 7736. Data Story Telling Visualizations. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

In today's world, data is omnipresent and most organizations are presented with billions of data points every morning. Good analysis parses these numerical outputs into an understanding of the organization or process and turns the raw numbers into a story about the performance. The challenge is to interpret and communicate these stories correctly. This course provides the fundamentals on how to design visualizations properly as well as provide techniques on how to communicate the analysis effectively. The class will use available tools such as Excel, Power BI and Tableau Public for labs and showing examples.

DAT 7741. Introduction to Data Science. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

This course builds a solid foundation for the underlying principles on which the entire data science stack is based on including statistics and probability and data management. You will have the opportunity to apply real world implementations of the techniques and algorithms used for both small and large data sets.

DAT 7742. Python Programming for Data Science. 0.0 Hours. Class-440.0. Clinical-0.0. Lab-0.0. Work-0.0

This is a hands-on course with practical case studies for manipulating, processing, cleaning, modeling and crunching datasets in Python. Go from messy, unstructured artifacts stored in SQL and NoSQL databases to a neat, well-organized dataset. The class is designed for analysts new to Python and for Python programmers new to data science.