Sales and Invoices dashboard in Power BI

This is a project in Business Intelligence, utilizing SAP S4HANA and Power BI, is a comprehensive initiative aimed at enhancing data-driven decision-making in the realm of sales. The project involves the creation of information cubes within the SAP S4HANA database, utilizing CDS technology. Subsequently, the data is transferred to the Power BI system through a nightly process facilitated by BW connection.

Some KPI's included in this dashboards are:

1. Number of Customers

2. Number of Active Customers

3. Number of Customers with Sales

4. Average Sales per Customer

5. Current Year Sales and Year-on-Year Comparison

6. Sales Returns and Quotations

7. Number and Amount of Sales by Materials and Customers

1. Sales Conversion Rate

2. Gross Profit Margin

3. Sales by Region