Skip to content

This project shows the creation of an SQL database from six related csv datasets, focused on an organization containing over 300,000 employees. I also conducted queries in order to obtain specific pre-defined results.

Notifications You must be signed in to change notification settings

NeonOstrich/Business-Data-Analysis-Queries-in-SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Business Data Analysis: Queries in SQL

This is an assignment that I completed for the George Washington University Data Analytics Bootcamp, focused on analysis in SQL.

##Background In this project I am analyzing 6 csv datasets which are focused on an organization that contains over 300,000 employees. I will be conducting queries in order to obtain specific pre-defined results.

##Organization Within the sql-challenge repository, you will find this readme file in addition to three folders: data, Analyzing Data, and Screen Shots. The data file contains the 6 csv files that I will analyze. The Analyzing Data folder contains my SQL script for the analysis as well as the database design which I made QuickDBD, and which I used to generate the tables in SQL. And finally, within the Screen Shots folder, you will find screenshots of the database relationship structure that was created in QuickDBD as well as screen shots of the results of the 8 questions which I answered with my analysis.

Screen Shot 2023-03-01 at 2 53 09 PM

Q1

Q4

About

This project shows the creation of an SQL database from six related csv datasets, focused on an organization containing over 300,000 employees. I also conducted queries in order to obtain specific pre-defined results.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published