GlobalSmile Data Analyst Portfolio

A data analyst skilled with the necessary technical and soft skills that will contribute to the success of the business and an outstanding approach to problem solving.

Optimizing Inventory Management - SQL & Power BI

SellCheapy Retail is a chain of department stores that sells a wide range of products, including bikes and different components. Despite having a large customer base, the company has been struggling to increase sales in recent years. The management team is looking to use data analysis to understand customer spending patterns and make changes to their sales and marketing strategies to improve performance.

Impact of Weather Conditions on Air Quality - Excel& Power BI

A company in the environmental consulting industry is seeking to analyze the air quality in a specific city during hot and cold weather, during high-wind conditions and during precipitation. They are interested in making recommendations to the government and businesses in the region on how to mitigate the impact of weather conditions on air quality.

Olympic Games Analysis - SQL & Power BI

The purpose of this Olympic Games analysis is to visualize data that will help readers understand how countries have performed historically in the summer Olympic Games. There is also an interest in the details about the competitors.