Final-Project-Transforming-and-Analyzing-Data-with-SQL

Project/Goals

1. Ask the right questions
2. Clean the data appropriately
3. Create an ERD for the database
4. Do due diligence on quality assurance to verify results

Process

Loading CSV files into PGADMIN

1. Created new database inside PGADMIN titled ecommerce
2. Matched table and column names to line up adequately with CSV files

Cleaning data & Quality Assurance

1. Read and tackle the questions to understand what data needs to be cleaned
2. Started cleaning data

Answered questions

1. Answered starting questions first
2. Reflective and tried to ask meaning questions
   for starting data questions

Challenges

Asking the right questions and not trying to ask too many

The real challenge is reigning yourself in and not going off on tangets. As I worked through the project it became increasing difficult to focus on the initial questions asked and not to over complicate the process with the unending questions that would appear in my head.

Cleaning the data

This to becomes easy to overcomplicate by making sure you don't go Cleaning data you don't need, at least within the confines of this project

QA Process

I don't think I fully understand or can conceptualize the QA process as well as the other steps, more practice definetely needed