you could build dynamic and auto refreshable dashboards with Excel using http://www.exceldashboard.org