Portfolio

Kmart Monthly Sales report 2021 projet

Design an automatic monthly sales report of stores nationwide of the Kmart Vietnam convenience store chain. The report is built on Power BI based on the database provided by the partner and automatically updated with the information when the partner updates the monthly sales database.

Analysis tool: Power BI 

Field: Business Analytic

Mitsushi HR Analytics dashboard

Design a human resource analysis dashboard for Misushi Factory. Evaluation parameters: The client wants to know the ratio of human resources by age group, education level, monthly human resource attrition rate by department, by age group, by gender and education level, and employee satisfaction rate with the company. 

Analysis tool: Tableau 

Field: Human Resources

Bank loan report

This Bank Loan Report aims to provide insights into key loan-related metrics and their changes over time. The report helps the client make data-driven decisions, track our loan portfolio's health & identify trends. The Excel dashboard consists of 2 parts that have been shown on separate sheets and linked together: summary and overview. The summary includes KPIs. The Overview part visually represents critical loan-related metrics and trends using a variety of chart types. Users can easily switch sheets by clicking buttons. Data of charts and graphs is also linked together through layer filters.