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
Pharmacy Sales & Profitability Analytics | Power BI
Developed an interactive Power BI dashboard to analyze the financial and operational performance of a pharmaceutical sales business from January to September 2026.
The dashboard tracks key KPIs including Revenue, Gross Profit, Gross Margin, COGS, Units Sold, and Unique Customers. It also analyzes monthly revenue and profitability trends, product category performance, supplier-related COGS, brand-level revenue and gross profit, and revenue distribution by customer type.
A key focus of the analysis is inventory efficiency, using Inventory Turnover and Days Inventory Outstanding (DIO) to show how quickly inventory moves over time and how long products remain in stock.
The dashboard also includes a P&L view, connecting sales performance with COGS, operating expenses, EBITDA, EBIT, taxes, and Net Income to provide a consolidated view of profitability.
Built in Power BI using Power Query, data modeling, and DAX measures, with interactive date filtering for period-based analysis.
Data ModelingData VisualizationFinancial AnalysisMicrosoft ExcelMicrosoft PowerPointMicrosoft Power BI
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
This is such a great example of turning complex data into a visual experience. 🎾🔥
Love how the court becomes part of the analytics instead of just sitting in the background. Really impressive work!
When does a sports dashboard need the court to be more than a background?
In this case, we were designing Deuce a tennis analytics platform that needed to make complex match data feel immediate and spatial, not just numerical.
The brief was clear: analysts and coaches don't just...
Sustainable Emission Tracker Dashboard
Sustainability platforms often bring together a large amount of environmental data.
The challenge is turning that information into something people can understand quickly.
For this Sustainable Emission Tracker Dashboard, we designed the experience around emissions performance, sustainability targets and progress tracking.
The interface uses clear metric cards, structured charts and visual indicators to create a more understandable view of environmental performance.
Rather than treating every data point equally, the dashboard creates hierarchy around the information users are most likely to monitor and act on.
Focus: Carbon Emissions Tracking · Sustainability Dashboard · ESG UI/UX · Data Visualization · Climate-Tech Product Design
The goal was to make complex environmental data feel structured, readable and useful.
Designed by WaxyWeb.
Building a sustainability or climate-tech product?
Excellent job!
Created an interactive Power BI dashboard to analyze loan applications, funded amounts, loan quality, and borrower trends. Used Power Query and DAX to clean data, create measures, and visualize key insights.
