What you'll learn

Integrate valuable applied dataskills employers need for a wide range of data-related roles in a culminating project. 
Gain hands-on experience using industry-specific data tools.
Demonstrate best practices and apply those methodologies through industry-standard processes.
Showcase your ability to solve problems relevant to working with data that you can discuss with colleagues and prospective employers.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

4 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Build your Data Analysis expertise

This course is part of the IBM Data Management Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from SkillUp EdTech

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 2 modules in this course

In this capstone course, you’ll demonstrate your ability to solve problems relevant to data-related roles, which you can then showcase in your portfolio and share with prospective employers. You will apply the skills you’ve learned throughout this data manager program with this hands-on culminating project.

The project provides you the opportunity to solidify your proficiency when working with data and integrate them into a single project. You’ll apply many industry-specific tools and industry-standard best practices with a real-world data integration scenario using an ETL process. As part of this process, you utilize relational databases and SQL queries. You’ll also manipulate data using spreadsheets and BI tools to create visualizations and a dashboard to readily communicate your data insights. We recommend that you complete all the previous courses in this Professional Certificate before starting this course.

In this module, you will work with Customer Data and Transaction Data to prepare them for advanced analysis. You will begin by analyzing the data set to identify key fields and understand its structure. Next, you will clean the data by removing duplicates, handling missing values, and correcting inconsistencies using Excel. During the transformation phase, you will create new data fields and categorize information to uncover customer segments and transaction patterns. Additionally, you will focus on visualizing the data to extract actionable insights. You will use Excel’s charting tools to create bar charts, line graphs, and pie charts. To ensure all tasks are completed accurately, each lab includes a checklist, which verifies that you have completed all essential steps.