Data Management Capstone Project

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.

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.

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.

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.

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.

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.