Hint: Press the bold words throughout the text!
I started off with a Excel Spreadsheet containing all of my data. The only problem is that the data was unnormalized. I normalized the spreadsheet data by putting it into third normal form to remove redundancy and maintain data integrity.
I had a clear visualization of the entities and attributes. This information was critical for my design of a data model. I ended up creating a data model on erwin Data Modeler by connecting these entities through branches. Once I finished designing this data model, I forward engineered it into SSMS. This turned my data model into a database, filled with different tables and attributes.
I went back to my Excel file to access the company's data. Using different Excel techniques, such as concatenation, I was able to create all of my "INSERT INTO" statements. I copied and pasted these statements into a SQL query and it imported the data into these tables.
I performed 12 different SQL statements by using subqueries, JOIN, and aggregate functions to answer different analysis questions.
View the rest of the code on Github!
Here is my full report.