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
Consolidated data from multiple Excel files and worksheets using Power Query, automated repetitive transformations, and created a structured, refreshable dataset.
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
Excel-based financial analysis and data reporting project focusing on structured data organization, budgeting, and performance metrics.
Built a 4-page Power BI dashboard analyzing hotel booking performance for AtliQ Grands across 25 properties in 4 Indian cities (Delhi, Mumbai, Bangalore, Hyderabad), covering May–July 2022.
Designed a star schema data model (dim_date, dim_hotels, dim_rooms, fact_booking, fact_aggregated_bookings) and built pages covering Executive Summary, Occupancy, Customer Insights, and a dedicated Caveats page documenting data limitations and QA methodology.
Key finding: weekend occupancy (51.85%) exceeded weekday occupancy (35.92%), and Delhi recorded both the highest occupancy (42.42%) and highest average guest rating (3.8/5).
🔗 GitHub: github.com/firdous-cloud-analyst/AtliQ-Grands-Hospitality-Performance-Dashboard
: Built an interactive Excel dashboard for retail sales analysis — 4 KPI cards, region/category breakdowns, monthly trends, and a salesperson leaderboard, all powered by live formulas (SUMIFS, SUMPRODUCT, COUNTIF) with no hardcoded numbers.
