Applied Technology College in San Diego

Request Info from CIAT Admissions Advisors

Talk to an Advisor

Book an appointment with one of our Admissions Advisors for personalized guidance on building your education plan.

Enrollment Deadline - March 8th, 2025

By checking this box, you agree to receive SMS messages from our organization regarding our services.

*By submitting this form, you are giving your express written consent for California Institute of Applied Technology to contact you regarding our educational programs and services using email, telephone or text – including use of automated technology for calls and periodic texts to any wireless number you provide. Message and data rates may apply. This consent is not required to purchase goods or services and you may always call us directly at 877-559-3621. You can opt-out any time by calling us or responding STOP to any text message.

BDA101B — Data Fundamentals Part 2

AAS in Business Data Analytics

Course ID: BDA101B
Course Credits: 4

About BDA101B — Data Fundamentals Part 2

Data Fundamentals Part 2 is the second in a two-part series, continuing from BDA 101A to further develop students' understanding of data analytics. In this part, students will refine their analytical skills by tackling more complex data scenarios and applying advanced techniques. The course is designed to solidify your ability to confidently manage and interpret data and enhance your readiness for a professional role in data analysis. The knowledge gained can continued to be applied towards your effort to pass CompTIA Data+ (Exam DA0-001) certification exam.

Topics Covered in Course

BDA101B Topics

Understand the Basics of Excel
Describe the Distribution of a Variable
Summarize Categorical Variables

Summarize Numeric Variables
Use Excel Tables for Filtering, Sorting, and Summarizing
Describe the relationship between categorical variables and numeric variables
Understand the relationship between correlation and covariance
Understand the proper use of scatterplots
Understand relational databases
Develop an Excel Data Model
Describe the value of data cleansing
Understand Sampling techniques (Clustering, Multistage, Random)
Describe how to select a sample size
Describe Sampling Distributions (t-distribution)
Understand Confidence Intervals (Mean, Total, Proportion, Standard Deviation)
Understand the difference between Null and Alternative Hypothesis
Describe hypothesis and Confidence Interval testing
Understand proper usage of a scatterplot
Differentiate between Simple Linear Regression and Mulitple Regression
Describe sampling distribution of the regression coefficients
Understand Stepwise regression

Prerequisites

Completion of BDA101A: Data Fundamentals Part 1

Address

401 Mile of Cars Way #100, National City, CA 91950

Phone

(877) 559-3621

Get Started

For Students

Information

GI Bill® is a registered trademark of the U.S. Department of Veterans Affairs (VA). More information about education benefits offered by VA is available at the official U.S. government website at https://www.benefits.va.gov/gibill. CIAT is approved to offer VA benefits. *Financial aid is available for those who qualify. *Students are encouraged to take certification exams while actively enrolled in their Certificate or Degree program. Unlimited certification exam attempts expire 180 days after graduation. Select exams are not eligible for unlimited retakes - see certification exam policy for details. Certifications or courses may change to address industry trends or improve quality