Fictional company Pewlett Hackard needs to determine the number of retiring employees per title and identify employees who are eligible to participate in a mentorship program. Both tasks are accomplished using SQL queries.

Data modeling, engineering, and analysis of employee data. Created an ERD and table schema, then loaded and analyzed data using PostgreSQL.

delivering retirement metrics and work statistics from a large pool of data

Created SQL tables from multiple csv files and sketched and Entity Relationship Diagram

Implemented ETL process, exported csv files, and created an ERD diagram and relationship tables and schemas

Creating SQL database using PostgreSQL and pgAdmin

Data Modeling, Engineering, SQL to search database for potential credit card fraud

To answer important business questions for the company’s HR department, we utilized Postres SQL as the database to load, build, and host the company data. We used pgAdmin to run quarries and generated multiple analyses in a well-designed database with reporting capabilities. The final data reporting can be adapted by any large coorporation to pr…

Designed and Built a database for a pizzeria and ran custom SQL queries

A final group project for the UNC Chapel Hill Data Analytics and Visualization Boot Camp

Analysis of Employee data.

La idea fundamental de este proyecto es permitir la programación de citas a través de la web, con la capacidad de enviar confirmaciones por correo electrónico. Inicialmente, cada usuario podrá iniciar sesión para confirmar sus citas. Este sistema está especialmente diseñado para barberías.

The company Pewlett-Hackard wants to know the number of employess and the titles.The company also asked us to come up with numbers of elegible mentorship program. Number of retiress, their titles and departments.

By utilizing PostgreSQL via pgAdmin, this data analysis helps a large company prepare for a surge of employee retirements.

Explored employee data from the 1980s and 1990s through data modeling, engineering, and SQL analysis. Uncovered insights into demographics and trends.

SQL and pgAdmin to examine retirement data

An HR Department analysis using SQL to to prepare for a retirement surge and mentoring program

Data modeling and engineering

Module 9 Challenge involves data modelling, engineering and analysis. Use of QuickDBD to sketch an ERD and table schemas, data type, primary and foreign key relationships. SQL queries for data analysis.

retrieving data from the database with SQL