Skip to Main Content Skip to bottom Skip to Chat, Email, Text

BDAT/376

Preparing Data for Analysis

Course level: Upper Division

3 credits

Total credits

5 weeks

Course length

Take this course on its own, or as part of a degree or certificate program.

Please Note: Attendance and participation are mandatory in all University courses, and specific requirements may differ by course. If attendance requirements are not met, a student may be removed from the course. Please review the Course Attendance Policy in the Catalog for more information.

University of Phoenix reserves the right to modify courses. While widely available, not all programs are available to residents of all states. Please check with a University Enrollment Representative.

This course covers prepping, cleaning, organizing, and augmenting data for analysis. Students learn how to prepare data by cleaning it, creating the necessary variables, formatting all variables, transcribing data, adjusting data that requires weighting, scale transformations, and selecting the data analysis strategy.

Please Note: Attendance and participation are mandatory in all University courses, and specific requirements may differ by course. If attendance requirements are not met, a student may be removed from the course. Please review the Course Attendance Policy in the Catalog for more information.

University of Phoenix reserves the right to modify courses. While widely available, not all programs are available to residents of all states. Please check with a University Enrollment Representative.

Earn these career-relevant skills in weeks, not years.

  • Identify and define a business question and evaluate relevant sources of data collection.
  • Identify principles of data management.
  • Define statistical properties that can describe data.
  • Explain the different types of data and distinguish between qualitative and quantitative data.

  • Summarize the data analysis process from collecting data to reporting findings.
  • Identify, define, and critique sources of errors in data.
  • Evaluate a data set to identify missing data and outliers.

  • Clean and recode data to prepare it for analysis using data cleaning techniques in Excel®.
  • Prepare a summary description of actions taken to clean data for analysis.
  • Explain data cleaning tasks and illustrate data cleaning tasks with examples.
  • Verify data consistency, manipulate heterogeneous data, and identify missing data using Microsoft® Excel®.

  • Create a clear and documented report dashboard with visualizations using Microsoft® Excel®.
  • Describe and compare how and when to use tables, charts, and graphs for data presentation.
  • Manipulate data sets and create tables, graphs, and charts in Microsoft® Excel® for presenting cleaned data.
  • Arrange data graphically using the appropriate tool for the data.

  • Apply quantitative modeling and data analysis techniques to the solution of real-world business problems, communicate findings, and effectively present results using data visualization techniques.
  • Employ appropriate data-cleaning modeling techniques to evaluate and analyze a business problem.
  • Evaluate code of ethics for a professional organization and apply ethical standards to a data modeling business case.

Why take courses at University of Phoenix?

University of Phoenix serves busy adults

Accreditation that matters

We’ve been accredited by the Higher Learning Commission (hlcommission.org) for more than 40 years.

Real-world instructors

Learn from instructors who bring an average of 25 years of working experience to the classroom.

Affordable and potentially reimbursable

Our tuition and fees are competitive and fixed. Also, check to see if your employer will cover you for this course.

Transfer-friendly courses

Before you enroll in a course, check with your school of choice to make sure they will accept your transfer credits and to understand any requirements or limitations. Then you can request your transcripts.

Transferability of credit is at the discretion of the receiving institution. It is the student’s responsibility to confirm whether or not credits earned at University of Phoenix will be accepted by another institution of the student’s choice. If you have a question contact us at (866) 354-1800.

Enrollment representative Sarah P.

Enrollment Rep. Sarah P.

Start a conversation about your future today.

Speak with an enrollment representative.

Call 844-937-8679 or chat with us 7 days a week.

University of Phoenix reserves the right to modify courses. Although our continuing teacher education courses are accepted by some state agencies in the United States toward teacher certifications and endorsements, this may not be the case in all states or foreign jurisdictions. If you plan to use courses for certification or endorsement, please check with your own state agency and your school district for applicability. Continuing teacher education courses are not eligible to apply to degree programs at University of Phoenix. These courses are not eligible for federal financial aid. While widely available, not all programs are available to residents of all states. Please check with a University Enrollment Representative. If you have a question contact us at (866) 354-1800.