Meta Database Engineer Portfolio

Overview

Welcome to my portfolio showcasing the skills and projects I have developed during the Meta Database Engineer Professional Certificate program. This portfolio includes various data modeling and database management projects that demonstrate my understanding of database concepts, SQL, data modeling, and visualization techniques. 📊

📖Table of Contents

• About Me 👤
• Course Overview 📚
• Projects 🚀
  • Project 1: Data Modeling Project 📐
  • Project 2: SQL Analysis 🔍
  • Project 3: Data Visualization 📈
• Tech Stack ⚙️
• Installation 👨🏿‍💻
• Usage 🛠️
• License 📜

🙋🏿‍♂️About Me

I am a passionate data enthusiast with a keen interest in database engineering and data analytics. Through the Meta Database Engineer Professional Certificate, I have gained hands-on experience in designing and managing databases, performing data analysis, and creating insightful visualizations. 🌟

Course Overview📝

The Meta Database Engineer Professional Certificate program covers essential topics, including:

• Database design and data modeling 📊
• SQL for data manipulation and querying 🗄️
• Data normalization and denormalization 📋
• Database management systems (DBMS) 🖥️
• Data visualization techniques 🌈
• Real-world data analysis projects 🔗

📁Projects

Project 1: Data Modeling Project 📐

• Description: This project involved designing a relational database for a fictional e-commerce platform. The database was designed to manage customer information, orders, and product data.
• Technologies Used: SQLite, Python, Pandas
• Key Features:
  • Entity-relationship diagrams (ERD) 📊
  • Data normalization to eliminate redundancy ♻️
  • SQL scripts for creating and populating tables 📝

Project 2: SQL Analysis 🔍

• Description: In this project, I performed SQL queries to analyze sales data from a retail database. The focus was on extracting insights related to sales trends and customer behavior.
• Technologies Used: SQLite, SQL
• Key Features:
  • Aggregate functions (SUM, AVG, COUNT) ➕
  • Grouping and filtering data 🔎
  • Joins to combine data from multiple tables 🔗

Project 3: Data Visualization 📈

• Description: This project involved visualizing the results from the SQL analysis using Python libraries. I created interactive charts and dashboards to present the findings effectively.
• Technologies Used: Python, Matplotlib, Plotly, Dash
• Key Features:
  • Interactive plots and dashboards 🎨
  • Insights into sales performance by region and product 📊
  • User-friendly interface for data exploration 👥

Tech Stack⚙️

• Python 🐍
• SQL (SQLite) 📄
• Pandas 📊
• Matplotlib 🎨
• Plotly 📉
• Dash 📊
• Jupyter Notebook 📒
• Tableau 📊
• SQL🛢️
• Excel 📅
• MySQL Workbench 🛢️

Installation 👨🏿‍💻

To set up the projects locally, follow these steps:

1. Clone the repository:

   git clone https://github.com/Willie-Conway/Meta-Database-Engineer-Portfolio.git
   cd Meta-Database-Engineer-Portfolio

2. Set up a virtual environment (optional but recommended):

   python -m venv venv
   source venv/bin/activate  # On Windows use `venv\Scripts\activate`

3. Install the required packages:

   pip install -r requirements.txt

Usage 🛠️

• To run the Data Modeling Project, navigate to the project directory and execute the following command:

  python Data_Modeling_Project.py

• For SQL Analysis and Data Visualization, follow the respective project instructions in their directories.

License 📜

This project is licensed under the MIT License - see the LICENSE file for details.

Acknowledgments 🙏

I would like to thank the Meta team for providing a comprehensive and insightful learning experience through the Professional Certificate program.