Adventure Works Data Visualization

About this project

Situation: After the completion of my online certification course Microsoft Power BI Desktop for Business Intelligence, I chose to work with Adventure Works data to test my understanding of what was covered.

Task: I've decided to group the data depending on their content after electing to use Adventure Works Data to help them tell a better tale. With that strategy, I have decided to divide them into three parts, namely Sales, Product, and Customer, based on the data.

Action:

1. Executive Summary: Its purpose is to let the user gain various insights related to Orders, Profit, Revenue, Returns, and Monthly Targets.
2. Product Overview: In order to determine how well a product serves clients and is enjoyed by them, Orders and Returns are the main criteria on which we should concentrate while inspecting a product. This sheet comprises the information related to the total products that were ordered and their corresponding return count along with the top product based on Profit and Sales, a gauge chart representing the current month's orders, revenue, and returns with the previous month's data, a line chart to depict the trend in the weekly profit.
3. Customer Overview: As customers are the main pillar of any business, in order to better understand them and the pattern of their shopping, I have displayed the customer, the total revenue gained from them along with total orders by them, a deeper segment based on their gender, occupation, and income with doughnut chart, have used tree maps in order to define the generation wide popularity of the company.

Result:

Have created a report with the interaction between three pages by enabling global filters and letting the visuals present the data accordingly.