In the 16th session of Chandoo.org podcast, lets review 3 very useful books for aspiring analysts.
What is in this session?
Analytics is an increasingly popular area now. Every day, scores of fresh graduates are reporting to their first day of work as analysts. But to succeed as an analyst?
By learning & practicing of course.
And books play a vital role in opening new pathways for us. They can alter the way we think, shape our behavior and make us awesome, all in a few page turns.
So in this episode, let me share 3 must have books for (aspiring) analysts.
Note: these are not only 3 books you should read. But these 3 are the ones I am reading now and I think they will certainly help you.
Participate in our Analyst Book Giveaway & win:
- You could win a copy of any of these 3 books.
- Last date: 15-AUG-2014 – Friday.
Listen to the podcast to know how to participate.
This podcast is essentially a review of the 3 books – Data Smart by John Foreman, Ctrl+Shift+Enter by Mike Girvin & Think Like a Freak by Steven Levitt & Stephen Dubner.
- Why this book?
- About John Foreman
- Writing style
- Example chapter
- Why this book?
- About Mike Girvin
- Writing style
- Example Array Formulas
- Why a non-Excel book?
- About authors
- Writing style
- Example Chapter on Takeru Kobayashi
Note about the book links: These are affiliate links. It means, when you click on them and purchase a copy of the book, Chandoo.org receives a small commission. I recommend these books because I really enjoy them and I genuinely think they will benefit you. I would have recommended them even when there is no commission involved.
Go ahead and listen to the show
Podcast: Play in new window | Download
Subscribe: RSS
Links & Resources mentioned in this session:
About the bicycle ride
Excelapalooza Excel conference:
Advanced Excel, Dashboards & Power Pivot Masterclass:
More on Array Formulas:
Transcript of this session:
Download this podcast transcript [PDF].
Which is your favorite book for analysts?
I read quite a few books every year. Apart from these three, I also enjoy and recommend these books.
What about you? What is your favorite book for analysts? Please share your thoughts in comments.
Participate in our Analyst Book Giveaway & win:
- You could win a copy of any of these 3 books.
- Last date: 15-AUG-2014 – Friday.
Listen to the podcast to know how to participate.
8 Responses to “Introducing PHD Sparkline Maker – Dead Simple way to Create Excel Sparklines”
This looks like it could be very useful for a project I'm putting together right now, thank you so much. Quick & silly question, how do I copy & paste the sparkline as a picture?
Question answered. For anyone else:
Select chart>Hold Shift key & select Edit/Copy Picture>Paste
[...] more information about PHD Sparkline Maker, please read this article and to learn more about Sparklines, read this article from Microsoft Excel 2010 blog. Also there [...]
Am I right in thinking that the y-axis is set automatically by excel?
That makes it possible to get the column chart not to start at zero.
Andy - yes, it is currently set to 'auto', which defaults to a zero base for positive values, but you can change that by left-clicking the chart, then choosing (in Excel 2007):
"Chart Tools/Layout/Axes/Primary Vertical Axis/More Primary Vertical Axis Options"
PUBLIC SERVICE ANNOUNCEMENT: When manually editing a chart's minimum/maximum axis values, PLEASE be sure there's a valid reason and that doing so won't skew the message shown by the data (e.g. by exaggerating differences). If in doubt, go back and read Tufte. (W.W.T.D.?)
[...] gridlines, axis, legend, titles, labels etc.) and resize it so that it fits nicely in a cell [example]. This is the easiest and cleanest way to get sparklines in earlier versions of excel. However this [...]
thanks for the work creating the template!!!!
looks good