Project Details

In this project, the goal was to create a single, unified report that could serve stakeholders across sales, marketing, finance, and the executive team. The core focus areas included:

1. Building a robust data model
2. Designing the report with a user-centered approach
3. Providing detailed, drillable insights


Through this project, I developed key skills, including:

1. Performing both basic and advanced operations in Power Query
2. Writing DAX formulas, from foundational to complex
3. Structuring data models that integrate over 10 tables
4. Selecting and formatting visuals effectively
5. Applying principles of intuitive dashboard design
6. Utilizing bookmarks for enhanced user navigation
7. Deploying reports on the Power BI service
8. Acting on feedback from stakeholders
9. Working with a range of metrics relevant to sales, marketing, finance, and supply chain

Live Interactive Dashboard

Project Details

In this project, I developed a sales report in Excel using pivot tables, designed to help businesses determine optimal customer discounts, support consumer negotiations, and pinpoint growth opportunities in high-potential countries. The reports deliver actionable insights and strategic recommendations to enhance sales effectiveness, boost customer satisfaction, and drive revenue growth.

Key skills I acquired include:
Creating Pivot Tables
Using Power Query
Basic DAX
Applying Conditional Formatting
Enhancing Report Aesthetics
Understanding Sales Metrics

This project equips businesses with essential tools and insights to monitor, assess, and improve their sales operations. Leveraging data-driven sales analysis allows businesses to identify new opportunities, fuel growth, and maintain a competitive edge in the evolving market.