Business and Professional Development/ Professional Development

Data Management and Analysis CBPD-7430

In this certificate, you will learn how to use Excel to perform basic to advanced techniques for data analysis and then present meaningful, data-driven insights to inform business decisions. Explore how to ask the right questions to ensure you collect the right data, and benefit your business by converting raw data into meaningful, actionable insights. Build predictive models and use data to help inform your business and make improved tactical and strategic decisions. Lastly, you will complete a capstone project to bring all of your learning together. Classes include: Data Analysis Basic, Data Analysis Intermediate, Data Analysis Advanced, and Data Analysis Capstone.

Ready to learn more? Complete our online form or contact us at 319-398-1022.

Upcoming Offerings:
Begins July 25th, Hiawatha

Click here to view a full list of upcoming offerings.

Tuition Assistance:
Yes. Full tuition assistance is available to support your career goals. Fill out our referral form at www.kirkwood.edu/cefunding.
*Some eligibility restrictions may apply.

Industry Credentials Earned:
None. This program does not award any nationally recognized certification upon completion.

Entrance Requirements/Prerequisites:
Must be proficient in Excel navigation.

Delivery Method:
Classroom

Length of Program and CEU Credits:
45 hours, 5.4 CEUs

Program Completion Requirements:
This is a pass/fail certificate. Students will need to complete a capstone project in the Data Analysis: Advanced course in order to pass the certificate. The final project will be a hands-on project that will simulate a real-world scenario.

Course Objectives:

• Explore example types of analysis projects, from sample data to finished product.
• Set yourself up for success by learning about common data analysis considerations.
• Learn and understand the different types of data and how to preprocess it correctly.
• Create linear and non-linear predictions.
• Utilize Excel to create basic and advanced formulas, readable graphs and charts, model business problems, macros, dashboards, and more.
• Learn how to use general statistics that will cover over 90 percent of what you’re likely to encounter in day-to-day work.
• Determine statistical significance and how to recognize bad or missing data.
• Choose impactful variables to get the most out of your data.
• Design quality surveys and identify biases to gather usable data.
• Complete a capstone project applicable and relevant to the workplace.

Learning Outcomes:
Upon completion of this program, students will be able to utilize Excel to perform basic to advanced techniques to analyze data and then present meaningful, data-driven insights to inform business decisions.

Other Items to Know About this Course:
All classroom materials are included in the tuition fee and will be provided in class.

Pathway to Credit Program:
None.

Related Information: 
NA