Logistics: Power BI

Explore my portfolio here: https://francescostara.com/. Client Problem: The operations team of a logistics company suspected irregularities in revenue and cost data for May and June 2024. They needed a clear, interactive Power BI dashboard to identify:

Potential revenue leakage

Inefficient routes or customers

Cost distribution between carrier and own fleet

Week-over-week and month-over-month profitability trends

However, the raw dataset had:

Incorrect cost carrier values (inflated by decimal issues)

Loaded the dataset in Python for initial EDA and data quality checks

Identified Cost Carrier discrepancies and recalculated using: Revenue - Gross Profit - Cost Contractor

Cleaned and trimmed text fields in Power Query

Created an Is_International column for domestic vs international route analysis

Built a star schema for clarity and performance:

Established proper relationships and cardinality

Built key KPIs:

Highlighted low-profit or loss-making shipments with a Leakage Status field

Designed intuitive dashboard pages with slicers and cards

Created a dynamic bubble map to show Profit, Revenue, and Cost by Sender Country

Included breakdowns by customer, route, and international status

84% of revenue came from international shipments

One single route contributed over 18% of total revenue

Several routes and customers were operating at a loss

Carrier services made up 91% of cost base — highlighting optimization potential

Result: The final dashboard gave the client a detailed view of cost structures and performance drivers. It empowered the operations team to spot loss-making routes, optimize fleet usage, and improve profitability — all through a clear, stakeholder-friendly interface.