Below is the comprehensive report outlining the dashboard design that simulates the impact of a 25% tariff between Canada and the USA on OMIS Store. This report explains the four integrated dashboard components, details which parts of the OMIS Store dataset to use for each, and provides links to exemplary Tableau Public dashboards. It also explains how this design aligns with your specific assignment as Dashboard 1: Sales Performance Analysis.

Dashboard Design Report: Simulating a 25% Tariff Impact on OMIS Store

Overview

The purpose of this project is to create an interactive Tableau dashboard that simulates how a hypothetical 25% tariff imposed between Canada and the USA would affect the OMIS Store’s sales performance. Although the OMIS Store dataset is fictional and used solely for this assignment, it includes key fields such as “Order Date”, “Sales”, “Profit”, “Category”, “Sub-category”, “Market”, and “Orders”. Our comprehensive dashboard design is structured into four complementary components. Each part provides unique insights—from tracking sales trends over time and mapping geographic impacts, to analyzing profit margins and enabling dynamic “what-if” scenarios.

Dashboard Components

  1. Time Series Sales Trend with Tariff Annotation

A dual-axis or annotated line chart will plot separate sales trends for the U.S. and Canadian markets. A prominent annotation will mark the point when the 25% tariff is implemented, creating a clear “before and after” comparison.

• Design Reference:

Sales Trends and Analysis – Tableau Public Dashboard by Ihor Shvets

  1. Geographic Impact Analysis

• Dataset Fields: “Market”, “Sales”, “Profit” (and additional geographic details, if available)

• Design Approach:

A geographic heat map will display regional variations in sales volume and profit margins. By focusing on the U.S. and Canada, this visualization will highlight which regions are most impacted by the tariff, offering spatial insights into market performance.

• Design Reference:

CAR SALES ANALYSIS DASHBOARD – Tableau Public Dashboard by Alkesh Acharya

  1. Profit Margin Impact Analysis

• Dataset Fields: “Sales”, “Profit”, “Category”, “Sub-category”

• Design Approach: