This Power BI report will take you on a journey through three years of Nigeria's Agricultural Export
Context: Our fictitious dataset encompasses detailed export data, including metrics such as export value, units sold, number of shipments, and profit. The data is segmented by products, companies, destination countries, and periods, providing a comprehensive view of export performance over multiple years.
Business Questions addressed:
- Which products and companies are driving our export performance?
- How do the key performance indicators vary year over year?
- What are the trends in export value across different years?
- How does our export performance differ across destination countries?
Techniques Used: To craft a compelling data storytelling experience, we employed the following techniques:
Interactive Visuals:
- Card Visuals: Key performance indicators such as total export value, units sold, profit, and profit percentage are presented in card visuals for quick insights.
- Line and Lollipop Charts: Trend analyses are shown using line and lollipop charts, comparing current and previous year export values.
Dynamic Slicers:
- Year Slicer: Allows users to filter data by specific years to see how metrics change over time.
- Destination Country Slicer: Dedicated slicer for selecting destination countries to analyze export performance metrics.
inPage Navigator and Bookmark Navigator:
- inPage Navigator: Users can toggle between views of products, companies, and export value trends using the page navigator buttons.
- Bookmark Navigator: Provides a streamlined way to switch between different visualizations and analysis points.
Conditional Formatting:
- Visuals are dynamically colored to highlight positive and negative performance changes, enhancing data readability and interpretation.
User-Guided Tour:
- A guided tour feature helps users navigate through the report, presenting a business question at each visual and explaining how the visual answers it.
Feel free to explore the report and see how these techniques bring the export data to life!
