We developed a data warehouse for lending and funding data using SSIS and SQL Server. After building the warehouse, data is visualized with Tableau, providing clear insights into funds, loans, and balance sheets for better decision-making.
We developed an executive dashboard for the Integrated Criminal Case Management System. It includes three main categories: Data Exchange Monitoring, Case Handling Monitoring, and Case Analysis. Each category tracks case progress from initial police investigation to court verdict and termination analysis.
We developed an executive dashboard for mall tenant performance, categorized by Retail or F&B and business types like Beauty, Health, and Fashion. It covers lease details, transaction volumes, and sales, providing insights on sales summaries, occupancy, revenue sharing, and mall comparisons.