Course Outline:

Module 1: Understanding Trade Data Ecosystems

• Key trade databases (UN Comtrade, ITC, WTO, WITS)
• Trade classifications: HS, SITC, ISIC
• Data formats and limitations
• Case Study: Analyzing Kenya’s trade with East Africa

Module 2: Trade Data Cleaning and Transformation

• Handling missing, duplicate, and inconsistent data
• Using Excel and Power Query for data wrangling
• Data normalization techniques
• Real-Life Project: Preparing a clean export dataset

Module 3: Trade Analysis Techniques

• Export/import trend analysis
• Country, product, and partner profiling
• Comparative advantage measurement
• Case Study: Identifying leading export sectors for SMEs

Module 4: Trade Data Visualization

• Data dashboards using Power BI/Tableau
• Interactive visual storytelling
• Custom trade dashboards
• Real-Life Project: Building a dashboard for an export product

Module 5: Communicating Trade Insights

• Writing policy briefs using data
• Reporting and presentation skills
• Integrating trade data into national planning
• Case Study: Preparing a national trade performance report