The Colony Scent Sales Dashboard for 2020

I designed this Excel dashboard tailored for The Colony, where I systematically organized and refined the dataset to ensure accuracy. The foundation of this visualization involved employing pivot tables to distill complex data into a comprehensible format.

Opulent Sip Sales Dashboard For 2014 - 2015

Utilizing Excel, I designed a dashboard for Opulent Sip, revealing key insights such as the highest income-generating liquor product, the city boasting the highest sales, and a comprehensive sales trend spanning from 2014 to 2015. The process involved systematic data cleaning, sorting, and filtering

2015 - 2021 Annual Compensation Dashboard for Splittify

I developed a comprehensive compensation dashboard for Splittify, meticulously illustrating the intricacies of staff remuneration. The dashboard highlights top earners, identifies departments with varying compensation levels, and provides insights into how each department compares to others in terms

SQL Investigative Analysis

In this project, I conducted an investigative analysis using SQL to solve a murder mystery. By leveraging advanced SQL queries, including HAVING, LIMIT, and JOIN statements, I systematically analyzed the data to identify the murderer and uncover the mastermind behind the crime. This project showcase

SQL + POWERBI AVIATION OPERATIONS DASHBOARD

The Aviation Operations Dashboard is an essential tool for aviation professionals, providing key metrics on aircraft and airline performance. The Aviation Operations Dashboard provides key insights into aircraft manufacturer market share, fleet composition, airline reach, and landing frequency etc.

SQL + POWERBI MISON'S PRODUCTS REVIEW DASHBOARD

In this project, I performed an in-depth SQL analysis on a coffee sales and consumption dataset, showcasing my expertise in SQL for data manipulation, querying, and deriving actionable business insights.

2006-2020 PETKOFF CHANNEL SUBSCRIBER ANALYSIS DASHBOARD

In this project, I developed a dashboard to analyze a subscriber channel. The analysis includes channel type distribution by category rank, subscriber distribution by country, and total subscriber count per channel, providing comprehensive insights into subscriber metrics.

POWERBI WHATSAPP MESSAGES ANALYSIS

n this project, I conducted an analysis of the WhatsApp messages from the Data School Cohort 9A group chat. Using Power BI, I created a dashboard to visualize various insights derived from the message data.

SQL + POWERBI GLOBAL SUPERSTORES SALES ANALYSIS DASHBOARD

In this project, I conducted a thorough analysis of the Global Superstore sales data, which involved multiple stages of data handling and interpretation. The initial phase focused on data cleaning using SSMS. To ensure the dataset was structured appropriately for analysis