The following documentation was drafted with the support of Generative AI. The content may contain mistakes or be misleading. This is especially important for any claims regarding specific metrics or calculations. It is recommended that team members double check any critical claims made in this documentation before proceeding with their work.

📌 Key Resources

Dashboard Design Guide

📅 Deadline & Research Plan: Tableau Public Visualization Examples

🦾 AI Tools Help

🤝 Meetings Transcripts

Adriel Tableau Guide

https://www.tariffinder.ca/en/getStarted

Executive Summary:

The ongoing trade conflict initiated in early 2025 between the United States and Canada, characterized by reciprocal tariffs of 25%, has significantly disrupted business operations and profitability, notably impacting OMIS Store's financial performance. These tariffs have introduced substantial challenges, including increased product costs, strained supply chains, and reduced profitability for products heavily reliant on cross-border trade. OMIS Store, with significant exposure in these markets, must swiftly adapt by identifying and leveraging alternative growth opportunities and mitigating negative impacts.

In this presentation, we will clearly demonstrate how OMIS Store has been affected by the trade war, particularly focusing on reduced sales trends, profitability erosion in key product categories, operational inefficiencies, and the identification of promising international markets unaffected by these tariffs. Through straightforward, easy-to-understand Tableau visualizations, we will provide OMIS Store executives with clear insights and actionable recommendations to strategically adapt, reduce costs, and capitalize on emerging market opportunities.

Division of Responsibilities:

Team Member Dashboard Assignment Task Responsibility
Narotam Dhaliwal Sales Performance Analysis Clearly show how the 25% tariffs have affected overall sales, highlighting key product categories and geographic markets (especially US and Canada).
Monisha Manikandan Profit & Margin Analysis Simply illustrate how the tariffs reduced product profit margins, clearly identifying the most impacted product categories.
Aravind Bhatla Geographic Market Opportunities Identify and visualize international markets (EMEA, APAC, LATAM) where sales remain strong or growing, suggesting opportunities to shift resources away from tariff-affected regions.
Adriel O'Malley Operational Impact & Recommendations Clearly present how tariffs increased supply chain costs and delays and provide straightforward strategic recommendations to reduce these problems.

📈 Key Takeaways and Visualization Types:

Team Member Key Takeaway Recommended Visualization Type Sandbox (files)
Narotam Dhaliwal Major decline in US and Canada sales post-tariff Line charts, bar charts, and geographic heat maps
Monisha Manikandan Significant margin decline in key product categories due to tariffs Waterfall charts and heat maps
Aravind Bhatla Significant growth opportunities in EMEA, APAC, and LATAM regions Geographic heat maps and comparative bar charts
Adriel O'Malley Increased operational costs and delays directly linked to tariffs Bar charts

2024 Country profile: Canada - WTO https://www.wto.org/english/res_e/statis_e/tariff_profiles_list_e.htm

https://www.wto.org/english/res_e/statis_e/daily_update_e/tariff_profiles/CA_E.pdf