Transforming Data into Actionable Information

Challenge: A Vice President & General Manager of an international company received monthly Excel worksheets reporting total (global) company wins, pending awards and prospects by category. The GM needed to analyze this raw data, filter it for U.S. opportunities only, and create a monthly report for his senior management team.

Solution: DataBasics provided advanced programming to automate the application.

Now, each month the new Excel spreadsheet is programmatically reviewed for U.S. opportunities, Euros are converted to dollars where necessary and the opportunities are consolidated by category.  All data is maintained in Excel which automatically creates preformatted charts.