My Portfolio

Portfolio of Projects in Power BI - Dashboards from various sectors created with the objective of bringing analysis and information in a simple and practical way for the monitoring of the company's main indicators.

Commercial Dashboard

Dashboard for the sales department developed for Contoso company. The dashboard uses SQL as a data source.

SalesSQLRevenue Analysis

Key Indicators:

  • •Sales revenue and YoY comparison (Year Over Year)
  • •Quantity sold and YoY comparison
  • •Cancelled/Returned sales
  • •Number of customers
  • •Sales by region
  • •Sales analysis by customer category
  • •Simulation of scenarios with price adjustments and monthly revenue/profit forecast

Logistics Dashboard

Dashboard focused on the logistics department. The dashboard uses Excel as a data source.

LogisticsExcelCost Analysis

Key Indicators:

  • •Current Month vs. Previous Month Freight Comparison
  • •Current Month vs. Previous Month Number of Trips Comparison
  • •Total Weight (ton) by Brand
  • •Daily Costs by Brand
  • •Fixed and Variable Costs by Year and Month
  • •Total Cost per Kilometer, Year, Month, and Vehicle Type
  • •Detailed Deliveries by Brand
  • •Final Profit by Year and Month

Customer Service Dashboard

Dashboard for the user support department. The dashboard uses Excel as a data source.

Customer ServiceExcelSupport Metrics

Key Indicators:

  • •Total number of support requests per year
  • •Average by index
  • •Comparison of Responded Calls vs. Open Calls
  • •Distribution of received calls by problem and user
  • •Average handling time

Human Resources Dashboard

Dashboard for the Human Resources department. The dashboard uses Excel as a data source.

HRExcelWorkforce Analytics

Key Indicators:

  • •Overall distribution of the employee roster
  • •Yearly comparison of hires vs. separations
  • •Turnover percentage
  • •Overall distribution of hires by location, department, level, tenure, and age group
  • •Overall distribution of separations by location, department, level, tenure, and age group
  • •Employee distribution by gender
  • •Detailed employee profile

Stock Dashboard

Dashboard for the stock Department. The dashboard uses SQL as a data source.

InventorySQLStock Management

Key Indicators:

  • •Distribution of items by location, product, and category
  • •Distribution of total revenue results by month, year, store, and product
  • •Detailed analysis by product