Friday, July 19, 2013
Energy Dashboard for Euro Zone
This is an Excel based interactive dashboard visualizing energy statistics in Euro Zone. Underlying data was obtained from Eurostats (http://epp.eurostat.ec.europa.eu/portal/page/portal/eurostat/home). The dashboard incldes various interactive charts and data filters.
Inventory Calculator
This template is prepared for simulating orders and inventory positions according to Safety Stock policy.
Dow Jones Components Dashboard
This is an Excel based interactive dashboard visualizing last 5-Year data of Dow Jones Components.
Personal Monthly Budget
Keep your personal monthly income and expenses. Track them tables and charts.
HR Dashboard
This is a dashboard for employee by departments, salary distribution and number of employees by years analysis. Also, detailed information of a single employee can be reached easily.
Headcount and Payroll Plan
This template is prepared for planning number of employees and their salaries quarterly for different departments. Department names and job titles are editable. In addition to salaries, Fringe Benefit, compensations and variable pays by departments are also evaluated. On a secodary sheet, a dashboard is provided.
Hotel Dashboard 2
This template is prepared for keeping track of the processes carried out in a hotel and analyzing the performance of the hotel with the aid of a dashboard. Daily inputs are tracked in a Data sheet. Inputs are dynamically converted into a dashboard. Revenue types, ADR, RevPAR, occupancy rate, monthly and yearly revenues are analyzed in the dashboard. SpreadsheetWEB version of the template carries the dashboard onto the web and may easily be updated.
Subscribe to:
Posts (Atom)