scobleizer

Mike Arcuri - More business intelligence in Office 2007

Download this episode

Download Video

Description

This is a second, deeper look at Excel 2007's business intelligence capabilities (Mike Arcuri was on Channel 9 a few weeks ago). Really cool stuff for helping your business see what is happening.

The demos start at 6:15 into this video. Really great stuff, if you are an Excel freak, don't miss!

Tags:

MS Office, Office

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    • Zeo
      Thanks for reponding to the feedback and putting up another Office 2007 video.

      Mike has a "ship it" award, I wonder what product that is for?
    • ZippyV

      Has the number-of-columns-limit been changed already or not?

    • meysun
      I love excel charting capabilities
    • SlackmasterK
      Nice stuff. Scoble, you weren't by any chance excited by all this, were you?  I couldn't really tell... Smiley
    • DigitalDud
      ZippyV wrote:

      Has the number-of-columns-limit been changed already or not?



      You get 16,384 columns and 1,048,576 rows now.
    • scobleizer
      SlackmasterK wrote:
      Nice stuff. Scoble, you weren't by any chance excited by all this, were you?  I couldn't really tell... Smiley


      No, I was bored out of my mind! Heheh.

      Sorry, I get excited by charts and graphs. Smiley
    • SlackmasterK
      scobleizer wrote:

      No, I was bored out of my mind! Heheh.

      Sorry, I get excited by charts and graphs. Smiley


      Yeah, I've noticed you seem somewhat partial to some productivity apps, which is understandable given your occupation .  Keep it up!

      Oh, and try to teach your camera-steadying techniques to whoever shot that previous video...
    • dahowlett
      Mike and others. Maybe a stupid question if so I apologize but...is there any easy way to extract the presentation element from Excel 2007and then include it in a portal style app as some sort of widget? It seems to me that would be a good thing for helping people share information and act as coordinated teams?
    • ohgood
      I've been confused lately, with all the talk of Open Documents, and such. Will Office2007 break the OpenOffice compatibility ? I understand there are DRM possibilities with Office2007, and if _that_ is the only restricting portion of the app, it could still be valuable. If the application itself disallowes any non-Office system to read the files at all, it will be a large problem for businesses and users that use the better alternative(s).

      Just a thought.

      Keep up the work.Smiley
    • littleguru
      Wow! Excel 2007, and Office 2007 in general, is going to be great! Wonderful.

      I'm looking forward to the next Office 12 videos! Thank you for this video, Scoble!
    • PaoloM
      ohgood wrote:
      I've been confused lately, with all the talk of Open Documents, and such. Will Office2007 break the OpenOffice compatibility ?

      What OpenOffice compatibility?
      ohgood wrote:
      I understand there are DRM possibilities with Office2007, and if _that_ is the only restricting portion of the app, it could still be valuable.

      You can apply DRM to any office document today, on Office 2003.
      ohgood wrote:
      If the application itself disallowes any non-Office system to read the files at all, it will be a large problem for businesses and users

      Uh? With an open file format how can they disallow other apps to read the files?
      ohgood wrote:
      that use the better alternative(s).

      "better alternative(s)"? Such as...?
    • Andretzu
      What about the row limit when importing?  Does it still just truncate at 65K rows?  Would be nice to be given the option to continue loading to the next sheet!
    • TrayJoe
      Nice stuff.

      When's the last time Mike got a day off and more than 5 hours sleep?  Looks like he could use a vacation.
    • Simo
      Looks cool.

      I have a questions about the new table cell naming (ie where cell refrences like  $E2 are replaced with  names like [2004 prices] (http://channel9.msdn.com/Showpost.aspx?postid=177827&pvrid=269).

      If I build a table in Excel 07 and my formulas are automaticaly translated this way. What happens when somebody attempts to open the sheet in Excel '03?
    • pringles
      considering Tables don't exist in '03, there shouldn't be a problem there anyway.

      PIVOTtables are in '03, but the table example he uses is new to '07. the closest thing to the Table in '03 is the ListObject, but the Table in '03 is a major step up from that.

      and you can't change formulas in PivotTables anyway.

    • mike_arcuri
      Thanks for the comments and questions.  Here are some answers and pointers.

      dahowlett - If you're interested in using charts and Excel information in web portals, that will be possible with Excel Services in Office 2007.  You may want to watch some of my earlier Channel 9 video, and look at some of the Excel Services posts on the Excel blog to learn more.

      TrayJoe - If I look sleepy it's because of the 5 month old boy and 2.5 year old girl at home.   Smiley

      ohgood - Looks like you've gotten some replies on your post already.  There are new file formats for Office 2007, but they will be fully documented and open XML.  I'm sure other products that read Office 2003 files will add support for these new formats in no time.  Plus, people will still be able to save files in the older formats.  If you have more quesitons, you might follow up Brian Jones (at his Office 2007 file format blog: http://blogs.msdn.com/brian_jones/).

      Andretzu and Simo - We're being very careful about backward compatability with older versions of Excel.  For answers to these specific questions, you may want to ask David Gainer (at his Excel 2007 blog: http://blogs.msdn.com/excel/)

      - Mike Arcuri
    • rasx
      Excel 2007 has new, rich, semantic formatting features---adding both visuals and meaning. Very impressive! All those gradients will export to XAML with high fidelity one day...Big Smile
    • roframj
      Is this video still available??

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.