The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
❌ PROBLEM I saw:
One company had Excel with 2000 employees. They knew attrition is high, but didn't know WHICH Job Role has highest attrition.
They were guessing.
I analyzed it.
✅ WHAT THIS CHART SHOWS :
In this HR Dashboard - Attrition Rate by Job Role:
Sales Executive: 25.0% attrition (Highest!)
Laboratory Technician: 23%
Research Scientist: 16%
Research Director: Only 2%
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Trending
retrofuturism
Share your favorite designs from the past exploring the distant future. Or your own take on the aesthetic 🚀
halftone
Dots. Texture. Grain. Let's see your designs using the halftone technique.
Midjourney
Creatives are showing off what they're making with Midjourney.
colorgrade
Video editors sound off: How do you enhance the mood of your video in color grading?
Related posts
From Messy Data → Decision-Ready Data 📊
Cleaned, validated & analyzed an e-commerce dataset using Excel + Pivot Tables.
Raw data → Clean data → Clear insights.
📌 Portfolio demonstration using sample data.
#DataAnalysis #Excel #DataCleaning #Ecommerce .
Project Title: Hotel Revenue & Margin Optimization Engine
Role: Data Analyst / BI Developer Tools: Tableau, SQL (SQLite)
The Overview Most hospitality businesses celebrate top-line gross revenue but lack visibility into the millions bleeding out through third-party OTA commissions. I built an end-to-end data pipeline and interactive executive dashboard to transition a hotel’s focus from Gross ADR to true Net Profitability.
The Problem The client had a pipeline of 119,000+ bookings generating $26M in gross revenue. However, they had no automated way to track the $3.8M lost to commission leakage, nor could they pinpoint which customer booking behaviors were driving these losses.
My Solution I engineered a Dynamic Pricing & Revenue Engine designed for senior leadership:
Data Modeling (SQL): Wrote complex queries utilizing Common Table Expressions (CTEs) and Window Functions to dynamically calculate Net ADR and aggregate commission costs across multiple distribution channels.
Executive Dashboard Design (Tableau): Developed a low-cognitive-load, Dark SaaS-themed UI. I applied strict semantic color coding (Teal for retained profit, Muted Coral for commission loss) to instantly guide executive attention to critical margins.
The Impact & Insights
Isolated exactly where the $3.8M in revenue leakage was occurring.
Revealed a major vulnerability in "Long Lead" bookings (90+ days in advance), empowering the management team to adjust dynamic pricing and minimum length-of-stay restrictions.
Provided an interactive, filterable tool for regional managers to assess profitability between City and Resort properties in real time.
Need clarity on your business data? I combine hands-on operational hospitality experience with advanced data analytics to build tools that drive strategic decisions. If you need to uncover hidden revenue or upgrade your reporting infrastructure, let’s collaborate.
Small Business Social Audience Audit & Growth Analysis
A data-driven performance audit analyzing audience metrics, visibility trends, and user conversion funnels to pinpoint growth opportunities for an online brand presence.
