Clothing Sales Store Analysis (Guided Project)

Excel dashboard showing key metrics and insights of clothing sale performance for the year 2023. This project is presumed to be the sales of clothing from a multi-online shopping platform in India. The dataset contains sales data of 10k distinct orders from January to December.

Covid 19 Dashboard Analysis (Guided Project)

Project involves acquiring global COVID-19 data and then imported into MySQL database for the cleaning & exploration process. This project is guided by the YouTube channel Alex The Analyst, however, SQL queries are partially different. Visualization demonstrates future prediction of infection rate

Hotel Revenue Dashboard (Guided Project)

The personal project revolves around the analysis of key revenue trends for years. It's demonstrated an informative dashboard of total revenue, average hotel daily rate, and reservation trends between hotels over the years.

Sales Insight - Profit Analysis (Guided Project)

Profit analysis project by performing ETL using SQL. The data has been employed as needed using CASE, VIEW, JOIN, and others. Visualization includes profit trends, profit margins, and revenue. Profit margins provide insights into sales efficiency while revenue shows overall sales performance.

Data Cleaning - Household Income & Expenditure in Malaysia (Unguided Project)

This project focuses on cleaning data in MySQL by identifying and correcting errors. Data manipulation used in this project includes format date, data splitting into two columns, inserting data, filling in null values, updating missing strings, and joining tables.

Factory ABC Accident Performance Dashboard (Unguided Project)

Provide safety & accident-related information for year 2023. Main key indicator to measure company's safety performance is Total accidents, Lost Time Injury Rate (LTI), Severity Rate, Accident Trend, Training & Accident Agent. The data has been extrapolated through MySQL & visualize in Tableau.

AtliQ' Mart Sales Analysis (Unguided)

AtliQ Mart, which is a retail giant with over 50 supermarkets in the southern region of India ran a massive promotion during Diwali 2023 and Sankranti 2024. This insight is intended to identify which promotion did well. KPIs Include: Incremental Sold Units (ISU), Incremental Revenue (IR) & Revenue

AtliQ Hotel Analysis (Guided Project)

Hotel Analysis Project by identifying key metrics for hotel domain. This project fully utilizes Power BI as analysis tools to measure important key metrics such as Revenue, Occupancy, Average Daily Rate and etc.