Project Description for Payroll Analytics in POWER BI

The client wanted to process the real estate construction operations data and needed Payroll Analytics in Power BI for their management decisions.

Designed and developed the following BI Reports:

  1. Spending categories
  2. Scaffold hire and purchase
  3. Framework hire and purchase
  4. Tools and equipment hire and purchase
  5. Total invoice by companies
  6. invoice by companies
  7. Amount payable
  8. Vendor payment history
  9. Influencers of framework
  10. Influencers of scaffold
  11. Influencers of tools and equipment
  12. Forecast, total amount, and balance
  13. Forecast
  14. Description amount balance

Developed data pipeline to load data from the data source to the POWER BI so that the reports can be automatically updated and graphs populated whenever there is a change in the data at the data center.

Data Visualization Deliverables

  • Presentation
  • Dashboard
  • Map
  • API Integration

Data Visualization Tools

Microsoft Power BI

Data Visualization Languages

Project Snapshots

  • Payroll Analytics in POWER BI
  • Construction Accounts Payable
  • Construction Accounts Payable 2
  • spending categories
  • hire and purchase
  • form work hire
  • vendor payment history
  • key influencers of framework
  • key influencers of scaffold for Payroll Analytics in POWER BI
  • tools and equipment for Payroll Analytics in POWER BI
  • balance forecast
  • forecast amount
  • Payroll Analytics in POWER BI

 

Project Website

https://app.powerbi.com/groups/me/reports/2f171dd4-7f5d-470d-a240-6ea14f00d7e6/ReportSectione6f3f43fe1439f1911cb

RELATED ARTICLESMORE FROM AUTHOR