Overview

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.

Syllabus

Introduction and Data Preparation and Exploratory Analysis with Excel

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.

Relational Database (OLTP)

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.

Data Warehouse

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.

Data Privacy, Security, Governance, Risk, and Compliance

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.

Data Vizualization and Dashboard

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.

Final Submission & Peer Review

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.