Business Intelligence in Excel 2007 | Charles

Cornelius Ellsonpeter

Zeo! You're hired! Don't let the NON-mvp types get you down. THEY just don't "get" it when it comes to the MVP program. What's a little excitement between MVPs??!?!

Dr. Ellsonpeter (MVP AND DON'T YOU FORGET IT)

daSmirnov

Office 2007 rocks. Looks like I'm going to be compiling all the traffic from my websites into Excel 2007 just cuz it's so cool - I need some reason to use it. Cool

bitJunkie

Looking very very nice.

I am looking forward to see all the changes in the charting...it's the only thing that ever bugged me seriously.

Sure i know there are a stack of third party charting packages out there but some flexible charting that you can plot up in a report without it looking totally generic would be cool to have....not technical paper quality but somewhere closer would be cool. Guess being an engineer got me fired up about that.

You put all that work in to getting your data in a good shape...kind of nice if you can present it in a cool way too Cool

DarkByte

One thing that would be marvelous with excel is changing the how cells are ranged. I mean, currently excel has this limit of 64K Rows x 256 Columns, but if i needed only 128 columns, i would then be able to get 128K rows.

Where i work at, we often have to work with data that has many rows. We, as standard users, have no access to the underlying queries and as such, must often run a standard report that returns 100's of thousands of rows. So the 64k limit is really bad. I know this has to do with memory management, but by reselecting how rows and columns are split, i could use the same amount of memory with a limit that makes more sense to me.

I mean, how many times did you have to work with more than 32 columns ? Unless its a full application with protected cells etc. in which case you will probably not need 64K rows. On the other hand, the inverse could be true. One could need more Columns and less rows.

Would be interesting to have feedback on this.

nojetlag

Fantastic video, finally MS brings a good front end for analysis server. I was already playing with Excel 12, however I will have now a look at the Sharepoint integration. Hopefully I can show now a complete migration path to an all MS BI Solution and kick out the old Business Objects stuff.

The only thing I fear is that it might take again ages to convince the company to migrate their office to the latest version Sad

Anyway then it might be time to look for a more innovative company Big Smile

ZippyV
Fired Up

DarkByte wrote:
One thing that would be marvelous with excel is changing the how cells are ranged. I mean, currently excel has this limit of 64K Rows x 256 Columns, but if i needed only 128 columns, i would then be able to get 128K rows.

Yeah, there should be a way to remove the rows and columns limit. A lot of people are complaining about not enough columns. Especially if you want a column for every day of the year (>365 columns).

JoshRoss
A righteous infliction of retribution manifested by an appropriate agent.

If you use ODBC to import data into a pivot table you can have millions of rows. However, you can only display 2^16 rows in Office < 2007. I use sum, min, max, and count to rollup most of my queries.

anywhere

"I'd love to see a video on building the Dashboard without any code!"

Robert ... Let me add my vote as well to get this on video ASAP !!!

szaske

ZippyV wrote:

DarkByte wrote: One thing that would be marvelous with excel is changing the how cells are ranged. I mean, currently excel has this limit of 64K Rows x 256 Columns, but if i needed only 128 columns, i would then be able to get 128K rows.

Yeah, there should be a way to remove the rows and columns limit. A lot of people are complaining about not enough columns. Especially if you want a column for every day of the year (>365 columns).

Excel 12 will be able to support 1,048,576 rows by 16,384 columns. So you'll be able to have a column for each day over 44 years (if you choose). You can find out all of the new features on the Official Excel Blog

-=STZ=-