Dashboard Creation with PowerBI (Excel)

Project Description

An interactive employee turnover report made using Excel’s PowerBI suite of plugins. This dashboard displays employee turnover data originally managed in an Excel Table, then prepared for PowerBI online by PowerPivot (kpis & calculations) and PowerView (graphical display).

Note: dashboard display changes as it adapts to different sized screens, or browsers.

Project Details

  • Question:What is our company's employee turnover by region? Where are these employees from?
  • Answer:Over the timeframe chosen employee turnover varies between 13-50% by region, and because the majority of workers are Albertan, this cohort represents the largest turnover population
  • Challenges:To clearly display the desired information and distribute it to key stakeholders online
  • Purpose:To present employee metrics in an accessible fashion so strategic personel decisions can be made


Leave Reply

Your email address will not be published. Required fields are marked *