Company Email Analysis [ Honorable Mention by Zoom Charts - Best Design]

Email Communication Analysis

Effective communication is crucial in both professional endeavors and daily interactions. Clear communication not only resolves misunderstandings but also fosters productivity and collaboration.

Assumption:

As a Data Analyst at Onyxdata Solutions, I analyze internal email data to gauge employee sentiments and optimize organizational efficiency.

Limitations: Limitations include restricted data details such as dates, sender information including department, email reactions (positive, negative, neutral), and mail status (opened, unopened). However, the absence of contextual information about topics restricts deeper sentiment analysis.

Note: This report is designed with consideration for future data additions and refreshes

It contains 3 pages.

Overview Page:

Provides details of email transfers within our company:

• Emails sent to different departments on various topics.
• Emails sent and received by different seniority levels.
• Active senders and receivers.
• Daily and weekly email trends.
• Sentiment analysis of topics.
• On-time and off-time communication.

Employee View:

Offers information on selected employees across different dimensions:

• Sent and received emails by topic and department.
• Number of emails received from and sent to other individuals.
• Emails sent during working hours and days.
• Weekly and daily trends of sent and received emails.

Details Page:

Provides an in-depth view of each email.

Filters available to understand patterns according to specific requirements.