Course Details

This course covers the basics of data analytics, utilizing spreadsheets, statistics, and exploratory data analysis. Students journey through the data analytics project cycle by defining the problem, preparing the information, analyzing the data, visualizing insights and presenting results. As they engage in this course, students organically develop problem-solving acumen and hone critical thinking skills essential for data analysis.

This course teaches essential spreadsheet skills for data analysis while integrating basic statistical principles. Students become proficient in spreadsheet functionalities such as data entry, formatting, and formula use, progressing to techniques like identifying outliers, employing descriptive statistics, examining relationships between variables, and harnessing the power of pivot tables for comprehensive data summarization and analysis using spreadsheets. Through practical exercises and real-world case studies, students learn to navigate spreadsheet software effectively, analyze data sets, and derive meaningful insights, culminating in the ability to apply statistical concepts within spreadsheet environments for informed decision-making and analysis.

This course will teach students how to use spreadsheets for data analysis. Students will learn how to pull data from the web into a spreadsheet and what to do with that data afterward. This will include how to find and filter information and how to use basic data-related tools used in industry for data analytics.. Students will learn how to create visualizations and dashboards in spreadsheets. We will also go over custom functions and macros to automate repeated tasks.

This course provides a comprehensive understanding of SQL's foundational principles tailored for data analysis within relational databases. Students develop expertise in constructing SQL queries for data retrieval, focusing on pulling, filtering, aggregating, and joining datasets. Through hands-on projects, they'll apply these skills, learning to extract, filter, and manipulate data effectively, gaining a solid foundation in SQL's role within the realm of data analysis.

The Advanced SQL course equips students with the skills to manage and query relational databases using advanced techniques. Through hands-on projects, students gain experience designing and interacting with multi-dimensional databases and managing large datasets. Students who complete this course will be able to efficiently retrieve, analyze, and manage data in complex database environments.

This course teaches fundamental Python skills tailored for data analysis, encompassing Python's core syntax, data structures, and procedural programming techniques. Students perform data cleaning, data manipulation, and exploratory analysis using industry-standard libraries, fostering expertise in managing, analyzing, and visualizing data. Through practical projects, learners refine their abilities, gaining confidence to proficiently handle, analyze, and present data using Python. This course cultivates real-world application skills and sharpens proficiency in data project documentation, serving as a strong foundation for future data science endeavors.

The Advanced Python for Data Analytics course builds upon the principles learned in Python Programming. In this course, students learn to access remote databases using Python. Students then use the data they have pulled to create, manipulate, and filter data using multiple industry standard libraries essential for data analytics. Students also learn to create ad hoc visualizations with Python ok, code. Students who complete this course are able to use a variety of Python libraries in the data analytics industry to collect, clean, analyze, and present data.

This course teaches students the core principles of data visualization essential for data analysis. With a focus on practical application using industry-standard tools, participants learn to translate complex datasets into compelling visual stories. Covering visualization design fundamentals, data cleansing, exploration of interactive dashboards, and consistent ethical considerations, learners cultivate aptitude essential for creating impactful visualizations. Through hands-on projects, individuals refine their skills, gaining the ability to extract insights effectively and drive informed decision-making across diverse industries.

Career and Workplace Success is designed to help students find, apply for, and obtain gainful and satisfying employment by developing essential work habits, attitudes, and human relations skills. Topics include common challenges faced in the workplace and the job search, such as presenting yourself professionally, interviewing effectively, selling and promoting relevant abilities and skills, developing a professional work ethic, navigating office politics successfully, developing interpersonal skills, and planning and managing a career.

This course teaches students to harness their data analytics skills by undertaking a comprehensive capstone project. Using various tools and techniques learned throughout the course of this program, students demonstrate their ability to identify business questions, collect, clean, and analyze data. The culmination of this project involves presenting their meaningful insights and findings through a visualization tool, class presentation and written report.

This course familiarizes students with practical techniques in designing, constructing, and managing database systems. Through exploration of database design, development, and management, students explore strategies that optimize stored data, ensuring its integrity and maximizing its value. By learning these skills, students gain proficiency in creating, implementing, and maintaining databases crucial for efficient information systems.