logo
For Power BI
  • Products
    • Drill Down Donut Pro Drill Down Donut PRO
    • Drill Down Pie Pro Drill Down Pie PRO
    • Drill TimeSeries Pro Drill Down TimeSeries PRO
    • Drill Combo Pro Drill Down Combo PRO
    • Drill Map Pro Drill Down Map PRO
    • Drill Scatter Pro Drill Down Scatter PRO
    • Drill Down Network Pro Drill Down Network PRO
    • Drill Down Waterfall Pro Drill Down Waterfall PRO
    • Drill Down Graph Pro Drill Down Graph PRO
    • Drill Down Timeline Pro Drill Down Timeline PRO
    • Drill Down Combo Bar PRO Drill Down Combo Bar PRO

    Video tutorials

    Watch Now

    More than 90 videos on how to enhance Power BI with ZoomCharts

    Learn more
    All visuals
  • Resources

      Resources

    • Documentation
    • Report Examples
    • Blog
    • Webinars
    • Video Tutorials
    • Visuals Gallery

    Support

    • ZoomCharts Assistance
    • Contact Sales
    • Contact Support
    • FAQ

    Challenges

    Challenges

    Improve your report creation skills by participating in free challenges for report creators.

    Learn more
    Start trial
  • Services
    • Power BI Report Development
    • Custom Visual Development
  • Challenges
  • Pricing
Request a quote Start Free Book a Demo Sign in
Request a quote Start Free Book a Demo Sign in
Get it now
Go back

Contents

Go back

Sep 22, 2020

Power BI Email Analysis: How To Visualize Internal Communication

You and your colleagues, most likely, send thousands of emails between each other. You can transform these emails into valuable data by performing a Power BI email analysis. It's a great way to optimize your internal communication channels and identify possible issues, and in this article, we will show you how to do it by using Drill Down Graph PRO.

Title image
Title image

You and your colleagues, most likely, send thousands of emails between each other. You can transform these emails into valuable data by performing a Power BI email analysis. It's a great way to optimize your internal communication channels and identify possible issues, and in this article, we will show you how to do it by using Drill Down Graph PRO.

Contents

Share this article

Whether its sales, finance, HR, security or operations, all of these are not possible without internal communication. This very fundamental information exchange process can be invisible in day-to-day business cycle; however, it may reveal many important aspects about your company. 
 
For instance, do you know who is communicating with whom in your company? How often? How much of communication is happening outside the working hours? Communication frequency or lack thereof can help you identify the true inside-influencers that may help accelerate projects, or, conversely, put your company at risk. Lack of communication may shed a light on slackers and help identify problems early on.
With these few examples in mind, let’s look at how you can use Drill Down Graph PRO to visualize your communications and perform a thorough Power BI email analysis.
You will learn:
  • how to build an email analysis report from scratch
  • how to use latest features of Power BI and Drill Down Graph PRO
  • how to perform internal communication analysis and get valuable insights from your data.

Power BI Email Analysis Step 1: Process and Add Data

As digital communication is an important everyday component for business of any size, communication analysis is critical to identify the actual communication channels in your organization.
 
When building an email analysis graph, every email address should be considered as a vertex (node), every related email (recipient, cc, bcc) should be considered as a related vertex (node), and each interaction between them (in this case, an email letter) then determines the relationship among those email addresses. For example, if [email protected] sends an email to [email protected], both John and Sue will be vertices (nodes) and they would be linked together with an edge (link) which represents this particular email.
 
Power BI email data
To proceed with the Power BI email analysis visualization, we first need email data. Microsoft Power BI provides you countless data connectors, making it connectable to virtually anything (databases, APIs, spreadsheets, etc.). For this example, we will use a basic Microsoft Excel file that contains the list of emails that have been sent within a certain time period. Each row contains the sender, recipient and date. Note: there may be multiple recipients in the same column separated by comma.
 
In addition, we have multiple columns with additional data that can be used to customize your Power BI email analysis report and view data from multiple angles. These are fields such as sender/recipient topic or recipient’s department - these fields can be used to filter the main graph or give additional info in a tooltip. In addition, you manually pick node colors and add images for each sender and recipient. 
 
We are also using additional data tables that will help customize the graph. Once set up in the Power BI, the data model will look like this:
Power BI email data model
 

Power BI Email Analysis Step 2: Create a Graph Chart

