About this Major
A Certificate of Training demonstrates you have proven the necessary skills to succeed as a data analyst. Classes will be instructor-led for three hours Tuesday, and Thursday night twice a week. There will be some weeks that the class does not meet.
It is suggested but not required that students in this course have a working knowledge of Excel to the extent they are comfortable working with PivotTables, and also a working knowledge of Python before enrolling
Excel training classes are available at the Rockwell campus.
Python training classes are available at the Reno campus.
Program Courses
Learn the foundational principles of data science and analytics, including key terminology, tools, and processes. This course prepares students for the DSBiz certification, a recognized credential for data-literate professionals.
Understand how to structure and organize data for analysis. Explore the principles of relational databases, data warehousing, and model design to support accurate and efficient data querying.
Dive into advanced Excel techniques for cleaning, analyzing, and visualizing data. Learn to build dashboards and reports using functions, pivot tables, and charts that support decision-making.
Explore Microsoft Power BI to build interactive dashboards, connect to multiple data sources, and perform detailed data analysis using DAX formulas and Power Query.
Learn how to use Tableau to create dynamic, visually compelling dashboards and reports. Gain hands-on experience in transforming raw data into clear, actionable insights.
Discover the basics of programming in R and its applications in data analysis. Topics include importing data, performing statistical analysis, and creating visualizations.
Learn to write and optimize SQL queries to extract and manage data from relational databases. This class covers filtering, joins, subqueries, and aggregation techniques.
Gain essential Python skills focused on cleaning, transforming, and preparing data for analysis. Learn to work with libraries such as pandas and NumPy to manage large datasets efficiently.
Apply the knowledge and skills gained throughout the program to complete a real-world data project. The capstone involves defining a problem, gathering and analyzing data, and presenting actionable insights through a final report or dashboard.
A Capstone Project will be completed by the end of the course. Students are expected to meet assignment deadlines, and attend ALL class sessions.
