Email Communication Report- Data DNA – Dataset Challenge

Introduction

As part of the Onyx Data Challenge for July 2024, in collaboration with ZoomCharts, Bletchley Park AI User Group, and Data Career Jumpstart, I had the incredible opportunity to dive deep into the world of email communication patterns within an organization. This project has been a significant milestone in my data analytics journey, enhancing my expertise in data modeling, DAX, and interactive visualizations. Here's a snapshot of the key insights from my analysis:

📊 Key Highlights:

• Total Emails Analyzed: 1,132
• Emails Opened: 1,034 (Open Rate: 91%)
• Device Usage: Desktop (76.21%) vs. Mobile (23.79%)
• Peak Communication Week: 2nd week with 309 emails
• Sentiment Analysis: Predominantly positive with 353 positive emails

🔍 Detailed Insights:

1. Email Open Rates by Seniority and Department: Product Development department and Professional seniority level led the engagement with the highest open rates.
2. Device Usage for Email: Desktop usage was dominant at 76.21%, indicating a preference for desktop over mobile for email communications.
3. Email Sentiments: Legal Matters had the highest negative sentiment with 20 negative reviews, while Sales and Marketing had the highest overall email reviews with a balanced sentiment distribution.
4. Email Traffic During Work Hours and Workdays: Recognizing peak email sending and opening times can help optimize communication timing, ensuring higher engagement and response rates.
5. Device Usage for Opening Emails: Understanding which devices are most commonly used to open emails helps us tailor email formats and designs to those devices, improving readability and accessibility.
6. Email Topic Trends Over Time: Tracking the prevalence of different email topics over time reveals shifting priorities and emerging issues, enabling proactive management and strategic planning.

🌟 Impactful Benefits:

• Strategic Decision-Making: Visualizing email trends and patterns to drive informed strategic decisions.
• Enhanced Communication Strategies: Tailoring email content and timing based on department and seniority engagement insights.
• Improved Device-Specific Designs: Optimizing email formats for the most used devices, enhancing readability and user experience.
• Proactive Issue Management: Identifying emerging issues and shifting priorities through email topic trends to enable proactive management.

🛠 Tools Used: SQL, Power BI, DAX, Data Modeling, Interactive Visualizations

This dashboard has been a transformative experience, refining my skills in data analysis and storytelling. I'm eager to leverage these insights to drive strategic improvements within the organization.