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
Using logical formulas is essential for automated data categorization and reporting. This project demonstrates how to apply IF, IFS, COUNTIF, and SUM functions in Excel to process sales data effectively:
-IF Function (Binary Logic): Automatically flags whether a transaction is "Untung" (Profit) or "Rugi" (Loss) based on a single condition.
-IFS Function (Multi-tier Logic): Handles multiple conditions to classify sales performance into tiered categories ("Low", "Medium", "High") based on revenue thresholds.
-COUNTIF Function (Data Aggregation): Calculates the exact number of transactions that fall into each specific performance category.
-SUM Function (Totaling Data): Computes the grand total of all transactions to ensure complete data reconciliation in the summary table.
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
Related posts
RouteMind is a multi-tenant fleet management SaaS with live GPS tracking and an AI voice agent for operators. I built the full stack and the AI layer end to end.
The hardest part was the data architecture. Structured records like fleet profiles, driver data, and route history sit in MySQL. The high-frequency GPS event stream, which would choke a relational setup, runs through MongoDB instead. Vehicle positions render on a live map with latency low enough that movement feels real-time. That split is what kept the dashboard fast while thousands of GPS events landed every minute.
The AI layer is a voice agent built on a RAG pipeline and the OpenAI API. Operators call in, and the agent retrieves from a vector database of indexed fleet policies and route procedures before answering, never generic output. Questions outside its scope trigger a clean handoff to a human.
The platform is fully multi-tenant with strict data isolation between businesses. Roles and permissions are set from the dashboard, so onboarding a new operator needs no code change.
What the client gets: live fleet visibility, an AI agent that answers policy questions without tying up staff, and an architecture that holds up as the fleet grows.
Great work! my fyp was about Driver's behaviour analysis (dowsiness, distraction detection ) for fleet transportation system and generating alerts while danger is detected.
Power BI Hospitality Dashboard — 11-Page Hotel & Booking Business Intelligence Report
Business Problem: A travel and tourism client needed a centralized system to track bookings, payments, hotel performance, and supplier relationships across multiple properties.
Tools Used: Power BI, DAX, Power Query
KPIs Tracked: Total Sales ($365K), Total Profit ($165K), Profit Margin (45.2%), Total Bookings, Hotel Performance by Agent
Insights Discovered:
• Profitability: Achieved 45.2% profit margin across all hotel operations
• Operational Scope: 11 interactive pages covering Bookings, Payments, Transport, and Meal Services
• Supplier Analysis: Supplier vs Client comparison enabled cost optimization
Trending
Claude
Claude has entered the design space. How are you using Claude Design?
Contra University
Learn from expert creatives how to earn more using next-gen AI tools.
fifaworldcup2026
The World Cup is here and the whole world's watching. How are you designing for the world stage?
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?