Overview:

This client required a more efficient data analysis and reporting system in order to improve decision making.

The Problem:

Due to a fragmented data repository, a holistic view of present data was unattainable. In order to run accurate data analysis, this client required a professional who could build and maintain a set of operational dashboards.

The Solution:

After consulting with the client, dashboards were created across several different departments for increased reporting and visibility. Each of these dashboards required different data sources to be combined and cleaned, ensuring the proper data would be analyzed by the proper dashboard. These dashboards included:

• Human Resources Analytics: Identifying headcount trends, attrition rates, employee demographics, etc in order to provide insight into trends concerning hiring, terminations, and retention.
• Finance Analytics: Advanced analytics in the area of bookings-to-revenue lifecycle; giving the client an accurate representation of the ordering process, backlogs, reserves, and billings in order to make inferences and trending projections for upcoming quarters.
• Invoice Analytics: Invoicing specific analytics designed to flush out information throughout the invoicing lifecycle; such as policy violations, expenditures, supplier lists, etc.
• Forecasting: Inference based analytics measuring planning, financial forecasting, expense data, cost center levels, account expenses, etc.