Skip to main content

Posts

Showing posts from September, 2025

A STEP INTO BUSINESS ANALYTICS: CREATING AN INTERACTIVE SALES DASHBOARD FOR BAIRAHA FARMS PLC.

As part of my journey into business analytics , I recently created an interactive sales dashboard in Excel for Bairaha Farms PLC . About the Company Fig. 01: Logo of Bairaha Farms PLC. Bairaha Farms PLC is one of Sri Lanka’s leading poultry producers, well-known for its contribution to the nation’s food industry. The company is engaged in poultry breeding, processing, and distribution, delivering fresh chicken and related products to supermarkets and households across the country. What My Dashboard Shows This dashboard focuses on sales data for August 2025 , bringing the raw numbers to life through clean and interactive visuals. It highlights: πŸ“Œ Units Sold by Product (chicken, sausages, drumsticks, etc.) πŸ“Š Total Sales by Region and Distributor πŸ’‘ Key KPIs such as Sales Revenue, Average Sales, Profit, Total Cost of Goods Sold and Units Sold. πŸ“ˆ Trends and insights to quickly understand sales performance Here’s a quick preview of the dashboard: Fig. 02: A Preview ...