Farm Performance Management Dashboard | Microsoft Excel without VBA | Video Tutorial #2

Farm Performance Management Dashboard - Advanced Excel Analytics Tool

The first video tutorial is here!

Courses & Playlists:

0:00, Dashboard overview
0:40, Daily farm records Title
01:11, Insert Pivot table for the KPIs
04:51, Pen house slicer and dates Timeline
06:26, Total flock stock in the Beginning and in the end
10:20, Total birds mortality
11:32, Egg Production, Cumulative Eggs and Trays
15:33, Total Feed Intake, Eggs Cost and weights
17:17, Breed Names, Stocking Date, Hatched Date, and Birds Age
21:07, Daily Egg Register
25:51, Comments and notice bar
28:33, Dashboard Protection
30:06, Final dashboard design

Enhance your agricultural operations with the Farm Performance Management Dashboard, an advanced Excel Dashboard designed by Other Levels. This innovative tool empowers farmers, managers, and agribusiness professionals to monitor and optimize farm performance with precision and ease.
Comprehensive Farm Analytics
Track key metrics such as daily bird weight, feed intake, egg production, and mortality rates across multiple pen houses. Starting from week 12 up to week 90, the dashboard delivers insights into actual weights, bird counts, and averages for effective flock management.

Optimize your farm’s profitability with in-depth financial metrics, including Yearly and Monthly Revenue, Operational Profit, and Net Profit. Keep track of expenditures like workers' salaries, utilities, transportation, maintenance, and veterinary fees, ensuring a clear understanding of your working capital.

Stay on top of your inventory with detailed records of feed stocks, unit prices, and available quantities. The integrated Egg Register provides a comprehensive view of stock trays, sales, and closing balances, supporting seamless inventory management.
Built with an intuitive interface and dynamic visuals, this dashboard makes complex data easy to interpret. Features like slicers and pivot tables allow users to filter and analyze data based on specific criteria, providing actionable insights at a glance.

Key Features

Daily Bird's wight record For three Pen Houses:
Starting from week 12 until week number 90, showing the actual weight, count of birds, and average weight.
Daily record for the following:
Full Date
Year
Month
Day
Stocking Date
Flock Number
Pen House
Breed Name
Hatched Date
Birds Age Days
Birds Age Weeks
Beginning Stock #Flock
Total Mortality
End Stock #Flock
Cumulative Mortality
Cumulative Eggs
Cumulative Egg Trays
Egg Production %
Total Feed Intake (Kg)
Feed Conversion g/egg
Feed Conversion cost (N)/egg
Total Stock (Trays)
Sales (Trays)
Closing Stock (Trays)
Income Details:
Yearly Revenue
Monthly Revenue
Yearly Operational Profit
Monthly Operational Profit
Yearly Expenditure
Monthly Expenditure
Yearly Net Profit
Monthly Net Profit
Total Monthly Working Capital Expenditure:
Monthly Working Capital Expenditure 
Workers Salary
PAYE
Transportation
Maintenance
Veterinary Service Fee
Security
Feed Inventory
Feeds Name
Unit Price
Quantity in Stock

------------------------------------------------------------
Welcome to Other Level’s,
Your go to resource for unlocking the full potential of Microsoft Office.
Whether you're looking to enhance your skills in Excel, Word, PowerPoint, or data analysis, we simplify complex tools with clear, easy to follow tutorials.

Master Microsoft Office with Step by Step Tutorials and Expert Tips!

What sets us apart:
- Comprehensive breakdown of essential formulas, digital designs, and data visualization techniques.
- Straightforward, impactful videos focused on real world business applications.
- We create professional dashboards that help you elevate your productivity and projects.
- No unnecessary jargon just relevant content that helps you master Microsoft tools efficiently.
- Honest, relevant titles and thumbnails that reflect the value we deliver in every video.

Join us and transform the way you work with Microsoft Office.
Every second of our content is designed to help you succeed!

Copyright © 2025 Other Level's. All rights reserved.
"Any illegal reproduction of this content in any form will result in immediate action against the person concerned."

#Farm_Performance_Management #Excel #Dashboard

[RovyDigitalArt]

OMG, You Are the Best MVP Excel in the world, this will destroy Power Bi and the all complicated softwares ⭐️

[mohammadtanveermalik]

The voice over is so attracting....Perfect explaing the whole day

[mohammadtanveermalik]

I have seen so many dashboards, but Other's Level is just amazing. No words to admire. Attractive, self explanatory and the look is beautiful. Really what an extra ordinary effort without VBA coding. Its something special. God bless you.

[mohammadtanveermalik]

Just awesome. Want to kiss the hands of the creator of this dashboard.

[ismaelkourouma]

Thank you for sharing, very usefull as usual. I have increased my Other Level's with this again (fully completed). Great ! Should be good to have somewhere where we can share what we are learning with you, not only what we reproduce as this one. You should think about about it. It's increadible your exceptionnal capacity to sharing great things like this and helping people to grow their skills.

[cassioalexan]

Great new video, as usual!
I hope someday you create a dashboard which contains the revenues and expenses of a company, or even personal finances. I'm trying to make something like that, but I don't feel I'm being successful. I'd really enjoy if I could get some inspiration from this channel. You make such awesome dashboards that delight our eyes! Congrats!

[KHANDiagnostics]

Your videos are amazing and you are a great teacher Please I'm looking for something to track my employees training what different courses this can you show us some simple it's awesome simple way and look amazing the way you make yourI really appreciate it
If it's possible please can you show us how to make the excel sheet for employees training

[martinmendez]

I love your work! Really great ! Thanks for share!

[roycemekolle]

Hi other levels. once more I want to say thank you for always sharing your stunning works. they are truly inspirational and i have learn a lot from your videos. I will like you to help me with a problem I often run into. So when i create a dashboard on my Laptop I always make it full screen but then given the screen is small when this dashboard is being opened on a bigger screen it doesn't cover the screen so doesn't look nice. On the other hand when i create on a bigger screen and open on the smaller one you will have to be using the horizonal and vertical scroll bars to see the full dashboard. please is there a way around this?

[aventuraspensadas]

I would like to learn how to make a system like this for managing civil engineering works, could you help me?

[darksoul]

any dashboard to manage inventory?
I mean including any addition of inventory (stock) and/or indications of shortage of a particular inventory(Stock). Please suggest.

[mrgr]

Please do gantt chart and s-curve for us engineers

[IMRAN_Alam]

Hello Mam
Thanks for sharing
Earning much knowledge from your videos.. I would like to draw your attention please make industrial Daily weekly monthly yearly report dashboard..Which includes plan/actual production, raw Materials consumption, Yield %, quality, supply.

If you need any data please for the same please give your mail

[tolkinmarimov]

Super
I sent you a letter to your mail

[HamzaKhan-bppl]

can we get the dataset for this dashboard?

[baliflorent]

can excel support 2 000 000 lines ? If no, how can we solve this problem ?

[owen]

Keep up the awesome work. Crush your competition with P R O M O S M!!

[mykolaovdiichuk]

Ніколи б і не подумав що в екселі можна робити такий аналіз

[RisterSantory]

Жаль не по русски, ничего не понимаю.