Position: Data Analyst
Category: Data Analyst
English level: pre
Years of experience: 5

Implementation of SQL and Power BI in the company. Before that, all calculations were in Excel.
Coral Travel Ukraine company

The main functionality is divided into several sections

1. Sales department analytics
Calculations in Excel and the internal EagleEye database
Preparation of daily, monthly and control annual reports
Setting targets for sales departments
Development of reports for sales control
Preparation and preparation of analytical reports on competitors
Writing technical documentation for the IT department
Calculation of ABC analyte and RFM analysis
Evaluating the effectiveness of advertising campaigns

2. Call center analytics
Preparation of reports to monitor the implementation of plans for calls
Settings for uploading data from the contractor's database
Development and preparation of reports by department

3. Microsoft Dynamics 365 CRM administration
Writing IT department documentation to run a CRM system

4. Sales Manago
Preparation of bases for mailings.
Program administration.

5. Project manager implementation and development of the WebTutor training portal for Coral Travel
Writing a plan for the implementation of the portal
Communication with IT departments to launch the project
Control and communication with the departments responsible for filling the portal (content, business coaches, designers, technical staff)