Data Management Capstone Project

Instructor: Skill-Up EdTech Team

Advanced Level • 16 hours to complete 3 weeks at 5 hours a week • Flexible Schedule

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

Data Presentation
Data Security
Dashboard
Personally Identifiable Information
Data Management
Data Visualization Software
Role-Based Access Control (RBAC)
MySQL
Data Integration
SQL
Data Transformation
Relational Databases
Database Design
Data Cleansing
Tableau Software
Data Warehousing
Microsoft Excel

Shareable Certificate

Earn a shareable certificate to add to your LinkedIn profile

Outcomes

  • 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

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.

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.