Using PowerBI for Google Analytics

[Nikesh Valji]

Hi,

Does anyone know of a good add-in for extracting website and social media data in order to carry out analytics in Excel? I have tried Excellent Analytics and Analytics Edge however the former kept crashing my excel and the latter was very difficult to use as the dialogue boxes were VERY small.

Does anyone have any ideas?

Many thanks,

Nikesh

 

[mrzoogle]

You can use power query to get data from various social sites. I have used to mind data from Facebook feeds.
Here's an example:
https://support.office.com/en-us/article/Connect-to-Facebook-5c3f381b-7268-4fb6-a586-dfb94a03a0aa

Hope it helps.