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
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 & MID: To extract hidden codes and status keys from the Employee ID.
-VLOOKUP & HLOOKUP: To instantly pull data from reference tables using the extracted codes.
-IF & SUM: To handle dynamic allowance logic and calculate final net pay.
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
Bonus Analysis: Position Gains & Teammate Lockouts (Vettel vs Verstappen)
Two supplementary charts from the main project, covering metrics that didn't fit the primary scorecard.
Average position gained per race — measures whether a driver typically finished ahead of or behind their grid slot. Verstappen's 2023 (+1.9) is the only positive season across both drivers' combined 8 title years.
1st & 2nd lockouts with teammate — tracks how often the champion and their teammate swept the podium's top two spots. Verstappen's 2021 (closest title) had zero; his 2023 (most dominant) had six.
💎 Luxury Retail Performance Dashboard
Description:
Built a professional Luxury Retail Performance Dashboard to help premium retail brands monitor sales performance, understand VIP customer behavior, compare store performance, and drive revenue growth through data-driven insights.
This dashboard provides a comprehensive overview of Premium Sales, VIP Customers, Product Performance, Store Comparison, Revenue Growth, and Customer Insights, enabling luxury retailers to identify high-performing products, evaluate store performance, analyze customer purchasing behavior, improve customer retention, and maximize profitability.
Developed using Microsoft Power BI, SQL, and Microsoft Excel, the dashboard features executive-level KPI cards, interactive visualizations, premium customer segmentation, sales trend analysis, store comparison reports, and dynamic performance metrics. It transforms complex retail data into actionable business intelligence, empowering organizations to deliver exceptional customer experiences and make strategic business decisions.
Key Features
💎 Premium Sales Performance Analysis
👑 VIP Customer Insights & Segmentation
🛍️ Luxury Product Performance Tracking
🏬 Store Comparison & Benchmarking
📈 Revenue Growth & Profitability Analysis
📊 Executive KPI Dashboard with Interactive Reports
Client Note
Looking for a customized Luxury Retail Performance Dashboard tailored to your business? I design premium, executive-level Business Intelligence dashboards that transform complex retail data into meaningful business insights. Every dashboard is customized to your business objectives, helping you monitor premium sales, understand VIP customer behavior, compare store performance, optimize product strategies, and accelerate revenue growth. If you're looking for a high-quality, professional dashboard that combines elegant design with actionable analytics, I'd be happy to build a solution that supports your business goals and delivers measurable value.
📊 CEO Executive Business Command Center
Description:
Built a professional CEO Executive Business Command Center to provide executives with a centralized, real-time view of critical business performance metrics for faster, smarter, and data-driven strategic decision-making.
This dashboard provides a comprehensive overview of Company Revenue, Profit Margin, Sales Growth, Customer Growth, Financial KPIs, and Business Health Score, enabling executives to monitor overall business performance, evaluate financial health, identify growth opportunities, measure operational efficiency, and make informed executive decisions with confidence.
Developed using Microsoft Power BI, SQL, and Microsoft Excel, the dashboard features executive-level KPI cards, interactive visualizations, financial performance reports, trend analysis, business health indicators, and dynamic drill-down capabilities. It transforms complex enterprise data into clear, actionable insights, empowering leadership teams to monitor organizational performance from a single, intuitive dashboard.
Key Features
📈 Company Revenue & Financial Performance Analysis
💰 Profit Margin & Business Profitability Tracking
📊 Sales Growth & Customer Growth Monitoring
📋 Executive Financial KPI Dashboard
❤️ Business Health Score & Performance Monitoring
🎯 Interactive Executive Reports & Strategic Insights
Client Note
Looking for a customized CEO Executive Business Command Center tailored to your organization? I create premium, executive-level Business Intelligence dashboards that consolidate key business metrics into one powerful decision-making platform. Every dashboard is designed to provide real-time visibility into revenue, profitability, customer growth, financial performance, and overall business health. With a strong focus on usability, visual excellence, and actionable insights, I deliver dashboards that help executives make faster, more confident strategic decisions. If you're looking for a professional solution that delivers measurable business value and executive-level reporting, I'd be delighted to build a dashboard customized to your organization's goals.
