Skip to main content

Posts

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 ...
Post a Comment
Read more
Recent posts

DIGITAL TRANSFORMATIONAL STRATEGY: A MUST FOR TRADITIONAL BUSINESSES.

The Rising Importance of Digital Transformation. Digital transformation is now a survival strategy for established firms, not a luxury. Leaders in a variety of sectors, including banking, manufacturing, retail, and logistics, are using data, software, and artificial intelligence (AI) to remain resilient and competitive in volatile markets.  Fig. 01: Digital Transformation in Traditional Business.   The global investment data demonstrate how significant this change is: According to International Data Corporation , global spending on digital transformation (DX) is expected to reach around $3.9 trillion by 2027, indicating a trend of consistent double-digit growth. Nevertheless, research conducted by McKinsey & Company and BCG regularly demonstrate that only around 30% of digital transformation projects are successful in reaching their objectives, even with these massive investments. Execution, not technology, is the problem; adjustments in operating model, talent, and...
Post a Comment
Read more

CASE STUDY: ADOPTION OF E-COMMERCE AND DELIVERY APPS – CARGILLS FOOD CITY.

1. Introduction In Sri Lanka, the supermarket sector has grown to be a vital part of the retail industry, providing customers convenient and well-organized access to necessities. The Sri Lankan supermarket sector has demonstrated resilience amid economic challenges, contributing over 30% to national GDP and 14% to direct employment [Source: The Sunday Times, 2024 ]. Fig 01: A Picture of a Supermarket. Over the past 20 years, supermarkets like Cargills Food City, Keells, and Arpico have expanded their reach throughout urban and semi-urban areas. In addition to facilitating effective product distribution, the industry supports local supply chains, generates employment for thousands of people, and promotes economic stability in the country. Supermarkets have shown resilience in the face of economic difficulties, such as import constraints, currency fluctuations, and inflationary pressures, while customer demand for necessities has remained steady. As the Sunday Times (2024)  reve...
1 comment
Read more

HOW BUSINESSES USE PREDICITVE ANALYTICS TO STAY AHEAD.

Businesses are no longer depending only on past performance or intuition when making decisions in the fast-paced digital economy of today.  Fig. 01: Predictive Analysis. Rather, they're focusing on the future, use predictive analytics to predict trends, foresee customer needs, and make strategic decisions that help them stay ahead of the competition. What is Predictive Analytics? According to Harvard Business School , "Predictive Analytics is the use of data to predict future trends and events. It uses historical data to forecast potential scenarios that can help drive strategic decisions." According to research by Lim, et al., (2023) , "Predictive analysis is a type of analysis that makes use of different techniques for efficient and accurate predictions. This helps to improve the future outcomes leading to overall performance improvement." Simply put, the practice of forecasting future events using statistical models, machine learning algorithms, and historica...
Post a Comment
Read more

HOW TECHNOLOGY DRIVES BUSINESS GROWTH.

Technology is no more merely a business support system in today's fast-paced world; rather, it is a key factor in innovation, growth, and competitiveness. The relationship between technology and business is growing more significant, vital, and revolutionary than ever. Figure 01: Business with Technology                                                         Staying ahead of the competition requires knowing how technology drives business success, whether you're a corporate leader, startup founder, or business and innovation student. Here is how technology is accelerating business success: 01. Artificial Intelligence Powered Decision Making. Businesses' usage of artificial intelligence is increasing frequently to foresee trends, analyze data in real time, and make quicker, more informed decisions.  According to a 2022 McKinsey survey , 63% of pa...
Post a Comment
Read more