Sales Call Report

This project generates weekly call performance reports for a sales team, based on calls taken and calls duration stored in a tabular format (Excel Spreadsheet) and then converted into a JSON format. The project is heavily focused on data manipulation and processing (Composer - Transform).

Specified KPIs

The team decided on the following KPIs:

• Total calls,
• Total accepted calls in percent,
• Who had the most calls,
• His accepted,
• How much more calls did he accept in comparison to the second best in percent,
• Who had the longest call and the time of that call,
• How many calls are in a particular range.

Provided Data

The data points they could provide for ~1K calls a week:

• Date and time (e.g. "2019-08-26 07:18:22"),
• Salesperson ( e.g. “John Doe”),
• Call status,
  • Accepted call (e.g. “completed”),
  • Rejected call (e.g. “busy”, “no-answer”, “failed”),
• Direction (“outbound”, “inbound”).

Project Details

Some project details:

• Creating a table with Statement Loops.
• Advanced use of Mapping Nodes and functions:
  • Sort and filter lists,
  • Count elements, also unique elements of a list,
  • Extract information and creating a new list,
  • Calculate averages,
  • Format output to match the numerical representation,
  • Date convert,
  • String processing.
• Use of Subgraphs to organize the Transform area.

• Language: English