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 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.

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

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

Category: Data Manipulation
Category: SQL
Category: Data Management
Category: Data Visualization Software
Category: Data Security
Category: Interactive Data Visualization
Category: Database Management
Category: Data Warehousing
Category: Dashboard Creation
Category: Data Presentation
Category: Tableau Software
Category: Data Cleansing
Category: Database Design
Category: Data Visualization
Category: Data Governance
Category: Data Integration

Tools you'll learn

Category: MySQL
Category: Microsoft Excel
Category: Dashboard
Category: Relational Databases

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

15 assignments¹

AI Graded see disclaimer

Taught in English

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.

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

Module 1 Graded Quiz: Introduction and Data Preparation and Exploratory Analysis with Excel15 minutes
Checklist: Data Cleaning & Transformation Using Excel30 minutes
Checklist: Data Visualization Using Excel30 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

Module 2 Graded Quiz: Data Setup Using Relational Database (OLTP)15 minutes
Checklist: Data Setup Using Relational Database10 minutes
Checklist: Data Analysis with SQL8 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

Module 3 Graded Quiz: Data Warehouse15 minutes
Checklist: Data Warehouse Design & Setup21 minutes
Checklist: Data Warehouse Analysis with SQL16 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

Module 4 Graded Quiz: Data Privacy, Security, Governance, Risk, and Compliance15 minutes
Checklist: Data Privacy, Security, Governance, Risk, and Compliance15 minutes
Checklist: Implementing Data Privacy, Security, Encryption, and Role-Based Access 21 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

Module 5 Graded Quiz: Data Vizualization and Dashboard30 minutes
Checklist: Business Intelligence Using Tableau 18 minutes
Checklist: Story Dashboard 21 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.

What's included

4 videos2 readings1 peer review4 plugins

4 videosTotal 22 minutes

Structure of a Presentation6 minutes
Best Practices for Presenting Your Findings4 minutes
Resume & Job Search Tips 7 minutes
Interview Preparation 5 minutes

2 readingsTotal 5 minutes

Congratulations and Next Steps3 minutes
Team and Acknowledgments2 minutes

1 peer reviewTotal 30 minutes

Submit your work and review your peers30 minutes

4 pluginsTotal 85 minutes

[Optional] Hands-on Lab: Getting started with PowerPoint for the web60 minutes
[Optional] Hands-on Lab: Save Your PowerPoint Presentation as a PDF5 minutes
Final Project Instructions15 minutes
Reading: Guide to Developing a Personal Portfolio5 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

SkillUp

144 Courses472,801 learners

Offered by

SkillUp

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions

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

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.

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.

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.

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.

¹ Some assignments in this course are AI-graded. For these assignments, your data will be used in accordance with Coursera's Privacy Notice.

Data Management Capstone Project

Data Management Capstone Project

What you'll learn

Skills you'll gain

Tools you'll learn

Details to know

Build your Data Management expertise

There are 6 modules in this course

Introduction and Data Preparation and Exploratory Analysis with Excel

What's included

Relational Database (OLTP)

What's included

Data Warehouse

What's included

Data Privacy, Security, Governance, Risk, and Compliance

What's included

Data Vizualization and Dashboard

What's included

Final Submission & Peer Review

What's included

Earn a career certificate

Instructor

Offered by

Why people choose Coursera for their career

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.

Frequently asked questions

What background knowledge is necessary?

What is the refund policy?

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