Project:
Develop SQL skills set
SQL is undoubtedly the principal gatherer of information around the world. Most of the organizations gather their data on top of this language? Tool?. A Data Analyst, even if do not contact with it on its role, must know the foundation of it, as he will be working with Data. Either gathering it, cleaning it, transforming it, loading it. For sure he will be handling a lot of Data. Absolutely certain is that he will be analysing data, and for that is crucial to know how to generate Data from Data, either querying it, creating it, transforming it, so a deep knowledge about this is fundamental.
Source
Tools
SQL Server 2022 | Excel | Python | PowerBI
Challenge
Target
Create a relational Database in SQL with the Olist Datasets.
What did we do?
Data Analysis – Data Transformation – Data Quality.
Data import – Create Database
SQL querying mastery
…
2 main tools: SQL & PowerBI
Also a bit of Python to understand how i could have used it for the ETL and EDA stages.
1 Week
Project
50 SQL Exercises approaching all areas thoroughly.
Have an idea? Contact me!
Home
Lisbon, Portugal
Contact us and provide details about your inquiry. Our team will get back to you soon.