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.
Data Management Capstone Project
This course is part of IBM Data Management Professional Certificate
Instructor: Skill-Up EdTech Team
Included with
Recommended experience
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.
Details to know
Add to your LinkedIn profile
15 assignments
See how employees at top companies are mastering in-demand skills
Build your Data Management expertise
- 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 6 modules in 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
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
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
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
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
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
2 videos2 readings1 peer review4 plugins
Instructor
Offered by
Recommended if you're interested in Data Management
Why people choose Coursera for their career
New to Data Management? Start here.
Open new doors with Coursera Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy
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.