How To Manage Big Data With Pivot Tables

This is probably the hardest concept to grasp when you’re first starting with pivot tables. So, for example, if you wanted to see visits to a site broken down by month and medium, you might be tempted to create a column for each medium (organic, PPC, social, email, etc.) and each month. This would be incorrect and will cause you all manner of aggravation when you go to pivot the data.

Full article: http://searchengineland.com/how-to-manage-big-data-with-p...

Tweets

@mattpolsky » 08 Aug '12, 1pm
I love pivot tables! Why you should too @seland --> [link]
@lyena » 25 Jul '12, 9pm
“@jennita: How To Manage Big Data With Pivot Tables - [link] from @AnnieCushing mentioned at #Mozcon” excellent post
@haiderferdous » 25 Jul '12, 9pm
RT @willcritchlow: How To Manage Big Data With Pivot Tables [link] - loved this from @anniecushing
@TheChrisPadilla » 25 Jul '12, 9pm
RT @jennita: How To Manage Big Data With Pivot Tables - [link] from @AnnieCushing mentioned at #Mozcon
@jennita » 25 Jul '12, 9pm
How To Manage Big Data With Pivot Tables - [link] from @AnnieCushing mentioned at #Mozcon
@ruthburr » 25 Jul '12, 9pm
RT @_george_andrews: @AnnieCushing Great Excel tips #mozcon check out her recent blog post on Search Engine Land [link]
@_george_andrews » 25 Jul '12, 8pm
@AnnieCushing So many great Excel tips #mozcon make sure you check out her recent blog post on Search Engine Land [link]
@willcritchlow » 25 Jul '12, 6pm
How To Manage Big Data With Pivot Tables [link] - loved this from @anniecushing
@seotweetz » 25 Jul '12, 12am
RT @gjbrits: Great and Thorough explanation on DIY #seo managment > [link] "How To Manage Big Data With Pivot Tables" @seland
@gjbrits » 25 Jul '12, 12am
Great and Thorough explanation on DIY #seo managment > [link] "How To Manage Big Data With Pivot Tables" @seland
@ClearAnalytics » 24 Jul '12, 9pm
How To Manage #BigData With #Excel Pivot Tables [link] via @sengineland #BI #analytics
@seotweetz » 24 Jul '12, 9pm
RT @MatthewForzan: Excel-ent guide! Manage Big Data With Pivot Tables via @anniecushing [link] #seo
@MatthewForzan » 24 Jul '12, 9pm
Excel-ent guide! Manage Big Data With Pivot Tables via @anniecushing [link] #seo
@NumericJobs » 24 Jul '12, 7pm
How To Manage Big Data With Pivot Tables [link] via @sengineland #analytics #measure #excel
@floraandflying » 24 Jul '12, 1pm
RT @tonia_ries: for data geeks: How To Manage Big Data With Pivot Tables (Search Engine Land) [link]
@_ryancampbell » 24 Jul '12, 12am
How To Manage Big Data With Pivot Tables [link] [ From @AnnieCushing. PPC changed forever when I figured out pivot tables]
@companydotcom » 23 Jul '12, 10pm
RT @smallbiztrends: RT @sengineland: How To Manage Big Data With Pivot Tables by @AnnieCushing [link]
@helenculshaw » 23 Jul '12, 4pm
We use pivot tables ALL the time >> How To Manage Big Data With Pivot Tables [link]
@daxeshpatel » 23 Jul '12, 1pm
How To Manage Big Data With Pivot Tables [link] #yam
@TimTheGuest » 23 Jul '12, 1pm
RT @alexmoss: How To Manage Big Data With Pivot Tables [link] via @sengineland
@fredzaguilar » 23 Jul '12, 12pm
20 How To Manage Big Data With Pivot Tables: Big data is all the rage right now. If you search Google News for t... [link]
@Philipp_Exa » 23 Jul '12, 10am
RT @MimounEXA: How To Manage #BigData With Pivot Tables [link]
@nickwilsdon » 23 Jul '12, 9am
RT @rishil: I love @AnnieCushing helping me with Pivot tables :) [link]
@rishil » 23 Jul '12, 9am
I love @AnnieCushing helping me with Pivot tables :) [link]
@hannah_bo_banna » 23 Jul '12, 9am
RT @philnottingham: Excel pornography from @AnnieCushing [link]
@philnottingham » 23 Jul '12, 9am
Excel pornography from @AnnieCushing [link]
@percevalSEO » 23 Jul '12, 7am
C'est pas faux: via @sengineland How To Manage Big Data With Pivot Tables [link]
@pandiyarajan » 23 Jul '12, 4am
Try Pivot Table Management for large data: [link]
@t_orth » 23 Jul '12, 4am
How To Manage #BigData With #Pivot Tables [link] via @sengineland #data #metrics #sm
@tquintana » 22 Jul '12, 9pm
Search Engine Land: How To Manage Big Data With Pivot Tables @tquintana [link]
@Nice1 » 22 Jul '12, 9pm
RT @VergeIndy: How To Manage Big Data With Pivot Tables [link]
@SpiderTrainers » 22 Jul '12, 9pm
To manage Big Data you can use pivot tables. They're easy to use once you learn the logic that powers them. [link]
@WordsBySusan » 22 Jul '12, 5pm
Great tip: How to handle #BigData with pivot tables, from @AnnieCushing [link] #SMSEO
@dynamicnet » 22 Jul '12, 5pm
How To Manage Big Data With Pivot Tables [link] #seo #sem {spreadsheet lovers unite}
@dannypenrose » 22 Jul '12, 11am
Great in-depth guide by @AnnieCushing RT @justinrbriggs: How To Manage Big Data With Pivot Tables - [link]
@andydoyles » 22 Jul '12, 11am
RT @justinrbriggs: How To Manage Big Data With Pivot Tables - [link]
@natzir9 » 22 Jul '12, 8am
"@Nansky: [link] How To Manage Big Data With Pivot Tables #analytics #analiticaweb"
@ChyTea » 22 Jul '12, 8am
RT @jackson_lo: Wouldn't survive without them :) - How To Manage Big Data With Pivot Tables [link]
@jackson_lo » 22 Jul '12, 8am
Wouldn't survive without them :) - How To Manage Big Data With Pivot Tables [link]
@Nansky » 22 Jul '12, 8am
[link] How To Manage Big Data With Pivot Tables #analytics #analiticaweb
@davidlavender » 22 Jul '12, 7am
How To Manage Big Data With Pivot Tables: [link] #technology
@sharethis_tech » 22 Jul '12, 4am
How To Manage Big Data With Pivot Tables [link] via @sharethis
@_rappy » 21 Jul '12, 10pm
RT @neyne: Annie's guide to pivot tables in Excel. Bookmarked forever and ever [link] by @AnnieCushing
@caseyhen » 21 Jul '12, 8pm
RT @Inboundorg: How To Manage Big Data With Pivot Tables - [link] - Discussion - [link]
@SEOTakeaways » 21 Jul '12, 6pm
RT @paulmay: How To Manage Big Data With Pivot Tables [link] via @sengineland
@neyne » 21 Jul '12, 5pm
Annie's guide to pivot tables in Excel. Bookmarked forever and ever [link] by @AnnieCushing
@joeysickler » 21 Jul '12, 5pm
RT @wilreynolds: Managing big SEO data - [link] by @AnnieCushing
@sengineland » 21 Jul '12, 2pm
Weekend Review: How To Manage Big Data With Pivot Tables by @AnnieCushing [link]
@JHTScherck » 21 Jul '12, 1pm
Of course @AnnieCushing uses "Gucci handbags" as an example in her insane data management post [link]
@thelostagency » 21 Jul '12, 1pm
RT @lyena: How To Manage Big Data With Pivot Tables [link] by @AnnieCushing