When Google comes to rescue!

This morning, I was working on a web analytics report  and badly needed Power view to help me deal with the data (mainly to visualize it!). Just when I opened the super powerful excel ’13 I realized my Office ’13 license has expired; I started thinking what shall I do?

Here is what helped me:

analytics google spreadsheet

I exported the Google Analytics data as Google Spreadsheet and inserted a chart for the required data columns

analytics insert chart

Voila! Mission accomplished!

*Update*

analytics pivot table

pivot2

Advertisements
%d bloggers like this: