In this portfolio, you will find several projects that showcase my skills and experience in SQL. Each project is unique and presents a different set of challenges and opportunities for me to demonstrate my abilities.
The objective of the project is to Analyze Trading Volume by Currency Pair.By using SQL queries to extract different insights from the data and gain a better understanding of the trading activity on the cryptocurrency exchange.
- To analyze the trading volume of different currency pairs on a cryptocurrency exchange.
- To calculate the total trading volume for each base currency.
- To calculate the average trading volume for each currency pair.
- To calculate the trading volume for each currency pair by day.
- To find the top 10 currency pairs by trading volume.
- To find the trading volume for each currency pair for a specific date range.
- To find the top 10 currency pairs by trading volume for a specific date range and hour of the day.
The objective is to segment customers based on their demographics and purchase history, and identify patterns and trends in their behavior. This project is based on a problem I encountered during my internship so the data source is confidential.
- This code will retrieve the customer data, and create new columns by segmenting the data based on income, age, and purchase frequency. Then it will group the data by these segments and count the number of customers in each segment.
- You can use this code to run the query on your database and see the results, which will be a table showing the size of each segment and the patterns and trends of the customer data.
For the Instagram cloning project, I worked on instagram cloning data which would allow users to analyze their Instagram data and gain insights into their behavior and performance on the platform. The project aimed to demonstrate my ability to work with data, extract insights, and communicate the results effectively.
International Debt Statistics (IDS), successor to Global Development Finance and World Debt Tables, is designed to respond to user demand for timely, comprehensive data on trends in external debt in low- and middle-income countries. we are gonna analyse and find the trends in the international debt data provided by the international debt statistics.
We are going to find the answer to questions like:
- What is the total amount of debt that is owed by the countries listed in the dataset?
- Which country owns the maximum amount of debt?
- What is the average amount of debt owed by countries and the reason for the loan grant?
For the stock market data analysis project, I worked on analyzing historical stock market data to gain insights into market trends and to identify patterns and relationships that could be used to inform investment decisions. The project aimed to demonstrate my ability to work with large datasets and communicate the results effectively through visualizations and reports.