Challenge

• A large building company works on many projects at the same time and for each project a lot of data has to be entered into various IT systems monthly
• To manage risks and cash, extended analyses and forecasts are needed
• The management wants good looking reports with high-level as well as project-related information

Solution

• Standardized Excel templates to capture all project information every month
• Central Excel tool to conslidate data, conduct calculations and move data to other IT systems
• Automated generation of reports with interactive elements for better analysis of information

Benefits

• Time savings for project leaders as they only have to enter monthly
  project data into one tool
• Data is modified centrally and automatically transferred to other systems
• Increased transparency for the management thanks to tailor-made reports with analysis functionality

Screenshot

Click on the picture to enlarge it.