How To Use Excel Pivot Tables To Analyze Massive Data Setshttp://www.businessinsider.com/excel-pivot-tables-analyze-data-2014-4/comments
en-usWed, 31 Dec 1969 19:00:00 -0500Sun, 02 Aug 2015 17:36:52 -0400Sara Silversteinhttp://www.businessinsider.com/c/53610090ecad04d02d0f9433InfoWed, 30 Apr 2014 09:54:24 -0400http://www.businessinsider.com/c/53610090ecad04d02d0f9433
Hello,
While I was going through this tutorial, I just thought of sharing an experience of mine. I recently came across this site,www.jolicharts.com for data visualization and creating charts derived directly from excel sheets.
It was good for me as day to day charting and data presentation was taking way too much of my time..
I hope this info also might help few more of us.
Well no harm in trying it for free..http://www.businessinsider.com/c/5356f73869bedd663b38394eAlejandro Tue, 22 Apr 2014 19:11:52 -0400http://www.businessinsider.com/c/5356f73869bedd663b38394e
Which version of excel is this??http://www.businessinsider.com/c/5356e98b6da811d619c470c1JaketooTue, 22 Apr 2014 18:13:31 -0400http://www.businessinsider.com/c/5356e98b6da811d619c470c1
Holy shit Sara. This made my countless hours reading click bait after click bait on BI worth it.
Always wanted to know what those finance guys are talking about when they spouted the word "pivot table", and Googling it didn't do shit for me. This explains everything!http://www.businessinsider.com/c/5356e1236bb3f7d71d9307a7StevexTue, 22 Apr 2014 17:37:39 -0400http://www.businessinsider.com/c/5356e1236bb3f7d71d9307a7
Exactly..,.not many executives probably care about having you "walking them" through the code.http://www.businessinsider.com/c/5356b05e6bb3f750749bb13cIn the 18th century educated folks spoke FrenchTue, 22 Apr 2014 14:09:34 -0400http://www.businessinsider.com/c/5356b05e6bb3f750749bb13c
Excel is the English of business and big data. There's nothing R or Python can do that Excel can't.
And there are several things Excel does that neither R or Python do. The most important of them is being a worldwide standard for business data exchange and processing.http://www.businessinsider.com/c/5356aad0ecad041a7ffcd216cezarepcTue, 22 Apr 2014 13:45:52 -0400http://www.businessinsider.com/c/5356aad0ecad041a7ffcd216
I know Python and Pandas but believe me, most people who do "Real Analysis" use Excel. You may use any language/tool you want to use to make sense out of a large data set (excel is poor with large data) but your final analysis is best done in Excel.
Once you have your data sorted out by year, by month, or by whatever parameter you want you then use a pivot table and graphs/charts for analysis. This is the quickest, time-efficient way to do it.
I know some people claiming they are experts in a bunch of languages and make fun of Excel. Most of these guys are tech-pros, meaning they are technically good with technical stuff (like in coding), but not necessarily good in analysis.http://www.businessinsider.com/c/53568c1a69beddba147ea9b3keycutsTue, 22 Apr 2014 11:34:50 -0400http://www.businessinsider.com/c/53568c1a69beddba147ea9b3
Using PivotTables is just the first step in aggregating and analyzing data. Analyzing data requires more than just Excel skills but also having an attitude of asking questions about the data and what are the key drivers for your business.
We also think using keyboard shortcuts to access PivotTables will save you a lot of time during your data crunching/analysis phase. For instance, on a PC, we use the shortcut ALT, N, V, T ENTER to quickly create your PivotTable after you have your data selected. There are also a ton of other shortcuts like creating calculated fields, summarizing your data in the PivotTable, etc. that can save you time as you are playing around with the PivotTable.
If you're interested in learning more keyboard shortcuts for Excel on the Mac, check out this keyboard cover solution we developed to help you out: www.thekeycuts.com/shop/keyboard-covershttp://www.businessinsider.com/c/53567c7869bedd1c5d7ea9aeAngry PopulistTue, 22 Apr 2014 10:28:08 -0400http://www.businessinsider.com/c/53567c7869bedd1c5d7ea9ae
Surprisingly/Sadly, knowing how to do this puts you above 90% of the people out there in the job market and is a skill set that's in demand to some extent.
Most data analysis jobs are more or less reporting roles, not many require actual real 'analysis'http://www.businessinsider.com/c/5356791c69bedd8a477ea9b1nerdbertTue, 22 Apr 2014 10:13:48 -0400http://www.businessinsider.com/c/5356791c69bedd8a477ea9b1
Many tools put out data in CSV files. Excel (and LibreOffice Calc) make using those sets trivial, which is nice if you're doing one-off analysis of a dataset. Sure, write some Python if you're going to do it more than once, but for quick analysis is tough to beat pivot tables.http://www.businessinsider.com/c/535670eb6bb3f7317c9bb13fDaniel RussellTue, 22 Apr 2014 09:38:51 -0400http://www.businessinsider.com/c/535670eb6bb3f7317c9bb13f
What did you just take an intro excel class? The fact that BI let you publish this is scary. When you actually want to analyze data you use R or Python, you know actual coding. This makes me want to smash my head on my desk. Tisk tisk BI.http://www.businessinsider.com/c/53566ae76da8119a53198ea2newTue, 22 Apr 2014 09:13:11 -0400http://www.businessinsider.com/c/53566ae76da8119a53198ea2
v goodhttp://www.businessinsider.com/c/5356693deab8eabe5a9bb142PascalTue, 22 Apr 2014 09:06:05 -0400http://www.businessinsider.com/c/5356693deab8eabe5a9bb142
Would be great to include a spreadsheet to give it a try!http://www.businessinsider.com/c/535666846bb3f7645e9bb13areymidasmoneyTue, 22 Apr 2014 08:54:28 -0400http://www.businessinsider.com/c/535666846bb3f7645e9bb13a
Congratulations. You discovered Microsoft Excel! :(