Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
TimmK
Helper IV
Helper IV

Outlook Email Statistics

A customer sends an email with an order request. This request needs to be clarified as the product is complex and needs to be tailored to the customer's need. Thus, emails are sent back and forth between the customer and our customer agent.

 

Now we want to see how fast a customer agent replies to each email from the customer. Is this generally possible with Power BI? If yes, how? Or is it easier to use an Outlook add-on or software for email statistics? Can you recommend one?

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

HI @TimmK,

I'd like to suggest you connect to the Microsoft Exchange service to analyze your email records.
Notice: these records are not such readable so you may need to do some additional steps to shape/transform these data first.

Analyzing your Microsoft Exchange Account Data with Power Query | Microsoft Power BI Blog | Microsof...

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
agustinamar
New Member

Hi, I hope you can answer this question. I am working with an outlook database, and to know the days elapsed since an email with a case to be resolved is received until its resolution, but I would not know how to put together the formula (I have the dates of sent and received), since there would be many mails (different cases per client) I thought of doing it by subject: when it starts, put region_customername_test1 and when region_customername_resolved_test1 is resolved. Would you have any suggestion? Is this possible to do? Thank you in advance

v-shex-msft
Community Support
Community Support

HI @TimmK,

I'd like to suggest you connect to the Microsoft Exchange service to analyze your email records.
Notice: these records are not such readable so you may need to do some additional steps to shape/transform these data first.

Analyzing your Microsoft Exchange Account Data with Power Query | Microsoft Power BI Blog | Microsof...

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors