Skip to content
August 5, 2011 / Erik Svensen

Analyze your inbox with PowerPivot

Inspired by an Microsoft Excel add-in where you can analyze your calendar items with Excel’s new PowerPivot tool, I decided to have a look at my inbox with Excel and PowerPivot.

And here is the interesting results.

The model reads all items in my inbox root folder (with currently over 1.800 items – been a while since I read about inbox Zero), and imports subject, sender, sender email address, size of the mail and number of attachments.

This data is inserted into a sheet in the workbook in a table. This table is then linked to PowerPivot window.

And in order to make some date grouping and calculate whether the mail was from a collegaue or external mail, I added some calculated columns in the PowerPivot model.

Based on the PowerPivot model I then created this overview / dashboard of my inbox.

I can see that

  • I receive most e-mail on Wednesdays
  • About 75 % of my mail is over 1 month old
  • 10 senders are responsible for 53 % of my big inbox and 33 % of all mails
  • I can see that 51 % percent of the Mb in my mail box comes from my colleagues meaning that they must learn how to insert links to files in their emails instead and we can save a lot of space on our mail server.

And the last interesting thing – my colleagues apparently eat around 12:00 and put their kids to bed at 20:00

If you want to try this on your own inbox, please send me a comment and I will send you the model. (Requires Excel 2010)

Advertisements

6 Comments

Leave a Comment
  1. Srdjan / Aug 5 2011 8:54 pm

    Sejt Erik!

  2. Peter Jansson / Aug 9 2011 12:21 pm

    Hej Erik, det var länge sedan men när det kommer till fina analyser är jag på :-). Vilken härlig överblick – självklart är jag intresserad av att testa detta och tar gärna emot din fil :-).

    Må så gott!
    Mvh
    Peter

  3. swap1712 / Apr 6 2012 11:26 pm

    Hi Erik,
    I have been working on something similar. I would appreciate if you could send me the model so I can get some pointers 🙂

    Thanks in advance!

    • Erik Svensen / Apr 10 2012 3:52 pm

      Hi,

      You can download my example from this link

      It is made on the 2008 power pivot version so you might have to update the model

      /Erik

  4. ronsemail / May 15 2012 8:27 pm

    Would love to try the model.

    Thanks,
    Ron

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: