Projects Profitability Analysis
Client Industry: Advertising & Communications, IT-outsource, Consulting, B2B Professional Services
Business Need: Track and control project finances before the completion of a project, automate budgeting, and conduct plan vs. actual analysis
Solution: maxidtp collected project data from project management, financial, and payroll systems into Power BI reports to analyze project profitability. Created an interface for project budgeting using Office 365 tools
Timeline: Delivered the first profitability report in 3 weeks. Completed the entire budgeting automation project in 6 months
Business Impact: Reduced the budgeting cycle from 20 to 3 days, enabled monthly budgeting, allowed financiers to identify unprofitable projects, and improved communication between account and financial managers