Entries:
Comments:
Posts:

Loading User Information from Channel 9

Something went wrong getting user information from Channel 9

Latest Achievement:

Loading User Information from MSDN

Something went wrong getting user information from MSDN

Visual Studio Achievements

Latest Achievement:

Loading Visual Studio Achievements

Something went wrong getting the Visual Studio Achievements

Mike Arcuri - More business intelligence in Office 2007

Download

Right click “Save as…”

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:

Follow the Discussion

  • ZeoZeo Channel 9 :)
    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?
  • ZippyVZippyV Fired Up

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

  • meysunmeysun Solutions Monkey
    I love excel charting capabilities
  • tsilbSlackmasterK This Space ​Intentional​ly Left Blank
    Nice stuff. Scoble, you weren't by any chance excited by all this, were you?  I couldn't really tell... Smiley
  • ZippyV wrote:

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



    You get 16,384 columns and 1,048,576 rows now.
  • scobleizerscobleizer I'm the video guy
    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
  • tsilbSlackmasterK This Space ​Intentional​ly Left Blank
    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...
  • 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?
  • 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
  • Christian Liensbergerlittleguru <3 Seattle
    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!
  • PaoloMPaoloM Hypermedioc​rity
    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...?
  • 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!
  • 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.
  • SimoSimo With me it's a full-time job.
    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?
  • pringlespringles sup?
    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.

  • 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
  • rasxrasx Emperor of String.Empty
    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
  • Is this video still available??

Remove this comment

Remove this thread

close

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.