The Big Data Panel at Case Western Reserve University Homecoming, 10/9/15Last week was Homecoming at my graduate school alma mater, Case Western Reserve University. The Weatherhead School of …
From Chaucer to Clusters: Data Analytics for Liberal Arts Grads
You've heard about "big data," "data analytics," and related fields (buzzwords?). Maybe you've thought about how to make a career out of it.One obstacle -- you've spent college reading Chaucer, not …
Continue Reading about From Chaucer to Clusters: Data Analytics for Liberal Arts Grads →
PivotTables: Add a Calculated Field
PivotTables are analytics machines. Think of all the ways you can slice and dice this data.Let’s take it even further — profit margin. Click inside your PivotTable. The home ribbon will have a couple …
Continue Reading about PivotTables: Add a Calculated Field →
#PivotTableProblems: Tweak Your View
Your PivotTable is looking good! Let’s make a few adjustments to supercharge it. You may be asking, why all the tweaks? We are modifying the PivotTable for the reasons we tweaked our vlookup formula. …
Continue Reading about #PivotTableProblems: Tweak Your View →
#PivotTableProblems: Avoid GETPIVOTDATA
Subscribe for more Excel tips and tricks. Avoid GETPIVOTDATAYou are hacking the PivotTable. All these little tricks are going to make you such a better analyst.There is one more trick I want to show …
Continue Reading about #PivotTableProblems: Avoid GETPIVOTDATA →
Anatomy of a PivotTable
Anatomy of a PivotTable You have a blank slate, a clean PivotTable. What’s great about PivotTable is that you can make pretty much any attribute into any one of features. It has Filters, Columns, …