<aside> <img src="data:image/svg+xml,%3csvg stroke-width='1' xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24' stroke='%23337EA9' fill='none' stroke-linecap='round' stroke-linejoin='round'%3e%3cpath stroke='none' d='M0 0h24v24H0z' fill='none'/%3e%3ccircle cx='12' cy='11' r='3'/%3e%3cpath d='M17.657 16.657 13.414 20.9a2 2 0 0 1-2.827 0l-4.244-4.243a8 8 0 1 1 11.314 0z'/%3e%3c/svg%3e" alt="data:image/svg+xml,%3csvg stroke-width='1' xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24' stroke='%23337EA9' fill='none' stroke-linecap='round' stroke-linejoin='round'%3e%3cpath stroke='none' d='M0 0h24v24H0z' fill='none'/%3e%3ccircle cx='12' cy='11' r='3'/%3e%3cpath d='M17.657 16.657 13.414 20.9a2 2 0 0 1-2.827 0l-4.244-4.243a8 8 0 1 1 11.314 0z'/%3e%3c/svg%3e" width="40px" /> Navigation bar

</aside>

<aside> <img src="/icons/arrow-northeast_blue.svg" alt="/icons/arrow-northeast_blue.svg" width="40px" /> Click here to view the original dashboard.

</aside>

<aside> <img src="/icons/light-bulb_blue.svg" alt="/icons/light-bulb_blue.svg" width="40px" /> Summary

Goal

This project aims to create a dynamic performance report using Power BI that allows users to analyze a pharmaceutical company's sales data, including total sales, sales quantity, YoY sales, and other key metrics.

Process

1. Importing the data into Power BI and cleaning it within Power Query.
2. Building core DAX measures.
3. Designing the report layout.
4. Applying conditional formatting to highlight important insights and trends.
5. Implementing dynamic chart titles and report titles to provide context.
6. Creating the report and preparing it for publication.

Insights

1. Japan and South Korea are the largest international markets for traditional Chinese medicine, driven primarily by plant extracts, which are also the leading contributors globally.
2. March, September, and November are the strongest sales months, attributable to seasonal marketing campaigns and promotions.
3. In the most recent year, top-performing products include P85, P103, and P185, while bottom performers are P80, P69, and P206, all categorized as plant extracts. </aside>

<aside> <img src="/icons/checkmark_blue.svg" alt="/icons/checkmark_blue.svg" width="40px" /> What is the largest international export market, and what are the main revenue drivers?

Japan and South Korea are the leading overseas markets for traditional Chinese medicine.

In both countries, plant extracts are the primary revenue driver.

The market share trends for various products in Japan and South Korea mirror those of the global market, with plant extracts as the main contributor.

</aside>

<aside> <img src="/icons/checkmark_blue.svg" alt="/icons/checkmark_blue.svg" width="40px" /> Are there any noticeable seasonal trends in sales?

The peak sales months are November, September, and March, with significant increases compared to the previous months. This trend is linked to the three major annual marketing campaigns launched in 2020.

</aside>

<aside> <img src="/icons/checkmark_blue.svg" alt="/icons/checkmark_blue.svg" width="40px" /> What are the top-performing and bottom-performing products?

The top three products are P85, P103, and P185, each exceeding 21 million units 2020.

Conversely, the bottom performers—P80, P69, and P206—did not sell more than 35 units each in the same year.

All these products fall under the plant extract category.

</aside>

<aside> <img src="/icons/checkmark_blue.svg" alt="/icons/checkmark_blue.svg" width="40px" /> Which price ranges are most popular, and what is the relationship between price and sales quantity?

Products priced below €25 are the most popular, as indicated by sales quantity.

• Price sensitivity is evident:
  • The peak sales months (December, September, and March) coincide with large-scale marketing campaigns featuring numerous promotions.
  • The scatter plot indicates that lower-priced products, especially those under €25, enjoy higher sales volumes, while products priced over €50 show significantly lower sales quantities. </aside>

Detailed Report — For More Information