Sales Report Dashboard on Power BI

Python (pandas, NumPy): Data cleaning, transformation, and analysis.

Power BI: Interactive dashboard design.

matplotlib and seaborn: Visual exploration of trends during analysis.

Excel: Initial data assessment and manual adjustments.

This project was designed to create an interactive and visually appealing sales status report for Future Global Data. The goal was to present key performance metrics—such as total profit, product sales, and client distribution—clearly and effectively, allowing stakeholders to make informed decisions. By showcasing trends and comparisons, the report provides actionable insights into sales performance across different dimensions, including product types, client segments, and store locations.

The process started with raw sales data, which required thorough preparation. I began by cleaning the data to ensure accuracy, removing duplicates, addressing missing values, and standardizing formats. For example, product names, client categories, and date formats were aligned to maintain consistency. I also tackled outliers to avoid skewed results, ensuring the data reflected the true performance.

Once the data was clean, I analyzed it using Python libraries like pandas and NumPy. The analysis focused on uncovering trends and patterns, such as identifying top-selling products, tracking profit margins, and segmenting sales by client type (individuals, companies, distributors, and government). I also compared sales performance across different store locations—like Madrid, Barcelona, and London—and explored how sales fluctuated throughout the year. To provide further insights, I added a year-over-year comparison, which revealed growth peaks during May and November.

The final step was creating a visually engaging and intuitive dashboard. Using Tableau and Power BI, I translated the analysis into an interactive report. The dashboard highlights the main metrics, such as total profit (€77.3M), profit margin (24.89%), and total product sales (30K), in a clean, easy-to-read format. A bar chart showcases the best-performing products, with Samsung Galaxy A54 and iPhone 15 leading the list. Pie charts visualize sales distribution by client type and location, making it easy to see how the business is performing across different segments. Finally, a year-over-year line chart compares monthly sales, helping to pinpoint trends and fluctuations between the current and previous year.

The entire project was built with a focus on clarity and usability, combining data accuracy with thoughtful design. By blending technical skills like data cleaning and analysis with a strong sense of visual storytelling, I was able to create a report that is both insightful and actionable. Whether a stakeholder needs a quick overview or an in-depth look at the numbers, the dashboard is designed to deliver.

This project allowed me to demonstrate my expertise in managing the entire workflow, from cleaning raw data to delivering a polished, interactive visualization. It highlights my ability to combine technical precision with creativity to turn data into meaningful insights.