Mike Arcuri - More business intelligence in Office 2007

Sign in to queue

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

Download

Download this episode

The Discussion

  • User profile image
    Deactivated User

    Comment removed at user's request.

  • User profile image
    ZippyV

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

  • User profile image
    meysun
    I love excel charting capabilities
  • User profile image
    SlackmasterK
    Nice stuff. Scoble, you weren't by any chance excited by all this, were you?  I couldn't really tell... Smiley
  • User profile image
    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.
  • User profile image
    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
  • User profile image
    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...
  • User profile image
    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?
  • User profile image
    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
  • User profile image
    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!
  • User profile image
    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...?
  • User profile image
    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!
  • User profile image
    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.
  • User profile image
    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?
  • User profile image
    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.

  • User profile image
    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
  • User profile image
    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
  • User profile image
    roframj
    Is this video still available??

Add Your 2 Cents