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

About Parth Acharya
Data Analyst | Social Media Evangelist | Film Maker

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: