Nigeria Agricultural Export

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:

1. 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.
2. 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.
3. 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.
4. Conditional Formatting:
   • Visuals are dynamically colored to highlight positive and negative performance changes, enhancing data readability and interpretation.
5. 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.