Create Your First Project
Start adding your projects to your portfolio. Click on "Manage Projects" to get started
SQL Database Analysis in Excel
Location
Charlotte, NC
Date
September 2022
Project type
Database Coding & Excel
Role
SQL Database Researcher
Class
BUSN 220, Management Information Systems
In-depth analysis of a hypothetical tutoring business with a database. Then used SQL queries to export necessary data from the database and import into Excel for further analysis. This project features coding from a database as well as advanced functions of Excel using formulas, pivot tables, data slicer, and timeline functions.
In this assignment, I learned how to write SQL queries to pull data out of a database and organize it in a meaningful way that is useful to an organization. I also learned how to use some advanced features of Excel which would be advantageous in virtually all career settings. Knowing how to make sense of data is a valuable skill that can give an organization a competitive advantage. If I could do this assignment again I would spend more time learning how to use SQL in the DataCamp tutorial. There is a lot of information available on the DataCamp site that would be advantageous for me to learn how to do it.



