Rheznandya Alisya

Travel Package Analytics Dashboard 📊✈️

An interactive Excel dashboard designed for travel agencies to track sales performance, booking conversions, and key business metrics in one place.

Key Highlights:

- KPI Tracking: Displays total Net Revenue (Rp 776.9M - excluding...

Turning complex spreadsheet noise into clear business insights! 📊

This project shows how raw sales order records can be converted into a user-friendly, interactive dashboard. Designed to help business owners and managers track revenue trends, monitor segment performance, and spot top-selling products in just a few clicks.🙌

HR & Salary Analytics Dashboard🙌

Excited to share my interactive HR & Salary Analytics Dashboard built in Microsoft Excel! Designed to help HR managers efficiently track compensation and employee metrics. Key Highlights:

-KPI Cards: Instant view of Headcount, Gross & Net Salary,...

The reference codes needed for the tables were mixed inside the Employee ID (like DR-K1.1995012), not written in separate columns. So, standard lookup formulas couldn't work normally.

Instead of manual inputs, I built advanced nested formulas to automate the entire process:

-LEFT...