AdwoaSQL-Portfolio

Data Analyst Portfolio using the following tools:

• MySQL
• Visual Studio Code
• Power BI

Project 1: Exploratory analysis of a company with mulitple datasets

• Datasets included in the project include company employees, company regions and company departments

• Performed analysis on each table, joining other tables where necessary

• Queries include basic select, from, where clauses as well as intermediate commands like cast, coalesce and rollup.
• Power BI Insights

Project 2: Analysis of multibranch store with 113,036 Transactions

• Dataset with 113,036 rows/transactions.
• Insights on customers, branches in different countries, and profit and revenues in different years.
• Power BI Insights

Project 3: Projects from Khan Academy

-Created tables and inserted values into them. -Performed joins, including left outer joins and self joins