Back to Catalog

Data Management Capstone Project

Learn on

Coursera logo
AdvancedCourse

This capstone project underscores the vital role of a Data Manager in steering FinPro Bank toward a data-centric culture. By overseeing every aspect of the data management process—from data cleaning in Excel to building interactive dashboards in Tableau—the Data Manager ensures that data is accurate, secure, and accessible at each stage.

Language

  • English

Topic

  • Data Management

Skills You Will Learn

  • Data Management, Data Security, Data Governance, SQL, Data Visualization, Data Warehouse

Offered By

  • SkillUpEdTech

Estimated Effort

  • 3 weeks

Platform

  • Coursera

Last Update

  • May 30, 2025
About 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. 

Course Syllabus

Module 1: Introduction and Data Preparation and Exploratory Analysis with Excel 
  • Video: Course Introduction 
  • Reading: Course Overview 
  • Reading: Data Platform Architecture 
  • Reading: Helpful Tips for Course Completion 
  • Video: Assignment Overview: Data Cleaning & Transformation Using Excel 
  • Reading: Data Set Description 
  • Lab 1: Data Cleaning & Transformation 
  • Checklist: Data Cleaning & Transformation Using Excel  
  • Video : Assignment Overview: Data Visualization Using Excel 
  • Lab 2: Data Visualization Using Excel 
  • Checklist: Data Visualization Using Excel 
  • Module 1: Summary and Highlights 
  • Module 1 Graded Quiz: Data Preparation and Exploratory Analysis with Excel 
Module 2: Relational Database (OLTP) 
  • Video : Assignment Overview: Data Setup Using Relational Database 
  • Lab 3: Data Setup Using Relational Database  
  • Checklist: Data Setup Using Relational Database 
  • Video : Assignment Overview: Data Analysis with SQL 
  • Lab 4: Data Analysis with SQL  
  • Checklist: Data Analysis with SQL  
  • Module 2: Summary and highlights 
  • Module 2 Graded Quiz: Data Setup Using Relational Database (OLTP) 
 Module 3: Data Warehouse  
  • Video : Assignment Overview: Data Warehouse Design & Setup 
  • Lab 5: Data Warehouse Design & Setup 
  • Checklist: Data Warehouse Design & Setup  
  • Video : Assignment Overview : Data Warehouse Analysis with SQL 
  • Lab 6: Data Warehouse Analysis with SQL 
  • Checklist: Data Warehouse Analysis with SQL 
  • Module 3: Summary and Highlights 
  • Module 3 Graded Quiz: Data Warehouse 
 Module 4: Data Privacy, Security, Governance, Risk, and Compliance 
  • Video : Data Integration, Governance and Security Implementation for FinPro Bank 
  • Reading: Recommendations on Integration, Governance and Compliance 
  • Checklist: Data Privacy, Security, Governance, Risk, and Compliance 
  • Video : Assignment Overview: Data Privacy, Security, Encryption, and Role-Based Access 
  • Lab 7: Implementing Data Privacy, Security, Encryption, and Role-Based Access using MySQL 
  • Checklist: Implementing Data Privacy, Security, Encryption, and Role-Based Access 
  • Module 4: Summary and Highlights 
  • Module 4 Graded Quiz: Data Privacy, Security, Governance, Risk, and Compliance 
 Module 5: Data Vizualization and Dashboard 
  • Video: Assignment Overview: Business Intelligence Using Tableau 
  • Lab: Business Intelligence Using Tableau 
  • Checklist: Business Intelligence Using Tableau 
  • Video: Assignment Overview: Story Dashboard 
  • Lab 9: Story Dashboard 
  • Checklist: Story Dashboard 
  • Module 5: Summary and Highlights 
  • Module 5 Graded Quiz: Data Visualization and Dashboards 
Module 6: Final Submission & Evaluation 
  • Structure of a presentation
  • Best Practices for Presenting Your Findings
  • [Optional] Hands-on Lab: Getting started with PowerPoint for the web 
  • [Optional] Hands-on Lab: Save Your PowerPoint Presentation as a PDF  
  • Reading: Final Project Instructions  
  • Assignment: Submit your work and review your peers 
  • Reading: Congratulations & Next Steps 
  • Reading: Team and Acknowledgements 
  • Video: Resume & Job Search Tips 
  • Reading: Guide to developing a Personal Portfolio 
  • Video: Interview Preparation 

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.

Recommended Skills Prior to Taking this Course

We recommend that you complete all the previous courses in IBM Data Management Professional Certificate  before starting this course.