Top Resources for Analysts: Excel, Data Analysis, and Business Intelligence

[This is part two of a two part series. See the first post for resources about charting, visualization, and presentations.]

If you work with data for a living, the following sites are worth a visit (or a subscription) to learn from some of the best, most passionate practitioners. While we’re at it, we are handing out our first annual Juicy Awards celebrating contributions to the analytics community. The categories are:

  1. Charts and graphs
  2. Information visualization
  3. Presentations
  4. Excel
  5. Data analysis
  6. Business intelligence

(Items 1, 2, and 3 were covered in part 1)

Here is an OPML file containing the finalists if you want to subscribe to these feeds (right click and save-as)

Juice Resources for Analysts.opml

***

4. Excel

The Juicy goes to Jon Peltier’s Excel Page. Jon shares a wide array of detailed descriptions and tutorials on Excel features. He demonstrates a particular passion for Excel charting.

Best of the rest:

  • Process Trends: Kelly O’Day, a FOJ (Friend of Juice) has put together a bunch of tips and tools to help with presenting and working in Excel.
  • Daily Dose of Excel: A multi-author blog focused on advanced Excel capabilities (i.e. lots of Visual Basic) and the new Excel 2007.
  • Andrew’s Excel Tips: Andrew demonstrates his exceptional Excel skills in this blog.
  • Tips and Tricks: A huge archive of (mostly) Excel tips.

5. Data analysis (mining, statistical, database marketing)

Winner of the Juicy is KD Nuggets. This is a data mining supercenter--not particularly pretty to look at but offering the data miner a vast directory of resources. You can subscribe to the newsletter here.

Best of the rest:

  • MineThatData: An active and well-researched blog about multichannel markeing and database marketing.
  • Jim Novo’s Drilling Down: Not exactly a blog--but Jim does offer lots of fresh content about customer analytics.
  • Data Mining Research: A new find for me, Sandro Saitta reviews books and discusses recent news and applications of data mining.

6. Business intelligence in the enterprise

Winner of the Juicy: Enterprise Data Management, a blog by the VP of Product Marketing at Fair Isaac covering the business intelligence industry and practice. James Taylor has a rare corporate blog that is informative and passionate without feeling like a pitch.

Best of the rest:

  • Andy on Enterprise Software: Thoughts on data warehousing, business intelligence, and performance management from an industry insider.
  • Hired Brains knowledge repository: Here is a great group of articles and white papers about business analytics by Neil Raden.
  • Steve Krause Blog: Written by the VP of Analytic Product, CNET Channel. An interesting read covering a wide range of current topics, including commentary on the use and misuse of data.
  • Data Doghouse: "Unleashing observations on the business and technology of performance management, business intelligence, and data warehousing."
  • IT Toolbox nurtures a blog farm with dozens of IT-related blogs. Here is the section on business intelligence.