Tailwind Traders

Project Overview

Tailwind Traders is a fictional company and dataset created by Microsoft for Power BI student usage. This project was a capstone project for Power BI.

Project Goals

The objective of the project is to create a small report displaying sales data and profit data on separate pages to allow easy understanding of the data. An additional page was included for additional insight into international market penetration and performance. A mobile version was created as well and is shown in the gallery below.

Tools Used

Microsoft Power BI and Excel

Data Cleaning/Preparation

• Inspection of initial data
• Handling missing and blank values
• Removing outliers
• Data cleaning and normalization

Sales Data Requirements

Display sales data to see real-time insights into products to track inventory, outcome of loyalty points program and allow users to make decisions on stock, marketing and progress and spot trends. Due to the sales being international, it was necessary to obtain accurate currency conversion to display all revenue and sales in U.S. dollars.

KPI Cards Included: Stock on Hand, Quantity Sold, Median Sale amount

Charts:

Loyalty Points by Country in horizontal bar chart with values shown,

Top 10 Products in column chart,

Median Sales by Country in a pie chart, and

Median Sales Over Time in a line chart

Profit Data Requirements

KPI Cards Included: Year to date (YTD) Profit, Net Revenue in USD, and Sum of Gross Revenue

Charts:

Net Revenue in USD by Product in horizontal bar chart with values shown,

Yearly Profit Margin by Country in a donut chart, and

Yearly Profit Margin Over Time in a filled area chart

Country Statistics

Charts:

Revenue by Product Category in a column chart,

Most Profitable Products by Country in a horizontal bar chart with values shown,

Revenue by Country in a tree map, and

Net Revenue by Country in a matrix

Key Findings & Insights

While the customers in the UK have the most loyalty points, and French customers spend more per purchase, the most profit has come from Australian customers, followed by US customers.