What background knowledge is necessary?

You should have completed all prior courses in the program to take this course.

What is the refund policy?

If you subscribe, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.

Is this course really 100% online? Do I need to attend any classes in person?

This course is completely online, so there’s no need to show up to a classroom in person. You can access your lectures, readings, and assignments anytime and anywhere via the web or your mobile device.

What background knowledge is needed for this program?

This Professional Certificate is open to anyone with any job and academic background.

Can I get college credit for completing the professional certificate?

At this time, college credit is not available for taking this program.

What is data management?

Data management involves the collection, organization, protection, and analysis of data to ensure its accuracy, accessibility, and security. It includes processes like data integration, storage, and migration, as well as utilizing tools for analysis and visualization to generate insights that drive business decisions. In modern cloud environments, data management also focuses on optimizing scalability, security, and cost-efficiency while ensuring alignment with business goals through collaboration across teams.

What careers require data management skills taught in this program?

Data analyst, data engineer, database administrator, data compliance specialist, data governance, data steward, BI developer, data privacy specialist, data technician, research assistant, data quality analyst, metadata specialist, data operations associate, data IT support.

What credentials will I earn by completing this program?

Each course you complete earns you an IBM badge to certify successful course completion. By completing the entire program, you will earn an IBM data manager professional certificate.

When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Certificate?

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Data Management Capstone Project

This course is part of IBM Data Management Professional Certificate

Instructor: SkillUp

Included with

Learn more

6 modules

Gain insight into a topic and learn the fundamentals.

Advanced level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

6 modules

Gain insight into a topic and learn the fundamentals.

Advanced level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Integrate valuable applied data management skills employers need for a wide range of data-related roles in a culminating project. 
Gain hands-on experience using industry-specific data tools including Excel, SQL, PostgreSQL, Tableau, etc.
Demonstrate best practices and apply those methodologies through industry-standard processes, data design, governance, security, and reporting.
Showcase your ability to solve problems relevant to working with data that you can discuss with colleagues and prospective employers.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

15 assignments¹

AI Graded see disclaimer

Taught in English

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

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your Data Management 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

There are 6 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 management program with this hands-on culminating project.

The project provides you the opportunity to solidify your proficiency when working with various aspects of data and integrate them into a single project. You’ll apply many industry-specific tools and industry-standard best practices to a real-world-inspired scenario. 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.

Module details

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.

What's included

3 videos2 readings3 assignments5 plugins

3 videosTotal 15 minutes

Course Introduction4 minutes
Assignment Overview: Data Cleaning & Transformation Using Excel 6 minutes
Assignment Overview: Data Visualization Using Excel5 minutes

2 readingsTotal 7 minutes

Course Overview5 minutes
Module 1 Summary: Introduction and Data Preparation and Exploratory Analysis with Excel2 minutes

3 assignmentsTotal 75 minutes

Checklist: Data Cleaning & Transformation Using Excel30 minutes
Checklist: Data Visualization Using Excel30 minutes
Module 1 Graded Quiz: Introduction and Data Preparation and Exploratory Analysis with Excel15 minutes

5 pluginsTotal 130 minutes

Reading: Data Platform Architecture 4 minutes
Reading: Helpful Tips for Course Completion2 minutes
Reading: Data Set Description4 minutes
Lab 1: Data Cleaning & Transformation60 minutes
Lab 2: Data Visualization Using Excel60 minutes

In this module, you will design a data platform that uses MySQL as an OLTP database. You will be using MySQL to store the OLTP data.

What's included

2 videos1 reading3 assignments2 app items

2 videosTotal 6 minutes

Assignment Overview: Data Setup Using Relational Database3 minutes
Assignment Overview: Data Analysis with SQL2 minutes

1 readingTotal 2 minutes

Module 2 Summary: Data Setup Using Relational Database (OLTP)2 minutes

3 assignmentsTotal 33 minutes

Checklist: Data Setup Using Relational Database10 minutes
Checklist: Data Analysis with SQL8 minutes
Module 2 Graded Quiz: Data Setup Using Relational Database (OLTP)15 minutes

2 app itemsTotal 120 minutes

Lab 3: Data Setup Using Relational Database60 minutes
Lab 4: Data Analysis with SQL60 minutes

In this module, you will design and implement a data warehouse using the pgAdmin ERD design tool. You will then generate reports from the data in the data warehouse using cube and rollup aggregation queries.

What's included

2 videos1 reading3 assignments2 app items

2 videosTotal 6 minutes

Assignment Overview: Data Warehouse Design & Setup4 minutes
Assignment Overview : Data Warehouse Analysis with SQL 3 minutes

1 readingTotal 2 minutes

Module 3 Summary and Highlights: Data Warehouse2 minutes

3 assignmentsTotal 52 minutes

Checklist: Data Warehouse Design & Setup21 minutes
Checklist: Data Warehouse Analysis with SQL16 minutes
Module 3 Graded Quiz: Data Warehouse15 minutes

2 app itemsTotal 120 minutes

Lab 5: Data Warehouse Design & Setup60 minutes
Lab 6: Data Warehouse Analysis with SQL60 minutes

This module delves into the critical aspects of data privacy, security, governance, risk, and compliance technologies. It recommends practices required to protect the sensitive information of FinPro bank. As banks increasingly rely on data for their operations, securing this valuable asset against threats and breaches is paramount.

What's included

2 videos1 reading3 assignments1 app item1 plugin

2 videosTotal 6 minutes

Assignment Overview: Data Integration, Governance and Security Implementation for FinPro Bank3 minutes
Assignment Overview: Data Privacy, Security, Encryption, and Role-Based Access3 minutes

1 readingTotal 2 minutes

Module 4 Summary and Highlights: Data Privacy, Security, Governance, Risk, and Compliance2 minutes

3 assignmentsTotal 51 minutes

Checklist: Data Privacy, Security, Governance, Risk, and Compliance15 minutes
Checklist: Implementing Data Privacy, Security, Encryption, and Role-Based Access 21 minutes
Module 4 Graded Quiz: Data Privacy, Security, Governance, Risk, and Compliance15 minutes

1 app itemTotal 60 minutes

Lab: Implementing Data Privacy, Security, Encryption, and Role-Based Access using MySQL60 minutes

1 pluginTotal 4 minutes

Reading: Recommendations on Integration, Governance and Compliance4 minutes

Tools like Tableau provide advanced visualization capabilities. They allow you to extract more information from the data by providing better sorting and filtering features. They help you create interactive dashboards that enable users to make better decisions. In this module, you’ll perform advanced data visualization tasks. You’ll create worksheets using advanced filters and emphasizers and then assemble multiple worksheets to create interactive dashboards with features like calculated fields and interactivity allowing the filtering of data across multiple views.

What's included

2 videos1 reading3 assignments2 plugins

2 videosTotal 5 minutes

Assignment Overview: Business Intelligence Using Tableau 3 minutes
Assignment Overview: Story Dashboard 3 minutes

1 readingTotal 2 minutes

Module 5 Summary and Highlights: Data Vizualization and Dashboard2 minutes

3 assignmentsTotal 69 minutes

Checklist: Business Intelligence Using Tableau 18 minutes
Checklist: Story Dashboard 21 minutes
Module 5 Graded Quiz: Data Vizualization and Dashboard30 minutes

2 pluginsTotal 90 minutes

Lab 8: Business Intelligence Using Tableau60 minutes
Lab 9: Story Dashboard30 minutes

In this module, you will create a presentation based on all the tasks performed in previous modules. Through your presentation, you will explain your process and the results of your work. The presentation will be uploaded in a PDF format and will be reviewed by your peers. You’ll also be reviewing the work of some of your peers. This module also includes guidance to secure a job in a data management role. It offers tips for resume and job-searching, personal portfolio building, and interview preparation.