How-to use Analytics

April 13, 2010

Excel for Analysis? Is it obviously the best choice? Maybe, maybe not!

Filed under: Uncategorized — bankfield @ 9:42 pm

Most of us take Excel granted.  These are the reasons why I think Excel is such a great environment for analyzing data.

  • Layout – control the layout of your reports
  • formula – create custom formula
  • formatting – get exactly what you want
  • charting – cool charts
  • publishing – everyone has Excel, easy to share

Things that Nextanalytics helps  Excel users with…

  • Capacity – doesn’t hit memory or row or column limits
  • Ez pivot – you get pivoted date automatically, this gives you time series and distributions
  • Fix – change the spellings and wrongly categorized data, easily change technical terms to more readable ones
  • Analyze – all sorts of operations that you need
  • Refreshable – once you’ve done the work, don’t lose it just because the data changes

So why don’t more people use it?

  • Excel can get complicated
  • Excel can be error-prone
  • Custom systems and business intelligence give the appearance of being easier
Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: