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
Built the Excel stage of a hospitality analytics dashboard for AtliQ Grands — the foundation
Designed KPI cards (Revenue, Bookings, Occupancy%, Cancellation%, ADR), pivot table analysis across occupancy, cancellation, loyalty membership, and booking channel, plus charts for revenue by category, booking status, and weekday/weekend performance.
Key finding: weekend bookings ran ~43% higher and weekend revenue ~44% higher than weekdays. Mumbai was the top revenue-generating city, and Delhi recorded the highest occupancy rate (42.42%).
🔗 GitHub: github.com/firdous-cloud-analyst/AtliQ-Grands-Hospitality-Performance-Dashboard
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
Claude
Claude has entered the design space. How are you using it?
Contra University
Learn from expert creatives how to earn more using next-gen AI tools.
Brand Design
The best brand designers are on Contra. Scroll to see what's trending in brand design. What are you building?
creativeaiflow
Creative AI workflows are evolving. What tools do you use, and what are their strengths and weaknesses?
freelancerlife
Freelancer life is wins, pivots, and everything in between. What’s yours right now?
Related posts
Cleaned and validated a messy CSV dataset, standardized dates and currency values, removed duplicates, flagged uncertain rows, and delivered a concise quality report.
Converted irregular PDF tables into a clean Excel-ready structure, normalized dates and amounts, flagged uncertain values, and added a QA summary.
Redesigned an existing SaaS affiliate dashboard while preserving the original design system.
The goal wasn’t to reinvent the product, but to improve usability through clearer information hierarchy, actionable insights, and more focused analytics.
Key improvements included:
• Interactive KPI cards driving contextual analytics
• Priority Alerts replacing redundant quick actions
• Improved dashboard hierarchy and typography
• Referrals and Top Offers overview
• Refined filtering and financial summary
My focus was on making the dashboard easier to scan and use without introducing unnecessary complexity.
Always happy to work on existing products where thoughtful UX improvements matter more than visual redesigns 🙌
