Data Management Capstone Project

This course is part of IBM Data Management Professional Certificate

Instructor: SkillUp

Access provided by Fractal

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.

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 videos Total 15 minutes

Course Introduction 4 minutes
Assignment Overview: Data Cleaning & Transformation Using Excel 6 minutes
Assignment Overview: Data Visualization Using Excel 5 minutes

2 readings Total 7 minutes

Course Overview 5 minutes
Module 1 Summary: Introduction and Data Preparation and Exploratory Analysis with Excel 2 minutes

3 assignments Total 75 minutes

Module 1 Graded Quiz: Introduction and Data Preparation and Exploratory Analysis with Excel 15 minutes
Checklist: Data Cleaning & Transformation Using Excel 30 minutes
Checklist: Data Visualization Using Excel 30 minutes

5 plugins Total 130 minutes

Reading: Data Platform Architecture 4 minutes
Reading: Helpful Tips for Course Completion 2 minutes
Reading: Data Set Description 4 minutes
Lab 1: Data Cleaning & Transformation 60 minutes
Lab 2: Data Visualization Using Excel 60 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 videos Total 6 minutes

Assignment Overview: Data Setup Using Relational Database 3 minutes
Assignment Overview: Data Analysis with SQL 2 minutes

1 reading Total 2 minutes

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

3 assignments Total 33 minutes

Module 2 Graded Quiz: Data Setup Using Relational Database (OLTP) 15 minutes
Checklist: Data Setup Using Relational Database 10 minutes
Checklist: Data Analysis with SQL 8 minutes

2 app items Total 120 minutes

Lab 3: Data Setup Using Relational Database 60 minutes
Lab 4: Data Analysis with SQL 60 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 videos Total 6 minutes

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

1 reading Total 2 minutes

Module 3 Summary and Highlights: Data Warehouse 2 minutes

3 assignments Total 52 minutes

Module 3 Graded Quiz: Data Warehouse 15 minutes
Checklist: Data Warehouse Design & Setup 21 minutes
Checklist: Data Warehouse Analysis with SQL 16 minutes

2 app items Total 120 minutes

Lab 5: Data Warehouse Design & Setup 60 minutes
Lab 6: Data Warehouse Analysis with SQL 60 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 videos Total 6 minutes

Assignment Overview: Data Integration, Governance and Security Implementation for FinPro Bank 3 minutes
Assignment Overview: Data Privacy, Security, Encryption, and Role-Based Access 3 minutes

1 reading Total 2 minutes

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

3 assignments Total 51 minutes

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

1 app item Total 60 minutes

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

1 plugin Total 4 minutes

Reading: Recommendations on Integration, Governance and Compliance 4 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 videos Total 5 minutes

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

1 reading Total 2 minutes

Module 5 Summary and Highlights: Data Vizualization and Dashboard 2 minutes

3 assignments Total 69 minutes

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

2 plugins Total 90 minutes

Lab 8: Business Intelligence Using Tableau 60 minutes
Lab 9: Story Dashboard 30 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.