To proceed, we need to start Power BI Desktop or Power BI Service and add data (here's a guide on how to add data from Excel). Now, with data loaded in Power BI, it’s time to build the report with the Drill Down Graph PRO. You can add the visual from AppSource. Once added, the visual will appear in the Visualizations pane.
Power BI visualizations pane
 
Next, click on that new icon to add the visual to the report. Once that is done, you need to setup the data for the visual – drag “Sender Name_Surname” into “source nodes”, “Recipient Name_Surname” into “target nodes”. Finally, we need a value – in this case we will simply use count of the rows – to do that, just drag “Sender e-mails” in “Value” field and choose “count”.
Download the Excel file with data and sample .pbix file to see the data set-up in detail.
 
Congratulations! You have created a basic graph visual.
 

Power BI Email Analysis Step 3: Customize Your Graph

To make the graph more attractive, we will add images for email senders and recipients. You already noticed that there are columns in the dataset, listing image URIs. 
Node Pictures in Power BI email analysis graph
 
Note! Power BI has blocked image URL use in certified visuals due to security reasons. Drill Down Graph PRO offers a workaround for this limitation – you can still add images to the graph visual by converting them to base64. 
In this case we already had a data table with image URLs. To replace them with corresponding images in base64, we are adding additional data table to the report that will take care of that.

Power BI email data image URL

Once that's done, add image URI to the corresponding data fields: “source node image” and “target node image”.
 As a finishing touch, let’s add additional information in the graph’s tooltip by dragging sender email data into Tooltip Content data field.
Your graph visual is ready and you can already identify the following:
  • Who is sending emails to whom?
  • How many emails person has sent?

Power BI Email Analysis Step 4: Add Your Graph to a Report 

The graph that you just created can already be used to gain valuable insights about the communications flow in your company. However, you can push it even further by building a full-on Power BI email analysis report that features multiple additional visuals. In addition to providing extra info based on the context, they can also be used as an intuitive and easy-to-use filter for your report.

Let's start by adding more Drill Down Visuals to further analyze the data. In this example we are using:
  • Drill Down Donut PRO for grouping emails by sender / recipient and email topic (we will use this visual as slicer/filter)
  • Drill Down TimeSeries PRO for grouping emails by time and day (this will act as time slicer/filter as well)
If you need help with setting up with these visuals, take a look at the .pbix sample file.
 
We suggest you also take a look at the customization option tab. ZoomCharts Drill Down Visuals offer rich customization options. The sample file will show you which ones are used in this use case and will help you get a better idea of what can be achieved in terms of design of your Power BI reports.  
Now, this is the end of result of the sample use case we created. 
 
In this report you can see:
  • Senders by amount of emails sent and the topic of emails
  • Recipients by amount of emails received and the topic of emails
  • Graph structure among senders and recipients.
  • Emails by date (you can change this to days/years/hours/minutes/seconds, depending on how detailed your time data are). 

Cross-chart filtering on a Power BI email analysis dashboard

As all Drill Down Visuals support cross-chart filtering, we can analyze data using filtering with a simple touch. Let’s say we want to explore the emails sent only by Aurora Camilleri.
  • Select Aurora in the Senders by Topic Donut. Now, in the recipient chart, let’s select Maxine to reveal how often they communicate
  • Now, in either of donut chart lets select HR topic to see, how often they communicate about this topic.
  • Notice that TimeSeries visual also has been filtered to show respective dates of communication. You can use it to further filter data and analyze communication only for a specific time period, e.g., April.

Additional Power BI Email Analysis Examples

We can also use the same data to build a slightly different communication analysis, focusing on communication among departments.
In this case we are grouping email senders/receivers by department, utilizing graph customization options to color code employees by department, and using Drill Down Combo Bar PRO for additional filtering options.
 
For example, in this version of the report you can:
  • quickly map communication among different departments
  • further analyze communication down to particular employees
  • apply additional time filter
  • spot what amount of communication happens outside business days (thanks to holiday highlight feature of Drill Down TimeSeries visual)
Let’s see one example – communications of the Operations department:
  • Click on Operations department to see with which other departments they communicate
  • Click to turn off Finance, Legal and Sales in the graph legend, to see what communication happens only between Operations and IT department
  • Or select a person on a bar chart to see what communication operations department has with that particular person.

On-chart interactions on a Power BI email analysis report

For further details on how to build this particular chart combination, check out the sample .pbix file.

Power BI Email Analysis Report Live Demo

Now that you know how to use Drill Down Visuals, we welcome you to explore this example to get a taste of the possibilities that these visuals unlock.
We welcome you to download the sample .pbix and data file as well, to see how exactly these use cases are built, what customization options were used and what other features did we apply.
 
 

Conclusion

Connections can be observed in every aspect of business. Exploring and understanding the connections is tricky, but the Drill Down Graph PRO in combination with other Drill Down Visuals makes it simple, powerful and productive. Just imagine what else you could explore with this approach in your company and what new improvements could become possible. Read more about the features that this powerful visual offers in our blog article about Drill Down Graph PRO! 
 
Get Drill Down Graph PRO
envelope icon

Want more info like this?

Subscribe to our newsletter and be the first to read our latest articles and expert data visualization tips!


Find out more

May 08, 2025

Blog Thumbnail
Guides

Data Literacy: What It Is and Why Every Modern Professional Needs It

Data literacy is no longer optional - it’s essential for success in today’s data-driven world. From marketers to HR professionals, everyone is expected to analyze data, spot trends, and make smart decisions. This article explores what data literacy really means, why it matters, and how to build it across your team and organization.

Apr 30, 2025

Blog Thumbnail
Product updates

April 2025 Update: Multiple Links in Graph PRO & Total Labels for Stacks

Create multiple links between nodes in Graph, enable and customize value labels for stack totals in Combo & Timeline, and more – read about what’s new in ZoomCharts visuals in April!

Mar 28, 2025

Blog Thumbnail
Product updates

March 2025 Update: Show Difference Between Two Values

This month brings multiple new features for better data visualization: change indicator for comparison between two values; on-chart annotations for Waterfall; layout modes for Network, and other improvements. 

Feb 26, 2025

Blog Thumbnail
Product updates

February 2025: What’s New in ZoomCharts Visuals for Power BI

You can now enable extended axis labels in Combo, Combo Bar and Waterfall, assign lasso shapes to specific shape layers in Map, and enter custom display names for link categories in Graph. Read more about the latest update in this article!

Jan 31, 2025

Blog Thumbnail
Guides

Top 12 Key SaaS Business Metrics You Must Track in 2025

ARR, CLV, NRR, churn, and more – learn about the most important SaaS business metrics, their formulas, how to read and interpret them, and how to best visualize them. 

Jan 15, 2025

Blog Thumbnail
Product updates

January 2025: New Customization Options

We have added outline conditional formatting, color customization for selection and highlight areas, comma-separated source nodes for Graph, and a setting to hide empty values in the tooltip.
  • 1
  • 2
  • 3
  • 4
  • 5
  • ...
  • 11
  • »

Contents

Share this article

Want more info like this?

Subscribe to our newsletter and be the first to read our latest articles and expert data visualization tips!


Thank you!

Check your inbox to verify your email address.

logo
[email protected]
+44 204 577 3993
logo

Products

Drill Down Network PRO Drill Down Waterfall PRO Drill Down Graph PRO Drill Down Combo PRO Drill Down Combo Bar PRO Drill Down Donut PRO Drill Down Pie PRO Drill Down TimeSeries PRO Drill Down Timeline PRO Drill Down Map PRO Drill Down Scatter PRO All Visuals

Resources

Report Examples Webinars Blog ZoomCharts Academy Visuals Gallery Documentation Custom Visual Development Subscribe to News

Solutions

Custom Visual Development

Company

Pricing About Us Partners Leave feedback Join PowerGroup EU Funding

Help

ZoomCharts Assistance Contact Sales Contact Support FAQ

Drill Down Network PRO Drill Down Waterfall PRO Drill Down Graph PRO Drill Down Combo PRO Drill Down Combo Bar PRO Drill Down Donut PRO Drill Down Pie PRO Drill Down TimeSeries PRO Drill Down Timeline PRO Drill Down Map PRO Drill Down Scatter PRO All Visuals

Report Examples Webinars Blog ZoomCharts Academy Visuals Gallery Documentation Custom Visual Development Subscribe to News

Custom Visual Development

Pricing About Us Partners Leave feedback Join PowerGroup EU Funding

ZoomCharts Assistance Contact Sales Contact Support FAQ
+44 204 577 3993
[email protected]

Ready to get in touch?

Contact our experts with any question about Power BI and ZoomCharts for Free!

Contact us

© 2025, Data Visualization Software Lab

U.S. Patents No. 11,645,343; 11,921,804

Cookies Policy
Manage cookies
Privacy Policy
Global
EULA
Patent
warning

Error message

success

Success info: Done!

ZoomCharts AI Assistant

We noticed you're using an old OS version.

For the best experience, we recommend upgrading to ensure that all website features display correctly.

Cookie settings

We use necessary cookies for site functionality, as well as statistic, marketing, and preference cookies to enhance your experience. For more information and to manage your preferences, please visit our Cookie policy