Sentiment Analysis in Excel & Power BI

Sentiment Analysis in Excel & Power BI

Today I would like to kickoff a special series on DataChant blog – For the first time ever,  we will incorporate Sentiment Analysis to our Excel workbooks and Power BI dashboards. This series of blog posts will walk you through the use of Sentiment Analysis in...
Use DAX for dynamic events in Power BI Pulse Chart

Use DAX for dynamic events in Power BI Pulse Chart

The Power BI team recently announced the release of the Pulse Chart custom visual. Excited by its potential, I decided to show you today how to define dynamic events, so your Pulse Chart will always trigger popups with top events, no matter how you slice and dice the...
Use DAX for dynamic events in Power BI Pulse Chart

Define top events in DAX for your Pulse Chart in Power BI

As I was working on the Presidential Facebook Reaction Dashboard here, the Power BI team have announced the release of the Pulse Chart. Excited by the potential of this custom visual, I set the next target for my blog – To share how to define...
Excel for Security Analysts – Episode 1

Excel for Security Analysts – Episode 1

In this walkthrough we will show step-by-step how to turn web traffic logs (W3C Extended Log File Format) into a powerful security analytics workbook. To watch other episodes of Excel for Security Analysts go here. Web traffic logs are generated by web proxies and...
My Calendar Insights in Excel 2016

My Calendar Insights in Excel 2016

This week we have announced on Office Blogs the release of 3 new Excel templates that harness advanced data analytics technologies in Excel 2016: Power Query (Excel 2016 new get-data and transformation features that are available in the Get & Transform section of...