Overview
The repositories contain a collection of projects and exercises completed during the Analiza Data Analyst Practicum and continuing daily SQL and Python + Pandas libraries exercises on Stratscratsch. The projects focus on SQL, Excel, data analysis, and visualization using tools like SQL Server, Tableau, and Python.
Projects Summary
1. SQL Summary Exercises
A collection of SQL exercises aimed at strengthening SQL Server querying, data
manipulation, and database management skills.
Libraries Used: SQL Server
A collection of SQL exercises aimed at strengthening SQL Server querying, data
manipulation, and database management skills.
Libraries Used: SQL Server
2. Excel Summary Exercises
A series of Excel exercises designed to improve proficiency in data manipulation, formulas, functions, and visualization within Microsoft Excel.
Libraries Used: Microsoft Excel
A series of Excel exercises designed to improve proficiency in data manipulation, formulas, functions, and visualization within Microsoft Excel.
Libraries Used: Microsoft Excel
3. Fast & Furious Final Project
Data analysis report using MS SQL Server and Tableau for Fast & Furious, a bicycle manufacturer and retailer. The project aims to leverage stored data to provide strategic insights for decision-making across nationwide stores.
Libraries Used: SQL Server, Tableau, Excel, Statistics
Data analysis report using MS SQL Server and Tableau for Fast & Furious, a bicycle manufacturer and retailer. The project aims to leverage stored data to provide strategic insights for decision-making across nationwide stores.
Libraries Used: SQL Server, Tableau, Excel, Statistics
4. Northwind Summary Project
Data analysis report using MS SQL Server and Tableau for Northwind, a leading provider in the food industry. The report focuses on identifying opportunities to enhance profitability through strategic initiatives.
Libraries Used: SQL Server, Tableau, Excel, Statistics
Data analysis report using MS SQL Server and Tableau for Northwind, a leading provider in the food industry. The report focuses on identifying opportunities to enhance profitability through strategic initiatives.
Libraries Used: SQL Server, Tableau, Excel, Statistics
5. Daily StrataScratch Exercises
A compilation of daily SQL and Python (Pandas DataFrame) exercises from StrataScratch, designed to enhance practical skills in data querying, manipulation, and analysis.
Libraries Used: SQL Server, Python (Pandas, NumPy)
A compilation of daily SQL and Python (Pandas DataFrame) exercises from StrataScratch, designed to enhance practical skills in data querying, manipulation, and analysis.
Libraries Used: SQL Server, Python (Pandas, NumPy)
Tools used
